package group_head_package;

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.servlet.http.HttpSession;

import main_package.DataBaseMethods;
import main_package.DataBaseConnection;

@ManagedBean(name="viewDeleteFixedDepositIncome")
@ViewScoped

public class ViewDeleteFixedDepositIncomeBean implements Serializable
{
	ArrayList<IncomeList>dList;
    IncomeList selectedIncome;
    Date startDate=new Date(),endDate=new Date();
    public ViewDeleteFixedDepositIncomeBean()
    {
    	HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
    	Connection conn=DataBaseConnection.JAVAConnection();
    	startDate.setDate(1);
    	dList=new  DataBaseIncomeExpense().allFixedDepositIncomeList(branchId,startDate,endDate,conn);
    	try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
    }
    
	public void searchIncome()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		dList=new  DataBaseIncomeExpense().allFixedDepositIncomeList(branchId,startDate,endDate,conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}

	public void deleteSelectedIncome()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		String pMode=selectedIncome.getPaymentMode();
		Double amt=selectedIncome.getAmount();
		String bankId=selectedIncome.getTransferBank();
		int i=new DataBaseIncomeExpense().deleteFixedDepositIncome(selectedIncome,conn);
		if(i>=1)
		{
			dList=new DataBaseIncomeExpense().allFixedDepositIncomeList(branchId,startDate, endDate,conn);
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Record Deleted successfully"));
			if(pMode.equals("Cash") && ( bankId==null || bankId.equals("N/A")))
            {
            	new DataBaseMethods().decreaseCapitalCompanyAmount(branchId,amt);
            }
            else if(pMode.equals("Cash") && (!bankId.equals("N/A") && bankId!=null))
            {
            	new DataBaseMethods().decreaseBankBalance(bankId, amt,conn);
            }
            else if(pMode.equals("Cheque"))
            {
            	new DataBaseMethods().decreaseBankBalance(bankId, amt,conn);
            }
			try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
		else
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("An error found, try again"));
		}
	}

	public ArrayList<IncomeList> getdList() {
		return dList;
	}

	public void setdList(ArrayList<IncomeList> dList) {
		this.dList = dList;
	}

	public IncomeList getSelectedIncome() {
		return selectedIncome;
	}

	public void setSelectedIncome(IncomeList selectedIncome) {
		this.selectedIncome = selectedIncome;
	}

	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;
	}

	
}
