package main_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.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import report_package.BorrowerLenderInfo;
import report_package.DataBaseReportMethods;

@ManagedBean(name="viewDeleteInstantLoan")
@ViewScoped
public class ViewDeleteInstantLoanBean implements Serializable
{
	Date startDate=new Date(),endDate=new Date();
	ArrayList<SelectItem> blist;
	ArrayList<BorrowerLenderInfo> list, list1, list2;
	String selectedName, name, sDate, eDate;
	int branchId;
	boolean show;
	int totalCredit, totalDebit, balance;
	BorrowerLenderInfo selectedRow;
	
	public ViewDeleteInstantLoanBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		startDate.setDate(1);
		blist=new DataBaseMethods().allBorrowerOrLenderList(branchId,"borrower");
	}
	
	public void view()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		list=new DataBaseReportMethods().instantLoanReportDateWise(branchId,startDate, endDate);
		
		totalCredit=totalDebit=0;
		if(list.size()>0)
		{
			show=true;
			for(BorrowerLenderInfo ll:list)
			{
				totalDebit+=Integer.parseInt(ll.getDebit());
				totalCredit+=Integer.parseInt(ll.getCredit());
			}
		}
		else
		{
			show=false;
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("No Record Found"));
		}
	}

	
	public void deleteSelected()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		double amount=0;
		String bank=selectedRow.getBankName();
		int i=new DataBaseMethods().deleteInstantLoan(selectedRow);
		if(i>=1)
		{
			Connection conn=DataBaseConnection.JAVAConnection();
			if(Integer.parseInt(selectedRow.getCredit())>0)
			{
				amount=Integer.parseInt(selectedRow.getCredit());
				if(bank.equals("N/A"))
				{
					new DataBaseMethods().increaseCompanyCapitalAmount(branchId,amount,conn);
				}
				else
				{
					new DataBaseMethods().increaseBankBalance(bank, amount,conn);
				}
				
			}
			else
			{
				amount=Integer.parseInt(selectedRow.getDebit());
				if(bank.equals("N/A"))
				{
					new DataBaseMethods().decreaseCapitalCompanyAmount(branchId,amount);
				}
				else
				{
					new DataBaseMethods().decreaseBankBalance(bank, amount,conn);
				}
				try {
					conn.close();
				} catch (Exception e) {
					// TODO: handle exception
				}
			}
			
			
			
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Record Deleted successfully"));
			
			list=new DataBaseReportMethods().instantLoanReportDateWise(branchId,startDate, endDate);
			
		}
		else
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("An error found, try again"));
		}
	}
	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;
	}


	public String getSelectedName() {
		return selectedName;
	}

	public void setSelectedName(String selectedName) {
		this.selectedName = selectedName;
	}

	public ArrayList<SelectItem> getBlist() {
		return blist;
	}

	public void setBlist(ArrayList<SelectItem> blist) {
		this.blist = blist;
	}

	public ArrayList<BorrowerLenderInfo> getList() {
		return list;
	}

	public void setList(ArrayList<BorrowerLenderInfo> list) {
		this.list = list;
	}

	public ArrayList<BorrowerLenderInfo> getList1() {
		return list1;
	}

	public void setList1(ArrayList<BorrowerLenderInfo> list1) {
		this.list1 = list1;
	}

	public ArrayList<BorrowerLenderInfo> getList2() {
		return list2;
	}

	public void setList2(ArrayList<BorrowerLenderInfo> list2) {
		this.list2 = list2;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public int getTotalCredit() {
		return totalCredit;
	}

	public void setTotalCredit(int totalCredit) {
		this.totalCredit = totalCredit;
	}

	public int getTotalDebit() {
		return totalDebit;
	}

	public void setTotalDebit(int totalDebit) {
		this.totalDebit = totalDebit;
	}

	public int getBalance() {
		return balance;
	}

	public void setBalance(int balance) {
		this.balance = balance;
	}

	public String getsDate() {
		return sDate;
	}

	public void setsDate(String sDate) {
		this.sDate = sDate;
	}

	public String geteDate() {
		return eDate;
	}

	public void seteDate(String eDate) {
		this.eDate = eDate;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public BorrowerLenderInfo getSelectedRow() {
		return selectedRow;
	}

	public void setSelectedRow(BorrowerLenderInfo selectedRow) {
		this.selectedRow = selectedRow;
	}
	
	
	
	
}
