package main_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.faces.application.FacesMessage;
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 org.apache.poi.ss.formula.functions.Value;
import org.primefaces.event.FlowEvent;


@ManagedBean(name="loanOtherDetail")
@ViewScoped
public class LoanOtherDetailBean implements Serializable
{

	private static final long serialVersionUID = 1L;
	String loanNo, loanType="personalloan";
	UserInfo user_info;
	LoanInfo loan_info;
	List<String> nameList;
	DataBaseMethods obj=new DataBaseMethods();
	boolean show;
	List<CoapplicantInfo> otherList;
	private boolean skip;
	CoapplicantInfo coObj1,coObj2,coObj3,coObj4,coObj5,coObj6,coObj7;
	ArrayList<SelectItem> categoryList, bankList, maritalStatusList, relationList, telephoneIndicatorList, religionList, stateCodeList;
	int branchId =0;
	DataBaseMethodRahul dbr = new DataBaseMethodRahul();
	 ArrayList<nomineeGuarantorBankInfo> nGList;
	public List<String> completeLoanNo(String name)
	{
		Connection con = DataBaseConnection.JAVAConnection();
		try {
			HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			 branchId =(int) ss.getAttribute("branchId");
			nameList=new DataBaseAutoCompAndDuplicate().showLoanNoByLoanTypeForAppWithoutApprove(branchId,name,loanType, obj.userId(),con);
			categoryList=obj.allCategoryList();  // Static Caste-Catgory List
			religionList=obj.highMarkTableList("Religion", con);
		} catch (Exception e) {
			// TODO: handle exception
			
		}
		try {
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return nameList;

	}
	

	public void searchDetail()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		show=true;
		if(loanNo.contains("/"))
		{
			
				loanNo=loanNo.substring(0,loanNo.indexOf("/"));
		}
		user_info=obj.userInfoByLoanNoLoanType(loanNo,loanType,conn);
		loan_info=obj.loanInfoByLoanNoLoanType(loanNo,loanType, conn);
		coObj1 = new CoapplicantInfo();
		coObj2 = new CoapplicantInfo();
		coObj3 = new CoapplicantInfo();
		coObj4 = new CoapplicantInfo();
		coObj5 = new CoapplicantInfo();
		coObj6 = new CoapplicantInfo();
		coObj7 = new CoapplicantInfo();
		
		
		otherList=obj.showOhterListValues(loanNo,conn);	
		
		for (CoapplicantInfo selectItem : otherList) 
		{
			if(selectItem.getUserType().equals("guarantor1"))
			{
				coObj1 = selectItem;
			}
			if(selectItem.getUserType().equals("guarantor2"))
			{
				coObj2 = selectItem;
			}
			if(selectItem.getUserType().equals("coapplicant1"))
			{
				coObj3 = selectItem;
			}
			if(selectItem.getUserType().equals("coapplicant2"))
			{
				coObj4 = selectItem;
			}
			if(selectItem.getUserType().equals("coapplicant3"))
			{
				coObj5 = selectItem;
			}
			if(selectItem.getUserType().equals("nominee1"))
			{
				coObj6 = selectItem;
			}
			if(selectItem.getUserType().equals("nominee2"))
			{
				coObj7 = selectItem;
			}
		}
		
		
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		nomGuaBankDetail();
	}

	
	public void nomGuaBankDetail() {
		
		nGList = new ArrayList<>();
		
	   nGList = dbr.applicantPersonalloanDetailByShareHolderNo("personalloan",user_info.shareHolderNo,nGList, branchId);
		
	   for(nomineeGuarantorBankInfo  nn :nGList) {
		   
		   coObj1.setChequeNo(nn.getG1_chq_no());
		   coObj1.setBank_accountNo( nn.getG1_acc_no());
		   coObj1.setBank_name( nn.getG1_bank_name());
		   coObj1.setBranch( nn.getG1_bank_branch());
		   coObj1.setBankIfsc( nn.getG1_bank_ifsc());
		   coObj2.setChequeNo( nn.getG2_chq_no());
		   coObj2.setBank_accountNo( nn.getG2_acc_no());
		   coObj2.setBank_name( nn.getG2_bank_name());
		   coObj2.setBranch( nn.getG2_bank_branch());
		   coObj2.setBankIfsc( nn.getG2_bank_ifsc());
		   coObj6.setChequeNo( nn.getNom_chq_no());
		   coObj6.setBank_accountNo( nn.getNom_acc_no());
		   coObj6.setBank_name( nn.getNom_bank_name());
		   coObj6.setBranch( nn.getNom_bank_branch());
		   coObj6.setBankIfsc( nn.getNom_bank_ifsc());
	   }
		
	}
	
