public void updateLoanAmount(string type,decimal value, int pmode, int id) { decimal loanAmt=0; decimal diburseAmt=0; decimal pplanAmt=0; decimal fees=0; LoanDSTableAdapters.LoanFeesTableAdapter fee = new LoanDSTableAdapters.LoanFeesTableAdapter(); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); if (tblLoanApp.Rows.Count > 0) { loanAmt = tblLoanApp[0].datLoanAmount; diburseAmt = tblLoanApp[0].datDisburseAmount; pplanAmt = tblLoanApp[0].datPaymentPlanAmount; try { fees = tblLoanApp[0].datFees; } catch(Exception ex) { fees = 0; } if (type == "delete") { LoanDS.LoanFeesDataTable tblfee = fee.GetLoanFeeDetails(id); pmode= tblfee[0].datFeePaymentID; value = tblfee[0].datAmount; if (pmode == 1) { diburseAmt = diburseAmt - value; pplanAmt = pplanAmt - value; } else if (pmode == 2) { diburseAmt = diburseAmt + value; } else if (pmode == 3) { fees = fees - value; } } else if (type == "add") { if (pmode == 1) { diburseAmt = diburseAmt + value; pplanAmt = pplanAmt + value; } else if (pmode == 2) { diburseAmt = diburseAmt - value; } else if (pmode == 3) { fees = fees + value; } } } loanApp.UpdateLoanAmountComponents(diburseAmt, pplanAmt, fees,MySessionManager.AppID, MySessionManager.ClientID); }
public void updateLoanAmount(string type, decimal value, int pmode, int id) { decimal loanAmt = 0; decimal diburseAmt = 0; decimal pplanAmt = 0; decimal fees = 0; LoanDSTableAdapters.LoanFeesTableAdapter fee = new LoanDSTableAdapters.LoanFeesTableAdapter(); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); if (tblLoanApp.Rows.Count > 0) { loanAmt = tblLoanApp[0].datLoanAmount; diburseAmt = tblLoanApp[0].datDisburseAmount; pplanAmt = tblLoanApp[0].datPaymentPlanAmount; try { fees = tblLoanApp[0].datFees; } catch (Exception ex) { fees = 0; } if (type == "delete") { LoanDS.LoanFeesDataTable tblfee = fee.GetLoanFeeDetails(id); pmode = tblfee[0].datFeePaymentID; value = tblfee[0].datAmount; if (pmode == 1) { diburseAmt = diburseAmt - value; pplanAmt = pplanAmt - value; } else if (pmode == 2) { diburseAmt = diburseAmt + value; } else if (pmode == 3) { fees = fees - value; } } else if (type == "add") { if (pmode == 1) { diburseAmt = diburseAmt + value; pplanAmt = pplanAmt + value; } else if (pmode == 2) { diburseAmt = diburseAmt - value; } else if (pmode == 3) { fees = fees + value; } } } loanApp.UpdateLoanAmountComponents(diburseAmt, pplanAmt, fees, MySessionManager.AppID, MySessionManager.ClientID); }