package com.reallinkbilling.utils;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;

import org.apache.struts2.dispatcher.SessionMap;

import com.reallinkbilling.db.GetDBConnection;

public class GetProductDetailsUtil {
	
	
	public static float getProductPurchaseRateById(SessionMap<String, Object> sessionMap, String productId)
	{
		float productPurchaseRate = 0.0F;
		
		Connection connection = null;
		PreparedStatement preparedStatement= null;
		ResultSet  resultSet = null;
		
		String sql = "";
		String db = (String) sessionMap.get("db");
		
		try
		{
			String shopId = (String) sessionMap.get("shopId");
    		String shopCode = (String) sessionMap.get("shopCode");

			
			connection = GetDBConnection.getDBConnection(db);
			
			sql = "SELECT "
					+ "purchase_rate "
					+ "FROM "
					+ "shop_product_master "
					+ "WHERE "
					+ "product_id = ? "
					+ "AND "
					+ "shop_id = ? "
					+ "AND "
					+ "shop_code = ? ";
			
			preparedStatement = connection.prepareStatement(sql);
			
			preparedStatement.setString(1, productId);
			preparedStatement.setString(2, shopId);
			preparedStatement.setString(3, shopCode);
			
			
			resultSet = preparedStatement.executeQuery();
			
			if(resultSet.next())
			{
				productPurchaseRate = resultSet.getFloat(1);
			}
					
		}
		catch (SQLException e) 
		{		
				
		
		}catch (IOException e) {
			
	
		}
		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) {}
			}
			
		}
		
		
		return productPurchaseRate;
	}
	
	
	
	
	
	public static HashMap<String,Object> getProductDetailsById(SessionMap<String, Object> sessionMap, String productId)
	{
		HashMap<String,Object> productDetailsMap = new HashMap <String,Object>();
		Connection connection = null;
		PreparedStatement preparedStatement= null;
		ResultSet  resultSet = null;
		
		String sql = "";
		String db = (String) sessionMap.get("db");
		
		try
		{
			String shopId = (String) sessionMap.get("shopId");
    		String shopCode = (String) sessionMap.get("shopCode");

			
			connection = GetDBConnection.getDBConnection(db);
			
			sql = "SELECT "
					+ "purchase_rate,"
					+ "tax_id,"
					+ "tax_percentage,"
					+ "stock_conversion_ratio,"
					+ "product_name_eng,"
					+ "customer_sales_price,"
					+ "dealer_sales_price,"
					+ "retailer_sales_price,"
					+ "sales_unit "
					+ "FROM "
					+ "shop_product_master "
					+ "WHERE "
					+ "product_id = ? "
					+ "AND "
					+ "shop_id = ? "
					+ "AND "
					+ "shop_code = ? ";
			
			preparedStatement = connection.prepareStatement(sql);
			
			preparedStatement.setString(1, productId);
			preparedStatement.setString(2, shopId);
			preparedStatement.setString(3, shopCode);
			
			
			resultSet = preparedStatement.executeQuery();
			
			while(resultSet.next())
			{
				productDetailsMap.put("PURCHASERATE", resultSet.getFloat(1));
				productDetailsMap.put("TAXID", resultSet.getString(2));
				productDetailsMap.put("TAXPERCENTAGE", resultSet.getFloat(3));
				productDetailsMap.put("STOCKCONVERSIONRATIO", resultSet.getFloat(4));
				productDetailsMap.put("PRODUCTNAME", resultSet.getString(5));
				productDetailsMap.put("CUSTSALESRATE", resultSet.getFloat(6));
				productDetailsMap.put("DEALERSALESRATE", resultSet.getFloat(7));
				productDetailsMap.put("REATAILERSALESRATE", resultSet.getFloat(8));
				productDetailsMap.put("SALESUNIT", resultSet.getString(9));
				
			}
					
		}
		catch (SQLException e) 
		{		
				
		
		}catch (IOException e) {
			
	
		}
		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) {}
			}
			
		}
		
		
		return productDetailsMap;
	}

}
