package main_package;

import group_head_package.DataBaseIncomeExpense;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.text.DecimalFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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.primefaces.context.RequestContext;

@ManagedBean(name = "debitLoan")
@ViewScoped

public class DebitLoanBean implements Serializable
{
	private static final long serialVersionUID = 1L;
	
	String loanCategory, label, shareHolderNo, loanNo, paymentMode, chequeNo, bankName, bankBranch, userId, savingAccountNo, 
		   umrnNo, companyType;
	ArrayList<SelectItem> loanList;
	public static List<String> list;
	double amount,loanAmount,paidAmount;
	Date chequeDate,date;
	boolean showCheque,renderProceed, showTransfer, showDeduction, loanDeduction;
	ArrayList<SelectItem> bankList, loanTypeList;
	BankInfo bank_info;
	LoanInfo selectedLoan,loan_info,loan_info2;
	UserInfo savingDetail, user_info,user_info2;
	ArrayList<DebitInfo> transactionHistory;
	int flag=0;
	DsaListInfo commissionInfo;
	ArrayList<LoanInfo> loanEMIList;
	
	List<String> nameList;
	double totalPenaltyDue, totalPenaltyPaid, totalIntrest, totalEmi, totalInterestRemainLocal,totalChqChrgRemainLocal,totalPrincipalRemainLocal,totalPrincipal, totalDue, totalPaid, totalRemaining, totalIntrestRemain, totalPrincipalRemain, 
	totalPenaltyRemain, totalChqChargeRemain, discount, foreclosureCharges, foreClosureInterest, foreClosureTotalRemaining;
	double totalChqCharge, paidChqcharge,totalPenaltyRemainLocal, savingAmount,tilldateInterest,totalForCloser;
	boolean show, showDsaField,renderTableField, chkLoanSettlement=false,renderPayMode=true;
	boolean value, value1, value2, showTransferSelect=true, ecsDdNo;
	String transfer="No",submittedBankName, payType, receipt_no, voucherNo, dsaName;
	Date  paidDate=new Date();
	int MyId; 
	double discountPenalty, discountChequeBounce, discountIntrest, commission, loanSettlementAmount,amount2,amount3;
	String loanNo2,paymentMode2="Cash",product,dealer,imeiNoI,imeiNoII,securityype,loanName;
	boolean preLoan,preLoan2,showMobile;
	boolean preLoanAmountExceed;
	double billAmount,downPayment, finalAmount;
	String companyName;
	String loanCate;
	DataBaseMethodTaheer dbmt = new DataBaseMethodTaheer();
	DataBaseMethods obj = new DataBaseMethods();
	DbYashwant dby = new DbYashwant();
	DataBaseMethodsRaviK dbrk = new DataBaseMethodsRaviK();
	DecimalFormat dc = new DecimalFormat("##.##");
		
	boolean multiPreLoan = false, showMultiCloser;
	
	ArrayList<PreviousLoanInfo> allPreviousLoanList, selectedPreviousLoanList;
	
	
	
	public DebitLoanBean() throws ParseException 
	{   
		Connection conn = DataBaseConnection.JAVAConnection();
		userId = obj.userId();
		date = new Date();
		paymentMode = "Cash";
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		selectedLoan = (LoanInfo) ss.getAttribute("selected");
		companyType = (String) ss.getAttribute("companyType");
		int branchId = (int) ss.getAttribute("branchId");
		companyName = dbmt.companyNameByBranchId(branchId);
        
		shareHolderNo = selectedLoan.getShareHolderNo();
		loanTypeList = obj.loanTypeList(conn);
		loanCategory = (String) ss.getAttribute("loanType");
		
		setLoanCategory();
		if(loanCategory.equalsIgnoreCase("grouploan"))
		{
			loanNo = selectedLoan.getSubLoanNo();
		}
		else
		{
			loanNo = selectedLoan.getLoanNo();
		}
        
		System.out.println("hello1"+selectedLoan.getSecurityype());
		if ("14".equals(selectedLoan.getSecurityype()) || "15".equals(selectedLoan.getSecurityype()))
		{
			showMobile = true;
			downPayment = selectedLoan.getDownPayment();
			billAmount = selectedLoan.getBillAmount();
			imeiNoI = selectedLoan.getImeiNoI();
			imeiNoII = selectedLoan.getImeiNoII();
			dealer = dby.selectDealer(conn, selectedLoan.getDealer());
			product = selectedLoan.getProduct();			
		}
		 
		if ("14".equals(selectedLoan.getSecurityype()))
	    {
	    	product = dby.selectProduct(conn, selectedLoan.getProduct());
	    	loanName = "Mobile";
	    }
		else
	    {
			loanName = "";
	    }
	    
		user_info = obj.userInfoByLoanNoLoanType(loanNo,loanCategory,conn);
		loan_info = obj.loanInfoByLoanNoLoanType(loanNo,loanCategory, conn);
		
		System.out.println("FINDING LOANNO FOR DISBURSE : " + loanNo);
		//loanNo2 = dby.selectLoanPreLoanNo(conn, loanCategory , user_info.getShareHolderNo());
		loanNo2 = dbrk.selectLoanPreLoanNo(conn, loanNo, loanCategory, user_info.getShareHolderNo());
		System.out.println("FINDING OLD LOANNO TO PRECLOSER : " + loanNo2);
		
		if(loanNo2 != null && !loanNo2.isEmpty() && !loanNo.equals(loanNo2))
		{
			preLoan2=true;
		}
		else
		{
			preLoan = false;
		}
		
		receipt_no = String.valueOf(obj.loanPayReceiptNo());
		
		try 
		{
			conn.close();
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
		
		proceed();	
	
		detectMultiPreLoan();
	}
	
	
	
	public List<String> completeText(String name)
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		list = new DataBaseAutoCompAndDuplicate().shareHolderAllNo(branchId,name);
     	return list;
	}
	
	
	
	public void clearLoanCateg()
	{
		loanCategory = "";
		loanNo = "";
	}
	
	
	
//	public void detectPreLoanAmount() throws ParseException
//	{
//	    if (loanNo2 != null && !loanNo2.trim().equals("")) {
//	        userInfo();
//	    } else {
//	        preLoan = false;
//	        amount2 = 0;
//	    }
//	}
	
	
	
	public void detectPreLoanAmount() throws ParseException 
	{
		preLoanAmountExceed = false;

		if (loanNo2 != null && !loanNo2.trim().equals("")) 
		{
			if (preLoan) 
			{
				showMultiCloser = false;
				multiPreLoan = false;
				
				userInfo();
				System.out.println("========== PRE LOAN CHECK ==========");
				System.out.println("New Loan Amount : " + loanAmount);
				System.out.println("Pre Loan Amount : " + amount2);

				amount2 = Math.round(amount2);
				
				if (amount2 > loanAmount) 
				{
					preLoanAmountExceed = true;
					FacesContext.getCurrentInstance().addMessage(null,
							new FacesMessage(FacesMessage.SEVERITY_WARN, 
									"Pre-Loan Close amount (" + amount2 + ") is greater than Loan Amount (" + loanAmount
											+ "). Please uncheck Pre-Loan Close to release amount.","Pre-Loan Close"));
				}
			}
		}
		else 
		{
			preLoan = false;
			amount2 = 0;
			preLoanAmountExceed = false;
		}
	}
	
	
	
	public void setLoanCategory()
	{
		/*if(shareHolderNo.contains("/"))
		{
			shareHolderNo=shareHolderNo.substring(0,shareHolderNo.indexOf("/"));
		}*/
		
		loanList = new DataBaseAutoCompAndDuplicate().allLoanList(loanCategory, shareHolderNo);
	}
	
	
	
	public void proceed()
	{
		Connection conn = DataBaseConnection.JAVAConnection();

		paidAmount = 0;
		transactionHistory = obj.viewDebitLoanHistory(loanCategory, loanNo, shareHolderNo, conn);
		
		//loanAmount=obj.findLoanAmountByLoanNoLoanType(loanCategory,loanNo,shareHolderNo,conn);
		
		loanAmount = Double.valueOf(loan_info.getLoanAmount());
		try 
		{
			conn.close();
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
		
		
		for(DebitInfo dd : transactionHistory)
		{
			paidAmount = paidAmount + Double.valueOf(dd.getAmount());
		}
		
		amount = Math.round( loanAmount - paidAmount);
		amount3 = amount;
		
		if(amount > 0)
		{
			renderProceed = true;
		}
		else
		{
			renderProceed = false;
		}
	}
	
	
	
	private void sendMessage(Connection conn) 
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		String check = obj.checkStatusInMessageSettingTable("Loan Disburse");
		if(check.equals("active"))
		{
			Double msgAmt = amount;
			if(!paymentMode.equalsIgnoreCase("cash") && amount == Double.valueOf(loan_info.getLoanAmount()) && 
			    loanDeduction == true)
			{
				msgAmt = msgAmt + Double.valueOf(loan_info.getFileCharge()) + Double.valueOf(loan_info.getInsuranceFee());
			}
			
			boolean isDLT = dbmt.isDLTMessageApi(conn);
			if (isDLT)  
			{
				Map<String, String> variables = new HashMap<>();
				variables.put("name", user_info.getFirst_applicantName());
				variables.put("loanNo", loanNo);
				variables.put("amount", String.valueOf(msgAmt));
				
				if (loanCategory.equalsIgnoreCase("personalloan")) 
				{
					dbmt.sendDLTMessage(user_info.getContactNo(), null, variables, conn, "loan disbursed");
				}
				else if (loanCategory.equalsIgnoreCase("secure_loan"))
				{
					dbmt.sendDLTMessage(user_info.getContactNo(), null, variables, conn, "secure loan disbursed");
				}
			}
			else 
			{
				String typeMessage = "Dear " + loan_info.getApplicantName() + ", Your " + loan_info.getLoanType() + " No. " 
								   + loan_info.getLoanNo() + ", Rs. " + msgAmt + ",  is Disburse Sucessfully By " + paymentMode;
				
				obj.runMessageUrl(branchId, user_info.getContactNo(), typeMessage, "system", "1207166054349037096", conn);
				typeMessage = ""; 
			}
		}
		else
		{
			FacesContext.getCurrentInstance().addMessage(null, 
					new FacesMessage("Message For This Module is not Active. "
								   + "Please Go to In User Block and Active Message For This Module."));
		}
	}
	
	
	
