package main_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.IOException;
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;

@ManagedBean(name="addCreditCurrentAssetBank")
@ViewScoped

public class AddCreditCurrentAssetBankBean implements Serializable
{
	String transfer="",bankName="",submittedBankName="",chequeNo="",bankBranch="",address="",description="",accNo="",paymentMode="cheque";
	double amount=0.0;
	boolean value1,value2,showTransfer;
	Date date=new Date(),chequeDate;
	ArrayList<SelectItem> bankList;
	BankInfo bank_info;
	DataBaseMethods obj=new DataBaseMethods();
	DataBaseAutoCompAndDuplicate obj1=new DataBaseAutoCompAndDuplicate();
	DataBaseIncomeExpense obj3=new DataBaseIncomeExpense();
	
	
	public AddCreditCurrentAssetBankBean() 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		bankList=new DataBaseIncomeExpense().allBankList(conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void checkTransferMode()
	{
		if(transfer.equals("Yes"))
		{
			showTransfer=true;
		}
		else
		{
			showTransfer=false;
		}
	}
	
	public void checkBank()
	{
		Connection conn =DataBaseConnection.JAVAConnection();
		bank_info=new DataBaseMethods().obtainBankInfoById(bankName,conn);
		bankBranch=bank_info.bank_branch;
		address=bank_info.address;
		accNo=bank_info.acc_no;

		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}

		
	}
	
	public void addCredit() throws IOException
	{
	    System.out.println("=================================================");
	    System.out.println("FUNCTION START : addCredit()");
	    System.out.println("=================================================");

	    System.out.println("addCredit() :: paymentMode = " + paymentMode);
	    System.out.println("addCredit() :: transfer = " + transfer);
	    System.out.println("addCredit() :: bankName = " + bankName);
	    System.out.println("addCredit() :: bankBranch = " + bankBranch);
	    System.out.println("addCredit() :: accNo = " + accNo);
	    System.out.println("addCredit() :: address = " + address);
	    System.out.println("addCredit() :: amount = " + amount);
	    System.out.println("addCredit() :: date = " + date);
	    System.out.println("addCredit() :: description = " + description);
	    System.out.println("addCredit() :: chequeNo = " + chequeNo);
	    System.out.println("addCredit() :: chequeDate = " + chequeDate);
	    System.out.println("addCredit() :: submittedBankName = " + submittedBankName);


	    System.out.println("addCredit() :: Calling FacesContext.getCurrentInstance()");
	    HttpSession ss=(HttpSession) FacesContext.getCurrentInstance()
	            .getExternalContext().getSession(false);

	    System.out.println("addCredit() :: Session = " + ss);

	    int branchId = (int) ss.getAttribute("branchId");

	    System.out.println("addCredit() :: branchId = " + branchId);


	    System.out.println("addCredit() :: Calling DataBaseConnection.JAVAConnection()");
	    Connection conn= DataBaseConnection.JAVAConnection();

	    System.out.println("addCredit() :: Connection = " + conn);


	    if(paymentMode.equalsIgnoreCase("cheque") && transfer.equalsIgnoreCase("No"))
	    {
	        System.out.println("addCredit() :: Condition matched: paymentMode=cheque AND transfer=No");

	        submittedBankName="N/A";

	        System.out.println("addCredit() :: submittedBankName changed to = " + submittedBankName);
	    }


	    System.out.println("-------------------------------------------------");
	    System.out.println("addCredit() :: Calling DataBaseMethods.currentBankBalance()");
	    System.out.println("addCredit() :: currentBankBalance PARAM bankName = " + bankName);
	    System.out.println("addCredit() :: currentBankBalance PARAM conn = " + conn);

	    double remainingAmountInBank=
	            new DataBaseMethods().currentBankBalance(bankName, conn);

	    System.out.println("addCredit() :: DataBaseMethods.currentBankBalance() RETURN = "
	            + remainingAmountInBank);
	    System.out.println("-------------------------------------------------");


	    // if(amount<=remainingAmountInBank)
	    {
	        System.out.println("addCredit() :: Calling DataBaseIncomeExpense.addCurrentAssetBankCredit()");

	        System.out.println("addCurrentAssetBankCredit PARAM branchId = " + branchId);
	        System.out.println("addCurrentAssetBankCredit PARAM bankName = " + bankName);
	        System.out.println("addCurrentAssetBankCredit PARAM bankBranch = " + bankBranch);
	        System.out.println("addCurrentAssetBankCredit PARAM accNo = " + accNo);
	        System.out.println("addCurrentAssetBankCredit PARAM address = " + address);
	        System.out.println("addCurrentAssetBankCredit PARAM amount = " + amount);
	        System.out.println("addCurrentAssetBankCredit PARAM date = " + date);
	        System.out.println("addCurrentAssetBankCredit PARAM description = " + description);
	        System.out.println("addCurrentAssetBankCredit PARAM paymentMode = " + paymentMode);
	        System.out.println("addCurrentAssetBankCredit PARAM chequeNo = " + chequeNo);
	        System.out.println("addCurrentAssetBankCredit PARAM chequeDate = " + chequeDate);
	        System.out.println("addCurrentAssetBankCredit PARAM submittedBankName = " + submittedBankName);


	        int n=new DataBaseIncomeExpense().addCurrentAssetBankCredit(
	                branchId,
	                bankName,
	                bankBranch,
	                accNo,
	                address,
	                amount,
	                date,
	                description,
	                paymentMode,
	                chequeNo,
	                chequeDate,
	                submittedBankName
	        );


	        System.out.println("addCredit() :: DataBaseIncomeExpense.addCurrentAssetBankCredit() RETURN n = " + n);


	        if(n>=1)
	        {
	            System.out.println("addCredit() :: n >= 1");


	            System.out.println("-------------------------------------------------");
	            System.out.println("addCredit() :: Calling DataBaseMethods.decreaseBankBalance()");
	            System.out.println("decreaseBankBalance PARAM bankName = " + bankName);
	            System.out.println("decreaseBankBalance PARAM amount = " + amount);
	            System.out.println("decreaseBankBalance PARAM conn = " + conn);

	            new DataBaseMethods().decreaseBankBalance(
	                    bankName,
	                    amount,
	                    conn
	            );

	            System.out.println("addCredit() :: DataBaseMethods.decreaseBankBalance() COMPLETED");
	            System.out.println("-------------------------------------------------");


	            System.out.println("addCredit() :: transfer = " + transfer);


	            if(transfer.equals("Yes"))
	            {
	                System.out.println("addCredit() :: Transfer = Yes");


	                System.out.println("-------------------------------------------------");
	                System.out.println("addCredit() :: Calling DataBaseMethods.increaseBankBalance()");
	                System.out.println("increaseBankBalance PARAM submittedBankName = " + submittedBankName);
	                System.out.println("increaseBankBalance PARAM amount = " + amount);
	                System.out.println("increaseBankBalance PARAM conn = " + conn);

	                new DataBaseMethods().increaseBankBalance(
	                        submittedBankName,
	                        amount,
	                        conn
	                );

	                System.out.println("addCredit() :: DataBaseMethods.increaseBankBalance() COMPLETED");
	                System.out.println("-------------------------------------------------");
	            }
	            else
	            {
	                System.out.println("addCredit() :: Transfer is not Yes");


	                System.out.println("-------------------------------------------------");
	                System.out.println("addCredit() :: Calling DataBaseMethods.increaseCompanyCapitalAmount()");
	                System.out.println("increaseCompanyCapitalAmount PARAM branchId = " + branchId);
	                System.out.println("increaseCompanyCapitalAmount PARAM amount = " + amount);
	                System.out.println("increaseCompanyCapitalAmount PARAM conn = " + conn);

	                new DataBaseMethods().increaseCompanyCapitalAmount(
	                        branchId,
	                        amount,
	                        conn
	                );

	                System.out.println("addCredit() :: DataBaseMethods.increaseCompanyCapitalAmount() COMPLETED");
	                System.out.println("-------------------------------------------------");
	            }


	            System.out.println("addCredit() :: Calling FacesContext.addMessage()");

	            FacesContext.getCurrentInstance().addMessage(
	                    null,
	                    new FacesMessage("Amount Credited Successfully!")
	            );


	            System.out.println("addCredit() :: Calling FacesContext.redirect()");
	            System.out.println("addCredit() :: Redirect URL = mainDashBoard.xhtml");

	            FacesContext.getCurrentInstance()
	                    .getExternalContext()
	                    .redirect("mainDashBoard.xhtml");

	            System.out.println("addCredit() :: Redirect completed");
	        }


	        System.out.println("addCredit() :: Closing database connection");

	        try
	        {
	            System.out.println("addCredit() :: Calling Connection.close()");
	            conn.close();
	            System.out.println("addCredit() :: Connection.close() COMPLETED");
	        }
	        catch (Exception e)
	        {
	            // TODO: handle exception
	        }

	        System.out.println("addCredit() :: Database connection close attempted");
	    }


	    /*else
	    {
	        FacesContext fc=FacesContext.getCurrentInstance();
	        fc.addMessage(null, new FacesMessage("Sorry! Transaction Can't Be Treated. Specified Bank's Balance is '"+remainingAmountInBank+"'"));

	    }*/


	    System.out.println("=================================================");
	    System.out.println("FUNCTION END : addCredit()");
	    System.out.println("=================================================");
	}

