package main_package;

import java.io.Serializable;
import java.sql.Connection;
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.servlet.http.HttpSession;

import org.primefaces.context.RequestContext;

@ManagedBean(name="manageCompanyBank")
@ViewScoped
public class ManageCompanyBankBean implements Serializable
{
	DataBaseMethods obj=new DataBaseMethods();
	Date entryDate, chkDate=new Date();
	String description="",bankBranch="",id,bankName="",accNo="",bankAddress="",bankCode="",bankIFSC="",amount="0.0";
	BankInfo selectedBank;
	ArrayList<BankInfo> bank_info;
	double cashBalance=0, totalIn, totalOut, closingBalance, currentBalance;
	
	public ManageCompanyBankBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		 entryDate=new Date();
		bank_info = obj.allBankInfo();
		Connection conn=DataBaseConnection.JAVAConnection();
		cashBalance=obj.remainingCompanyCapitalAmount(branchId,conn);
		cashBalance=Double.parseDouble(new DecimalFormat("##.##").format(cashBalance));
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	
	 // This Method 
	 public void addBankAcc()
	 {
		 
		 HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			int branchId =(int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		 int n=obj.addBank(branchId,entryDate,bankName,bankBranch,bankAddress,accNo,bankCode,bankIFSC,description,amount,conn);
			try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		 if(n>=1)
		 {
			 FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Bank Added Successfully!"));
			 amount="0.0";
			 description=bankBranch=bankName=accNo=bankAddress=bankCode=bankIFSC="";
			 entryDate=new Date();
			 bank_info = obj.allBankInfo();
		 }
		 else
		 {
			 FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
		 }
	 }
	 
	 
	public void editDetails()
	{
		entryDate=selectedBank.getEntry_date();
		bankName = selectedBank.getBank_name();
		bankBranch = selectedBank.getBank_branch();
		bankAddress = selectedBank.getAddress();
		accNo=selectedBank.getAcc_no();
		bankCode=selectedBank.getBank_code();
		bankIFSC=selectedBank.getBank_IFSC();
		description=selectedBank.getDescription();
		id =  selectedBank.id;
		currentBalance=selectedBank.getAmount();
	}
	
	/*public void findClosingCashBalance()
	{
		totalIn=totalOut=closingBalance=0;
		totalIn=Double.parseDouble(new DecimalFormat("##.##").format(obj.closingCashInBalance(chkDate)));
		totalOut=Double.parseDouble(new DecimalFormat("##.##").format(obj.closingCashOutBalance(chkDate)));
		closingBalance=totalIn-totalOut;
	}*/
	
	public void update()
	{
		
			int n = obj.updateBank(id,entryDate,bankName,bankBranch,bankAddress,accNo,bankCode,bankIFSC,description,currentBalance);
			if(n>=1)
			{
				FacesContext fc=FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("Bank Updated Successfully"));
				bank_info = obj.allBankInfo();
				
				RequestContext.getCurrentInstance().execute("PF('editDialog').hide()");
				RequestContext.getCurrentInstance().update("form3");
				RequestContext.getCurrentInstance().update("instlmnt");
			}
			else
			{
				FacesContext fc=FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("An Error Occured...Please Try Again"));
			}
		
	}

	public double getCashBalance() {
		return cashBalance;
	}

	public void setCashBalance(double cashBalance) {
		this.cashBalance = cashBalance;
	}

	public Date getEntryDate() {
		return entryDate;
	}

	public void setEntryDate(Date entryDate) {
		this.entryDate = entryDate;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public String getBankBranch() {
		return bankBranch;
	}

	public void setBankBranch(String bankBranch) {
		this.bankBranch = bankBranch;
	}

	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public String getBankName() {
		return bankName;
	}

	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

	public String getAccNo() {
		return accNo;
	}

	public void setAccNo(String accNo) {
		this.accNo = accNo;
	}

	public String getBankAddress() {
		return bankAddress;
	}

	public void setBankAddress(String bankAddress) {
		this.bankAddress = bankAddress;
	}

	public String getBankCode() {
		return bankCode;
	}

	public void setBankCode(String bankCode) {
		this.bankCode = bankCode;
	}

	public String getBankIFSC() {
		return bankIFSC;
	}

	public void setBankIFSC(String bankIFSC) {
		this.bankIFSC = bankIFSC;
	}

	public BankInfo getSelectedBank() {
		return selectedBank;
	}

	public void setSelectedBank(BankInfo selectedBank) {
		this.selectedBank = selectedBank;
	}

	public ArrayList<BankInfo> getBank_info() {
		return bank_info;
	}

	public void setBank_info(ArrayList<BankInfo> bank_info) {
		this.bank_info = bank_info;
	}

	public Date getChkDate() {
		return chkDate;
	}

	public void setChkDate(Date chkDate) {
		this.chkDate = chkDate;
	}

	public double getTotalIn() {
		return totalIn;
	}

	public void setTotalIn(double totalIn) {
		this.totalIn = totalIn;
	}

	public double getTotalOut() {
		return totalOut;
	}

	public void setTotalOut(double totalOut) {
		this.totalOut = totalOut;
	}

	public double getClosingBalance() {
		return closingBalance;
	}

	public void setClosingBalance(double closingBalance) {
		this.closingBalance = closingBalance;
	}


	public double getCurrentBalance() {
		return currentBalance;
	}


	public void setCurrentBalance(double currentBalance) {
		this.currentBalance = currentBalance;
	}
	

}
