package com.reallinkbilling.utils;

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;

public class GetEmpoyeeDetailsById {
	
	public static HashMap<String,String> getEmployeeDetails(String employeeId, SessionMap<String,Object> sessionMap, Connection connection)
	{
		
		HashMap<String,String> employeeDetails = new HashMap<String,String>();
		
 		
    	
			String shopId = (String) sessionMap.get("shopId");
    		String shopCode = (String) sessionMap.get("shopCode");
    

		PreparedStatement preparedStatement= null;
		ResultSet resultSet = null;
	
			
		
		
		try
		{
			String sql = "SELECT "
					+ "employee_name,"
					+ "employee_mobile_number,"
					+ "employee_address,"
					+ "employee_birth_date,"
					+ "employee_aadhar_number,"
					+ "employee_pan_number,"
					+ "employee_bank_name,"
					+ "employee_bank_acc_number,"
					+ "employee_bank_ifsc_code,"
					+ "employee_bank_branch,"
					+ "employee_designation "
					+ "FROM "
					+ "shop_employee_master "
					+ "WHERE "
					+ "shop_id = ? "
					+ "AND "
					+ "shop_code = ? "
					+ "AND "
					+ "employee_id = ?";
			
			preparedStatement = connection.prepareStatement(sql);
			preparedStatement.setString(1, shopId);
			preparedStatement.setString(2, shopCode);
			preparedStatement.setString(3, employeeId);
			
			resultSet = preparedStatement.executeQuery();
			
			if(resultSet.next())
			{
				employeeDetails.put("EMPLOYEENAMEENG", resultSet.getString(1));
				employeeDetails.put("EMPLOYEEMOBNUM", resultSet.getString(2));
				employeeDetails.put("EMPLOYEEADDRESS", resultSet.getString(3));
				employeeDetails.put("EMPLOYEEBIRTHDATE", resultSet.getString(4));
				employeeDetails.put("EMPLOYEEAADHAR", resultSet.getString(5));
				employeeDetails.put("EMPLOYEEPAN", resultSet.getString(6));
				employeeDetails.put("EMPLOYEEBANKNAME", resultSet.getString(7));
				employeeDetails.put("EMPLOYEEACCNUMBER", resultSet.getString(8));
				employeeDetails.put("EMPLOYEEIFSCCODE", resultSet.getString(9));
				employeeDetails.put("EMPLOYEEBRANCH", resultSet.getString(10));
				employeeDetails.put("EMPLOYEEDESIGNATION", resultSet.getString(10));
			}
		}
		catch (SQLException e) {
			
		}
		catch (Exception e) {
			
		}
		finally {
			if(resultSet != null)
			{
				try {resultSet.close(); resultSet = null;} catch (SQLException e) {}
			}
			if(preparedStatement != null)
			{
				try {preparedStatement.close(); preparedStatement = null;} catch (SQLException e) {}
			}
			
			
		}
		
		
		return employeeDetails;
		
	}
	

}
