package hrm_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Date;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import main_package.DataBaseConnection;
import main_package.DataBaseMethodTaheer;
import main_package.DataBaseMethods;
import main_package.DataBaseMethodsSalary;
import main_package.EmpInfo;

@ManagedBean(name = "manageSalaryPayout")
@ViewScoped

public class ManageSalaryPayoutBean implements Serializable
{
	int count, branchId;
	
	
	double totalAmount;
	
	
	String empUserId;
	
	
	Date startDate, endDate;
	
	
	boolean showPanel;
	
	
	ArrayList<EmpInfo> list;
	ArrayList<SelectItem> empList;
	
	
	EmpInfo selectedRow;
	
	
	
	DataBaseMethodsSalary dbms = new DataBaseMethodsSalary();
	DataBaseMethods dbm = new DataBaseMethods();
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
	
	
	
	public ManageSalaryPayoutBean() 
	{
		startDate = new Date();
		endDate = new Date();
		startDate.setDate(1);
		
		Connection con = DataBaseConnection.JAVAConnection();
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		empList = dbms.allEmployeeList(branchId, con);
		
		try 
		{
			con.close();
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
	}
	
	

	public void searchData()
	{
		list = dbms.salaryPayoutData(startDate, endDate, empUserId);
		count = list.size();
		
		if(count > 0)
		{
			showPanel = true;
			totalAmount = 0;
			
			for(EmpInfo ee : list)
			{
				totalAmount += ee.getAmount();
			}
			
			totalAmount = Double.parseDouble(new DecimalFormat("##.##").format(totalAmount));
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found. "));
			showPanel = false;
		}
	}
	
	
	
	public void deleteData()
	{
		int i = 0;
		Connection conn = DataBaseConnection.JAVAConnection();
			
		if(selectedRow.getPayMode().equalsIgnoreCase("cash"))
		{   
			dbmt.updateEmpSalaryEntryPayStatus(selectedRow.getUname(), selectedRow.getMonth(), selectedRow.getYear());
			i = dbms.deleteSalaryPayoutEntry(selectedRow.getId());
			
			if(i > 0)
			{
				dbm.increaseCompanyCapitalAmount(branchId, selectedRow.getAmount(), conn);
			}
			
		}
		else if(selectedRow.getPayMode().equalsIgnoreCase("Transfer"))
		{
			FacesContext.getCurrentInstance().addMessage(null, 
							new FacesMessage("Transer Entry Option Will be Availble in Future, Please Contact to Administrator. "));
		}
		else
		{
			dbmt.updateEmpSalaryEntryPayStatus(selectedRow.getUname(), selectedRow.getMonth(), selectedRow.getYear());
			i = dbms.deleteSalaryPayoutEntry(selectedRow.getId());			
			
			if(i > 0)
			{
				dbm.increaseBankBalance(selectedRow.getSubmittedBank(), selectedRow.getAmount(), conn);
			}
		}
		
		if(i > 0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Entry Delete Sucessfully."));
			searchData();
		}
		else 
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occurred !!! "));
		}
		
		try 
		{
			conn.close();
		}
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
	}
	
	

	public ArrayList<EmpInfo> getList() {
		return list;
	}


	public void setList(ArrayList<EmpInfo> list) {
		this.list = list;
	}


	public int getCount() {
		return count;
	}


	public void setCount(int count) {
		this.count = count;
	}


	public Date getStartDate() {
		return startDate;
	}


	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}


	public Date getEndDate() {
		return endDate;
	}


	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}


	public ArrayList<SelectItem> getEmpList() {
		return empList;
	}


	public void setEmpList(ArrayList<SelectItem> empList) {
		this.empList = empList;
	}


	public boolean isShowPanel() {
		return showPanel;
	}


	public void setShowPanel(boolean showPanel) {
		this.showPanel = showPanel;
	}


	public EmpInfo getSelectedRow() {
		return selectedRow;
	}


	public void setSelectedRow(EmpInfo selectedRow) {
		this.selectedRow = selectedRow;
	}


	public String getEmpUserId() {
		return empUserId;
	}


	public void setEmpUserId(String empUserId) {
		this.empUserId = empUserId;
	}

	public double getTotalAmount() {
		return totalAmount;
	}

	public void setTotalAmount(double totalAmount) {
		this.totalAmount = totalAmount;
	}
	
}