package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.text.DecimalFormat;
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.servlet.http.HttpSession;

@ManagedBean(name="editLoanPayment")
@ViewScoped

public class EditLoanPaymentReceiptBean implements Serializable
{DataBaseMethods obj=new DataBaseMethods();
	private static final long serialVersionUID = 1L;
	Date currentDate,chequeDate;
	String paymentMode,chequeNo,bankName,loanNo,id,loanType;
	double amount,penalty,oldAmount;
	UserInfo user_info;
	LoanInfo loan_info;
	LoanEmiReceiptInfo selectedReceipt;
	boolean value2;
	
	public EditLoanPaymentReceiptBean() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		selectedReceipt=(LoanEmiReceiptInfo)ss.getAttribute("selectedReceipt");
		user_info=(UserInfo)ss.getAttribute("user_info");
		loan_info=(LoanInfo)ss.getAttribute("loan_info");
		
		paymentMode=selectedReceipt.getPay_mode();
		if(paymentMode.equals("cheque"))
		{
			value2=true;
			chequeNo=selectedReceipt.getChq_no();
			chequeDate=selectedReceipt.getChq_date();
			bankName=selectedReceipt.getBank_name();
		}
		else
		{
			value2=false;
		}
		
		loanNo=selectedReceipt.getLoanNo();
		loanType=selectedReceipt.getLoanType();
		amount=selectedReceipt.getAmount();
		oldAmount=selectedReceipt.getAmount();
		currentDate=selectedReceipt.getPay_date();
		
		penalty=selectedReceipt.getPenalty();
	}
	
	public String updateReceipt()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		id=selectedReceipt.getId();
		double paybleAmount=obj.checkForLoanPaymentReceipt(loanNo,loanType);
		double paidAmount=obj.loanPaidAmountByUser(loanType, loanNo, conn);
		paidAmount=paidAmount-oldAmount;
		if(paybleAmount>paidAmount)
		{
			double remainingAmount=Double.parseDouble(new DecimalFormat("##.##").format(paybleAmount-paidAmount));
			if(remainingAmount>=amount)
			{
				int n=obj.updateLoanEmiReceipt(id,amount,currentDate,chequeNo,chequeDate,bankName,penalty);
				if(n>=1)
				{
					FacesContext fc=FacesContext.getCurrentInstance();
					fc.addMessage(null, new FacesMessage("Loan Receipt Updated Successfully"));
					
					try {
						conn.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
					return "editViewDeleteLoanEmiPaymentReceipt";
				}
				else
				{
					FacesContext fc=FacesContext.getCurrentInstance();
					fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
					return "";
				}
			}
			else
			{
				FacesContext fc = FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("Unsuccessfull Transaction...Payable Amount = "+paybleAmount+ ". Paid Amount = "+paidAmount+ ". Now You Have To Pay Only "+remainingAmount));
				return "";
			}
		}
		else 
		{
			FacesContext fc=FacesContext.getCurrentInstance();
			fc.addMessage(null, new FacesMessage("Either You Have Paid All Installments Or Lesser Amount Than Installment Is To Be Paid..."));
			return "";
		}
	}

	public String getLoanType() {
		return loanType;
	}
	public void setLoanType(String loanType) {
		this.loanType = loanType;
	}
	public String getLoanNo() {
		return loanNo;
	}
	public void setLoanNo(String loanNo) {
		this.loanNo = loanNo;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public double getOldAmount() {
		return oldAmount;
	}
	public void setOldAmount(double oldAmount) {
		this.oldAmount = oldAmount;
	}
	
	public UserInfo getUser_info() {
		return user_info;
	}
	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}
	public LoanInfo getLoan_info() {
		return loan_info;
	}
	public void setLoan_info(LoanInfo loan_info) {
		this.loan_info = loan_info;
	}
	public LoanEmiReceiptInfo getSelectedReceipt() {
		return selectedReceipt;
	}
	public void setSelectedReceipt(LoanEmiReceiptInfo selectedReceipt) {
		this.selectedReceipt = selectedReceipt;
	}
	public boolean isValue2() {
		return value2;
	}
	public void setValue2(boolean value2) {
		this.value2 = value2;
	}
	public Date getCurrentDate() {
		return currentDate;
	}
	public void setCurrentDate(Date currentDate) {
		this.currentDate = currentDate;
	}
	public Date getChequeDate() {
		return chequeDate;
	}
	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}
	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 getBankName() {
		return bankName;
	}
	public void setBankName(String bankName) {
		this.bankName = bankName;
	}
	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;
	}
}
