package report_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.FacesContext;
import javax.faces.model.SelectItem;
import javax.servlet.http.HttpSession;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.LoanInfo;

@ManagedBean(name="loanMasterReport")
@ViewScoped
public class LoanMasterReportBean implements Serializable
{
	int branchId;
	List<SelectItem> branchList = new ArrayList<SelectItem>();
	String branchUserId, dsaCode;
	ArrayList<CommanInfo> list;
	ArrayList<SelectItem>  dsaList;
	DataBaseMethods dbm=new DataBaseMethods();
	
	public LoanMasterReportBean() 
	{
		Connection conn=DataBaseConnection.JAVAConnection();

		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		branchId = (int) ss.getAttribute("branchId");
		dsaList=dbm.allDsaList(branchId,"Loan",conn);
		branchUserId = (String) ss.getAttribute("branchUserId");
		branchList = dbm.branchList(branchUserId,conn);

		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void searchData()
	{
		list=new DataBaseReportMethods().loanMasterReportMethod(branchId,dsaCode);
	}

	public List<SelectItem> getBranchList() {
		return branchList;
	}

	public void setBranchList(List<SelectItem> branchList) {
		this.branchList = branchList;
	}

	public String getBranchUserId() {
		return branchUserId;
	}

	public void setBranchUserId(String branchUserId) {
		this.branchUserId = branchUserId;
	}

	public ArrayList<CommanInfo> getList() {
		return list;
	}

	public void setList(ArrayList<CommanInfo> list) {
		this.list = list;
	}

	public int getBranchId() {
		return branchId;
	}

	public void setBranchId(int branchId) {
		this.branchId = branchId;
	}

	public String getDsaCode() {
		return dsaCode;
	}

	public void setDsaCode(String dsaCode) {
		this.dsaCode = dsaCode;
	}

	public ArrayList<SelectItem> getDsaList() {
		return dsaList;
	}

	public void setDsaList(ArrayList<SelectItem> dsaList) {
		this.dsaList = dsaList;
	}
	
	
}	
