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 java.util.List;

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;

@ManagedBean(name="employeeSalaryPayout")
@ViewScoped

public class EmployeeSalaryPayoutBean implements Serializable
{
	String name, description, selectedName, paymentMode,chequeNo,savingAccountNo,bankBranch,bankName, label, borrowAmount, savingNo;
	ArrayList<SelectItem> list, bankList;
	public static List<String> savingAccList;
	boolean showCheque,showTransfer;
	double amount;
	UserInfo savingDetail;
	int no;
	Date payDate=new Date(), chequeDate;
	BankInfo bank_info;
	DataBaseMethods obj=new DataBaseMethods();
	public EmployeeSalaryPayoutBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		
		//no=obj.nextNo("borrower");
		Connection conn=DataBaseConnection.JAVAConnection();
		list=new DataBaseMethodsSalary().allEmployeeList(branchId,conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void savingAccountDetail()
	{
		
		//System.out.println("sv: "+savingAccountNo);
		if(savingAccountNo.contains("/"))
		{
			savingNo=savingAccountNo.substring(0,savingAccountNo.indexOf("/"));
		}
		
		savingDetail=obj.savingAccountDetailByAccountNo(savingNo);
	}
	
	public List<String> completeText(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		savingAccList=new DataBaseAutoCompAndDuplicate().savingAccountNo(branchId,name);
		if(savingAccList.size()==0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Saving Account Is not opened till now of Selected Share Holder"));
		}
		return savingAccList;
	}
	
	public void checkPaymentMode()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		if(paymentMode.equalsIgnoreCase("Cash"))
		{
			showCheque=false;
		}
		else if(paymentMode.equalsIgnoreCase("Transfer"))
		{
			showCheque=false;
			showTransfer=true;
		}
		
		else
		{
			bankList=new ArrayList<>();
			bankList=new DataBaseIncomeExpense().allBankList(conn);
			label=paymentMode;
			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;*/
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}

	public String addReturnBorrow()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		 int branchId = (int) ss.getAttribute("branchId");
		if(paymentMode.equalsIgnoreCase("Transfer"))
		{
			savingAccountDetail();
		}
		
		if(amount<=0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Amount Should be Greater than zero. Please Check..."));
		}
		else
		{ 
			int i=obj.addSalaryPayout(selectedName, amount,"Debit", payDate, paymentMode, chequeNo, chequeDate, bankName, bankBranch,description,branchId,"","");
			if(i>0)
			{
				//no=obj.nextNo("borrower");
				if(paymentMode.equalsIgnoreCase("Cash"))
				{
				  	obj.decreaseCapitalCompanyAmount(branchId,amount);
				  	FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Employee Salary Payout Sucessfully. Transaction Completed."));
				}
				else if(paymentMode.equalsIgnoreCase("Transfer"))
				{
					obj.increaseSavingAccountAmountForOdLoan(amount, savingNo);
					int a=obj.userDeposit(branchId,savingNo,String.valueOf(amount) , payDate, paymentMode, chequeNo, chequeDate,
							bankName, "approved", "N/A", "Salary Credit","");
					/*new DataBaseIncomeExpense().addExpense(payDate, "Other_Dr", paymentMode, String.valueOf(amount), chequeNo, bankBranch, bankName, chequeDate, 
							"Salary Credit", "Salary Credit", "0", "0", 0,"0");*/
					
					// Comment By Mr. Chetan Garg  4 Feb
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Employee Salary Payout Sucessfully. Transaction Completed."));
				}
				else
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Employee Salary Payout Sucessfully. Transaction Completed."));
				}
				
				return "employeeSalaryPayout";
			}
			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 getSavingAccountNo() {
		return savingAccountNo;
	}

	public void setSavingAccountNo(String savingAccountNo) {
		this.savingAccountNo = savingAccountNo;
	}

	public String getSavingNo() {
		return savingNo;
	}

	public void setSavingNo(String savingNo) {
		this.savingNo = savingNo;
	}

	public static List<String> getSavingAccList() {
		return savingAccList;
	}

	public static void setSavingAccList(List<String> savingAccList) {
		EmployeeSalaryPayoutBean.savingAccList = savingAccList;
	}

	public boolean isShowTransfer() {
		return showTransfer;
	}

	public void setShowTransfer(boolean showTransfer) {
		this.showTransfer = showTransfer;
	}

	public UserInfo getSavingDetail() {
		return savingDetail;
	}

	public void setSavingDetail(UserInfo savingDetail) {
		this.savingDetail = savingDetail;
	}

	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;
	}

	public DataBaseMethods getObj() {
		return obj;
	}

	public void setObj(DataBaseMethods obj) {
		this.obj = obj;
	}
	
	
}