	public String addDetails()
	{
		Connection con = DataBaseConnection.JAVAConnection();
		addOtherDetails1(coObj1,con);
		addOtherDetails2(coObj2,con);
		addOtherDetails3(coObj3,con);
		addOtherDetails4(coObj4,con);
		addOtherDetails5(coObj5,con);
		addOtherDetails6(coObj6,con);
		addOtherDetails7(coObj7,con);
		try {
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		loanNo="";
		
		return "loanOtherDetails.xhtml";
	}
	
	
	public void addOtherDetails1(CoapplicantInfo coObj1, Connection con) 
	{		
		try 
		{
			HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			int branchId =(int) ss.getAttribute("branchId");
					
			if(coObj1.getUserType()==null || coObj1.getUserType().isEmpty() || coObj1.getUserType().equals("") )
			{
				boolean addGuarantor=obj.addGuarantor(branchId,coObj1.office_application_no,coObj1.office_date,coObj1.shareNo,coObj1.first_applicantName,coObj1.dob,coObj1.
						father_husband_name,coObj1.guardian_name,coObj1.guardian_relation,coObj1.status,coObj1.PAN,coObj1.bank_accountNo,coObj1.bank_name,coObj1.branch,coObj1.address,coObj1.mobile,
						coObj1.nominee_name,coObj1.nominee_relation,coObj1.nominee_dob,coObj1.nominee_address,coObj1.applicant_photoPath,0,0,0,coObj1.
						perAddress,coObj1.signPath,coObj1.formPath,coObj1.category,coObj1.crNo,coObj1.votrId,coObj1.uniqueId,coObj1.rationNo,coObj1.dlNo,coObj1.electBill,coObj1.resCert,coObj1.appCheque,
						coObj1.gCheque,coObj1.submittedBankName,coObj1.
						tBill,coObj1.paymentMode,coObj1.bankNameCheque,coObj1.chequeNo,coObj1.doc1Path,coObj1. doc2Path,coObj1. doc3Path,coObj1. doc4Path,coObj1. doc5Path,0,coObj1.doc6Path,coObj1.doc7Path,coObj1.doc8Path,coObj1.
						cityName,coObj1.relation,coObj1.gender,coObj1.maritalStatus,coObj1.keyPersonName,coObj1.keyPersonRelation,coObj1.telephoneIndicator,0,
						coObj1.religion,coObj1.stateCode,coObj1.pinCode,coObj1.dsaCode,coObj1.email,coObj1. qualification,coObj1.occupation,coObj1.bankIfsc,coObj1.referenceBy, 
						coObj1.remark, coObj1.title, coObj1.monthlyIncome,"guarantor1",loanNo,con);
						if(addGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Guarantor I Added Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
							
						}

			}
			else
			{
				boolean updateGuarantor=obj.updateGuarantor(coObj1.id,coObj1.office_application_no,coObj1.office_date,coObj1.shareNo,coObj1.first_applicantName,coObj1.dob,coObj1.
						father_husband_name,coObj1.guardian_name,coObj1.guardian_relation,coObj1.status,coObj1.PAN,coObj1.bank_accountNo,coObj1.bank_name,coObj1.branch,coObj1.address,coObj1.mobile,coObj1.
						nominee_name,coObj1.nominee_relation,coObj1.nominee_dob,coObj1.nominee_address,coObj1.applicant_photoPath,0,0,0,coObj1.category
						,coObj1.perAddress,coObj1.signPath,coObj1.formPath,coObj1.votrId,coObj1.uniqueId,coObj1.rationNo,coObj1.dlNo,coObj1.electBill,coObj1.resCert,coObj1.appCheque,coObj1.gCheque,
						 coObj1.tBill,coObj1.doc1Path,coObj1.doc2Path,coObj1.doc3Path,coObj1.doc4Path,coObj1.doc5Path,coObj1.doc6Path,coObj1.doc7Path,coObj1.doc8Path,coObj1.gender,
						 coObj1.maritalStatus,coObj1.keyPersonName,coObj1.keyPersonRelation,coObj1.telephoneIndicator,0,coObj1.religion,coObj1.stateCode,coObj1.pinCode,coObj1.email,
						 coObj1.qualification,coObj1.occupation,coObj1.bankIfsc,coObj1.referenceBy,coObj1.remark,coObj1.title,coObj1.monthlyIncome,coObj1.relation,con);
						if(updateGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Guarantor I Updated Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
							
						}
			}
			
			
		} catch (Exception e) {
			// TODO: handle exception
		}
		
		
	}
	
	
	public void addOtherDetails2(CoapplicantInfo coObj2,Connection con) 
	{
		try 
		{
			HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			int branchId =(int) ss.getAttribute("branchId");
			
			if(coObj2.getUserType()==null || coObj2.getUserType().isEmpty() || coObj2.getUserType().equals("") )
			{
				boolean addGuarantor=obj.addGuarantor(branchId,coObj2.office_application_no,coObj2.office_date,coObj2.shareNo,coObj2.first_applicantName,coObj2.dob,coObj2.
						father_husband_name,coObj2.guardian_name,coObj2.guardian_relation,coObj2.status,coObj2.PAN,coObj2.bank_accountNo,coObj2.bank_name,coObj2.branch,coObj2.address,coObj2.mobile,
						coObj2.nominee_name,coObj2.nominee_relation,coObj2.nominee_dob,coObj2.nominee_address,coObj2.applicant_photoPath,0,0,0,coObj2.
						perAddress,coObj2.signPath,coObj2.formPath,coObj2.category,coObj2.crNo,coObj2. votrId,coObj2. uniqueId,coObj2. rationNo,coObj2. dlNo,coObj2. electBill,coObj2. resCert,coObj2. appCheque,coObj2. gCheque,coObj2.submittedBankName,coObj2.
						tBill,coObj2.paymentMode,coObj2.bankNameCheque,coObj2.chequeNo,coObj2.doc1Path,coObj2. doc2Path,coObj2. doc3Path,coObj2. doc4Path,coObj2. doc5Path,0,coObj2.doc6Path,coObj2.doc7Path,coObj2.doc8Path,coObj2.
						cityName,coObj2. relation,coObj2. gender,coObj2. maritalStatus,coObj2. keyPersonName,coObj2. keyPersonRelation,coObj2.
						telephoneIndicator,0,coObj2.religion,coObj2.stateCode,coObj2. pinCode,coObj2. dsaCode,coObj2.email,coObj2. qualification,coObj2. occupation,coObj2. bankIfsc,coObj2. 
						referenceBy, coObj2.remark, coObj2.title, coObj2.monthlyIncome,"guarantor2",loanNo,con);
						if(addGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Guarantor II Added Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
							
						}
			}
			else
			{
				boolean updateGuarantor=obj.updateGuarantor(coObj2.id,coObj2.office_application_no,coObj2.office_date,coObj2.shareNo,coObj2.first_applicantName,coObj2.dob,coObj2.
						father_husband_name,coObj2.guardian_name,coObj2.guardian_relation,coObj2.status,coObj2.PAN,coObj2.bank_accountNo,coObj2.bank_name,coObj2.branch,coObj2.address,coObj2.mobile,coObj2.
						nominee_name,coObj2.nominee_relation,coObj2.nominee_dob,coObj2.nominee_address,coObj2.applicant_photoPath,0,0,0,coObj2.category
						,coObj2.perAddress,coObj2.signPath,coObj2.formPath,coObj2.votrId,coObj2.uniqueId,coObj2.rationNo,coObj2.dlNo,coObj2.electBill,coObj2.resCert,coObj2.appCheque,coObj2.gCheque,
						 coObj2.tBill,coObj2.doc1Path,coObj2.doc2Path,coObj2.doc3Path,coObj2.doc4Path,coObj2.doc5Path,coObj2.doc6Path,coObj2.doc7Path,coObj2.doc8Path,coObj2.gender,
						 coObj2.maritalStatus,coObj2.keyPersonName,coObj2.keyPersonRelation,coObj2.telephoneIndicator,0,coObj2.religion,coObj2.stateCode,coObj2.pinCode,coObj2.email,
						 coObj2.qualification,coObj2.occupation,coObj2.bankIfsc,coObj2.referenceBy,coObj2.remark,coObj2.title,coObj2.monthlyIncome,coObj2.relation,con);
						if(updateGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Guarantor II Updated Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
							
						}
			}
	
			
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
	
	public void addOtherDetails3(CoapplicantInfo coObj3,Connection con) 
	{
		
		try 
		{
			HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			int branchId =(int) ss.getAttribute("branchId");
			
			if(coObj3.getUserType()==null || coObj3.getUserType().isEmpty() || coObj3.getUserType().equals("") )
			{
				boolean addGuarantor=obj.addGuarantor(branchId,coObj3.office_application_no,coObj3.office_date,coObj3.shareNo,coObj3.first_applicantName,coObj3.dob,coObj3.
						father_husband_name,coObj3.guardian_name,coObj3.guardian_relation,coObj3.status,coObj3.PAN,coObj3.bank_accountNo,coObj3.bank_name,coObj3.branch,coObj3.address,coObj3.mobile,
						coObj3.nominee_name,coObj3.nominee_relation,coObj3.nominee_dob,coObj3.nominee_address,coObj3.applicant_photoPath,0,0,0,coObj3.
						perAddress,coObj3.signPath,coObj3.formPath,coObj3.category,coObj3.crNo,coObj3. votrId,coObj3. uniqueId,coObj3. rationNo,coObj3. dlNo,coObj3. electBill,coObj3. resCert,coObj3. appCheque,coObj3. gCheque,coObj3.submittedBankName,coObj3.
						tBill,coObj3.paymentMode,coObj3.bankNameCheque,coObj3.chequeNo,coObj3.doc1Path,coObj3. doc2Path,coObj3. doc3Path,coObj3. doc4Path,coObj3. doc5Path,0,coObj3.doc6Path,coObj3.doc7Path,coObj3.doc8Path,coObj3.
						cityName,coObj3. relation,coObj3. gender,coObj3. maritalStatus,coObj3. keyPersonName,coObj3. keyPersonRelation,coObj3.
						telephoneIndicator,0,coObj3.religion,coObj3.stateCode,coObj3. pinCode,coObj3. dsaCode,coObj3.email,coObj3. qualification,coObj3. occupation,coObj3. bankIfsc,coObj3. 
						referenceBy, coObj3.remark, coObj3.title, coObj3.monthlyIncome,"coapplicant1",loanNo,con);
						if(addGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Co-Applicant I Added Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
														
						}

			}
			else
			{
				boolean updateGuarantor=obj.updateGuarantor(coObj3.id,coObj3.office_application_no,coObj3.office_date,coObj3.shareNo,coObj3.first_applicantName,coObj3.dob,coObj3.
						father_husband_name,coObj3.guardian_name,coObj3.guardian_relation,coObj3.status,coObj3.PAN,coObj3.bank_accountNo,coObj3.bank_name,coObj3.branch,coObj3.address,coObj3.mobile,coObj3.
						nominee_name,coObj3.nominee_relation,coObj3.nominee_dob,coObj3.nominee_address,coObj3.applicant_photoPath,0,0,0,coObj3.category
						,coObj3.perAddress,coObj3.signPath,coObj3.formPath,coObj3.votrId,coObj3.uniqueId,coObj3.rationNo,coObj3.dlNo,coObj3.electBill,coObj3.resCert,coObj3.appCheque,coObj3.gCheque,
						 coObj3.tBill,coObj3.doc1Path,coObj3.doc2Path,coObj3.doc3Path,coObj3.doc4Path,coObj3.doc5Path,coObj3.doc6Path,coObj3.doc7Path,coObj3.doc8Path,coObj3.gender,
						 coObj3.maritalStatus,coObj3.keyPersonName,coObj3.keyPersonRelation,coObj3.telephoneIndicator,0,coObj3.religion,coObj3.stateCode,coObj3.pinCode,coObj3.email,
						 coObj3.qualification,coObj3.occupation,coObj3.bankIfsc,coObj3.referenceBy,coObj3.remark,coObj3.title,coObj3.monthlyIncome,coObj3.relation,con);
						if(updateGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Co-Applicant I Updated Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
														
						}
			}
			 
		} catch (Exception e) {
			// TODO: handle exception
		}
		
	}
	
	public void addOtherDetails4(CoapplicantInfo coObj4,Connection con) 
	{
		
		try 
		{
			HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			int branchId =(int) ss.getAttribute("branchId");
				
			if(coObj4.getUserType()==null || coObj4.getUserType().isEmpty() || coObj4.getUserType().equals("") )
			{
				boolean addGuarantor=obj.addGuarantor(branchId,coObj4.office_application_no,coObj4.office_date,coObj4.shareNo,coObj4.first_applicantName,coObj4.dob,coObj4.
						father_husband_name,coObj4.guardian_name,coObj4.guardian_relation,coObj4.status,coObj4.PAN,coObj4.bank_accountNo,coObj4.bank_name,coObj4.branch,coObj4.address,coObj4.mobile,
						coObj4.nominee_name,coObj4.nominee_relation,coObj4.nominee_dob,coObj4.nominee_address,coObj4.applicant_photoPath,0,0,0,coObj4.
						perAddress,coObj4.signPath,coObj4.formPath,coObj4.category,coObj4.crNo,coObj4. votrId,coObj4. uniqueId,coObj4. rationNo,coObj4. dlNo,coObj4. electBill,coObj4. resCert,coObj4. appCheque,coObj4. gCheque,coObj4.submittedBankName,coObj4.
						tBill,coObj4.paymentMode,coObj4.bankNameCheque,coObj4.chequeNo,coObj4.doc1Path,coObj4. doc2Path,coObj4. doc3Path,coObj4. doc4Path,coObj4. doc5Path,0,coObj4.doc6Path,coObj4.doc7Path,coObj4.doc8Path,coObj4.
						cityName,coObj4. relation,coObj4. gender,coObj4. maritalStatus,coObj4. keyPersonName,coObj4. keyPersonRelation,coObj4.
						telephoneIndicator,0,coObj4.religion,coObj4.stateCode,coObj4. pinCode,coObj4. dsaCode,coObj4.email,coObj4. qualification,coObj4. occupation,coObj4. bankIfsc,coObj4. 
						referenceBy, coObj4.remark, coObj4.title, coObj4.monthlyIncome,"coapplicant2",loanNo,con);
						if(addGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Co-Applicant II Added Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
														
						}

			}
			else
			{
				boolean updateGuarantor=obj.updateGuarantor(coObj4.id,coObj4.office_application_no,coObj4.office_date,coObj4.shareNo,coObj4.first_applicantName,coObj4.dob,coObj4.
						father_husband_name,coObj4.guardian_name,coObj4.guardian_relation,coObj4.status,coObj4.PAN,coObj4.bank_accountNo,coObj4.bank_name,coObj4.branch,coObj4.address,coObj4.mobile,coObj4.
						nominee_name,coObj4.nominee_relation,coObj4.nominee_dob,coObj4.nominee_address,coObj4.applicant_photoPath,0,0,0,coObj4.category
						,coObj4.perAddress,coObj4.signPath,coObj4.formPath,coObj4.votrId,coObj4.uniqueId,coObj4.rationNo,coObj4.dlNo,coObj4.electBill,coObj4.resCert,coObj4.appCheque,coObj4.gCheque,
						 coObj4.tBill,coObj4.doc1Path,coObj4.doc2Path,coObj4.doc3Path,coObj4.doc4Path,coObj4.doc5Path,coObj4.doc6Path,coObj4.doc7Path,coObj4.doc8Path,coObj4.gender,
						 coObj4.maritalStatus,coObj4.keyPersonName,coObj4.keyPersonRelation,coObj4.telephoneIndicator,0,coObj4.religion,coObj4.stateCode,coObj4.pinCode,coObj4.email,
						 coObj4.qualification,coObj4.occupation,coObj4.bankIfsc,coObj4.referenceBy,coObj4.remark,coObj4.title,coObj4.monthlyIncome,coObj4.relation,con);
						if(updateGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Co-Applicant II Updated Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
														
						}
			}
			
		} catch (Exception e) {
			// TODO: handle exception
		}
		
	}
	
	public void addOtherDetails5(CoapplicantInfo coObj5,Connection con) 
	{
		
		try 
		{
			HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			int branchId =(int) ss.getAttribute("branchId");
			if(coObj5.getUserType()==null || coObj5.getUserType().isEmpty() || coObj5.getUserType().equals("") )
			{
				boolean addGuarantor=obj.addGuarantor(branchId,coObj5.office_application_no,coObj5.office_date,coObj5.shareNo,coObj5.first_applicantName,coObj5.dob,coObj5.
						father_husband_name,coObj5.guardian_name,coObj5.guardian_relation,coObj5.status,coObj5.PAN,coObj5.bank_accountNo,coObj5.bank_name,coObj5.branch,coObj5.address,coObj5.mobile,
						coObj5.nominee_name,coObj5.nominee_relation,coObj5.nominee_dob,coObj5.nominee_address,coObj5.applicant_photoPath,0,0,0,coObj5.
						perAddress,coObj5.signPath,coObj5.formPath,coObj5.category,coObj5.crNo,coObj5. votrId,coObj5. uniqueId,coObj5. rationNo,coObj5. dlNo,coObj5. electBill,coObj5. resCert,coObj5. appCheque,coObj5. gCheque,coObj5.submittedBankName,coObj5.
						tBill,coObj5.paymentMode,coObj5.bankNameCheque,coObj5.chequeNo,coObj5.doc1Path,coObj5. doc2Path,coObj5. doc3Path,coObj5. doc4Path,coObj5. doc5Path,0,coObj5.doc6Path,coObj5.doc7Path,coObj5.doc8Path,coObj5.
						cityName,coObj5. relation,coObj5. gender,coObj5. maritalStatus,coObj5. keyPersonName,coObj5. keyPersonRelation,coObj5.
						telephoneIndicator,0,coObj5.religion,coObj5.stateCode,coObj5. pinCode,coObj5. dsaCode,coObj5.email,coObj5. qualification,coObj5. occupation,coObj5. bankIfsc,coObj5. 
						referenceBy, coObj5.remark, coObj5.title, coObj5.monthlyIncome,"coapplicant3",loanNo,con);
						if(addGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Co-Applicant III Added Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
							
						}

			}
			else
			{
				boolean updateGuarantor=obj.updateGuarantor(coObj5.id,coObj5.office_application_no,coObj5.office_date,coObj5.shareNo,coObj5.first_applicantName,coObj5.dob,coObj5.
						father_husband_name,coObj5.guardian_name,coObj5.guardian_relation,coObj5.status,coObj5.PAN,coObj5.bank_accountNo,coObj5.bank_name,coObj5.branch,coObj5.address,coObj5.mobile,coObj5.
						nominee_name,coObj5.nominee_relation,coObj5.nominee_dob,coObj5.nominee_address,coObj5.applicant_photoPath,0,0,0,coObj5.category
						,coObj5.perAddress,coObj5.signPath,coObj5.formPath,coObj5.votrId,coObj5.uniqueId,coObj5.rationNo,coObj5.dlNo,coObj5.electBill,coObj5.resCert,coObj5.appCheque,coObj5.gCheque,
						 coObj5.tBill,coObj5.doc1Path,coObj5.doc2Path,coObj5.doc3Path,coObj5.doc4Path,coObj5.doc5Path,coObj5.doc6Path,coObj5.doc7Path,coObj5.doc8Path,coObj5.gender,
						 coObj5.maritalStatus,coObj5.keyPersonName,coObj5.keyPersonRelation,coObj5.telephoneIndicator,0,coObj5.religion,coObj5.stateCode,coObj5.pinCode,coObj5.email,
						 coObj5.qualification,coObj5.occupation,coObj5.bankIfsc,coObj5.referenceBy,coObj5.remark,coObj5.title,coObj5.monthlyIncome,coObj5.relation,con);
						if(updateGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Co-Applicant III Updated Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
							
						}
			}
		
			
			
		} catch (Exception e) {
			// TODO: handle exception
		}
		
	}
	
	public void addOtherDetails6(CoapplicantInfo coObj6,Connection con) 
	{
		
		try 
		{
			HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			int branchId =(int) ss.getAttribute("branchId");
			if(coObj6.getUserType()==null || coObj6.getUserType().isEmpty() || coObj6.getUserType().equals("") )
			{
				boolean addGuarantor=obj.addGuarantor(branchId,coObj6.office_application_no,coObj6.office_date,coObj6.shareNo,coObj6.first_applicantName,coObj6.dob,coObj6.
						father_husband_name,coObj6.guardian_name,coObj6.guardian_relation,coObj6.status,coObj6.PAN,coObj6.bank_accountNo,coObj6.bank_name,coObj6.branch,coObj6.address,coObj6.mobile,
						coObj6.nominee_name,coObj6.nominee_relation,coObj6.nominee_dob,coObj6.nominee_address,coObj6.applicant_photoPath,0,0,0,coObj6.
						perAddress,coObj6.signPath,coObj6.formPath,coObj6.category,coObj6.crNo,coObj6. votrId,coObj6. uniqueId,coObj6. rationNo,coObj6. dlNo,coObj6. electBill,coObj6. resCert,coObj6. appCheque,coObj6. gCheque,coObj6.submittedBankName,coObj6.
						tBill,coObj6.paymentMode,coObj6.bankNameCheque,coObj6.chequeNo,coObj6.doc1Path,coObj6. doc2Path,coObj6. doc3Path,coObj6. doc4Path,coObj6. doc5Path,0,coObj6.doc6Path,coObj6.doc7Path,coObj6.doc8Path,coObj6.
						cityName,coObj6. relation,coObj6. gender,coObj6. maritalStatus,coObj6. keyPersonName,coObj6. keyPersonRelation,coObj6.
						telephoneIndicator,0,coObj6.religion,coObj6.stateCode,coObj6. pinCode,coObj6. dsaCode,coObj6.email,coObj6. qualification,coObj6. occupation,coObj6. bankIfsc,coObj6. 
						referenceBy, coObj6.remark, coObj6.title, coObj6.monthlyIncome,"nominee1",loanNo,con);
						if(addGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Co-Applicant III Added Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
							
						}

			}
			else
			{
				boolean updateGuarantor=obj.updateGuarantor(coObj6.id,coObj6.office_application_no,coObj6.office_date,coObj6.shareNo,coObj6.first_applicantName,coObj6.dob,coObj6.
						father_husband_name,coObj6.guardian_name,coObj6.guardian_relation,coObj6.status,coObj6.PAN,coObj6.bank_accountNo,coObj6.bank_name,coObj6.branch,coObj6.address,coObj6.mobile,coObj6.
						nominee_name,coObj6.nominee_relation,coObj6.nominee_dob,coObj6.nominee_address,coObj6.applicant_photoPath,0,0,0,coObj6.category
						,coObj6.perAddress,coObj6.signPath,coObj6.formPath,coObj6.votrId,coObj6.uniqueId,coObj6.rationNo,coObj6.dlNo,coObj6.electBill,coObj6.resCert,coObj6.appCheque,coObj6.gCheque,
						 coObj6.tBill,coObj6.doc1Path,coObj6.doc2Path,coObj6.doc3Path,coObj6.doc4Path,coObj6.doc5Path,coObj6.doc6Path,coObj6.doc7Path,coObj6.doc8Path,coObj6.gender,
						 coObj6.maritalStatus,coObj6.keyPersonName,coObj6.keyPersonRelation,coObj6.telephoneIndicator,0,coObj6.religion,coObj6.stateCode,coObj6.pinCode,coObj6.email,
						 coObj6.qualification,coObj6.occupation,coObj6.bankIfsc,coObj6.referenceBy,coObj6.remark,coObj6.title,coObj6.monthlyIncome,coObj6.relation,con);
						if(updateGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Nominee 1 Updated Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
							
						}
			}
		
			
			
		} catch (Exception e) {
			// TODO: handle exception
		}
		
	}
	
	
	public void addOtherDetails7(CoapplicantInfo coObj7,Connection con) 
	{
		
		try 
		{
			HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
			int branchId =(int) ss.getAttribute("branchId");
			if(coObj7.getUserType()==null || coObj7.getUserType().isEmpty() || coObj7.getUserType().equals("") )
			{
				boolean addGuarantor=obj.addGuarantor(branchId,coObj7.office_application_no,coObj7.office_date,coObj7.shareNo,coObj7.first_applicantName,coObj7.dob,coObj7.
						father_husband_name,coObj7.guardian_name,coObj7.guardian_relation,coObj7.status,coObj7.PAN,coObj7.bank_accountNo,coObj7.bank_name,coObj7.branch,coObj7.address,coObj7.mobile,
						coObj7.nominee_name,coObj7.nominee_relation,coObj7.nominee_dob,coObj7.nominee_address,coObj7.applicant_photoPath,0,0,0,coObj7.
						perAddress,coObj7.signPath,coObj7.formPath,coObj7.category,coObj7.crNo,coObj7. votrId,coObj7. uniqueId,coObj7. rationNo,coObj7. dlNo,coObj7. electBill,coObj7. resCert,coObj7. appCheque,coObj7. gCheque,coObj7.submittedBankName,coObj7.
						tBill,coObj7.paymentMode,coObj7.bankNameCheque,coObj7.chequeNo,coObj7.doc1Path,coObj7. doc2Path,coObj7. doc3Path,coObj7. doc4Path,coObj7. doc5Path,0,coObj7.doc6Path,coObj7.doc7Path,coObj7.doc8Path,coObj7.
						cityName,coObj7. relation,coObj7. gender,coObj7. maritalStatus,coObj7. keyPersonName,coObj7. keyPersonRelation,coObj7.
						telephoneIndicator,0,coObj7.religion,coObj7.stateCode,coObj7. pinCode,coObj7. dsaCode,coObj7.email,coObj7. qualification,coObj7. occupation,coObj7. bankIfsc,coObj7. 
						referenceBy, coObj7.remark, coObj7.title, coObj7.monthlyIncome,"nominee2",loanNo,con);
						if(addGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Nominee 2 Added Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
							
						}

			}
			else
			{
				boolean updateGuarantor=obj.updateGuarantor(coObj7.id,coObj7.office_application_no,coObj7.office_date,coObj7.shareNo,coObj7.first_applicantName,coObj7.dob,coObj7.
						father_husband_name,coObj7.guardian_name,coObj7.guardian_relation,coObj7.status,coObj7.PAN,coObj7.bank_accountNo,coObj7.bank_name,coObj7.branch,coObj7.address,coObj7.mobile,coObj7.
						nominee_name,coObj7.nominee_relation,coObj7.nominee_dob,coObj7.nominee_address,coObj7.applicant_photoPath,0,0,0,coObj7.category
						,coObj7.perAddress,coObj7.signPath,coObj7.formPath,coObj7.votrId,coObj7.uniqueId,coObj7.rationNo,coObj7.dlNo,coObj7.electBill,coObj7.resCert,coObj7.appCheque,coObj7.gCheque,
						 coObj7.tBill,coObj7.doc1Path,coObj7.doc2Path,coObj7.doc3Path,coObj7.doc4Path,coObj7.doc5Path,coObj7.doc6Path,coObj7.doc7Path,coObj7.doc8Path,coObj7.gender,
						 coObj7.maritalStatus,coObj7.keyPersonName,coObj7.keyPersonRelation,coObj7.telephoneIndicator,0,coObj7.religion,coObj7.stateCode,coObj7.pinCode,coObj7.email,
						 coObj7.qualification,coObj7.occupation,coObj7.bankIfsc,coObj7.referenceBy,coObj7.remark,coObj7.title,coObj7.monthlyIncome,coObj7.relation,con);
						if(updateGuarantor)
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Co-Applicant III Updated Successfully"));
						}
						else
						{
							FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Error Occured Try Again.."));
							
						}
			}
		
			
			
		} catch (Exception e) {
			// TODO: handle exception
		}
		
	}
	
	public String onFlowProcess(FlowEvent event) {
        if (skip) {
            skip = false; //reset in case user goes back
            return "confirm";
        }
        else {
            return event.getNewStep();
        }
    }
	

	public List<String> getNameList() {
		return nameList;
	}

	public void setNameList(List<String> nameList) {
		this.nameList = nameList;
	}

	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 boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}


	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 List<CoapplicantInfo> getOtherList() {
		return otherList;
	}


	public void setOtherList(List<CoapplicantInfo> otherList) {
		this.otherList = otherList;
	}


	public boolean isSkip() {
		return skip;
	}


	public void setSkip(boolean skip) {
		this.skip = skip;
	}


	public ArrayList<SelectItem> getCategoryList() {
		return categoryList;
	}


	public void setCategoryList(ArrayList<SelectItem> categoryList) {
		this.categoryList = categoryList;
	}


	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}


	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}


	public ArrayList<SelectItem> getMaritalStatusList() {
		return maritalStatusList;
	}


	public void setMaritalStatusList(ArrayList<SelectItem> maritalStatusList) {
		this.maritalStatusList = maritalStatusList;
	}


	public ArrayList<SelectItem> getRelationList() {
		return relationList;
	}


	public void setRelationList(ArrayList<SelectItem> relationList) {
		this.relationList = relationList;
	}


	public ArrayList<SelectItem> getTelephoneIndicatorList() {
		return telephoneIndicatorList;
	}


	public void setTelephoneIndicatorList(ArrayList<SelectItem> telephoneIndicatorList) {
		this.telephoneIndicatorList = telephoneIndicatorList;
	}


	public ArrayList<SelectItem> getReligionList() {
		return religionList;
	}


	public void setReligionList(ArrayList<SelectItem> religionList) {
		this.religionList = religionList;
	}


	public ArrayList<SelectItem> getStateCodeList() {
		return stateCodeList;
	}


	public void setStateCodeList(ArrayList<SelectItem> stateCodeList) {
		this.stateCodeList = stateCodeList;
	}


	public CoapplicantInfo getCoObj1() {
		return coObj1;
	}


	public void setCoObj1(CoapplicantInfo coObj1) {
		this.coObj1 = coObj1;
	}


	public CoapplicantInfo getCoObj2() {
		return coObj2;
	}


	public void setCoObj2(CoapplicantInfo coObj2) {
		this.coObj2 = coObj2;
	}


	public CoapplicantInfo getCoObj3() {
		return coObj3;
	}


	public void setCoObj3(CoapplicantInfo coObj3) {
		this.coObj3 = coObj3;
	}


	public CoapplicantInfo getCoObj4() {
		return coObj4;
	}


	public void setCoObj4(CoapplicantInfo coObj4) {
		this.coObj4 = coObj4;
	}


	public CoapplicantInfo getCoObj5() {
		return coObj5;
	}


	public void setCoObj5(CoapplicantInfo coObj5) {
		this.coObj5 = coObj5;
	}


	public CoapplicantInfo getCoObj6() {
		return coObj6;
	}


	public void setCoObj6(CoapplicantInfo coObj6) {
		this.coObj6 = coObj6;
	}


	public CoapplicantInfo getCoObj7() {
		return coObj7;
	}


	public void setCoObj7(CoapplicantInfo coObj7) {
		this.coObj7 = coObj7;
	}




}
