package com.reallinkbilling.jspRedirect;

import java.io.File;
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 java.util.LinkedHashMap;
import java.util.Map;

import org.apache.struts2.dispatcher.SessionMap;
import org.apache.struts2.interceptor.SessionAware;

import com.opensymphony.xwork2.ActionSupport;
import com.reallinkbilling.cipher.EncryptionDecryption;
import com.reallinkbilling.db.GetDBConnection;

public class UpdateEmployeeDetailsJsp extends ActionSupport implements SessionAware{

	/**
	 * 
	 */
	private static final long serialVersionUID = -2516016896965191653L;
	private String key;
	private String employeeName;
	private String employeeMobileNumber;
	private String address;
	private String birthDate;
	private String employeeId;
	private File employeeImage;
	private HashMap<String,String> designationList = new LinkedHashMap<String,String>();
	private String employeePANNumber;
	private String employeeAADHARNumber;
	private String employeeBankName;
	private String employeeAccNumber;
	private String employeeBankBranch;
	private String employeeIFSCCode;
	private String designation;
	private String addSideBarJs;
	private SessionMap<String,Object> sessionMap;

	
	public String execute(){
		
		String result = "login";
		 
		 	if(this.getSessionMap()==null || this.getSessionMap().get("login")==null){ 
	        	addActionMessage("Please Logout and Login again !");
	        	result = "login";
	        }  
	        else{
	        	
	        	this.setDesignationList((HashMap<String, String>) this.getSessionMap().get("designationlist"));
	        	this.setAddSideBarJs("FALSE");
	       	   
	        	
	        	String shopId = (String) this.getSessionMap().get("shopId");
	    		String shopCode = (String) this.getSessionMap().get("shopCode");
	          	
	        	String employeeId = EncryptionDecryption.decrypt(this.getKey());
	        	
	        	Connection connection = null;
	       		PreparedStatement preparedStatement= null;
	       		ResultSet resultSet = null;
	       		
	       		String sql = "";
	       		String db = (String) this.getSessionMap().get("db");
	       		try 
	       		{
	       			
	       			
					connection = GetDBConnection.getDBConnection(db);
					sql = "SELECT "
							+ "employee_name,"
							+ "employee_mobile_number,"
							+ "employee_address,"
							+ "DATE_FORMAT(employee_birth_date,'%d-%m-%Y'),"
							+ "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 "
							+ "employee_id = ? "
							+ "AND "
							+ "shop_id = ? "
							+ "AND "
							+ "shop_code = ? ";
					
					preparedStatement = connection.prepareStatement(sql);
					preparedStatement.setString(1, employeeId);
					preparedStatement.setString(2, shopId);
					preparedStatement.setString(3, shopCode);
					
					
					resultSet = preparedStatement.executeQuery();
					
					if(resultSet.next())
					{
						this.setEmployeeName(resultSet.getString(1));
						this.setEmployeeMobileNumber(resultSet.getString(2));
						this.setAddress(resultSet.getString(3));
						this.setBirthDate(resultSet.getString(4));
						this.setEmployeeAADHARNumber(resultSet.getString(5));
						this.setEmployeePANNumber(resultSet.getString(6));
						this.setEmployeeBankName(resultSet.getString(7));
						this.setEmployeeAccNumber(resultSet.getString(8));
						this.setEmployeeIFSCCode(resultSet.getString(9));
						this.setEmployeeBankBranch(resultSet.getString(10));
						this.setDesignation(resultSet.getString(11));
						
						result = SUCCESS;
					}
					else
					{
						result = ERROR;
						
						addActionError("Details not found! Please try again!");
					}
							
					
					
	       		} catch (SQLException e) {
	       			result = ERROR;
   				
   				addActionMessage(e.getErrorCode()+"||"+e.getMessage()+"|| SOME ERROR");
			
			} catch (IOException e) {
				
				result = ERROR;
				addActionMessage(e.getMessage()+"|| SOME ERROR");
			}	
   			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 result;
}

	public String getKey() {
		return key;
	}

	public void setKey(String key) {
		this.key = key;
	}

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public String getBirthDate() {
		return birthDate;
	}

	public void setBirthDate(String birthDate) {
		this.birthDate = birthDate;
	}


	public static long getSerialversionuid() {
		return serialVersionUID;
	}

	public String getEmployeeName() {
		return employeeName;
	}

	public void setEmployeeName(String employeeName) {
		this.employeeName = employeeName;
	}

	public String getEmployeeMobileNumber() {
		return employeeMobileNumber;
	}

	public void setEmployeeMobileNumber(String employeeMobileNumber) {
		this.employeeMobileNumber = employeeMobileNumber;
	}

	public String getEmployeeId() {
		return employeeId;
	}

	public void setEmployeeId(String employeeId) {
		this.employeeId = employeeId;
	}

	public File getEmployeeImage() {
		return employeeImage;
	}

	public void setEmployeeImage(File employeeImage) {
		this.employeeImage = employeeImage;
	}

	public HashMap<String, String> getDesignationList() {
		return designationList;
	}

	public void setDesignationList(HashMap<String, String> designationList) {
		this.designationList = designationList;
	}

	public String getEmployeePANNumber() {
		return employeePANNumber;
	}

	public void setEmployeePANNumber(String employeePANNumber) {
		this.employeePANNumber = employeePANNumber;
	}

	public String getEmployeeAADHARNumber() {
		return employeeAADHARNumber;
	}

	public void setEmployeeAADHARNumber(String employeeAADHARNumber) {
		this.employeeAADHARNumber = employeeAADHARNumber;
	}

	public String getEmployeeBankName() {
		return employeeBankName;
	}

	public void setEmployeeBankName(String employeeBankName) {
		this.employeeBankName = employeeBankName;
	}

	public String getEmployeeAccNumber() {
		return employeeAccNumber;
	}

	public void setEmployeeAccNumber(String employeeAccNumber) {
		this.employeeAccNumber = employeeAccNumber;
	}

	public String getEmployeeBankBranch() {
		return employeeBankBranch;
	}

	public void setEmployeeBankBranch(String employeeBankBranch) {
		this.employeeBankBranch = employeeBankBranch;
	}

	public String getEmployeeIFSCCode() {
		return employeeIFSCCode;
	}

	public void setEmployeeIFSCCode(String employeeIFSCCode) {
		this.employeeIFSCCode = employeeIFSCCode;
	}

	public String getDesignation() {
		return designation;
	}

	public void setDesignation(String designation) {
		this.designation = designation;
	}

	public String getAddSideBarJs() {
		return addSideBarJs;
	}

	public void setAddSideBarJs(String addSideBarJs) {
		this.addSideBarJs = addSideBarJs;
	}


	public void setSession(Map<String, Object> map) {  
	    sessionMap=(SessionMap<String, Object>)map;  
	}


	public SessionMap<String, Object> getSessionMap() {
		return sessionMap;
	}

	public void setSessionMap(SessionMap<String, Object> sessionMap) {
		this.sessionMap = sessionMap;
	}
}
