package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

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 org.primefaces.context.RequestContext;

@ManagedBean(name="viewDeleteBankTransaction")
@ViewScoped
 
public class ViewDeleteBankTransactionBean implements Serializable
{
	BankInfo selectedBank;
	int branchId;
	ArrayList<BankInfo> bank_info;
	DataBaseMethods obj=new DataBaseMethods();
	Date startDate=new Date(), endDate=new Date();
	DataBaseMethodTaheer dbt= new DataBaseMethodTaheer();
	List<SelectItem> branchList;
	String companyName;
	boolean disBranch;
	String userType;
	
	public ViewDeleteBankTransactionBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		startDate.setDate(1);
		bank_info = obj.allBankTransactionInfo(branchId,startDate, endDate);
		
		String branchUserId = (String) ss.getAttribute("branchUserId");
		branchList=new ArrayList<>();
		
		Connection conn=DataBaseConnection.JAVAConnection();
		branchList = new DataBaseMethods().branchList(branchUserId,conn);
		companyName= dbt.companyNameByBranchId(branchId);
        userType= (String) ss.getAttribute("type"); 
		
		if(companyName.equalsIgnoreCase("FINAZONE MICRO SERVICES FOUNDATION") &&  userType.equalsIgnoreCase("masterAdmin"))
		{
			disBranch=true;
		}
		else {
			disBranch= false;
		}
      
	}
	
	
	public void searchData()
	{
		if(!companyName.equalsIgnoreCase("FINAZONE MICRO SERVICES FOUNDATION")  )
		{
			HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			branchId = (int) ss.getAttribute("branchId");
		
		}
			bank_info = obj.allBankTransactionInfo(branchId,startDate, endDate);
	}
	
	public void printVoucherDetail()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("voucherNo", "");
		ss.setAttribute("expDate", selectedBank.getEntry_date());
		ss.setAttribute("amount", String.valueOf(selectedBank.getAmount()));
		ss.setAttribute("vchtype", "Contra");
		ss.setAttribute("payTo", selectedBank.getDescription());
		ss.setAttribute("being", "Cash Deposit In Bank");
		ss.setAttribute("payMode", "Cash");
		
		RequestContext.getCurrentInstance().execute("window.open('printVoucher.xhtml')");
	}
	
	public void delete()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		String status=selectedBank.getStatus();
		double amount=selectedBank.getAmount();
		String bank=selectedBank.getBankId();
		String transferBank=selectedBank.getTransferBankId();
		int i=obj.deleteBankTransactionEntry(selectedBank.getId());
		if(i>=1)
		{
			bank_info = obj.allBankTransactionInfo(branchId,startDate, endDate);
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Entry Deleted successfully"));
			if(status.equals("deposited"))
			{
				obj.decreaseSharedCompanyAmount(branchId,amount);
				obj.decreaseBankBalance(bank, amount,conn);
			}
			else if(status.equalsIgnoreCase("other deposit"))
			{
				obj.decreaseBankBalance(bank, amount,conn);
			}
			else
			{
				if(transferBank.equals("N/A"))
				{
					obj.decreaseCapitalCompanyAmount(branchId,amount);
					obj.increaseBankBalance(bank, amount,conn);
				}
				else
				{
					obj.increaseBankBalance(bank, amount,conn);
					obj.decreaseBankBalance(transferBank, amount,conn);
				}
			}
			try {
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
	}

	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 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 int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}

	public List<SelectItem> getBranchList() {
		return branchList;
	}

	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}

	public String getCompanyName() {
		return companyName;
	}

	public void setCompanyName(String companyName) {
		this.companyName = companyName;
	}


	public boolean isDisBranch() {
		return disBranch;
	}


	public void setDisBranch(boolean disBranch) {
		this.disBranch = disBranch;
	}


	public String getUserType() {
		return userType;
	}


	public void setUserType(String userType) {
		this.userType = userType;
	}
	
	
}