	public String getTransfer() {
		return transfer;
	}

	public void setTransfer(String transfer) {
		this.transfer = transfer;
	}

	public String getBankName() {
		return bankName;
	}

	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

	public String getSubmittedBankName() {
		return submittedBankName;
	}

	public void setSubmittedBankName(String submittedBankName) {
		this.submittedBankName = submittedBankName;
	}

	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 getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public String getDescription() {
		return description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public String getAccNo() {
		return accNo;
	}

	public void setAccNo(String accNo) {
		this.accNo = accNo;
	}

	public String getPaymentMode() {
		return paymentMode;
	}

	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}

	public double getAmount() {
		return amount;
	}

	public void setAmount(double amount) {
		this.amount = amount;
	}

	public boolean isValue1() {
		return value1;
	}

	public void setValue1(boolean value1) {
		this.value1 = value1;
	}

	public boolean isValue2() {
		return value2;
	}

	public void setValue2(boolean value2) {
		this.value2 = value2;
	}

	public boolean isShowTransfer() {
		return showTransfer;
	}

	public void setShowTransfer(boolean showTransfer) {
		this.showTransfer = showTransfer;
	}

	public Date getDate() {
		return date;
	}

	public void setDate(Date date) {
		this.date = date;
	}

	public Date getChequeDate() {
		return chequeDate;
	}

	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}

	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public BankInfo getBank_info() {
		return bank_info;
	}

	public void setBank_info(BankInfo bank_info) {
		this.bank_info = bank_info;
	}
	
	

}
