package main_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.Serializable;
import java.sql.Connection;
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.DataBaseMethods;
import main_package.DataBaseMethodsSalary;

@ManagedBean(name="emppds")
@ViewScoped
public class EmployeePayDeductSubmissionBean implements Serializable
{
	String empPayCat, name, description, selectedName, paymentMode,chequeNo,bankBranch,bankName, label, borrowAmount, selectedEmployee;
	ArrayList<SelectItem> list, bankList, empList;
	boolean showCheque;
	double amount, leftAmount;
	int no;
	Date payDate=new Date(), chequeDate;
	BankInfo bank_info;
	DataBaseMethods obj=new DataBaseMethods();
	public EmployeePayDeductSubmissionBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		empPayCat=(String) ss.getAttribute("payCat");
		int branchId =(int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		empList=obj.employeeList(branchId,conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void calculateLeftAmount()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		double tot=obj.employeePayDeductAmount(empPayCat, selectedEmployee);
		double paid=obj.employeeSubmitPayDeductAmount(branchId,empPayCat);
		leftAmount=tot-paid;
		amount=leftAmount;
	}
	
	public void checkPaymentMode()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		if(paymentMode.equals("Cash"))
		{
			showCheque=false;
		}
		
		else if(paymentMode.equals("Cheque") || paymentMode.equals("Demand Draft")|| paymentMode.equals("neft"))
		{
			bankList=new ArrayList<>();
			bankList=new DataBaseIncomeExpense().allBankList(conn);
			if(paymentMode.equals("Cheque"))
			{
				label="Cheque";
			}
			else if(paymentMode.equals("neft"))
			{
				label="NEFT/RTGS/IMPS";
			}
			else
			{
				label="Demand Draft";
			}
			showCheque=true;
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}	
	
	
	public void checkBank()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		bank_info=obj.obtainBankInfoById(bankName,conn);
		bankBranch=bank_info.getBank_branch();
	/*	address=bank_info.address;
		accNo=bank_info.acc_no;*/
	}

	public String addDetail()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		if(amount<=0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Amount Should be Greater than zero. Please Check..."));
		}
		else if(amount>leftAmount)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Amount Should be Less than or Equal Left Amount. Please Check..."));
		}
		else
		{
			int i=obj.addEmplyeeSubmission(payDate,empPayCat,paymentMode,amount,chequeNo,bankBranch,bankName,chequeDate,
					description, selectedEmployee,branchId);
			if(i>0)
			{
				//no=obj.nextNo("borrower");
				if(paymentMode.equals("Cash"))
				{
				  	//obj.decreaseCapitalCompanyAmount(amount);
				  	FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("TDS Submission Sucessfully. Transaction Completed."));
				}
				else
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("TDS Submission  Sucessfully. Please Approve Cheque to complete the transaction."));
				}
				
				return "cashInOutFlow.xhtml";
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!"));
				
			}
		}
		
		return "";
	}
	
	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public String getSelectedName() {
		return selectedName;
	}

	public void setSelectedName(String selectedName) {
		this.selectedName = selectedName;
	}

	public String getPaymentMode() {
		return paymentMode;
	}

	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}

	public String getChequeNo() {
		return chequeNo;
	}

	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}

	public String getBankBranch() {
		return bankBranch;
	}

	public void setBankBranch(String bankBranch) {
		this.bankBranch = bankBranch;
	}

	public String getBankName() {
		return bankName;
	}

	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public String getBorrowAmount() {
		return borrowAmount;
	}

	public void setBorrowAmount(String borrowAmount) {
		this.borrowAmount = borrowAmount;
	}

	public ArrayList<SelectItem> getList() {
		return list;
	}

	public void setList(ArrayList<SelectItem> list) {
		this.list = list;
	}

	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public boolean isShowCheque() {
		return showCheque;
	}

	public void setShowCheque(boolean showCheque) {
		this.showCheque = showCheque;
	}

	public double getAmount() {
		return amount;
	}

	public void setAmount(double amount) {
		this.amount = amount;
	}

	public Date getPayDate() {
		return payDate;
	}

	public void setPayDate(Date payDate) {
		this.payDate = payDate;
	}

	public Date getChequeDate() {
		return chequeDate;
	}

	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}

	public String getEmpPayCat() {
		return empPayCat;
	}

	public void setEmpPayCat(String empPayCat) {
		this.empPayCat = empPayCat;
	}

	public String getSelectedEmployee() {
		return selectedEmployee;
	}

	public void setSelectedEmployee(String selectedEmployee) {
		this.selectedEmployee = selectedEmployee;
	}

	public ArrayList<SelectItem> getEmpList() {
		return empList;
	}

	public void setEmpList(ArrayList<SelectItem> empList) {
		this.empList = empList;
	}

	public double getLeftAmount() {
		return leftAmount;
	}

	public void setLeftAmount(double leftAmount) {
		this.leftAmount = leftAmount;
	}

	public int getNo() {
		return no;
	}

	public void setNo(int no) {
		this.no = no;
	}

	public BankInfo getBank_info() {
		return bank_info;
	}

	public void setBank_info(BankInfo bank_info) {
		this.bank_info = bank_info;
	}
	
	
}
