package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.servlet.http.HttpSession;

@ManagedBean(name="viewPropertyLoan")
@ViewScoped
public class ViewPropertyLoanBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	LoanInfo viewPrprtyLoan;
	UserInfo user_info,guarantorUser1,guarantorUser2;
	String guarantor1,guarantor2,frequency;
	DataBaseMethods dbm=new DataBaseMethods();
	
	public ViewPropertyLoanBean()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		viewPrprtyLoan=(LoanInfo) ss.getAttribute("selectedLoan");
		guarantor1=viewPrprtyLoan.getFirstGuarantor();
		guarantor2=viewPrprtyLoan.getSecondGuarantor();
		
		Connection conn=DataBaseConnection.JAVAConnection();
		
		user_info=dbm.userInfoByShareHolderNo(viewPrprtyLoan.getShareHolderNo(), conn);
		guarantorUser1=dbm.userInfoByShareHolderNo(guarantor1, conn);
		guarantorUser2=dbm.userInfoByShareHolderNo(guarantor2, conn);
		
		frequency=dbm.frequencyLabel(viewPrprtyLoan.getFrequency());
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public String backButton()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		String pageName=(String) ss.getAttribute("pageName");
		return pageName;
	}

	public LoanInfo getViewPrprtyLoan() {
		return viewPrprtyLoan;
	}

	public void setViewPrprtyLoan(LoanInfo viewPrprtyLoan) {
		this.viewPrprtyLoan = viewPrprtyLoan;
	}

	public UserInfo getUser_info() {
		return user_info;
	}

	public void setUser_info(UserInfo user_info) {
		this.user_info = user_info;
	}

	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 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 String getFrequency() {
		return frequency;
	}

	public void setFrequency(String frequency) {
		this.frequency = frequency;
	}
}
