package com.reallinkbilling.update;


import java.io.File;
import java.io.FileInputStream;
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.reallinkbilling.cipher.EncryptionDecryption;
import com.reallinkbilling.db.GetDBConnection;
import com.reallinkbilling.resource.CheckAlreadyAvailable;
import com.opensymphony.xwork2.ActionSupport;

public class UpdateEmployeeDetails extends ActionSupport implements SessionAware{

	/**
	 * 
	 */
	private static final long serialVersionUID = 6208411094853732491L;
	private SessionMap<String,Object> sessionMap;  
	
	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 String key;
	
	public String execute() {
		 
		String result = "login";
	
		
	        if(this.getSessionMap()==null || this.getSessionMap().get("login")==null){ 
	        	addActionMessage("Please Logout and Login again !");
	        	result = "login";
	        }  
	        else{
	        	
	        	String shopId = (String) this.getSessionMap().get("shopId");
	    		String shopCode = (String) this.getSessionMap().get("shopCode");
	    	
	    		Connection connection = null;
				PreparedStatement preparedStatement= null;
				ResultSet resultSet = null;
			
				String employeeId = EncryptionDecryption.decrypt(this.getKey());
				String sql = "";
				String db = (String)  this.getSessionMap().get("db");
				FileInputStream fis =  null;
				 
 				
				try
				{
					if(this.getEmployeeImage() != null )
	 				{
	 					fis =  new FileInputStream(getEmployeeImage());
	 				}
					
					connection = GetDBConnection.getDBConnection(db);
					if(this.getEmployeeImage() != null)
					{
						sql = "UPDATE "
								+ "shop_employee_master "
								+ "SET "
								+ "employee_name = ?,"
								+ "employee_mobile_number = ?,"
								+ "employee_address = ?,"
								+ "employee_birth_date = STR_TO_DATE(?,'%d-%m-%Y'),"
								+ "employee_image = ?,"
								+ "employee_aadhar_number = ?,"
								+ "employee_pan_number = ?,"
								+ "employee_bank_name = ?,"
								+ "employee_bank_acc_number = ?,"
								+ "employee_bank_ifsc_code = ?,"
								+ "employee_bank_branch = ?,"
								+ "employee_designation = ? "
								+ "WHERE "
								+ "employee_id = ? "
								+ "AND "
								+ "shop_id = ? "
								+ "AND "
								+ "shop_code = ? ";
						
						preparedStatement = connection.prepareStatement(sql);
						preparedStatement.setString(1, this.getEmployeeName().trim().toUpperCase());
						preparedStatement.setString(2, this.getEmployeeMobileNumber().trim().toUpperCase());
						preparedStatement.setString(3, this.getAddress().trim().toUpperCase());
						preparedStatement.setString(4, this.getBirthDate());
						preparedStatement.setBinaryStream(5, fis,(int)this.getEmployeeImage().length() );
						preparedStatement.setString(6, this.getEmployeeAADHARNumber().trim().toUpperCase());
						preparedStatement.setString(7, this.getEmployeePANNumber().trim().toUpperCase());
						preparedStatement.setString(8, this.getEmployeeBankName().trim().toUpperCase());
						preparedStatement.setString(9, this.getEmployeeAccNumber().trim().toUpperCase());
						preparedStatement.setString(10, this.getEmployeeIFSCCode().trim().toUpperCase());
						preparedStatement.setString(11, this.getEmployeeBankBranch().trim().toUpperCase());
						preparedStatement.setString(12, this.getDesignation());
						preparedStatement.setString(13, employeeId);
						preparedStatement.setString(14, shopId);
						preparedStatement.setString(15, shopCode);
						
						
					}
					else
					{
						sql = "UPDATE "
								+ "shop_employee_master "
								+ "SET "
								+ "employee_name = ?,"
								+ "employee_mobile_number = ?,"
								+ "employee_address = ?,"
								+ "employee_birth_date = STR_TO_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 = ? "
								+ "WHERE "
								+ "employee_id = ? "
								+ "AND "
								+ "shop_id = ? "
								+ "AND "
								+ "shop_code = ? ";
						
						preparedStatement = connection.prepareStatement(sql);
						preparedStatement.setString(1, this.getEmployeeName().trim().toUpperCase());
						preparedStatement.setString(2, this.getEmployeeMobileNumber().trim().toUpperCase());
						preparedStatement.setString(3, this.getAddress().trim().toUpperCase());
						preparedStatement.setString(4, this.getBirthDate());
						preparedStatement.setString(5, this.getEmployeeAADHARNumber().trim().toUpperCase());
						preparedStatement.setString(6, this.getEmployeePANNumber().trim().toUpperCase());
						preparedStatement.setString(7, this.getEmployeeBankName().trim().toUpperCase());
						preparedStatement.setString(8, this.getEmployeeAccNumber().trim().toUpperCase());
						preparedStatement.setString(9, this.getEmployeeIFSCCode().trim().toUpperCase());
						preparedStatement.setString(10, this.getEmployeeBankBranch().trim().toUpperCase());
						preparedStatement.setString(11, this.getDesignation());
						preparedStatement.setString(12, employeeId);
						preparedStatement.setString(13, shopId);
						preparedStatement.setString(14, shopCode);
					}
					int k = preparedStatement.executeUpdate();
					
					if(k > 0)
					{
						result = SUCCESS;
						addActionMessage("Employee details updated successfully!");
					}
					else
					{
						result = ERROR;
						addActionError("Details not updated! Please try again!");
					}
					
				}
				catch (SQLException e) {
					result = "error";
					
					addActionError(e.getErrorCode()+" || "+e.getMessage() +" || Something Went Wrong !");
				}
				catch (Exception e) {
						result = "error";
					
					addActionError(e.getMessage() +" || Something Went Wrong !");
				}
				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 void validate() {
		
	  	this.setDesignationList((HashMap<String, String>) this.getSessionMap().get("designationlist"));
    	this.setAddSideBarJs("FALSE");
    	
    	String employeeId = EncryptionDecryption.decrypt(this.getKey());
   	   
    	this.getDesignationList().put("", "--- SELECT DESIGNATION ---");
		
		if(this.getEmployeeName() == null || this.getEmployeeName().equals(""))
		{
			addActionError("Please provide Employee name!");
		}
		
		if(!hasActionErrors())
		{
			if(this.getEmployeeMobileNumber() == null || this.getEmployeeMobileNumber().equals(""))
			{
				addActionError("Please provide Employee mobile number!");
			}else if(this.getEmployeeMobileNumber().length() != 10)
			{
				addActionError("Please provide Employee mobile number!");
			}
		}
		
		
		if(!hasActionErrors())
		{
			if(this.getAddress() == null || this.getAddress().equals(""))
			{
				addActionError("Please provide correct address!");
			}
				
		}
		
		if(!hasActionErrors())
		{
			if(this.getBirthDate() == null || this.getBirthDate().equals(""))
			{
				addActionError("Please select Employee birth date!");
			}
		}
		
		
		if(!hasActionErrors())
		{
			String isCustomerAdded = "false";
			
			String [] result = new String[2];
			String condition  = "AND employee_id <> "+employeeId+" ";
			result = new CheckAlreadyAvailable().checkAvaibility("shop_employee_master", "employee_mobile_number", condition,this.getEmployeeMobileNumber(), this.getSessionMap());
			
			isCustomerAdded = result[0];
			
			if(isCustomerAdded.equals("true"))
			{
				addActionError("Employee is already added with same name OR mobile number!");
			}				
			
		}
		
		if(!hasActionErrors())
		{
			if(this.getEmployeeAADHARNumber() == null || this.getEmployeeAADHARNumber().equals(""))
			{
				addActionError("Please provide employee AADHAR number!");
			}
		}
		
		if(!hasActionErrors())
		{
			if(this.getEmployeePANNumber() == null || this.getEmployeePANNumber().equals(""))
			{
				addActionError("Please provide employee PAN number!");
			}
		}
		if(!hasActionErrors())
		{
			if(this.getEmployeeBankName() == null || this.getEmployeePANNumber().equals(""))
			{
				addActionError("Please provide employee Bank Name!");
			}
		}
		
		if(!hasActionErrors())
		{
			if(this.getEmployeeIFSCCode() == null || this.getEmployeeIFSCCode().equals(""))
			{
				addActionError("Please provide bank IFSC code!");
			}
		}
		
		if(!hasActionErrors())
		{
			if(this.getEmployeeBankBranch() == null || this.getEmployeeBankBranch().equals(""))
			{
				addActionError("Please provide branch name!");
			}
		}
		if(!hasActionErrors())
		{
			if(this.getDesignation() == null || this.getDesignation().equals(""))
			{
				addActionError("Please select designation of employee!");
			}
		}
		
	}
	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 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 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 static long getSerialversionuid() {
		return serialVersionUID;
	}


	public String getKey() {
		return key;
	}

	public void setKey(String key) {
		this.key = key;
	}

	public SessionMap<String, Object> getSessionMap() {
		return sessionMap;
	}

	public void setSessionMap(SessionMap<String, Object> sessionMap) {
		this.sessionMap = sessionMap;
	}

	public void setSession(Map<String, Object> map) {  
	    sessionMap=(SessionMap<String, Object>)map;  
	}
	

}



