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.servlet.http.HttpSession;

import org.primefaces.context.RequestContext;

@ManagedBean(name="manageDepositEmi")
@ViewScoped

public class ManageDepositEmiBean implements Serializable
{
	DataBaseMethods obj=new DataBaseMethods();
	private static final long serialVersionUID = 1L;
	UserInfo user_info;
	ArrayList<PaymentReceiptInfo> receipt_info;
	PaymentReceiptInfo selectedReceipt;
	String id,user_no,receipt_no, chequeNo, bankName, paymentMode;
	boolean value, value1, value2,show, showData;
	Date chequeDate, currentDate=new Date();
	double amount,penalty;
	List<String> nameList;
	
	public List<String> completeUserNo(String name)
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		nameList=new DataBaseAutoCompAndDuplicate().userAccoutnNo(branchId,name,conn);
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
     	return nameList;
	}
	
	public void userInfo() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		showData=true;
		if(user_no.contains("/"))
		{
			user_no=user_no.substring(0,user_no.indexOf("/"));
		}
		user_info = obj.userInfoDuringTransaction(user_no);
        receipt_info=obj.receiptInfo(branchId,user_no);
        if (user_info != null)
		{
			amount=user_info.getInstallment_amount();
			if(user_info.getScheme_type().equals("RD"))
			{
				show=true;
			}
			else
			{
				show=false;
			}
		}	
		else
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Account No. Does Not Exists! "));
		}
	}
	
	public void viewDetails()
	{
		if(selectedReceipt.getPayment_mode().equals("cheque"))
    	{
    		value=true;
      	}
    	else
    	{
    		value=false;
    	}
	}
	
	public void delete()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		id=selectedReceipt.getId();
		String pMode=selectedReceipt.getPayment_mode();
		Double amt=selectedReceipt.getAmount();
		String bankId=selectedReceipt.getTransferBank();
		int n=obj.removeReceipt(id);
		Connection conn=DataBaseConnection.JAVAConnection();
		if(n>=1)
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Receipt Removed Successfully"));
			RequestContext.getCurrentInstance().showMessageInDialog(new FacesMessage(FacesMessage.SEVERITY_INFO, "DSA Commsion Detail", "Please Check DSA Commsion For This Receipt and Delete Manually from DSA Wise Commission Report."));
			user_info = obj.userInfoDuringTransaction(user_no);
            receipt_info=obj.receiptInfo(branchId,user_no);
            if(pMode.equalsIgnoreCase("cash") && ( bankId==null || bankId.equalsIgnoreCase("N/A")))
            {
            	obj.decreaseCapitalCompanyAmount(branchId,amt);
            }
            else if(pMode.equalsIgnoreCase("cash") && (!bankId.equalsIgnoreCase("N/A") && bankId!=null))
            {
            	obj.decreaseBankBalance(bankId, amt,conn);
            }
            else
            {
            	obj.decreaseBankBalance(bankId, amt,conn);
            }
		}
		else
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
		}
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public String editDetails()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("selected", selectedReceipt);
		ss.setAttribute("user", user_info);
		return "editPaymentReceipt";
	}
	
	public void printDetails()
	{
		int id=Integer.valueOf(selectedReceipt.getId());
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		if(selectedReceipt.getStatus().equalsIgnoreCase("approved"))
		{
			ss.setAttribute("shareHolderNo", user_info.getShareHolderNo());
			ss.setAttribute("frequency", user_info.getFrequency());
			ss.setAttribute("office_application_no", user_info.getOffice_application_no());
			ss.setAttribute("scheme_type", user_info.getScheme_type());
			ss.setAttribute("rd_fdNo",user_info.getUser_no());
			ss.setAttribute("maturityDate",user_info.getStrMatDate());
			ss.setAttribute("date",selectedReceipt.getDate());
			ss.setAttribute("issue_date",user_info.getOffice_date());
			ss.setAttribute("maturity_value",user_info.getMaturity_value());
			ss.setAttribute("receipt_no", selectedReceipt.getReceiptNo());
			ss.setAttribute("installment_amount", selectedReceipt.getAmount());
			ss.setAttribute("id", id);
			ss.setAttribute("plan_no", user_info.getPlan_no());
			RequestContext.getCurrentInstance().execute("window.open('rd_fdReceipt.xhtml')");
			
			HeaderBean hh=new HeaderBean();
			if(hh.getName().equalsIgnoreCase("DEVKRIPA MICROFINANCE FOUNDATION"))
			{
				RequestContext.getCurrentInstance().execute("window.open('rd_fdReceiptGolden.xhtml')");
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Please Approve This Payment First"));
		}
	}
	
	public UserInfo getUser_info() {
		return user_info;
	}
	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}
	public ArrayList<PaymentReceiptInfo> getReceipt_info() {
		return receipt_info;
	}
	public void setReceipt_info(ArrayList<PaymentReceiptInfo> receipt_info) {
		this.receipt_info = receipt_info;
	}
	public PaymentReceiptInfo getSelectedReceipt() {
		return selectedReceipt;
	}
	public void setSelectedReceipt(PaymentReceiptInfo selectedReceipt) {
		this.selectedReceipt = selectedReceipt;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getUser_no() {
		return user_no;
	}
	public void setUser_no(String user_no) {
		this.user_no = user_no;
	}
	public String getReceipt_no() {
		return receipt_no;
	}
	public void setReceipt_no(String receipt_no) {
		this.receipt_no = receipt_no;
	}
	public String getChequeNo() {
		return chequeNo;
	}
	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}
	public String getBankName() {
		return bankName;
	}
	public void setBankName(String bankName) {
		this.bankName = bankName;
	}
	public String getPaymentMode() {
		return paymentMode;
	}
	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}
	public boolean isValue() {
		return value;
	}
	public void setValue(boolean value) {
		this.value = value;
	}
	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 Date getChequeDate() {
		return chequeDate;
	}
	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}
	public Date getCurrentDate() {
		return currentDate;
	}
	public void setCurrentDate(Date currentDate) {
		this.currentDate = currentDate;
	}
	public double getAmount() {
		return amount;
	}
	public void setAmount(double amount) {
		this.amount = amount;
	}
	public double getPenalty() {
		return penalty;
	}
	public void setPenalty(double penalty) {
		this.penalty = penalty;
	}
	public boolean isShow() {
		return show;
	}
	public void setShow(boolean show) {
		this.show = show;
	}

	public boolean isShowData() {
		return showData;
	}

	public void setShowData(boolean showData) {
		this.showData = showData;
	}
}
