package main_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.Serializable;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.SQLException;
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="instanceBorrow")
@ViewScoped
public class InstantBorrowBean implements Serializable
{
	String name, description, selectedName, paymentMode,chequeNo,bankBranch,bankName, label, borrowAmount;
	ArrayList<SelectItem> list, bankList;
	boolean showCheque, showExtraAmt;
	double amount, extraAmount;
	int no;
	Date borrowDate=new Date(), chequeDate;
	BankInfo bank_info;
	DataBaseMethods obj=new DataBaseMethods();
	
	public InstantBorrowBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		no=obj.nextNo("borrower",branchId);
		list=obj.allBorrowerOrLenderList(branchId,"borrower");
	}
	
	public void checkPaymentMode()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		if(paymentMode.equalsIgnoreCase("Cash"))
		{
			showCheque=false;
			showExtraAmt=true;
		}
		
		else
		{
			bankList=new ArrayList<>();
			bankList=new DataBaseIncomeExpense().allBankList(conn);
			label=paymentMode;
			showCheque=true;
			showExtraAmt=false;
		}
		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 void checkAmount()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		int cr=obj.checkInstantBorrowAmount(selectedName, "credit",branchId);
		int dr=obj.checkInstantBorrowAmount(selectedName, "debit",branchId);
		double bAmount=cr-dr;
		borrowAmount=BigDecimal.valueOf(bAmount).toPlainString();
	}

	
	public String addBorrow()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		
		if(amount<=0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Amount Should be Greater than zero. Please Check..."));
		}
		else
		{
			int i=obj.addInstantBorrow(selectedName, amount, description, borrowDate, "credit", chequeNo, chequeDate, bankName, bankBranch, paymentMode,branchId);
			if(i>0)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Instant Borrow Add Sucessfully"));
				no=obj.nextNo("borrower",branchId);
				if(paymentMode.equalsIgnoreCase("Cash"))
				{
				  	obj.increaseCompanyCapitalAmount(branchId,amount,conn);
				}
				return "instantBorrow";
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!"));
			}
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
		
		return "";
	}
	
	public String addReturnBorrow()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		HeaderBean hh=new HeaderBean();
		if(amount<=0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Amount Should be Greater than zero. Please Check..."));
		}
		else if(amount>Double.parseDouble(borrowAmount) && !hh.getName().equalsIgnoreCase("R.K. RISE NIDHI LIMITED"))
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("You can return only "+borrowAmount));
		}
		else
		{
			int i=obj.addInstantBorrow(selectedName, amount, description, borrowDate, "debit", chequeNo, chequeDate, bankName, bankBranch, paymentMode,branchId);
			if(i>0)
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Instant borrow Return Sucessfully"));
				no=obj.nextNo("borrower",branchId);
				if(paymentMode.equals("Cash"))
				{
				  	obj.decreaseCapitalCompanyAmount(branchId,amount);
				}
				
				if(extraAmount>0 && paymentMode.equalsIgnoreCase("Cash"))
				{
					Connection con=DataBaseConnection.JAVAConnection();
					String voucherNo=new DataBaseMethods().generateVoucherNo(branchId,"expense_table", con);
					int j=new DataBaseIncomeExpense().addExpense(branchId,borrowDate, "Other_Dr", paymentMode,String.valueOf(extraAmount), chequeNo, bankBranch, bankName, 
							chequeDate, description, "Instant Borrow Interest", "", voucherNo, 0,"0","","");
					if(j>0)
					{
					 	obj.decreaseCapitalCompanyAmount(branchId,extraAmount);
					}
					
					try {
						con.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}
				
				
				return "returnInstantBorrow";
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured!!!"));
				
			}
		}
		
		return "";
	}
	
	
	public String addName()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		int i=obj.addBorrowerLenderName(no,name,"borrower",branchId);
		if(i>0)
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Name Add Sucessfully"));
			no=obj.nextNo("borrower",branchId);
			
			return "instantBorrow";
		}
		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 ArrayList<SelectItem> getList() {
		return list;
	}

	public void setList(ArrayList<SelectItem> list) {
		this.list = list;
	}

	public double getAmount() {
		return amount;
	}

	public void setAmount(double amount) {
		this.amount = amount;
	}

	public int getNo() {
		return no;
	}

	public void setNo(int no) {
		this.no = no;
	}

	public String getSelectedName() {
		return selectedName;
	}

	public void setSelectedName(String selectedName) {
		this.selectedName = selectedName;
	}

	

	

	

	public String getBorrowAmount() {
		return borrowAmount;
	}

	public void setBorrowAmount(String borrowAmount) {
		this.borrowAmount = borrowAmount;
	}

	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 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 Date getBorrowDate() {
		return borrowDate;
	}

	public void setBorrowDate(Date borrowDate) {
		this.borrowDate = borrowDate;
	}

	public BankInfo getBank_info() {
		return bank_info;
	}

	public void setBank_info(BankInfo bank_info) {
		this.bank_info = bank_info;
	}

	public Date getChequeDate() {
		return chequeDate;
	}

	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}

	public double getExtraAmount() {
		return extraAmount;
	}

	public void setExtraAmount(double extraAmount) {
		this.extraAmount = extraAmount;
	}

	public boolean isShowExtraAmt() {
		return showExtraAmt;
	}

	public void setShowExtraAmt(boolean showExtraAmt) {
		this.showExtraAmt = showExtraAmt;
	}
	
	
	
	
}
