package com.reallinkbilling.test;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

import com.reallinkbilling.db.GetDBConnection;
import com.reallinkbilling.resource.GetListResource;

public class InsertDairyMilkSupplierList {
	
	
	public static void main(String[] args) {
		
		
		
		Connection connection = null;
		PreparedStatement preparedStatement= null;
		ResultSet  resultSet = null;
		
		try
		{
			
			
			
			String sql = "";
			String db = "reallinkshop";
			
			
			connection = GetDBConnection.getDBConnection(db);
			
			File mslistfile = new File("e:\\shop_product_master_19.txt");
			
			BufferedReader br = new BufferedReader(new FileReader(mslistfile) );
			
			File errorFile = new File("e:\\shop_product_master_19_error.txt");
			

			
			BufferedWriter bufferedErrorWriter = null;
			
		
			bufferedErrorWriter = new BufferedWriter(new FileWriter(errorFile));
			
			System.out.println("HEllo");
			String line = "";
			int k = 1;
			
			 while( (line = br.readLine()) != null)
			 {
				System.out.println(line);
				
				String [] lineData = line.split(",");
				
				//2	PAWARTRACTORS	25-11-2020	ROD TIE	ROD TIE	1	10	83	83	83	83	5	18	UNITS	UNITS	P660207	1	14	RA5-D1
				//276,WHEEL POWER 1KG,व्हील पावडर १ की,276,48,Packs,Packs
				//15-10-2019,SHENGADANA,शेंगदाणा,1,2,100,90,90,1,Bags,Kilograms,123,1,-56.75
				
				
				//185,19,BKMARTKARMALA,2021-10-14, Star G POHA 1KG, स्टार ग पोहे १ किलो,8908008978005,POHE1KG,12,90,90,90,90,1,0,Kilograms,Kilograms,1234,1,NULL,99942,NA,0,90,PERQUANTITY,15,75,1

				sql = "INSERT "
						+ "INTO "
						+ "shop_product_master "
						+ "("
						+ "product_id,"
						+ "shop_id,"
						+ "shop_code,"
						+ "add_date,"
						+ "product_name_eng,"
						+ "product_name_mar,"
						+ "product_short_code,"
						+ "product_alias,"
						+ "low_stock_count,"
						+ "purchase_rate,"
						+ "customer_sales_price,"
						+ "dealer_sales_price,"
						+ "retailer_sales_price,"
						+ "tax_id,"
						+ "tax_percentage,"
						+ "purchase_unit,"
						+ "sales_unit,"
						+ "hsn_sac_code,"
						+ "stock_conversion_ratio,"						
						+ "in_stock_quantity,"
						+ "rack_number) "
						+ "values "
						+ "(?,?,?,STR_TO_DATE(?, '%d-%m-%Y'),?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
				
						try

						{
						preparedStatement = connection.prepareStatement(sql);
						preparedStatement.setString(1, ""+k);
						preparedStatement.setString(2, "30");
						preparedStatement.setString(3, "RANJITKATARIYA");
						preparedStatement.setString(4, "06-07-2021");
						preparedStatement.setString(5, lineData[4].toUpperCase().trim().replace("-", ""));
						preparedStatement.setString(6, lineData[5].toUpperCase().trim().replace("-", ""));
						preparedStatement.setString(7, lineData[6].toUpperCase().trim().replace("-", ""));
						preparedStatement.setString(8, lineData[7]);
						preparedStatement.setString(9, "10");
						preparedStatement.setString(10, lineData[9]);
						preparedStatement.setString(11, lineData[10]);
						preparedStatement.setString(12, lineData[11]);
						preparedStatement.setString(13, lineData[12]);
						preparedStatement.setString(14, "1");
						preparedStatement.setString(15, "0");
						preparedStatement.setString(16, lineData[15]);
						preparedStatement.setString(17, lineData[16]);
						preparedStatement.setString(18, "1234");
						preparedStatement.setString(19, "1");
						preparedStatement.setString(20, "10000000");
						preparedStatement.setString(21, "NA");
						
						int i = preparedStatement.executeUpdate();
						
						if(i > 0)
						{
							System.out.println("Added Successfully!");
		     				
						}
						else
						{
							System.out.println("Errror Added Successfully!");
							bufferedErrorWriter.newLine();
		    				bufferedErrorWriter.write(line);
						}
						
						
						}catch (ArrayIndexOutOfBoundsException e) {
							e.printStackTrace();
							bufferedErrorWriter.newLine();
		    				bufferedErrorWriter.write(line);
						}catch(SQLException e)
						{
							e.printStackTrace();
							bufferedErrorWriter.newLine();
		    				bufferedErrorWriter.write(line);
							
						}
						catch(Exception e)
						{
							bufferedErrorWriter.newLine();
		    				bufferedErrorWriter.write(line);
							
						}
				
				
				k++;
				
			 }
			
			 bufferedErrorWriter.flush();
			br.close();
			bufferedErrorWriter.close();
			
		}catch(Exception e)
		{
			System.out.println("Errror Added Successfully!");
			e.printStackTrace();
		}finally {
			if(resultSet !=null)
			{
				try {resultSet.close(); resultSet = null;} catch (SQLException e) {}
			}
			if(preparedStatement != null)
			{
				try {preparedStatement.close(); preparedStatement = null;} catch (SQLException e) {}
			}
			if(connection != null)
			{
				
				try {connection.close();
				 connection = null;
				}catch (SQLException e) {}
			}
		}
		
	}

}