	public void checkPaymentMode()
	{
		Connection conn = DataBaseConnection.JAVAConnection();
		String fcStatus = obj.checkSettingFromMasterSettingNewTable("File Charge", conn);
		String insFeeStatus = obj.checkSettingFromMasterSettingNewTable("Insurance Fee", conn);
		
		if(paymentMode.equalsIgnoreCase("Cash"))
		{
			showDeduction = false;
			showCheque = false;
			showTransfer = false;
		}
		else if(paymentMode.equalsIgnoreCase("Transfer"))
		{
			showDeduction = false;
			if(fcStatus.equalsIgnoreCase("loan_disburse") && insFeeStatus.equalsIgnoreCase("loan_disburse") && 
			   amount == Double.valueOf(loan_info.getLoanAmount()))
			{
				showDeduction = true;
			}
			
			savingDetail = obj.savingAccountDetailByShareHolderNo (selectedLoan.getShareHolderNo());
			savingAccountNo = savingDetail.getAccountNo();
			if(savingAccountNo != null && !savingAccountNo.equals(""))
			{
				showCheque=false;
				showTransfer=true;
			}
			else
			{
				paymentMode="";
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(selectedLoan.getShareHolderNo()+" Doesn't any Saving Account. Please open a Saving Account Than Transfer Amount. "));
			}
		}
		else
		{
			if(fcStatus.equalsIgnoreCase("loan_disburse") && insFeeStatus.equalsIgnoreCase("loan_disburse") && amount==Double.valueOf(loan_info.getLoanAmount()))
			{
				showDeduction=true;
			}
			
			bankList=new DataBaseIncomeExpense().allBankList(conn);
			label=paymentMode;
			showCheque=true;
			showTransfer=false;
		}
		proceed();
	}
	
	public void checkBank()
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		bank_info=obj.obtainBankInfoById(bankName,conn);
		bankBranch=bank_info.bank_branch;
	/*	address=bank_info.address;
		accNo=bank_info.acc_no;*/
		try {
			conn.close();
		} catch (Exception e) {
			// TODO: handle exception
		}
	}
    
	public void calculationMethod()
	{
		if(!paymentMode.equalsIgnoreCase("cash") && amount==Double.valueOf(loan_info.getLoanAmount()) && loanDeduction==true)
		{
			Connection conn=DataBaseConnection.JAVAConnection();
			
			String fcStatus=obj.checkSettingFromMasterSettingNewTable("File Charge", conn);
			if(fcStatus.equalsIgnoreCase("loan_disburse"))
			{
				amount=amount-Double.valueOf(loan_info.getFileCharge());
				amount3=amount3-Double.valueOf(loan_info.getFileCharge());
				
			}
			
			String insFeeStatus=obj.checkSettingFromMasterSettingNewTable("Insurance Fee", conn);
			if(insFeeStatus.equalsIgnoreCase("loan_disburse"))
			{
				amount=amount-Double.valueOf(loan_info.getInsuranceFee());
				amount3=amount3-Double.valueOf(loan_info.getInsuranceFee());
			}
			
			String pcStatus=obj.checkSettingFromMasterSettingNewTable("Processing Charge", conn);
			if(pcStatus.equalsIgnoreCase("loan_disburse"))
			{
				amount=amount-Double.valueOf(loan_info.getProcessingCharge());
				amount3=amount3-Double.valueOf(loan_info.getProcessingCharge());
			}
			
			String stampFeeStatus=obj.checkSettingFromMasterSettingNewTable("Stamp Fee", conn);
			if(stampFeeStatus.equalsIgnoreCase("loan_disburse"))
			{
				amount=amount-Double.valueOf(loan_info.getStamp());
				amount3=amount3-Double.valueOf(loan_info.getStamp());
			}
		     
			flag=1;
			
			try
			{
				conn.close();
			}
			catch (SQLException e) 
			{
				e.printStackTrace();
			}
		}
		else
		{
			flag=0;
		}
		
		
		if(preLoan== true)
		{
			amount=amount-Math.round(amount2);
		}
		
		if (paymentMode.equalsIgnoreCase("cash")) 
		{
			if (companyName.equalsIgnoreCase("TRP MICRO FINANCE FOUNDATION")) 
			{
				finalAmount = amount - loan_info.getTotalAdvanceEMIAmount() - Double.valueOf(loan_info.getFileCharge()) - 
							  Double.valueOf(loan_info.getProcessingCharge()) - Double.valueOf(loan_info.getInsuranceFee());
			
				System.out.println(finalAmount);
			}
			else 
			{
				finalAmount = amount;
			}
		}
		else 
		{
			finalAmount = amount - loan_info.getTotalAdvanceEMIAmount();
		}
		
		preLoanAmountExceed = false;
		
		checkPreviousLoan();
	}
	
	
	
	public void checkPreviousLoan()
	{
		if (selectedLoan.getPreviousLoan() != null && !selectedLoan.getPreviousLoan().isEmpty())
		{
			FacesContext.getCurrentInstance().addMessage(null, 
					new FacesMessage("Customer " + selectedLoan.getShareHolderNo() 
								   + " already have exiting Loan : " + selectedLoan.getPreviousLoan())); 
		}
	}
	
	
	
	public void calculateCommission(Connection conn)
	{
		if(loan_info2.getPlanNo()==null || loan_info2.equals(""))
		{
			System.out.println("1");
			commission=0;
		}
		else
		{
			commissionInfo=obj.checkPlanCommissionDetail(loan_info2.getPlanNo(), conn);
			if(commissionInfo==null || commissionInfo.getStatusNullCheck().equals("0"))
			{
				System.out.println("5");
				commission=0;
			}
			else
			{
				double val=0;
				val=Double.parseDouble(loan_info2.getLoanAmount());
			   if(commissionInfo.getCommissionBase().equalsIgnoreCase("closure"))
			   {
				   if(commissionInfo.getCommission_type().equalsIgnoreCase("percent"))
				   {
					   commission=(val/100)*commissionInfo.getCommission_value();
				   }
				   else
				   {
					   commission=commissionInfo.getCommission_value();
				   }
			   }
			   else
			   {
				   commission=0;
			   }
			   commission=Double.parseDouble(dc.format(commission));
			}
		}
	}
	
	
	public void userInfo() throws ParseException 
	{
		Connection conn=DataBaseConnection.JAVAConnection();
		/*HttpSession ss1=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		pageName=(String) ss1.getAttribute("pageName");
		if(pageName!=null && pageName.equals("particularLoan"))
		{
			// System.out.println("if");
			loanNo=((LoanInfo) ss1.getAttribute("selectedLoan")).getLoanNo();
		}
		else
		{
			// System.out.println("else");
			loanNo=loanNo.substring(0,loanNo.indexOf("/"));
		}*/
		
		show=true;
//		if(loanNo.contains("/"))
//		{
//			loanNo=loanNo.substring(0,loanNo.indexOf("/"));
//		}
		
		if(loanNo2.contains("GL"))
		{
			loanCate="grouploan";
		}
		else if (loanNo2.contains("PL")) 
		{
			loanCate="personalloan";
		}
		else if (loanNo2.contains("SL")) 
		{
			loanCate="secure_loan";
		}
		
		System.out.println("loan No 2 : " + loanNo2 + "   " + loanCate);
		
		user_info2=obj.userInfoByLoanNoLoanType(loanNo2,loanCate, conn);
		loan_info2=obj.loanInfoByLoanNoLoanType(loanNo2,loanCate, conn);
		//amount=loan_info.getInstallAmount();
		//// System.out.println(loan_info.getEmiMode());
		if(loan_info2.getDsacode()==null || loan_info2.getDsacode().equals(""))
		{
			//System.out.println("ifffffffffffff");
			commission=0;
			showDsaField=false;
		}
		else
		{
			dsaName=obj.dsaNameById(loan_info2.getDsacode(),conn);
			showDsaField=true;
			calculateCommission(conn);
			
		}
		
		if(loan_info2.getEmiMode().equals("both"))
		{
			renderTableField=true;
		}
		
		loanEMIList=obj.loanInstallment(loanCate,loanNo2, conn);
		
		foreClosureInterest=foreClosureTotalRemaining=0;
		for(int l=0;l<loanEMIList.size();l++)
		{
			Date dt=new Date();
			if(loanEMIList.get(l).getStatus().equals("Paid"))
			{
				loanEMIList.get(l).setColorStatus("paid");
			//	System.out.println("value of the forClosureInterest :::::::"+foreClosureInterest);
			}
			else
			{
				if(loanEMIList.get(l).getInstallDate().before(dt))
				{
					loanEMIList.get(l).setColorStatus("due");
					foreClosureInterest+=Double.parseDouble(dc.format(Double.parseDouble(loanEMIList.get(l).getInterestAmount())));
				
				}
				else
				{
					loanEMIList.get(l).setColorStatus("upcoming");
				}
			}
		}
		loanEMIList=obj.penaltyCalculationMethod(loanCate, loanNo2, loanEMIList, conn);
		
		double totPaid=obj.totalPaidPenaltyAndChequeBounceCharges(loanNo2, "Penalty", conn);
		if(totPaid>0)
		{
			for(int i=0; i<loanEMIList.size(); i++)
			{
				if(totPaid>loanEMIList.get(i).getPenaltyDue())
				{
					loanEMIList.get(i).setPenaltyPaid(loanEMIList.get(i).getPenaltyDue());
				}
				else
				{
					loanEMIList.get(i).setPenaltyPaid(totPaid);
					break;
				}
				totPaid=totPaid-loanEMIList.get(i).getPenaltyDue();
			}
			
		}
	
		
		totalPenaltyDue=totalPenaltyPaid=totalIntrest=totalEmi=totalPrincipal=totalDue=totalPaid=totalIntrestRemain=totalPrincipalRemain=totalChqCharge=0;
		for(LoanInfo ll: loanEMIList)
		{    System.out.println("value of the one day interest :"+totalInterestRemainLocal);
		    System.out.println("l");
			totalEmi+=ll.getInstallAmount();
			totalIntrest+=Double.parseDouble(ll.getInterestAmount());
			System.out.println("value of the month Interest :::::::"+ll.getInterestAmount());
			totalPrincipal+=Double.parseDouble(ll.getPrincipalAmount());
			totalPaid+=ll.getPaidAmount();
			totalDue+=ll.getDueAmount();
			totalPenaltyDue+=ll.getPenaltyDue();
			totalPenaltyPaid+=ll.getPenaltyPaid();
			
			/*if(ll.getStatus().equals("Due"))
			{
				totalIntrestRemain+=Double.parseDouble(ll.getInterestAmount());
				totalPrincipalRemain+=Double.parseDouble(ll.getPrincipalAmount());
			}*/
		}
		
		double totPrPaid=obj.totalPrincipalPaidByLoanNo(loanNo2);
		double totIrPaid=obj.totalIntrestPaidByLoanNo(loanNo2);
		if(loan_info2.getEmiMode().equals("interest"))
		{
			totalPrincipalRemain=Double.parseDouble(loan_info2.getLoanAmount());
		}
		else
		{
			totalPrincipalRemain=Double.parseDouble(loan_info2.getLoanAmount())-totPrPaid;
		}
		
		//totalPrincipalRemain=Double.parseDouble(loan_info.getLoanAmount())-totPrPaid;
		totalIntrestRemain=totalIntrest-totIrPaid;
		totalIntrestRemain=totalIntrestRemain-loan_info2.getDiscount();  // Discount adjust in Loan Interest Amount
//		System.out.println("tir : " + totalIntrestRemain);
//		System.out.println(totalPrincipal+"====="+totPrPaid);
//		System.out.println(totalIntrest+"====="+totIrPaid);
		
		totalChqCharge=obj.calculatePenaltyAndChequeBounceCharges(loanNo2, "Cheque Bounce",loanCate, conn);
		paidChqcharge=obj.totalPaidPenaltyAndChequeBounceCharges(loanNo2, "Cheque Bounce", conn);
		totalChqChargeRemain=Double.parseDouble(dc.format(totalChqCharge-paidChqcharge));
		
		totalEmi=Double.parseDouble(dc.format(totalEmi));
		totalIntrest=Math.round(totalIntrest);
		
		totalPrincipal=Math.round(totalPrincipal);
		totalPaid=Double.parseDouble(dc.format(totalPaid));
		totalDue=Double.parseDouble(dc.format(totalDue));
		totalPenaltyDue=Double.parseDouble(dc.format(totalPenaltyDue));
		totalPenaltyPaid=Double.parseDouble(dc.format(totalPenaltyPaid));
		totalPenaltyRemain=Double.parseDouble(dc.format(totalPenaltyDue-totalPenaltyPaid));
		totalIntrestRemain=Double.parseDouble(dc.format(totalIntrestRemain));
		if(totalIntrestRemain<0)
		{
			totalIntrestRemain=0;
		}
		totalPrincipalRemain=Double.parseDouble(dc.format(totalPrincipalRemain));
		if(totalPrincipalRemain<0)
		{
			totalPrincipalRemain=0;
		}
		totalRemaining=Double.parseDouble(dc.format(totalIntrestRemain+totalPrincipalRemain+totalChqChargeRemain+totalPenaltyRemain+savingAmount));

		amount2=totalRemaining;
		
		foreClosureInterest=Double.parseDouble(dc.format(foreClosureInterest));
		foreClosureTotalRemaining=totalPrincipalRemain+totalPenaltyRemain+totalChqChargeRemain+foreClosureInterest;
		foreClosureTotalRemaining=Double.parseDouble(dc.format(foreClosureTotalRemaining));
		
//		printDt=new SimpleDateFormat("dd/MM/yyyy").format(paidDate);
		try
		{
			conn.close();
		} 
		catch (Exception e) 
		{
			// TODO: handle exception
		}
		
		checkDetailRR();
	}
	
	
	
	public void checkDetailRR() throws ParseException 
	{	
		LoanInfo lastPaidEmi = null;
		LoanInfo nextEmi = null;
		LoanInfo lastDueEmi=null;
		Double lateInterest = 0.0;
		boolean Duecase = false;

		for (int i = 0; i < loanEMIList.size(); i++) 
		{
		    LoanInfo current = loanEMIList.get(i);
		    
			String dateString = current.getStrInstlmntDate();
			
			SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
			Date Ldate = sdf.parse(dateString);
			Date todayDate = new Date(); 
			boolean lastPaidGet = false;
			
			if (current.getStatus().equalsIgnoreCase("Due")) 
			{
			    lastPaidGet = true;   
			}


		    if (current.getStatus().equalsIgnoreCase("Paid")) 
		    {
		        lastPaidEmi = current;
		    } 
		    
		    else if(Ldate.before(todayDate)&& lastPaidGet==true) 
		    {	
		    	lateInterest += current.getInterest();
		    	lastDueEmi = current ; 
		    	Duecase = true;
		    }
		    else if (Ldate.after(todayDate)&& lastPaidGet==true) 
		    {
		    	nextEmi = current;
		    	lastPaidGet=false;
		    	break;
		    }
		}	    
	}
		

	
	
	public void checkPaid() throws ParseException
	{
		userInfo();
		discount=0;
		// System.out.println(discount);
		totalChqChrgRemainLocal=totalChqChargeRemain;
		totalInterestRemainLocal=totalIntrestRemain;
		totalPenaltyRemainLocal=totalPenaltyRemain;
		double maxDis=totalIntrestRemain+totalChqChargeRemain+totalPenaltyRemain;
		discount=discountChequeBounce+discountIntrest+discountPenalty;
		if(discount<=maxDis)
		{
			if(totalChqChargeRemain>=discountChequeBounce)
			{
				totalChqChargeRemain-=discountChequeBounce;
			}
			else
			{
				discountChequeBounce=totalChqChargeRemain;
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Cheque Bounce Discount Can't be greater than Rs. "+discountChequeBounce));
			}
			
			if(totalIntrestRemain>=discountIntrest)
			{
				totalIntrestRemain-=discountIntrest;
			}
			else
			{
				discountIntrest=totalIntrestRemain;
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Intrest Discount Can't be greater than Rs. "+discountIntrest));
			}
			
			if(totalPenaltyRemain>=discountPenalty)
			{
				totalPenaltyRemain-=discountPenalty;
			}
			else
			{
				discountPenalty=totalPenaltyRemain;
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Penalty Discount Can't be greater than Rs. "+discountPenalty));
			}
			
			discount=discountChequeBounce+discountIntrest+discountPenalty;
			// System.out.println("discount "+discount+" int: "+discountIntrest+" pen: "+discountPenalty+" disin: "+discountChequeBounce);
			amount2=totalRemaining-discount;
			amount2+=foreclosureCharges;
		}
		else
		{
			discount=discountChequeBounce=discountIntrest=discountPenalty=0;
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Discount Can't be greater than Rs. "+maxDis));
		}
		amount2=Double.parseDouble(dc.format(amount2));
		amount2 = Math.round(amount2);
		
		amount=amount3;
		amount=amount-amount2;
		
		//finalAmount = amount - loan_info.getTotalAdvanceEMIAmount() - loan_info.getStamp() - Double.valueOf(loan_info.getFileCharge());
		
		finalAmount = Math.round(amount - loan_info.getTotalAdvanceEMIAmount() - loan_info.getStamp() - Double.valueOf(loan_info.getFileCharge()) - 
				Double.valueOf(loan_info.getInsuranceFee()) - Double.valueOf(loan_info.getProcessingCharge()));
		
		if (preLoan && amount2 > loanAmount && finalAmount <= 0) 
		{
		    preLoanAmountExceed = true;
		}
		else
		{
		    preLoanAmountExceed = false;
		}	
	}

	
	
	public void submit() 
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId =(int) ss.getAttribute("branchId");
		FacesContext fc=FacesContext.getCurrentInstance();
		int flag=1;
		String savingAccountNo="";
		if(paymentMode2.equalsIgnoreCase("Transfer")  && chkLoanSettlement==false)
		{
			UserInfo savingDetail=obj.savingAccountDetailByShareHolderNo(user_info.getShareHolderNo());
			savingAccountNo=savingDetail.getAccountNo();
			if(savingDetail!=null && savingDetail.getAmount()<amount2)
			{	
				flag=96;
			}
			
			Timestamp curr=new Timestamp(paidDate.getTime());
			curr.setHours(0);curr.setMinutes(0);curr.setSeconds(0);curr.setNanos(0);
			if(savingDetail!=null && savingDetail.getEntryDate().after(curr))
			{
				flag=95;
			}
		}
		
		if(flag==1)
		{   		
			String addloancloser = obj.addLoanCloser(receipt_no, totalPenaltyRemainLocal, totalInterestRemainLocal, 
													 totalChqChrgRemainLocal, totalRemaining, discount, amount2, date, 
													 paymentMode2, transfer, loanNo2, discountIntrest, discountPenalty, 
													 discountChequeBounce, chequeNo, chequeDate, totalPrincipalRemain, dsaName, 
													 branchId, foreclosureCharges, "", "", 0, 0);
			
			Connection conn = DataBaseConnection.JAVAConnection();
			if(paymentMode2.equalsIgnoreCase("cash") || paymentMode2.equalsIgnoreCase("Transfer"))
			{
				submittedBankName = "N/A";
			}
			
			double principalIntrest = amount2 - (totalChqChargeRemain + totalPenaltyRemain + savingAmount + foreclosureCharges);
			// System.out.println("called "+amount);
			receipt_no = String.valueOf(obj.loanPayReceiptNo());
			int	n = obj.payLoanEMI(branchId, loanNo2, loanCate, principalIntrest, date, paymentMode2, chequeNo, chequeDate, 
								   bankName, 0, receipt_no, submittedBankName, "No", discountIntrest, -1, loan_info.getDsacode(), 
								   "", "");
			MyId = n;
			if (n >= 1) 
			{
				addSavingAmount(conn);
				//totalIntrestRemain=totalIntrestRemain-discount;
				if(commission > 0)
				{
					System.out.println("commmison: "+commission);
					String emiNo = "all";
					boolean checkEntry = obj.checkDuplicacyInDsaCommissionTable(loan_info.getLoanNo(),emiNo);
					if(checkEntry == false)
					{
						String dsaName = obj.dsaNameById(loan_info.getDsacode(),conn);
						int j = obj.insertDataInDsaCommissionTable(branchId, loan_info.getLoanType(), loan_info.getLoanNo(), 
																   loan_info.getDsacode(), commission, paidDate, emiNo);
						if(j > 0)
						{
							fc = FacesContext.getCurrentInstance();
							fc.addMessage(null, new FacesMessage("Commission Auto Credited to "+loan_info.getDsacode()+" - "+dsaName+" Rs.:- "+commission));
						}
					}
				}
				if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No"))
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
					
					obj.updateInterestAmountInLoanPayReceipt(branchId,n, totalIntrestRemain);
					obj.decreaseSharedCompanyAmount(branchId,totalPrincipalRemain);
					RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
				}
				else if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("Yes"))
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
					
					obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(n, totalIntrestRemain);
					obj.increaseBankBalance(submittedBankName, amount2,conn);
					RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
				}
				else if(paymentMode2.equalsIgnoreCase("Transfer") && chkLoanSettlement==false)
				{
					String svRemark = "Loan Closer "+loanNo2+" EMI Deposit";
					int	m = obj.userWithdrwal(branchId,savingAccountNo, String.valueOf(principalIntrest), paidDate,paymentMode2, chequeNo, chequeDate, bankName, "","approved",svRemark,"");
					if (m >= 1) 
					{
						double preAmount=obj.acconuntHolderAmountByAccountNo(savingAccountNo);
						Double newAmount=preAmount-principalIntrest;
						obj.updateSavingAmountByAccountNo(savingAccountNo,newAmount);
						
						obj.updateInterestAmountInLoanPayReceipt(branchId,n, totalIntrestRemain);
					}
				}	
				else
				{
					obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(n, totalIntrestRemain);
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully... Please Approve Your Payment"));
				}
				
				detailsForLoanPrint();
				obj.updateStatusOfLoan(loanCate,loanNo2);
				
				discount=0;
				
				if(totalPenaltyRemain>0 && chkLoanSettlement==false)
				{
					totalPenaltyRemain=Double.parseDouble(dc.format(totalPenaltyRemain));
					voucherNo=obj.generateVoucherNo(branchId,"income_table",conn);
					int i=new DataBaseIncomeExpense().addIncome(branchId,date,"Other_Cr",paymentMode2,String.valueOf(totalPenaltyRemain) ,chequeNo,"",bankName,chequeDate,
							"Penalty Income","Receive Penalty",0,submittedBankName, "0", discountPenalty,loanNo2, loanCategory, voucherNo,"",0,"active",""); 
					if(i>=1)
					{ 
					    //FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Income Added Successfully"));
					    if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("No"))
						{
							obj.increaseCompanyCapitalAmount(branchId,totalPenaltyRemain,conn);
						}
						else if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("Yes"))
						{
							obj.increaseBankBalance(submittedBankName, totalPenaltyRemain,conn);
						}
					    
						else if(paymentMode2.equalsIgnoreCase("Transfer") && chkLoanSettlement==false)
						{
							String svRemark=loanNo2+" Penalty Deposit";
							int	m = obj.userWithdrwal(branchId,savingAccountNo, String.valueOf(totalPenaltyRemain), date,paymentMode2, chequeNo, chequeDate, bankName, "","approved",svRemark,"");
							if (m >= 1) 
							{
								double preAmount=obj.acconuntHolderAmountByAccountNo(savingAccountNo);
								Double newAmount=preAmount-totalPenaltyRemain;
								obj.updateSavingAmountByAccountNo(savingAccountNo,newAmount);
							}
						}	
					}   
				
				}
				
				if(totalChqChargeRemain>0 && chkLoanSettlement==false)
				{
					voucherNo=obj.generateVoucherNo(branchId,"income_table",conn);
					int j=new DataBaseIncomeExpense().addIncome(branchId,paidDate,"Other_Cr",paymentMode2,String.valueOf(totalChqChargeRemain) ,chequeNo,"",bankName,
							chequeDate,"Cheque Bounce Income","Receive Cheque Bounce Charges",0,submittedBankName, "0", discountChequeBounce,loanNo2, loanCategory,voucherNo,"",0,"active",""); 
					if(j>=1)
					{
					    //FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Income Added Successfully"));
					    if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("No"))
						{
							obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(totalChqChargeRemain),conn);
						}
						else if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("Yes"))
						{
							obj.increaseBankBalance(submittedBankName, Double.valueOf(totalChqChargeRemain),conn);
						}
						else if(paymentMode2.equalsIgnoreCase("Transfer") && chkLoanSettlement==false)
						{
							String svRemark=loanNo2+" Bounce Charge Deposit";
							int	m = obj.userWithdrwal(branchId,savingAccountNo, String.valueOf(totalChqChargeRemain), paidDate,paymentMode2, chequeNo, chequeDate, bankName, "","approved",svRemark,"");
							if (m >= 1) 
							{
								double preAmount=obj.acconuntHolderAmountByAccountNo(savingAccountNo);
								Double newAmount=preAmount-totalChqChargeRemain;
								obj.updateSavingAmountByAccountNo(savingAccountNo,newAmount);
							}
						}	
					}   
				}
				
				if(foreclosureCharges>0 && chkLoanSettlement==false)
				{
					voucherNo=obj.generateVoucherNo(branchId,"income_table",conn);
					int j=new DataBaseIncomeExpense().addIncome(branchId,paidDate,"Other_Cr",paymentMode2,String.valueOf(foreclosureCharges) ,chequeNo,"",bankName,
							chequeDate,"Receive Loan Foreclosure Charges","Loan Foreclosure Charges",0,submittedBankName, "0", 
							discountChequeBounce,loanNo2, loanCategory,voucherNo,"",0,"active",""); 
					if(j>=1)
					{
					    //FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Income Added Successfully"));
					    if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("No"))
						{
							obj.increaseCompanyCapitalAmount(branchId,foreclosureCharges,conn);
						}
						else if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("Yes"))
						{
							obj.increaseBankBalance(submittedBankName, foreclosureCharges,conn);
						}
						else if(paymentMode2.equalsIgnoreCase("Transfer") && chkLoanSettlement==false)
						{
							String svRemark=loanNo2+" Foreclosure Charges";
							int	m = obj.userWithdrwal(branchId,savingAccountNo, String.valueOf(foreclosureCharges), paidDate,paymentMode2, chequeNo, chequeDate, bankName, "","approved",svRemark,"");
							if (m >= 1) 
							{
								double preAmount=obj.acconuntHolderAmountByAccountNo(savingAccountNo);
								Double newAmount=preAmount-foreclosureCharges;
								obj.updateSavingAmountByAccountNo(savingAccountNo,newAmount);
							}
						}	
					}   
				}
				
				loanSettlementAmount=amount2;
				if(chkLoanSettlement==true)
				{
					voucherNo=obj.generateVoucherNo(branchId,"expense_table",conn);
					int x=new DataBaseIncomeExpense().addExpense(branchId,paidDate,"Other_Dr",paymentMode2,String.valueOf(loanSettlementAmount),chequeNo,"",submittedBankName,
							chequeDate,"Loan Settlement", "Loan Settlement","0", voucherNo, 0,"0",loanNo2,loanCategory); 
				}
				
				value2= false;paymentMode2=chequeNo=bankName="";
				amount2=0;chequeNo=bankName="";chequeDate=null;show=false;
				try {
					conn.close();
				} catch (Exception e) {
					// TODO: handle exception
				}
				 
			}
			else
			{
				fc = FacesContext.getCurrentInstance();
				fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
			}
		}
		else if(flag==96)
 		{
 			fc.addMessage(null, new FacesMessage("Saving Account No. "+savingAccountNo+" doesn't have sufficient Balance. "));
 		}
		else
		{
			fc.addMessage(null, new FacesMessage("Some Error Occured!!!"));
		}
		
	}
	
	
	
	public void addSavingAmount(Connection conn)
	{
	
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		if(savingAmount>0)
 		{
 			String accno=obj.savingAccountByShareHolderNo(user_info.getShareHolderNo());
 			String app_status="approved";
 			String detail=loanNo+" EMI Deposit";
 			int	n = obj.userDeposit(branchId,accno, String.valueOf(savingAmount), paidDate,"cash", "", null, "",app_status,"N/A",detail, "");
			if (n >= 1) 
			{
				double preAmount=obj.acconuntHolderAmountByAccountNo(accno);
				Double newAmount=preAmount+savingAmount;
				obj.updateSavingAmountByAccountNo(accno,newAmount);
				obj.increaseCompanyCapitalAmount(branchId,savingAmount,conn);
			}
 		}
	}
	
	
	
	public void detailsForLoanPrint()
	{
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		ss.setAttribute("shareHolderNo", user_info.getShareHolderNo());
		ss.setAttribute("loanNo",loanNo2);
		ss.setAttribute("receipt_no",receipt_no);
		ss.setAttribute("installment_amount",amount2);
		ss.setAttribute("loanType", loanCategory);
		ss.setAttribute("id",MyId);
		ss.setAttribute("receipt_date",new SimpleDateFormat("dd/MM/yyyy").format(paidDate));
		ss.setAttribute("instlmnt_no","Loan Closure");
	}
	
	
	
	public String releasePayment()
	{	
		if (preLoan && amount2 > loanAmount) 
		{
			FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(FacesMessage.SEVERITY_WARN,
						"Please uncheck Pre-Loan Close to release amount.", "pls uncheck pre cl"));
			return "";
		}
		
		HttpSession ss=(HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		Connection conn=DataBaseConnection.JAVAConnection();
		double paybleAmount=loanAmount-paidAmount;
		double remainingCompanyCapitalAmount=obj.remainingCompanyCapitalAmount(branchId,conn);
		
		if(paymentMode.equalsIgnoreCase("Cash"))
		{
			if(amount<=remainingCompanyCapitalAmount)
		    {
				if(amount<=paybleAmount)
				{
					int i=obj.addDebitLoan(branchId,shareHolderNo,loanCategory,loanNo,Math.round(amount),paymentMode,bankName,bankBranch,chequeNo,chequeDate,date,umrnNo);
			       
					if(preLoan == true || multiPreLoan == true)
					{
						obj.addDebitLoan(branchId,shareHolderNo,loanCategory,loanNo,Math.round(amount2),paymentMode,bankName,bankBranch,chequeNo,chequeDate,date,umrnNo);
						
						if (multiPreLoan) 
						{
							submitForMultiLoanCloser();
						}
						else
						{
							submit();
						}
					}
					
					if(i>=1)
			        {
						if (loan_info.getTotalAdvanceEMIAmount() > 0) 
						{
							for (i = 1; i <= loan_info.getAdvanceTerm(); i++)
							{
								receipt_no=String.valueOf(obj.loanPayReceiptNo());
								obj.payLoanEMI(branchId, loanNo, loanCategory, loan_info.getInstallAmount(), date, 
											   paymentMode, chequeNo, date, bankName, 0, receipt_no, "N/A", "No", 
											   0, i, loan_info.getDsacode(), "", "");
							}
						}
						
			        	sendMessage(conn);
						obj.increaseSharedCompanyAmount(branchId,amount,conn);						
						
						FacesContext fc=FacesContext.getCurrentInstance();
						// File Charge Amount Add on Loan Approval
						String fcStatus=obj.checkSettingFromMasterSettingNewTable("File Charge", conn);
						if(fcStatus.equalsIgnoreCase("loan_disburse"))
						{
							int z=obj.updateIncomeTableSelectedPendingEntryStatus("File Charge","active" , loanNo,conn,date);
							if(z>0)
							{
								if(Double.valueOf(selectedLoan.getFileCharge())>0)
								{
									obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(selectedLoan.getFileCharge()), conn);
									fc.addMessage(null, new FacesMessage("File Charge "+selectedLoan.getFileCharge() +" Rs. Add Sucessfully."));
								}
							}
						}	
						
						// Insurance Fee Amount Add on Loan Approval
						String insFeeStatus=obj.checkSettingFromMasterSettingNewTable("Insurance Fee", conn);
						if(insFeeStatus.equalsIgnoreCase("loan_disburse"))
						{
							int z=obj.updateIncomeTableSelectedPendingEntryStatus("Insurance Fee","active" , loanNo,conn, date);
							if(z>0)
							{
								if(Double.valueOf(selectedLoan.getInsuranceFee())>0)
								{
									obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(selectedLoan.getInsuranceFee()), conn);
									fc.addMessage(null, new FacesMessage("Insurance Fee "+selectedLoan.getInsuranceFee() +" Rs. Add Sucessfully."));
								}
							}
						}	
						
						String pcStatus=obj.checkSettingFromMasterSettingNewTable("Processing Charge", conn);
						if(pcStatus.equalsIgnoreCase("loan_disburse"))
						{
							int z=obj.updateIncomeTableSelectedPendingEntryStatus("Processing Charge","active" , loanNo,conn, date);
							if(z>0)
							{
								if(Double.valueOf(selectedLoan.getProcessingCharge())>0)
								{
									obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(selectedLoan.getProcessingCharge()), conn);
									fc.addMessage(null, new FacesMessage("Processing Charge "+selectedLoan.getProcessingCharge() +" Rs. Add Sucessfully."));
								}
							}
						}
						
						String sfStatus=obj.checkSettingFromMasterSettingNewTable("Stamp Fee", conn);
						if(sfStatus.equalsIgnoreCase("loan_disburse"))
						{
							int z=obj.updateIncomeTableSelectedPendingEntryStatus("Stamp Fee","active" , loanNo,conn, date);
							if(z>0)
							{
								if(Double.valueOf(selectedLoan.getStamp()) > 0)
								{
									obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(selectedLoan.getStamp()), conn);
									fc.addMessage(null, new FacesMessage("Stamp Fee "+selectedLoan.getStamp() + " Rs. Add Sucessfully."));
								}
							}
						}
						
						
						
						shareHolderNo=loanCategory=loanNo=bankBranch=bankName=chequeNo=paymentMode="";
						chequeDate=null;
						transactionHistory=obj.viewDebitLoanHistory(loanCategory, loanNo, shareHolderNo,conn);
						RequestContext.getCurrentInstance().update(":form5");
						RequestContext.getCurrentInstance().showMessageInDialog(new FacesMessage(FacesMessage.SEVERITY_INFO, "Loan Disburse Message", loanNo+" Loan Amount Released Succesfully."));
						
						
						try 
						{
							conn.close();
						} 
						catch (Exception e) 
						{
							e.printStackTrace();
						}
					
						return "pendingLoanDisburseList.xhtml";
				    }
			        else
			        {
			        	FacesContext fc=FacesContext.getCurrentInstance();
			        	fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
			        	return "";
			        }
				}
				else
				{
					FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Only Rs."+paybleAmount+" is to be paid. Please Check!"));
					return "";
				}
				
		    }
		    else
			{
			   FacesContext fc=FacesContext.getCurrentInstance();
			   fc.addMessage(null, new FacesMessage("Sorry! Loan Amount Can't Be released. Company's Remaining Capital Amount is '"+remainingCompanyCapitalAmount+"'"));
			   return "";
			}
		}
		
		if(paymentMode.equalsIgnoreCase("transfer"))
		{
			if(amount<=paybleAmount)
			{
				int i=obj.addDebitLoan(branchId,shareHolderNo,loanCategory,loanNo,amount,paymentMode,bankName,bankBranch,chequeNo,chequeDate,date,umrnNo);
		        
				
				if(preLoan == true)
			       {
						obj.addDebitLoan(branchId,shareHolderNo,loanCategory,loanNo,Math.round(amount2),paymentMode2,"","","",null,date,umrnNo);

			    	   submit();
			       }
				if(i>=1)
		        {
		        	obj.decreaseBankBalance(bankName, amount, conn);
		        	String remark="Transfer From Loan A/C "+loanNo;
		        	int	n = obj.userDeposit(branchId,savingAccountNo,String.valueOf(amount), date,paymentMode, chequeNo, 
		        			chequeDate, bankName,"approved","N/A",remark,"");
					if (n >= 1) 
					{
						String message="Payment Transfer SuccessFully.";
						FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(message));
						double preAmount=obj.acconuntHolderAmountByAccountNo(savingAccountNo);
						Double newAmount=preAmount+amount;
						obj.updateSavingAmountByAccountNo(savingAccountNo,newAmount);
					}	
						
						
		        	// Due to Auto Entry of File Charge and Insurance Fee
					if(flag==1)
			        {
						double remainDisburse=0;
						 FacesContext fc=FacesContext.getCurrentInstance();
						// File Charge Amount Add on Loan Approval
						conn=DataBaseConnection.JAVAConnection();
						String fcStatus=obj.checkSettingFromMasterSettingNewTable("File Charge", conn);
						if(fcStatus.equalsIgnoreCase("loan_disburse"))
						{
							int z=obj.updateIncomeTableSelectedPendingEntryStatus("File Charge","active" , loanNo,conn,date);
							if(z>0)
							{
								if(Double.valueOf(selectedLoan.getFileCharge())>0)
								{
									obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(selectedLoan.getFileCharge()), conn);
									remainDisburse+=Double.valueOf(selectedLoan.getFileCharge());
									fc.addMessage(null, new FacesMessage("File Charge "+selectedLoan.getFileCharge() +" Rs. Add Sucessfully."));
								}
							}
						}	
						// Insurance Fee Amount Add on Loan Approval
						String insFeeStatus=obj.checkSettingFromMasterSettingNewTable("Insurance Fee", conn);
						if(insFeeStatus.equalsIgnoreCase("loan_disburse"))
						{
							int z=obj.updateIncomeTableSelectedPendingEntryStatus("Insurance Fee","active" , loanNo,conn, date);
							if(z>0)
							{
								if(Double.valueOf(selectedLoan.getInsuranceFee())>0)
								{
									obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(selectedLoan.getInsuranceFee()), conn);
									remainDisburse+=Double.valueOf(selectedLoan.getInsuranceFee());
									fc.addMessage(null, new FacesMessage("Insurance Fee "+selectedLoan.getInsuranceFee() +" Rs. Add Sucessfully."));
								}
							}
						}
						
						String pcStatus=obj.checkSettingFromMasterSettingNewTable("Processing Charge", conn);
						if(pcStatus.equalsIgnoreCase("loan_disburse"))
						{
							int z=obj.updateIncomeTableSelectedPendingEntryStatus("Processing Charge","active" , loanNo,conn,date);
							if(z>0)
							{
								if(Double.valueOf(selectedLoan.getProcessingCharge())>0)
								{
									obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(selectedLoan.getProcessingCharge()), conn);
									remainDisburse+=Double.valueOf(selectedLoan.getProcessingCharge());
									fc.addMessage(null, new FacesMessage("Processing Charge "+selectedLoan.getProcessingCharge() +" Rs. Add Sucessfully."));
								}
							}
						}	
						System.out.println(remainDisburse);
						
						if(remainDisburse>0)
						{
							i=obj.addDebitLoan(branchId,shareHolderNo,loanCategory,loanNo,remainDisburse,"Cash","N/A",bankBranch,chequeNo,chequeDate,date,umrnNo);
					        if(i>=1)
					        {
					        	obj.increaseSharedCompanyAmount(branchId,remainDisburse,conn);
					        }
						}
						
			        }
					
		        	shareHolderNo=loanCategory=loanNo=bankBranch=bankName=chequeNo=paymentMode="";
					chequeDate=null;
					try {
						conn.close();
					} catch (Exception e) {
						// TODO: handle exception
					}
					RequestContext.getCurrentInstance().showMessageInDialog(new FacesMessage(FacesMessage.SEVERITY_INFO, "Loan Disburse Message", paymentMode+" Released Succesfully. Please check due cheque/NEFT notification"));
					return "pendingLoanDisburseList.xhtml";
		        }
		        else
		        {
		        	FacesContext fc=FacesContext.getCurrentInstance();
		        	fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
		        	return "";
		        }
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Only Rs."+paybleAmount+" is to be paid. Please Check!"));
				return "";
			}
		}
		else
		{
			if(amount<=paybleAmount)
			{
				int i=obj.addDebitLoan(branchId,shareHolderNo,loanCategory,loanNo,Math.round(amount),paymentMode,bankName,bankBranch,chequeNo,chequeDate,date,umrnNo);
				
				if(preLoan == true || multiPreLoan == true)
			       {
						obj.addDebitLoan(branchId,shareHolderNo,loanCategory,loanNo,Math.round(amount2),paymentMode2,"","","",null,date,umrnNo);

						if (multiPreLoan) 
						{
							submitForMultiLoanCloser();
						}
						else
						{
							submit();
						}
			       }
		        if(i>=1)
		        {
		        	if (loan_info.getTotalAdvanceEMIAmount() > 0) 
					{
						for (i=1; i <= loan_info.getAdvanceTerm(); i++)
						{
							receipt_no=String.valueOf(obj.loanPayReceiptNo());
							obj.payLoanEMI(branchId, loanNo, loanCategory, loan_info.getInstallAmount(), date, 
										   paymentMode, chequeNo, date, bankName, 0, receipt_no, "N/A", "No", 
										   0, i, loan_info.getDsacode(), "", "");
						}
					}
		        	
		        	obj.decreaseBankBalance(bankName, amount, conn);
		        	sendMessage(conn);
		        	// Due to Auto Entry of File Charge and Insurance Fee
		        	
					if(flag==1 || loanDeduction==false)
			        {
		
						double remainDisburse=0;
						 FacesContext fc=FacesContext.getCurrentInstance();
						// File Charge Amount Add on Loan Approval
						String fcStatus=obj.checkSettingFromMasterSettingNewTable("File Charge", conn);
						if(fcStatus.equalsIgnoreCase("loan_disburse"))
						{
							int z=obj.updateIncomeTableSelectedPendingEntryStatus("File Charge","active" , loanNo,conn,date);
							System.out.println("z is :"+z);
							if(z>0)
							{
								
								if(Double.valueOf(selectedLoan.getFileCharge())>0)
								{
									obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(selectedLoan.getFileCharge()), conn);
									remainDisburse+=Double.valueOf(selectedLoan.getFileCharge());
									
									fc.addMessage(null, new FacesMessage("File Charge "+selectedLoan.getFileCharge() +" Rs. Add Sucessfully."));
								}
							}
						}	
						
						System.out.println("file charge is:"+selectedLoan.getFileCharge());
						System.out.println("file charge is:"+remainDisburse);
						
						// Insurance Fee Amount Add on Loan Approval
						String insFeeStatus=obj.checkSettingFromMasterSettingNewTable("Insurance Fee", conn);
						if(insFeeStatus.equalsIgnoreCase("loan_disburse"))
						{
							int z=obj.updateIncomeTableSelectedPendingEntryStatus("Insurance Fee","active" , loanNo,conn, date);
							if(z>0)
							{
								if(Double.valueOf(selectedLoan.getInsuranceFee())>0)
								{
									obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(selectedLoan.getInsuranceFee()), conn);
									remainDisburse+=Double.valueOf(selectedLoan.getInsuranceFee());
									fc.addMessage(null, new FacesMessage("Insurance Fee "+selectedLoan.getInsuranceFee() +" Rs. Add Sucessfully."));
								}
							}
						}
						
						String pcStatus=obj.checkSettingFromMasterSettingNewTable("Processing Charge", conn);
						System.out.println(pcStatus);
						if(pcStatus.equalsIgnoreCase("loan_disburse"))
						{int z=0;
							if("NBFC".equalsIgnoreCase(companyType))
							{
								z=dby.updateIncomeTableSelectedPendingEntryStatusForOnline("Processing Charge","active" , loanNo,conn,date,paymentMode,chequeNo,chequeDate,bankName);
							}
							else {
								 z=obj.updateIncomeTableSelectedPendingEntryStatus("Processing Charge","active" , loanNo,conn,date);

							}
							
							if(z>0)
							{
								if(Double.valueOf(selectedLoan.getProcessingCharge())>0)
								{
									obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(selectedLoan.getProcessingCharge()), conn);
									remainDisburse+=Double.valueOf(selectedLoan.getProcessingCharge());
									fc.addMessage(null, new FacesMessage("Processing Charge "+selectedLoan.getProcessingCharge() +" Rs. Add Sucessfully."));
								}
							}
						}	
						
						String sfStatus=obj.checkSettingFromMasterSettingNewTable("Stamp Fee", conn);
						if(sfStatus.equalsIgnoreCase("loan_disburse"))
						{int z=0;
							if("NBFC".equalsIgnoreCase(companyType))
							{
								z=dby.updateIncomeTableSelectedPendingEntryStatusForOnline("Stamp Fee","active" , loanNo,conn,date,paymentMode,chequeNo,chequeDate,bankName);
							}
							else {
								 z=obj.updateIncomeTableSelectedPendingEntryStatus("Stamp Fee","active" , loanNo,conn,date);

							}
							
							if(z>0)
							{
								if(Double.valueOf(loan_info.getStamp())>0)
								{
									obj.increaseCompanyCapitalAmount(branchId,Double.valueOf(loan_info.getStamp()), conn);
									remainDisburse+=Double.valueOf(loan_info.getStamp());
									fc.addMessage(null, new FacesMessage("Stamp Fee "+loan_info.getStamp() +" Rs. Add Sucessfully."));
								}
							}
						}
						
						
						
						
						if(remainDisburse>0 &&  loanDeduction==true)
						{
							if("NBFC".equalsIgnoreCase(companyType))
							{
								i=obj.addDebitLoan(branchId,shareHolderNo,loanCategory,loanNo,remainDisburse,paymentMode,"N/A",bankBranch,chequeNo,chequeDate,date,umrnNo);

							}
							else
							{
								i=obj.addDebitLoan(branchId,shareHolderNo,loanCategory,loanNo,remainDisburse,"Cash","N/A",bankBranch,chequeNo,chequeDate,date,umrnNo);
							}
					        if(i>=1)
					        {
					        	obj.increaseSharedCompanyAmount(branchId,remainDisburse,conn);
					        }
						}
						
			        }
					
					
		        	shareHolderNo=loanCategory=loanNo=bankBranch=bankName=chequeNo=paymentMode="";
					chequeDate=null;
					try {
						conn.close();
					} catch (Exception e) {
						// TODO: handle exception
					}
					RequestContext.getCurrentInstance().showMessageInDialog(new FacesMessage(FacesMessage.SEVERITY_INFO, "Loan Disburse Message", paymentMode+" Released Succesfully. Please check due cheque/NEFT notification"));
					 
					return "pendingLoanDisburseList.xhtml";
		        }
		        else
		        {
		        	FacesContext fc=FacesContext.getCurrentInstance();
		        	fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
		        	return "";
		        }
			}
			else
			{
				FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Only Rs."+paybleAmount+" is to be paid. Please Check!"));
				return "";
			}
				
		}
	}
	
	
	
	public void detectMultiPreLoan() throws ParseException 
	{
		amount3 = Double.valueOf(loan_info.getLoanAmount());
		calculationMethod();
		amount2 = 0;
		
		try (Connection conn = DataBaseConnection.JAVAConnection())
		{
			allPreviousLoanList = dbmt.selectLoanPreLoanNo(conn, loanNo, loanCategory, user_info.getShareHolderNo());
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
        
		if (allPreviousLoanList != null) 
		{
			if (allPreviousLoanList.size() > 1) 
			{
				if ("Vibhu Micro Benefit Foundation".equalsIgnoreCase(companyName)) 
				{
					showMultiCloser = true;
				}
			}
			else 
			{
				showMultiCloser = false;
			}
			
			if (showMultiCloser) 
			{
				for (PreviousLoanInfo pl : allPreviousLoanList)
				{
					userInfoForMultiLoanCloser(pl);
					
					if (pl.isSelected())
					{
						multiPreLoan = true;
					}
				}

				amount2 = Math.round(amount2);
				
				if (amount2 > loanAmount) 
				{
					preLoanAmountExceed = true;
					FacesContext.getCurrentInstance().addMessage(null,
							new FacesMessage("Pre-Loan Close amount (" + amount2 + ") is greater than Loan Amount (" + loanAmount
										   + "). Please uncheck Pre-Loan Close to release amount.","Pre-Loan Close"));
				}
			}
		} 
		else 
		{
			multiPreLoan = false;
			amount2 = 0;
			preLoanAmountExceed = false;
		}
	}
	
	
	
	public void userInfoForMultiLoanCloser(PreviousLoanInfo pl) throws ParseException 
	{
		Connection conn = DataBaseConnection.JAVAConnection();
		
		show = true;
		
		System.out.println("Pre Close Loan No : " + pl.getLoanNo() + "   " + pl.getLoanCategory());
		
		user_info2 = obj.userInfoByLoanNoLoanType(pl.getLoanNo(), pl.getLoanCategory(), conn);
		loan_info2 = obj.loanInfoByLoanNoLoanType(pl.getLoanNo(), pl.getLoanCategory(), conn);
		
		if(loan_info2.getDsacode() == null || loan_info2.getDsacode().equals(""))
		{
			commission = 0;
			showDsaField = false;
		}
		else
		{
			dsaName = obj.dsaNameById(loan_info2.getDsacode(),conn);
			showDsaField = true;
			calculateCommission(conn);
		}
		
		if(loan_info2.getEmiMode().equals("both"))
		{
			renderTableField = true;
		}
		
		loanEMIList = obj.loanInstallment(pl.getLoanCategory(), pl.getLoanNo(), conn);
		
		foreClosureInterest = foreClosureTotalRemaining = 0;
		
		for(int l = 0; l < loanEMIList.size(); l++)
		{
			Date dt = new Date();
			if(loanEMIList.get(l).getStatus().equals("Paid"))
			{
				loanEMIList.get(l).setColorStatus("paid");
			}
			else
			{
				if(loanEMIList.get(l).getInstallDate().before(dt))
				{
					loanEMIList.get(l).setColorStatus("due");
					foreClosureInterest += Double.parseDouble(dc.format(
										   Double.parseDouble(loanEMIList.get(l).getInterestAmount())));
				}
				else
				{
					loanEMIList.get(l).setColorStatus("upcoming");
				}
			}
		}
		
		loanEMIList = obj.penaltyCalculationMethod(pl.getLoanCategory(), pl.getLoanNo(), loanEMIList, conn);
		
		double totPaid = obj.totalPaidPenaltyAndChequeBounceCharges(pl.getLoanNo(), "Penalty", conn);
		if(totPaid > 0)
		{
			for(int i = 0; i < loanEMIList.size(); i++)
			{
				if(totPaid > loanEMIList.get(i).getPenaltyDue())
				{
					loanEMIList.get(i).setPenaltyPaid(loanEMIList.get(i).getPenaltyDue());
				}
				else
				{
					loanEMIList.get(i).setPenaltyPaid(totPaid);
					break;
				}
				
				totPaid = totPaid - loanEMIList.get(i).getPenaltyDue();
			}
		}
		
		totalPenaltyDue = totalPenaltyPaid = totalIntrest = totalEmi = totalPrincipal = totalDue=totalPaid = 
		totalIntrestRemain = totalPrincipalRemain = totalChqCharge = 0;
		
		for(LoanInfo ll : loanEMIList)
		{    
			System.out.println("value of the one day interest : " + totalInterestRemainLocal);
		    System.out.println("l");
			totalEmi += ll.getInstallAmount();
			totalIntrest += Double.parseDouble(ll.getInterestAmount());
			System.out.println("value of the month Interest :::::::" + ll.getInterestAmount());
			totalPrincipal += Double.parseDouble(ll.getPrincipalAmount());
			totalPaid += ll.getPaidAmount();
			totalDue += ll.getDueAmount();
			totalPenaltyDue += ll.getPenaltyDue();
			totalPenaltyPaid += ll.getPenaltyPaid();
		}
		
		double totPrPaid = obj.totalPrincipalPaidByLoanNo(pl.getLoanNo());
		double totIrPaid = obj.totalIntrestPaidByLoanNo(pl.getLoanNo());
		if(loan_info2.getEmiMode().equals("interest"))
		{
			totalPrincipalRemain = Double.parseDouble(loan_info2.getLoanAmount());
		}
		else
		{
			totalPrincipalRemain = Double.parseDouble(loan_info2.getLoanAmount())-totPrPaid;
		}
		
		totalIntrestRemain = totalIntrest - totIrPaid;
		totalIntrestRemain = totalIntrestRemain - loan_info2.getDiscount();  
		
		totalChqCharge = obj.calculatePenaltyAndChequeBounceCharges(pl.getLoanNo(), "Cheque Bounce", pl.getLoanCategory(), conn);
		paidChqcharge = obj.totalPaidPenaltyAndChequeBounceCharges(pl.getLoanNo(), "Cheque Bounce", conn);
		totalChqChargeRemain = Double.parseDouble(dc.format(totalChqCharge - paidChqcharge));
		
		totalEmi = Double.parseDouble(dc.format(totalEmi));
		totalIntrest = Math.round(totalIntrest);
		
		totalPrincipal = Math.round(totalPrincipal);
		totalPaid = Double.parseDouble(dc.format(totalPaid));
		totalDue = Double.parseDouble(dc.format(totalDue));
		totalPenaltyDue = Double.parseDouble(dc.format(totalPenaltyDue));
		totalPenaltyPaid = Double.parseDouble(dc.format(totalPenaltyPaid));
		totalPenaltyRemain = Double.parseDouble(dc.format(totalPenaltyDue-totalPenaltyPaid));
		totalIntrestRemain = Double.parseDouble(dc.format(totalIntrestRemain));
		
		if(totalIntrestRemain < 0)
		{
			totalIntrestRemain = 0;
		}
		
		totalPrincipalRemain = Double.parseDouble(dc.format(totalPrincipalRemain));
		
		if(totalPrincipalRemain < 0)
		{
			totalPrincipalRemain = 0;
		}
		totalRemaining = Double.parseDouble(dc.format(totalIntrestRemain + totalPrincipalRemain + totalChqChargeRemain 
													+ totalPenaltyRemain));

//		amount2 = totalRemaining;
		
		foreClosureInterest = Double.parseDouble(dc.format(foreClosureInterest));
		foreClosureTotalRemaining = totalPrincipalRemain + totalPenaltyRemain + totalChqChargeRemain + foreClosureInterest;
		foreClosureTotalRemaining = Double.parseDouble(dc.format(foreClosureTotalRemaining));
			
		pl.setPrincipalRemaining(totalPrincipalRemain);
		pl.setInterestRemaining(totalIntrestRemain);
		pl.setPenaltyRemaining(totalPenaltyRemain);
		pl.setChequeBounceRemaining(totalChqChargeRemain);

		pl.setTotalRemaining(roundMultiMoney(totalRemaining));

		double rowDiscount = pl.getDiscountInterest() + pl.getDiscountPenalty() + pl.getDiscountChequeBounce();

		pl.setTotalDiscount(roundMultiMoney(rowDiscount));

		pl.setClosureAmount(roundMultiMoney(totalRemaining - rowDiscount + pl.getForeclosureCharges()));
		
		try
		{
			conn.close();
		} 
		catch (Exception e) 
		{
			e.printStackTrace();
		}
	}
	
	
	
	public void checkPaidForMultiLoanCloser() 
	{	
	    double selectedClosureTotal = 0.0;
	    boolean invalidDiscount = false;

	    if (allPreviousLoanList != null) 
	    {
	        for (PreviousLoanInfo pl : allPreviousLoanList) 
	        {
	        	if (pl.isSelected())
				{
					multiPreLoan = true;
				}
	        	
	            double principal = pl.getPrincipalRemaining();
	            double interest = pl.getInterestRemaining();
	            double penalty = pl.getPenaltyRemaining();
	            double chequeBounce = pl.getChequeBounceRemaining();

	            double discountInterest = pl.getDiscountInterest();
	            double discountPenalty = pl.getDiscountPenalty();
	            double discountChequeBounce = pl.getDiscountChequeBounce();

	            if (discountInterest < 0 || discountInterest > interest) 
	            {
	                discountInterest = 0.0;
	                pl.setDiscountInterest(0.0);
	                invalidDiscount = true;
	            }

	            if (discountPenalty < 0 || discountPenalty > penalty) 
	            {
	                discountPenalty = 0.0;
	                pl.setDiscountPenalty(0.0);
	                invalidDiscount = true;
	            }

	            if (discountChequeBounce < 0 || discountChequeBounce > chequeBounce) 
	            {
	                discountChequeBounce = 0.0;
	                pl.setDiscountChequeBounce(0.0);
	                invalidDiscount = true;
	            }

	            double totalRemaining = principal + interest + penalty + chequeBounce;

	            double totalDiscount = discountInterest + discountPenalty + discountChequeBounce;

	            double closureAmount = totalRemaining - totalDiscount + pl.getForeclosureCharges();

	            if (closureAmount < 0) 
	            {
	                closureAmount = 0.0;
	                invalidDiscount = true;
	            }

	            pl.setTotalRemaining(roundMultiMoney(totalRemaining));
	            pl.setTotalDiscount(roundMultiMoney(totalDiscount));
	            pl.setClosureAmount(roundMultiMoney(closureAmount));

	            if (pl.isSelected()) 
	            {
	                selectedClosureTotal += pl.getClosureAmount();
	            }
	        }
	    }

	    amount2 = roundMultiMoney(selectedClosureTotal);

	    amount = amount3 - amount2;

	    finalAmount = Math.round(amount);

	    preLoanAmountExceed = multiPreLoan && (amount2 >= loanAmount || finalAmount <= 0);
	    
	    System.out.println("New loan base amount : " + amount3);
	    System.out.println("Selected closure total : " + amount2);
	    System.out.println("Amount after closures : " + amount);
	    System.out.println("Final release amount : " + finalAmount);
	    System.out.println("Closure exceeds limit : " + preLoanAmountExceed);

	    if (invalidDiscount) 
	    {
	        FacesContext.getCurrentInstance().addMessage(null, 
	        							new FacesMessage("Discount cannot exceed the outstanding balance or be negative. "
	        										   + "Invalid discounts were reset to zero."));
	    }
	}
	
	
	
	public void submitForMultiLoanCloser() 
	{
		HttpSession ss = (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false);
		int branchId = (int) ss.getAttribute("branchId");
		FacesContext fc = FacesContext.getCurrentInstance();
		int flag = 1; 
		String savingAccountNo = "";
		
		if(paymentMode2.equalsIgnoreCase("Transfer")  && chkLoanSettlement == false)
		{
			UserInfo savingDetail = obj.savingAccountDetailByShareHolderNo(user_info.getShareHolderNo());
			savingAccountNo = savingDetail.getAccountNo();
			if(savingDetail != null && savingDetail.getAmount() < amount2)
			{	
				flag = 96;
			}
			
			Timestamp curr = new Timestamp(paidDate.getTime());
			curr.setHours(0);
			curr.setMinutes(0);
			curr.setSeconds(0);
			curr.setNanos(0);
			
			if(savingDetail != null && savingDetail.getEntryDate().after(curr))
			{
				flag = 95;
			}
		}
		
		if(flag == 1)
		{   
			selectedPreviousLoanList = getSelectedLoansForClosure();
			
			Connection conn = DataBaseConnection.JAVAConnection();
			
			for (PreviousLoanInfo pl : selectedPreviousLoanList)
			{
				receipt_no = String.valueOf(obj.loanPayReceiptNo());
			
				double principalIntrest = pl.getClosureAmount() - (pl.getChequeBounceRemaining() + pl.getPenaltyRemaining() 
										+ pl.getForeclosureCharges());
				
				if(paymentMode2.equalsIgnoreCase("cash") || paymentMode2.equalsIgnoreCase("Transfer"))
				{
					submittedBankName = "N/A";
				}
				
				int closer = dbmt.addLoanCloser(receipt_no, pl.getPenaltyRemaining(), pl.getInterestRemaining(), 
												pl.getChequeBounceRemaining(), pl.getTotalRemaining(), pl.getTotalDiscount(), 
												Math.round(pl.getClosureAmount()), date, paymentMode2, transfer, pl.getLoanNo(), 
												pl.getDiscountInterest(), pl.getDiscountPenalty(), pl.getDiscountChequeBounce(), 
												chequeNo, chequeDate, pl.getPrincipalRemaining(), dsaName, branchId, 
												pl.getForeclosureCharges(), "", "", 0, 0);
					
				int n = obj.payLoanEMI(branchId, pl.getLoanNo(), pl.getLoanCategory(), Math.round(principalIntrest), date, 
									   paymentMode2, chequeNo, chequeDate, bankName, 0, receipt_no, submittedBankName, "No", 
									   pl.getDiscountInterest(), -1, loan_info.getDsacode(), "", "");
				
				MyId = n;
				if (n >= 1) 
				{
					addSavingAmount(conn);

					if(commission > 0)
					{
						String emiNo = "all";
						boolean checkEntry = obj.checkDuplicacyInDsaCommissionTable(loan_info.getLoanNo(),emiNo);
						if(checkEntry == false)
						{
							String dsaName = obj.dsaNameById(loan_info.getDsacode(),conn);
							int j = obj.insertDataInDsaCommissionTable(branchId, loan_info.getLoanType(), loan_info.getLoanNo(), 
																	   loan_info.getDsacode(), commission, paidDate, emiNo);
							if(j > 0)
							{
								fc = FacesContext.getCurrentInstance();
								fc.addMessage(null, new FacesMessage("Commission Auto Credited to " + loan_info.getDsacode() 
																   + " - " + dsaName + " Rs.:- " + commission));
							}
						}
					}
					if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("No"))
					{
						FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
						
						obj.updateInterestAmountInLoanPayReceipt(branchId, n, pl.getInterestRemaining() 
															   - pl.getDiscountInterest());
						obj.decreaseSharedCompanyAmount(branchId, pl.getInterestRemaining() - pl.getDiscountInterest());
						RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
					}
					else if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equalsIgnoreCase("Yes"))
					{
						FacesContext.getCurrentInstance().addMessage(null, new FacesMessage("Payment Done SuccessFully..."));
						
						obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(n, pl.getInterestRemaining() 
																							  - pl.getDiscountInterest());
						obj.increaseBankBalance(submittedBankName, pl.getClosureAmount(), conn);
						RequestContext.getCurrentInstance().execute("window.open('loanPayReceipt.xhtml')");
					}
					else if(paymentMode2.equalsIgnoreCase("Transfer") && chkLoanSettlement==false)
					{
						String svRemark = "Loan Closer " + pl.getLoanNo() + " EMI Deposit";
						int	m = obj.userWithdrwal(branchId, savingAccountNo, String.valueOf(principalIntrest), paidDate, 
												  paymentMode2, chequeNo, chequeDate, bankName, "", "approved", svRemark, "");
						if (m >= 1) 
						{
							double preAmount = obj.acconuntHolderAmountByAccountNo(savingAccountNo);
							Double newAmount = preAmount - principalIntrest;
							
							obj.updateSavingAmountByAccountNo(savingAccountNo, newAmount);
							obj.updateInterestAmountInLoanPayReceipt(branchId, n, pl.getInterestRemaining() 
																   - pl.getDiscountInterest());
						}
					}	
					else
					{
						obj.updateInterestAmountInLoanPayReceiptWithoutIncreasingCompanyCapital(n, pl.getInterestRemaining() 
																							  - pl.getDiscountInterest());
						FacesContext.getCurrentInstance().addMessage(null, 
												new FacesMessage("Payment Done SuccessFully... Please Approve Your Payment"));
					}
					
					detailsForLoanPrint();
					obj.updateStatusOfLoan(pl.getLoanCategory(), pl.getLoanNo());
					
					discount = 0;
					
					if(pl.getPenaltyRemaining() > 0 && chkLoanSettlement == false)
					{
						pl.setPenaltyRemaining(Double.parseDouble(dc.format(pl.getPenaltyRemaining())));
						voucherNo = obj.generateVoucherNo(branchId, "income_table", conn);
						int i = new DataBaseIncomeExpense().addIncome(branchId, date, "Other_Cr", paymentMode2, 
																	  String.valueOf(pl.getPenaltyRemaining()), chequeNo, "", 
																	  bankName, chequeDate, "Penalty Income", "Receive Penalty", 
																	  0, submittedBankName, "0", pl.getDiscountPenalty(), 
																	  pl.getLoanNo(), pl.getLoanCategory(), voucherNo, "", 0, 
																	  "active", ""); 
						if(i >= 1)
						{ 
						    if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("No"))
							{
								obj.increaseCompanyCapitalAmount(branchId, pl.getPenaltyRemaining() - pl.getDiscountPenalty(), conn);
							}
							else if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("Yes"))
							{
								obj.increaseBankBalance(submittedBankName, pl.getPenaltyRemaining() - pl.getDiscountPenalty(), conn);
							}
						    
							else if(paymentMode2.equalsIgnoreCase("Transfer") && chkLoanSettlement == false)
							{
								String svRemark = pl.getLoanNo() + " Penalty Deposit";
								double tpr = pl.getPenaltyRemaining() - pl.getDiscountPenalty();
								
								int	m = obj.userWithdrwal(branchId, savingAccountNo, String.valueOf(tpr), date, 
														  paymentMode2, chequeNo, chequeDate, bankName, "", "approved", 
														  svRemark, "");
								if (m >= 1) 
								{
									double preAmount = obj.acconuntHolderAmountByAccountNo(savingAccountNo);
									Double newAmount = preAmount - tpr;
									obj.updateSavingAmountByAccountNo(savingAccountNo, newAmount);
								}
							}	
						}   
					}
					
					if(pl.getChequeBounceRemaining() > 0 && chkLoanSettlement == false)
					{
						double cbr = pl.getChequeBounceRemaining() - pl.getDiscountChequeBounce();
						voucherNo = obj.generateVoucherNo(branchId, "income_table", conn);
						int j = new DataBaseIncomeExpense().addIncome(branchId, paidDate, "Other_Cr", paymentMode2, 
																	  String.valueOf(cbr), chequeNo, "", bankName, chequeDate, 
																	  "Cheque Bounce Income", "Receive Cheque Bounce Charges", 0, 
																	  submittedBankName, "0", pl.getDiscountChequeBounce(), 
																	  pl.getLoanNo(), pl.getLoanCategory(), voucherNo, 
																	  "", 0, "active", ""); 
						if(j >= 1)
						{
						    if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("No"))
							{
								obj.increaseCompanyCapitalAmount(branchId, Double.valueOf(cbr), conn);
							}
							else if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("Yes"))
							{
								obj.increaseBankBalance(submittedBankName, Double.valueOf(cbr), conn);
							}
							else if(paymentMode2.equalsIgnoreCase("Transfer") && chkLoanSettlement == false)
							{
								String svRemark = pl.getLoanNo() + " Bounce Charge Deposit";
								int	m = obj.userWithdrwal(branchId, savingAccountNo, String.valueOf(cbr), paidDate, paymentMode2, 
														  chequeNo, chequeDate, bankName, "", "approved", svRemark, "");
								if (m >= 1) 
								{
									double preAmount = obj.acconuntHolderAmountByAccountNo(savingAccountNo);
									Double newAmount = preAmount - cbr;
									obj.updateSavingAmountByAccountNo(savingAccountNo, newAmount);
								}
							}	
						}   
					}
					
					if(pl.getForeclosureCharges() > 0 && chkLoanSettlement == false)
					{
						voucherNo = obj.generateVoucherNo(branchId, "income_table", conn);
						int j = new DataBaseIncomeExpense().addIncome(branchId, paidDate, "Other_Cr", paymentMode2, 
																	  String.valueOf(pl.getForeclosureCharges()), chequeNo, "", 
																	  bankName, chequeDate, "Receive Loan Foreclosure Charges", 
																	  "Loan Foreclosure Charges", 0, submittedBankName, "0", 
																	  pl.getDiscountChequeBounce(), pl.getLoanNo(), 
																	  pl.getLoanCategory(), voucherNo, "", 0, "active", ""); 
						if(j >= 1)
						{
						    if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("No"))
							{
								obj.increaseCompanyCapitalAmount(branchId, pl.getForeclosureCharges(), conn);
							}
							else if(paymentMode2.equalsIgnoreCase("Cash") && transfer.equals("Yes"))
							{
								obj.increaseBankBalance(submittedBankName, pl.getForeclosureCharges(),conn);
							}
							else if(paymentMode2.equalsIgnoreCase("Transfer") && chkLoanSettlement == false)
							{
								String svRemark = loanNo2 + " Foreclosure Charges";
								int	m = obj.userWithdrwal(branchId, savingAccountNo, String.valueOf(pl.getForeclosureCharges()), 
														  paidDate, paymentMode2, chequeNo, chequeDate, bankName, "", 
														  "approved", svRemark, "");
								if (m >= 1) 
								{
									double preAmount = obj.acconuntHolderAmountByAccountNo(savingAccountNo);
									Double newAmount = preAmount - pl.getForeclosureCharges();
									obj.updateSavingAmountByAccountNo(savingAccountNo, newAmount);
								}
							}	
						}   
					}
					
					loanSettlementAmount = pl.getClosureAmount();
					if(chkLoanSettlement == true)
					{
						voucherNo = obj.generateVoucherNo(branchId,"expense_table",conn);
						int x = new DataBaseIncomeExpense().addExpense(branchId, paidDate, "Other_Dr", paymentMode2, 
																	   String.valueOf(loanSettlementAmount), chequeNo, "", 
																	   submittedBankName, chequeDate, "Loan Settlement", 
																	   "Loan Settlement", "0", voucherNo, 0, "0", pl.getLoanNo(), 
																	   pl.getLoanCategory()); 
					}
					try 
					{
						conn.close();
					}
					catch (Exception e)
					{
						e.printStackTrace();
					}	 
				}
				else
				{
					fc = FacesContext.getCurrentInstance();
					fc.addMessage(null, new FacesMessage("An Error Occured... Please Try Again"));
				}
			}
			
			value2 = false;
			paymentMode2 = chequeNo = bankName = "";
			amount2 = 0;
			chequeNo = bankName = "";
			chequeDate = null;
			show = false;
		}
		else if(flag == 96)
 		{
 			fc.addMessage(null, new FacesMessage("Saving Account No. " + savingAccountNo + " doesn't have sufficient Balance. "));
 		}
		else
		{
			fc.addMessage(null, new FacesMessage("Some Error Occured!!!"));
		}	
	}
	
	
	
	private ArrayList<PreviousLoanInfo> getSelectedLoansForClosure() 
	{
	    ArrayList<PreviousLoanInfo> selectedLoans = new ArrayList<>();

	    if (allPreviousLoanList != null) 
	    {
	        for (PreviousLoanInfo pl : allPreviousLoanList) 
	        {
	            if (pl != null && pl.isSelected()) 
	            {
	                selectedLoans.add(pl);
	            }
	        }
	    }

	    if (selectedLoans.isEmpty()) 
	    {
	        FacesContext.getCurrentInstance().addMessage(null,
				            						new FacesMessage("Please select at least one previous loan to close."));
	        return null;
	    }

	    checkPaidForMultiLoanCloser();

	    if (preLoanAmountExceed) 
	    {
	        FacesContext.getCurrentInstance().addMessage(null,
	        								new FacesMessage("The selected loan closure amount exceeds the allowed amount."));
	        return null;
	    }

	    return selectedLoans;
	}
	
	
	
	private double roundMultiMoney(double value) 
	{
	    return Double.parseDouble(dc.format(value));
	}
	
	
	
	public String getLoanCategory() {
		return loanCategory;
	}

	public void setLoanCategory(String loanCategory) {
		this.loanCategory = loanCategory;
	}

	public String getShareHolderNo() {
		return shareHolderNo;
	}

	public void setShareHolderNo(String shareHolderNo) {
		this.shareHolderNo = shareHolderNo;
	}

	public String getLoanNo() {
		return loanNo;
	}

	public void setLoanNo(String loanNo) {
		this.loanNo = loanNo;
	}

	public ArrayList<SelectItem> getLoanList() {
		return loanList;
	}

	public void setLoanList(ArrayList<SelectItem> loanList) {
		this.loanList = loanList;
	}

	public static List<String> getList() {
		return list;
	}

	public static void setList(List<String> list) {
		DebitLoanBean.list = list;
	}

	public String getLabel() {
		return label;
	}

	public void setLabel(String label) {
		this.label = label;
	}

	public String getPaymentMode() {
		return paymentMode;
	}

	public void setPaymentMode(String paymentMode) {
		this.paymentMode = paymentMode;
	}

	public String getChequeNo() {
		return chequeNo;
	}

	public void setChequeNo(String chequeNo) {
		this.chequeNo = chequeNo;
	}

	public Date getChequeDate() {
		return chequeDate;
	}

	public void setChequeDate(Date chequeDate) {
		this.chequeDate = chequeDate;
	}

	public String getBankName() {
		return bankName;
	}

	public void setBankName(String bankName) {
		this.bankName = bankName;
	}

	public String getBankBranch() {
		return bankBranch;
	}

	public void setBankBranch(String bankBranch) {
		this.bankBranch = bankBranch;
	}

	public double getAmount() {
		return amount;
	}

	public void setAmount(double amount) {
		this.amount = amount;
	}

	public boolean isShowCheque() {
		return showCheque;
	}

	public void setShowCheque(boolean showCheque) {
		this.showCheque = showCheque;
	}

	public ArrayList<SelectItem> getBankList() {
		return bankList;
	}

	public void setBankList(ArrayList<SelectItem> bankList) {
		this.bankList = bankList;
	}

	public BankInfo getBank_info() {
		return bank_info;
	}

	public void setBank_info(BankInfo bank_info) {
		this.bank_info = bank_info;
	}

	public boolean isRenderProceed() {
		return renderProceed;
	}

	public void setRenderProceed(boolean renderProceed) {
		this.renderProceed = renderProceed;
	}

	public ArrayList<DebitInfo> getTransactionHistory() {
		return transactionHistory;
	}

	public void setTransactionHistory(ArrayList<DebitInfo> transactionHistory) {
		this.transactionHistory = transactionHistory;
	}

	public Date getDate() {
		return date;
	}

	public void setDate(Date date) {
		this.date = date;
	}

	public double getLoanAmount() {
		return loanAmount;
	}

	public void setLoanAmount(double loanAmount) {
		this.loanAmount = loanAmount;
	}

	public double getPaidAmount() {
		return paidAmount;
	}

	public void setPaidAmount(double paidAmount) {
		this.paidAmount = paidAmount;
	}

	public ArrayList<SelectItem> getLoanTypeList() {
		return loanTypeList;
	}

	public void setLoanTypeList(ArrayList<SelectItem> loanTypeList) {
		this.loanTypeList = loanTypeList;
	}

	public String getSavingAccountNo() {
		return savingAccountNo;
	}

	public void setSavingAccountNo(String savingAccountNo) {
		this.savingAccountNo = savingAccountNo;
	}

	public boolean isShowTransfer() {
		return showTransfer;
	}

	public void setShowTransfer(boolean showTransfer) {
		this.showTransfer = showTransfer;
	}

	public LoanInfo getSelectedLoan() {
		return selectedLoan;
	}

	public void setSelectedLoan(LoanInfo selectedLoan) {
		this.selectedLoan = selectedLoan;
	}

	public UserInfo getSavingDetail() {
		return savingDetail;
	}

	public void setSavingDetail(UserInfo savingDetail) {
		this.savingDetail = savingDetail;
	}

	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 isShowDeduction() {
		return showDeduction;
	}

	public void setShowDeduction(boolean showDeduction) {
		this.showDeduction = showDeduction;
	}

	public boolean isLoanDeduction() {
		return loanDeduction;
	}

	public void setLoanDeduction(boolean loanDeduction) {
		this.loanDeduction = loanDeduction;
	}

	public String getUmrnNo() {
		return umrnNo;
	}

	public void setUmrnNo(String umrnNo) {
		this.umrnNo = umrnNo;
	}

	public String getCompanyType() {
		return companyType;
	}

	public void setCompanyType(String companyType) {
		this.companyType = companyType;
	}

	public String getUserId() {
		return userId;
	}

	public void setUserId(String userId) {
		this.userId = userId;
	}

	public int getFlag() {
		return flag;
	}

	public void setFlag(int flag) {
		this.flag = flag;
	}

	public DsaListInfo getCommissionInfo() {
		return commissionInfo;
	}

	public void setCommissionInfo(DsaListInfo commissionInfo) {
		this.commissionInfo = commissionInfo;
	}

	public ArrayList<LoanInfo> getLoanEMIList() {
		return loanEMIList;
	}

	public void setLoanEMIList(ArrayList<LoanInfo> loanEMIList) {
		this.loanEMIList = loanEMIList;
	}

	public List<String> getNameList() {
		return nameList;
	}

	public void setNameList(List<String> nameList) {
		this.nameList = nameList;
	}

	public double getTotalPenaltyDue() {
		return totalPenaltyDue;
	}

	public void setTotalPenaltyDue(double totalPenaltyDue) {
		this.totalPenaltyDue = totalPenaltyDue;
	}

	public double getTotalPenaltyPaid() {
		return totalPenaltyPaid;
	}

	public void setTotalPenaltyPaid(double totalPenaltyPaid) {
		this.totalPenaltyPaid = totalPenaltyPaid;
	}

	public double getTotalIntrest() {
		return totalIntrest;
	}

	public void setTotalIntrest(double totalIntrest) {
		this.totalIntrest = totalIntrest;
	}

	public double getTotalEmi() {
		return totalEmi;
	}

	public void setTotalEmi(double totalEmi) {
		this.totalEmi = totalEmi;
	}

	public double getTotalInterestRemainLocal() {
		return totalInterestRemainLocal;
	}

	public void setTotalInterestRemainLocal(double totalInterestRemainLocal) {
		this.totalInterestRemainLocal = totalInterestRemainLocal;
	}

	public double getTotalChqChrgRemainLocal() {
		return totalChqChrgRemainLocal;
	}

	public void setTotalChqChrgRemainLocal(double totalChqChrgRemainLocal) {
		this.totalChqChrgRemainLocal = totalChqChrgRemainLocal;
	}

	public double getTotalPrincipalRemainLocal() {
		return totalPrincipalRemainLocal;
	}

	public void setTotalPrincipalRemainLocal(double totalPrincipalRemainLocal) {
		this.totalPrincipalRemainLocal = totalPrincipalRemainLocal;
	}

	public double getTotalPrincipal() {
		return totalPrincipal;
	}

	public void setTotalPrincipal(double totalPrincipal) {
		this.totalPrincipal = totalPrincipal;
	}

	public double getTotalDue() {
		return totalDue;
	}

	public void setTotalDue(double totalDue) {
		this.totalDue = totalDue;
	}

	public double getTotalPaid() {
		return totalPaid;
	}

	public void setTotalPaid(double totalPaid) {
		this.totalPaid = totalPaid;
	}

	public double getTotalRemaining() {
		return totalRemaining;
	}

	public void setTotalRemaining(double totalRemaining) {
		this.totalRemaining = totalRemaining;
	}

	public double getTotalIntrestRemain() {
		return totalIntrestRemain;
	}

	public void setTotalIntrestRemain(double totalIntrestRemain) {
		this.totalIntrestRemain = totalIntrestRemain;
	}

	public double getTotalPrincipalRemain() {
		return totalPrincipalRemain;
	}

	public void setTotalPrincipalRemain(double totalPrincipalRemain) {
		this.totalPrincipalRemain = totalPrincipalRemain;
	}

	public double getTotalPenaltyRemain() {
		return totalPenaltyRemain;
	}

	public void setTotalPenaltyRemain(double totalPenaltyRemain) {
		this.totalPenaltyRemain = totalPenaltyRemain;
	}

	public double getTotalChqChargeRemain() {
		return totalChqChargeRemain;
	}

	public void setTotalChqChargeRemain(double totalChqChargeRemain) {
		this.totalChqChargeRemain = totalChqChargeRemain;
	}

	public double getDiscount() {
		return discount;
	}

	public void setDiscount(double discount) {
		this.discount = discount;
	}

	public double getForeclosureCharges() {
		return foreclosureCharges;
	}

	public void setForeclosureCharges(double foreclosureCharges) {
		this.foreclosureCharges = foreclosureCharges;
	}

	public double getForeClosureInterest() {
		return foreClosureInterest;
	}

	public void setForeClosureInterest(double foreClosureInterest) {
		this.foreClosureInterest = foreClosureInterest;
	}

	public double getForeClosureTotalRemaining() {
		return foreClosureTotalRemaining;
	}

	public void setForeClosureTotalRemaining(double foreClosureTotalRemaining) {
		this.foreClosureTotalRemaining = foreClosureTotalRemaining;
	}

	public double getTotalChqCharge() {
		return totalChqCharge;
	}

	public void setTotalChqCharge(double totalChqCharge) {
		this.totalChqCharge = totalChqCharge;
	}

	public double getPaidChqcharge() {
		return paidChqcharge;
	}

	public void setPaidChqcharge(double paidChqcharge) {
		this.paidChqcharge = paidChqcharge;
	}

	public double getTotalPenaltyRemainLocal() {
		return totalPenaltyRemainLocal;
	}

	public void setTotalPenaltyRemainLocal(double totalPenaltyRemainLocal) {
		this.totalPenaltyRemainLocal = totalPenaltyRemainLocal;
	}

	public double getSavingAmount() {
		return savingAmount;
	}

	public void setSavingAmount(double savingAmount) {
		this.savingAmount = savingAmount;
	}

	public double getTilldateInterest() {
		return tilldateInterest;
	}

	public void setTilldateInterest(double tilldateInterest) {
		this.tilldateInterest = tilldateInterest;
	}

	public double getTotalForCloser() {
		return totalForCloser;
	}

	public void setTotalForCloser(double totalForCloser) {
		this.totalForCloser = totalForCloser;
	}

	public boolean isShow() {
		return show;
	}

	public void setShow(boolean show) {
		this.show = show;
	}

	public boolean isShowDsaField() {
		return showDsaField;
	}

	public void setShowDsaField(boolean showDsaField) {
		this.showDsaField = showDsaField;
	}

	public boolean isRenderTableField() {
		return renderTableField;
	}

	public void setRenderTableField(boolean renderTableField) {
		this.renderTableField = renderTableField;
	}

	public boolean isChkLoanSettlement() {
		return chkLoanSettlement;
	}

	public void setChkLoanSettlement(boolean chkLoanSettlement) {
		this.chkLoanSettlement = chkLoanSettlement;
	}

	public boolean isRenderPayMode() {
		return renderPayMode;
	}

	public void setRenderPayMode(boolean renderPayMode) {
		this.renderPayMode = renderPayMode;
	}

	public boolean isValue() {
		return value;
	}

	public void setValue(boolean value) {
		this.value = value;
	}

	public boolean isValue1() {
		return value1;
	}

	public void setValue1(boolean value1) {
		this.value1 = value1;
	}

	public boolean isValue2() {
		return value2;
	}

	public void setValue2(boolean value2) {
		this.value2 = value2;
	}

	public boolean isShowTransferSelect() {
		return showTransferSelect;
	}

	public void setShowTransferSelect(boolean showTransferSelect) {
		this.showTransferSelect = showTransferSelect;
	}

	public boolean isEcsDdNo() {
		return ecsDdNo;
	}

	public void setEcsDdNo(boolean ecsDdNo) {
		this.ecsDdNo = ecsDdNo;
	}

	public String getTransfer() {
		return transfer;
	}

	public void setTransfer(String transfer) {
		this.transfer = transfer;
	}

	public String getSubmittedBankName() {
		return submittedBankName;
	}

	public void setSubmittedBankName(String submittedBankName) {
		this.submittedBankName = submittedBankName;
	}

	public String getPayType() {
		return payType;
	}

	public void setPayType(String payType) {
		this.payType = payType;
	}

	public String getReceipt_no() {
		return receipt_no;
	}

	public void setReceipt_no(String receipt_no) {
		this.receipt_no = receipt_no;
	}

	public String getVoucherNo() {
		return voucherNo;
	}

	public void setVoucherNo(String voucherNo) {
		this.voucherNo = voucherNo;
	}

	public String getDsaName() {
		return dsaName;
	}

	public void setDsaName(String dsaName) {
		this.dsaName = dsaName;
	}

	public Date getPaidDate() {
		return paidDate;
	}

	public void setPaidDate(Date paidDate) {
		this.paidDate = paidDate;
	}

	public int getMyId() {
		return MyId;
	}

	public void setMyId(int myId) {
		MyId = myId;
	}

	public double getDiscountPenalty() {
		return discountPenalty;
	}

	public void setDiscountPenalty(double discountPenalty) {
		this.discountPenalty = discountPenalty;
	}

	public double getDiscountChequeBounce() {
		return discountChequeBounce;
	}

	public void setDiscountChequeBounce(double discountChequeBounce) {
		this.discountChequeBounce = discountChequeBounce;
	}

	public double getDiscountIntrest() {
		return discountIntrest;
	}

	public void setDiscountIntrest(double discountIntrest) {
		this.discountIntrest = discountIntrest;
	}

	public double getCommission() {
		return commission;
	}

	public void setCommission(double commission) {
		this.commission = commission;
	}

	public double getLoanSettlementAmount() {
		return loanSettlementAmount;
	}

	public void setLoanSettlementAmount(double loanSettlementAmount) {
		this.loanSettlementAmount = loanSettlementAmount;
	}

	public DataBaseMethods getObj() {
		return obj;
	}

	public void setObj(DataBaseMethods obj) {
		this.obj = obj;
	}

	public DbYashwant getDby() {
		return dby;
	}

	public void setDby(DbYashwant dby) {
		this.dby = dby;
	}

	public DecimalFormat getDc() {
		return dc;
	}

	public void setDc(DecimalFormat dc) {
		this.dc = dc;
	}

	public LoanInfo getLoan_info2() {
		return loan_info2;
	}

	public void setLoan_info2(LoanInfo loan_info2) {
		this.loan_info2 = loan_info2;
	}

	public UserInfo getUser_info2() {
		return user_info2;
	}

	public void setUser_info2(UserInfo user_info2) {
		this.user_info2 = user_info2;
	}

	public String getLoanNo2() {
		return loanNo2;
	}

	public void setLoanNo2(String loanNo2) {
		this.loanNo2 = loanNo2;
	}

	public boolean isPreLoan() {
		return preLoan;
	}

	public void setPreLoan(boolean preLoan) {
		this.preLoan = preLoan;
	}

	public double getAmount2() {
		return amount2;
	}

	public void setAmount2(double amount2) {
		this.amount2 = amount2;
	}

	public boolean isPreLoan2() {
		return preLoan2;
	}

	public void setPreLoan2(boolean preLoan2) {
		this.preLoan2 = preLoan2;
	}

	public String getPaymentMode2() {
		return paymentMode2;
	}

	public void setPaymentMode2(String paymentMode2) {
		this.paymentMode2 = paymentMode2;
	}

	public double getAmount3() {
		return amount3;
	}

	public void setAmount3(double amount3) {
		this.amount3 = amount3;
	}

	public String getProduct() {
		return product;
	}

	public void setProduct(String product) {
		this.product = product;
	}

	public String getDealer() {
		return dealer;
	}

	public void setDealer(String dealer) {
		this.dealer = dealer;
	}

	public String getImeiNoI() {
		return imeiNoI;
	}

	public void setImeiNoI(String imeiNoI) {
		this.imeiNoI = imeiNoI;
	}

	public String getImeiNoII() {
		return imeiNoII;
	}

	public void setImeiNoII(String imeiNoII) {
		this.imeiNoII = imeiNoII;
	}

	public String getSecurityype() {
		return securityype;
	}

	public void setSecurityype(String securityype) {
		this.securityype = securityype;
	}

	public double getBillAmount() {
		return billAmount;
	}

	public void setBillAmount(double billAmount) {
		this.billAmount = billAmount;
	}

	public double getDownPayment() {
		return downPayment;
	}

	public void setDownPayment(double downPayment) {
		this.downPayment = downPayment;
	}

	public boolean isShowMobile() {
		return showMobile;
	}

	public void setShowMobile(boolean showMobile) {
		this.showMobile = showMobile;
	}

	public String getLoanName() {
		return loanName;
	}

	public void setLoanName(String loanName) {
		this.loanName = loanName;
	}

	public double getFinalAmount() {
		return finalAmount;
	}

	public void setFinalAmount(double finalAmount) {
		this.finalAmount = finalAmount;
	}

	public String getCompanyName() {
		return companyName;
	}

	public void setCompanyName(String companyName) {
		this.companyName = companyName;
	}

	public boolean isPreLoanAmountExceed() {
		return preLoanAmountExceed;
	}

	public void setPreLoanAmountExceed(boolean preLoanAmountExceed) {
		this.preLoanAmountExceed = preLoanAmountExceed;
	}

	public String getLoanCate() {
		return loanCate;
	}

	public void setLoanCate(String loanCate) {
		this.loanCate = loanCate;
	}

	

	public boolean isMultiPreLoan() {
		return multiPreLoan;
	}



	public void setMultiPreLoan(boolean multiPreLoan) {
		this.multiPreLoan = multiPreLoan;
	}


	
	public ArrayList<PreviousLoanInfo> getAllPreviousLoanList() {
		return allPreviousLoanList;
	}



	public void setAllPreviousLoanList(ArrayList<PreviousLoanInfo> allPreviousLoanList) {
		this.allPreviousLoanList = allPreviousLoanList;
	}



	public ArrayList<PreviousLoanInfo> getSelectedPreviousLoanList() {
		return selectedPreviousLoanList;
	}



	public void setSelectedPreviousLoanList(ArrayList<PreviousLoanInfo> selectedPreviousLoanList) {
		this.selectedPreviousLoanList = selectedPreviousLoanList;
	}



	public boolean isShowMultiCloser() {
		return showMultiCloser;
	}



	public void setShowMultiCloser(boolean showMultiCloser) {
		this.showMultiCloser = showMultiCloser;
	}
		
}