package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.text.SimpleDateFormat;
import java.util.ArrayList;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

@ManagedBean(name="viewOdLoanDetails")
@ViewScoped
public class ViewOdLoanBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	LoanInfo viewPrsnlLoan;
	UserInfo user_info,guarantorUser1,guarantorUser2;
	String guarantor1,guarantor2,user_no,strOffcDate,plan_no,frequencyLabel,scheme_type,strMatDate,planSchemeTypeForOd;
	ArrayList<UserInfo>userList;
	UserInfo selectedInfo;
	double installment_amount,odAmount,applicantFees,frequency,interest,maturity_value,totalDepositamount;
	int terms;
	DataBaseMethods obj=new DataBaseMethods();
	
	public ViewOdLoanBean()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		viewPrsnlLoan=(LoanInfo) ss.getAttribute("selectedLoan");
		planSchemeTypeForOd=obj.planSchemeType(viewPrsnlLoan.odScheme);
		
		
		selectedInfo=obj.selectedInfoForDepositList(viewPrsnlLoan.getShareHolderNo(), viewPrsnlLoan.getOdLoanDepositType(), conn);
		
		user_no=selectedInfo.getUser_no();
		plan_no=selectedInfo.getPlanName();
		scheme_type=selectedInfo.getScheme_type();
		terms=selectedInfo.getTerms();
		frequencyLabel=selectedInfo.getFrequencyLabel();
		applicantFees=selectedInfo.getApplicant_fees();
		installment_amount=selectedInfo.getInstallment_amount();
		interest=selectedInfo.getInterest();
		strMatDate=new SimpleDateFormat("dd/MM/yyyy").format(selectedInfo.getMaturity_date());
		maturity_value=selectedInfo.getMaturity_value();
		scheme_type=selectedInfo.getScheme_type();
		odAmount=selectedInfo.getOdAmount()*0.8;
		totalDepositamount=selectedInfo.getOdAmount();
		strOffcDate=new SimpleDateFormat("dd/MM/yyyy").format(selectedInfo.getOffice_date());
		
		user_info=new DataBaseMethods().userInfoByShareHolderNo(viewPrsnlLoan.getShareHolderNo(), conn);
		guarantorUser1=new DataBaseMethods().userInfoByShareHolderNo(guarantor1, conn);
		guarantorUser2=new DataBaseMethods().userInfoByShareHolderNo(guarantor2, conn);
		
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public String backButton()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		String pageName=(String) ss.getAttribute("pageName");
		return pageName;
	}

	public String getGuarantor1() {
		return guarantor1;
	}

	public void setGuarantor1(String guarantor1) {
		this.guarantor1 = guarantor1;
	}

	public String getGuarantor2() {
		return guarantor2;
	}

	public void setGuarantor2(String guarantor2) {
		this.guarantor2 = guarantor2;
	}

	public UserInfo getGuarantorUser1() {
		return guarantorUser1;
	}

	public void setGuarantorUser1(UserInfo guarantorUser1) {
		this.guarantorUser1 = guarantorUser1;
	}

	public UserInfo getGuarantorUser2() {
		return guarantorUser2;
	}

	public void setGuarantorUser2(UserInfo guarantorUser2) {
		this.guarantorUser2 = guarantorUser2;
	}

	public UserInfo getUser_info() {
		return user_info;
	}

	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}

	public LoanInfo getViewPrsnlLoan() {
		return viewPrsnlLoan;
	}

	public void setViewPrsnlLoan(LoanInfo viewPrsnlLoan) {
		this.viewPrsnlLoan = viewPrsnlLoan;
	}

	public String getUser_no() {
		return user_no;
	}

	public void setUser_no(String user_no) {
		this.user_no = user_no;
	}

	public String getPlan_no() {
		return plan_no;
	}

	public void setPlan_no(String plan_no) {
		this.plan_no = plan_no;
	}

	public String getScheme_type() {
		return scheme_type;
	}

	public void setScheme_type(String scheme_type) {
		this.scheme_type = scheme_type;
	}

	

	public String getStrMatDate() {
		return strMatDate;
	}

	public void setStrMatDate(String strMatDate) {
		this.strMatDate = strMatDate;
	}

	public ArrayList<UserInfo> getUserList() {
		return userList;
	}

	public void setUserList(ArrayList<UserInfo> userList) {
		this.userList = userList;
	}

	public double getInstallment_amount() {
		return installment_amount;
	}

	public void setInstallment_amount(double installment_amount) {
		this.installment_amount = installment_amount;
	}

	public double getOdAmount() {
		return odAmount;
	}

	public void setOdAmount(double odAmount) {
		this.odAmount = odAmount;
	}

	public double getApplicantFees() {
		return applicantFees;
	}

	public void setApplicantFees(double applicantFees) {
		this.applicantFees = applicantFees;
	}

	public double getFrequency() {
		return frequency;
	}

	public void setFrequency(double frequency) {
		this.frequency = frequency;
	}

	public double getInterest() {
		return interest;
	}

	public void setInterest(double interest) {
		this.interest = interest;
	}

	public double getMaturity_value() {
		return maturity_value;
	}

	public void setMaturity_value(double maturity_value) {
		this.maturity_value = maturity_value;
	}

	public int getTerms() {
		return terms;
	}

	public void setTerms(int terms) {
		this.terms = terms;
	}

	public DataBaseMethods getObj() {
		return obj;
	}

	public void setObj(DataBaseMethods obj) {
		this.obj = obj;
	}

	public String getPlanSchemeTypeForOd() {
		return planSchemeTypeForOd;
	}

	public void setPlanSchemeTypeForOd(String planSchemeTypeForOd) {
		this.planSchemeTypeForOd = planSchemeTypeForOd;
	}

	public String getFrequencyLabel() {
		return frequencyLabel;
	}

	public void setFrequencyLabel(String frequencyLabel) {
		this.frequencyLabel = frequencyLabel;
	}

	public double getTotalDepositamount() {
		return totalDepositamount;
	}

	public void setTotalDepositamount(double totalDepositamount) {
		this.totalDepositamount = totalDepositamount;
	}

	public String getStrOffcDate() {
		return strOffcDate;
	}

	public void setStrOffcDate(String strOffcDate) {
		this.strOffcDate = strOffcDate;
	}

	public UserInfo getSelectedInfo() {
		return selectedInfo;
	}

	public void setSelectedInfo(UserInfo selectedInfo) {
		this.selectedInfo = selectedInfo;
	}

	

	
}
