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;

@ViewScoped
@ManagedBean(name="viewBusinessLoan")
public class ViewBusinessLoanBean implements Serializable
{
	LoanInfo viewPrsnlLoan;
	UserInfo user_info,guarantorUser1,guarantorUser2;
	String guarantor1,guarantor2,frequency;
	DataBaseMethods dbm=new DataBaseMethods();
	
	public ViewBusinessLoanBean()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		viewPrsnlLoan=(LoanInfo) ss.getAttribute("selectedLoan");
		guarantor1=viewPrsnlLoan.getFirstGuarantor();
		guarantor2=viewPrsnlLoan.getSecondGuarantor();
		
		Connection conn=DataBaseConnection.JAVAConnection();
		user_info=dbm.userInfoByShareHolderNo(viewPrsnlLoan.getShareHolderNo(), conn);
		guarantorUser1=dbm.userInfoByShareHolderNo(guarantor1, conn);
		guarantorUser2=dbm.userInfoByShareHolderNo(guarantor2, conn);
		
		frequency=dbm.frequencyLabel(viewPrsnlLoan.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 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 getFrequency() {
		return frequency;
	}

	public void setFrequency(String frequency) {
		this.frequency = frequency;
	}
}
