protected void Page_Load(object sender, EventArgs e) { try { if (Request.QueryString["id"] != null) { int id=Convert.ToInt32(Request.QueryString["id"]); string val = Request.QueryString["action"]; LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); if (val=="reinstate") { LoanDS.LoanApplicationsRow rLoanApp = loanApp.GetLoanApplication(id.ToString())[0]; if (rLoanApp.IsdatReinstateIDNull() == false) { int reinstateid = rLoanApp.datReinstateID; loanApp.UpdateAppReinstate(reinstateid, id); } } else if( val=="delete") { loanApp.UpdateAppReinstate(null, id); } } }catch(Exception ex){} }
protected void Page_Load(object sender, EventArgs e) { try { if (Request.QueryString["id"] != null) { int id = Convert.ToInt32(Request.QueryString["id"]); string val = Request.QueryString["action"]; LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); if (val == "reinstate") { LoanDS.LoanApplicationsRow rLoanApp = loanApp.GetLoanApplication(id.ToString())[0]; if (rLoanApp.IsdatReinstateIDNull() == false) { int reinstateid = rLoanApp.datReinstateID; loanApp.UpdateAppReinstate(reinstateid, id); } } else if (val == "delete") { loanApp.UpdateAppReinstate(null, id); } } }catch (Exception ex) {} }
public void createAccount() { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); mainDS.ClientDataTable tblClient = client.GetClientProfile(MySessionManager.ClientID); decimal interestrate = Convert.ToDecimal(tblLoanApp[0].datInterestRate.ToString()); decimal IntAmt = (Convert.ToDecimal(lbltotalamt.InnerText) * (interestrate / 100)); interestamt = IntAmt; decimal AmtOut = Convert.ToDecimal(lbltotalamt.InnerText); decimal FinRptBalance_monthly = IntAmt + AmtOut; DateTime enddate = addMonth(DateTime.Now, Convert.ToInt32(tblLoanApp[0].datDuration.ToString())); if ((tblClient.Rows.Count > 0) || (tblLoanApp.Rows.Count > 0)) { int refreshedID = 0; if (tblLoanApp[0].IsdatRefreshedIDNull() == false) { refreshedID = tblLoanApp[0].datRefreshedID; } LoanAccountDSTableAdapters.GetLoanAccountTableAdapter account = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); account.InsertLoanAccount(createAccountNumber(MySessionManager.ClientID), Convert.ToDecimal(tblLoanApp[0].datFees.ToString()), MySessionManager.ClientID, MySessionManager.AppID, Convert.ToInt32(tblLoanApp[0].datTeamID.ToString()), DateTime.Now, enddate, Convert.ToInt32(tblLoanApp[0].datInterestRate), Convert.ToInt32(tblLoanApp[0].datDuration.ToString()), 0, IntAmt, AmtOut, FinRptBalance_monthly, MySessionManager.CurrentUser.UserID, FinRptBalance_monthly, DateTime.Now, DateTime.Now, Convert.ToInt32(tblLoanApp[0].datPurpose.ToString()), IntAmt, refreshedID, Convert.ToInt32(tblLoanApp[0].datCreditTeamID.ToString()), tblClient[0].datClientName.ToString(), Convert.ToInt32(tblLoanApp[0].datLoanType.ToString())); } LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountDataTable tblLoanAc = loanAc.GetLoanAccount1(MySessionManager.AppID, MySessionManager.ClientID); if (tblLoanAc.Rows.Count > 0) { MySessionManager.AccountID = tblLoanAc[0].datID; MySessionManager.AppBranchID = tblLoanApp[0].datTeamID; } }
public void loadLoanDetails(int AppID) { try{ // DateTime myDateTime = DateTime.Parse(txtFirstPaymentDate.Text, usCulture.DateTimeFormat).To; LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable loanAppDetails = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); if (loanAppDetails.Rows.Count > 0) { txtLoanAmount.Value = loanAppDetails[0].datLoanAmount.ToString(); txtDuration.Value = loanAppDetails[0].datDuration.ToString(); txtFirstPaymentDate.Text = DateTime.Parse(loanAppDetails[0].datFirstPaymentDate.ToString()).ToString("dd-MM-yyyy"); txtNoYrs.Value = loanAppDetails[0].datNumberOfYears.ToString(); txtInterestrate.Value = loanAppDetails[0].datInterestRate.ToString(); if (loanAppDetails[0].IsdatLoanTypeNull() == false) { ddlLoanType.SelectedValue = loanAppDetails[0].datLoanType.ToString(); } if (loanAppDetails[0].IsdatInterestRateNull() == false) { ddlInterestRate.SelectedValue = loanAppDetails[0].datInterestRateType.ToString(); } if (loanAppDetails[0].IsdatPurposeNull() == false) { ddlloanpurpose.SelectedValue = loanAppDetails[0].datPurpose.ToString(); } if (loanAppDetails[0].IsdatTypeOfBusinessNull() == false) { ddlTypeOfBusiness.SelectedValue = loanAppDetails[0].datTypeOfBusiness.ToString(); } if (loanAppDetails[0].IsdatAveMonthlyIncomeNull() == false) { txtAveMonthlyIncome.Value = loanAppDetails[0].datAveMonthlyIncome.ToString(); } if (loanAppDetails[0].IsdatNatureOfBusinessNull() == false) { txtNatureOfBusiness.Value = loanAppDetails[0].datNatureOfBusiness.ToString(); } string ApNo = loanAppDetails[0].datApplicationNumber.ToString(); if (ApNo == "") { this.appCode.Value = (100000 + (Convert.ToInt32(loanAppDetails[0].datID.ToString()))).ToString(); } else { this.appCode.Value = loanAppDetails[0].datApplicationNumber.ToString(); } this.editskip.Value = "2"; } else { } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public void loadLoanDetails(int AppID) { try { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable loanAppDetails = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); if (loanAppDetails.Rows.Count > 0) { string ApNo; try { ApNo = loanAppDetails[0].datApplicationNumber.ToString(); } catch (Exception ex) { ApNo = ""; } if (ApNo == "") { this.appCode.Value = (100000 + (Convert.ToInt32(loanAppDetails[0].datID.ToString()))).ToString(); } else { this.appCode.Value = loanAppDetails[0].datApplicationNumber.ToString(); } this.editskip.Value = "2"; if (loanAppDetails[0].IsdatLoanAmountNull() == false) { txtLoanAmount.Value = loanAppDetails[0].datLoanAmount.ToString(); } if (loanAppDetails[0].IsdatDurationNull() == false) { txtDuration.Value = loanAppDetails[0].datDuration.ToString();} if (loanAppDetails[0].IsdatFirstPaymentDateNull() == false) { txtFirstPaymentDate.Text = DateTime.Parse(loanAppDetails[0].datFirstPaymentDate.ToString()).ToString("dd-MM-yyyy");} if (loanAppDetails[0].IsdatInterestRateNull() == false) { txtInterestrate.Value = loanAppDetails[0].datInterestRate.ToString(); } try { ddlLoanType.ClearSelection(); ddlTypeOfBusiness.ClearSelection(); ddlloanpurpose.ClearSelection(); ddlInterestRate.ClearSelection(); if (loanAppDetails[0].IsdatLoanTypeNull()==false) { ddlLoanType.SelectedValue = loanAppDetails[0].datLoanType.ToString(); } if (loanAppDetails[0].IsdatInterestRateTypeNull()==false) { ddlInterestRate.SelectedValue = loanAppDetails[0].datInterestRateType.ToString(); } if (loanAppDetails[0].IsdatPurposeNull()==false) { ddlloanpurpose.SelectedValue = loanAppDetails[0].datPurpose.ToString(); } if (loanAppDetails[0].IsdatTypeOfBusinessNull()==false) { ddlTypeOfBusiness.SelectedValue = loanAppDetails[0].datTypeOfBusiness.ToString(); } } catch (Exception ex) { } txtAveMonthlyIncome.Value = loanAppDetails[0].datAveMonthlyIncome.ToString(); } else { } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { Utility util = new Utility(); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(Convert.ToString(MySessionManager.AppID)); if (tblLoanApp.Rows.Count > 0) { if (!(this.editskip.Value == "2")) { if (tblLoanApp[0].IsdatDurationNull() == false) { txtperiod.Text = tblLoanApp[0].datDuration.ToString(); } if (tblLoanApp[0].IsdatInterestRateNull() == false) { txtinterestrate.Text = tblLoanApp[0].datInterestRate.ToString(); } if (tblLoanApp[0].IsdatInterestRateTypeNull() == false) { txtinterestrateType.Text = util.displayValue("opt_interest_rate_types", tblLoanApp[0].datInterestRateType.ToString()); } if (tblLoanApp[0].IsdatFirstPaymentDateNull() == false) { txtfirstpaymentdate.Text = tblLoanApp[0].datFirstPaymentDate.ToString("dd-MM-yyyy"); } txtFrequency.Text = util.displayValue("opt_frequencies", tblLoanApp[0].datFrequency.ToString()); if (tblLoanApp[0].IsdatLoanAmountNull() == false) { txtprincipal.Text = tblLoanApp[0].datLoanAmount.ToString(); } this.editskip.Value = "2"; int mnths = Convert.ToInt32(tblLoanApp[0].datDuration.ToString()); double per = Convert.ToDouble(tblLoanApp[0].datInterestRate.ToString()); double amt = Convert.ToDouble(tblLoanApp[0].datLoanAmount.ToString()); try { GenerateMonths(mnths, DateTime.Parse(txtfirstpaymentdate.Text)); } catch (Exception ex) { } } else { int mnths = Convert.ToInt32(txtperiod.Text); double per = Convert.ToDouble(txtinterestrate.Text); double amt = Convert.ToDouble(txtprincipal.Text); try { GenerateMonths(mnths, DateTime.Parse(txtfirstpaymentdate.Text)); } catch (Exception ex) { } } } }
protected void Page_Load(object sender, EventArgs e) { ListItem LItem = new ListItem("--Select--", "0"); ddlPaymetMode.Items.Insert(0, LItem); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); txtBranch.InnerText = util.displayValue("tbl_teams", loanApp.GetLoanAppBranch(MySessionManager.AppID, MySessionManager.ClientID).ToString()); if (tblLoanApp.Rows.Count > 0) { this.lblTotalAmt.InnerText = tblLoanApp[0].datDisburseAmount.ToString("c").Replace("$",""); this.txtDate.Text = DateTime.Now.ToString("dd-MM-yyyy"); } if (!(this.editskip1.Value == "2")) { txtVoucherNo.Value = getPVNo(); loadfv(); txtTotalAmount.Text = sumAmount().ToString(); txtAmtWords.Value = NTE.changeNumericToWords(Convert.ToDouble(sumAmount())) + "Ghana Cedis "; } if (!(Request.QueryString["pvedit"] == null)) { type = "update"; id = Convert.ToInt32(Request.QueryString["pvedit"]); if (!(this.editskip.Value == "2")) { //txtVoucherNo.Value = getPVNo(); loadpv(id); } } else if (!(Request.QueryString["pvdelete"] == null)) { try { string id = Request.QueryString["pvdelete"]; util.deleteItem("tbl_payment_vouchers", id); Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "pvdelete")); } catch { } } }
protected void Page_Load(object sender, EventArgs e) { ListItem LItem = new ListItem("--Select--", "0"); ddlPaymetMode.Items.Insert(0, LItem); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); txtBranch.InnerText = util.displayValue("tbl_teams", loanApp.GetLoanAppBranch(MySessionManager.AppID, MySessionManager.ClientID).ToString()); if (tblLoanApp.Rows.Count > 0) { this.lblTotalAmt.InnerText = tblLoanApp[0].datDisburseAmount.ToString("c").Replace("$", ""); this.txtDate.Text = DateTime.Now.ToString("dd-MM-yyyy"); } if (!(this.editskip1.Value == "2")) { txtVoucherNo.Value = getPVNo(); loadfv(); txtTotalAmount.Text = sumAmount().ToString(); txtAmtWords.Value = NTE.changeNumericToWords(Convert.ToDouble(sumAmount())) + "Ghana Cedis "; } if (!(Request.QueryString["pvedit"] == null)) { type = "update"; id = Convert.ToInt32(Request.QueryString["pvedit"]); if (!(this.editskip.Value == "2")) { //txtVoucherNo.Value = getPVNo(); loadpv(id); } } else if (!(Request.QueryString["pvdelete"] == null)) { try { string id = Request.QueryString["pvdelete"]; util.deleteItem("tbl_payment_vouchers", id); Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "pvdelete")); } catch { } } }
protected void Page_Load(object sender, EventArgs e) { Utility util = new Utility(); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(Convert.ToString(MySessionManager.AppID)); if (tblLoanApp.Rows.Count > 0) { if (!(this.editskip.Value == "2")) { if (tblLoanApp[0].IsdatDurationNull()==false){ txtperiod.Text = tblLoanApp[0].datDuration.ToString(); } if (tblLoanApp[0].IsdatInterestRateNull()==false){txtinterestrate.Text = tblLoanApp[0].datInterestRate.ToString();} if (tblLoanApp[0].IsdatInterestRateTypeNull() == false) { txtinterestrateType.Text = util.displayValue("opt_interest_rate_types", tblLoanApp[0].datInterestRateType.ToString()); } if (tblLoanApp[0].IsdatFirstPaymentDateNull() == false) { txtfirstpaymentdate.Text = tblLoanApp[0].datFirstPaymentDate.ToString("dd-MM-yyyy"); } txtFrequency.Text = util.displayValue("opt_frequencies", tblLoanApp[0].datFrequency.ToString()); if (tblLoanApp[0].IsdatLoanAmountNull() == false) { txtprincipal.Text = tblLoanApp[0].datLoanAmount.ToString(); } this.editskip.Value = "2"; int mnths = Convert.ToInt32(tblLoanApp[0].datDuration.ToString()); double per = Convert.ToDouble(tblLoanApp[0].datInterestRate.ToString()); double amt = Convert.ToDouble(tblLoanApp[0].datLoanAmount.ToString()); try { GenerateMonths(mnths, DateTime.Parse(txtfirstpaymentdate.Text)); } catch (Exception ex) { } } else { int mnths = Convert.ToInt32(txtperiod.Text); double per = Convert.ToDouble(txtinterestrate.Text); double amt = Convert.ToDouble(txtprincipal.Text); try { GenerateMonths(mnths, DateTime.Parse(txtfirstpaymentdate.Text)); } catch (Exception ex) { } } } }
protected void Page_Load(object sender, EventArgs e) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); lblbranch.InnerText = util.displayValue("tbl_teams", loanApp.GetLoanAppBranch(MySessionManager.AppID, MySessionManager.ClientID).ToString()); mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter(); try { lblTotal.Text = tempHolder.GetTransTotalAmount(MySessionManager.AppID).ToString(); } catch (Exception ex) { lblTotal.Text = "0.00"; } if (tblLoanApp.Rows.Count > 0) { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); lbltotalamt.InnerText = tblLoanApp[0].datLoanAmount.ToString("c").Replace("$", ""); lbldate.InnerText = DateTime.Now.ToLongDateString(); lblClient.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString(); } if (!(this.editskip.Value =="2")) { } if (!(Request.QueryString["trdelete"] == null)) { try { string id = Request.QueryString["trdelete"]; tempHolder.DeleteTransactionDetails(Convert.ToInt32(id), MySessionManager.AppID); Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "trdelete")); } catch { } } }
public void showLoanAppInfo() { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); if (tblLoanApp.Rows.Count > 0) { try { this.lblapplicantName.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString(); this.lblInterestRate.InnerText = tblLoanApp[0].datInterestRate.ToString("c").Replace("$", "") + "%"; this.lblDuration.InnerText = tblLoanApp[0].datDuration.ToString() + " month(s)"; this.lblAppNo.InnerText = tblLoanApp[0].datApplicationNumber.ToString(); this.loanAmount.InnerText = tblLoanApp[0].datLoanAmount.ToString("c").Replace("$", ""); this.lblloantype.InnerText = util.displayValue("opt_loan_types", tblLoanApp[0].datLoanType.ToString()); this.lblClientNo.InnerText = client.GetClientNo(MySessionManager.ClientID).ToString(); } catch (Exception ex) { } } }
protected void Page_Load(object sender, EventArgs e) { ListItem LItem = new ListItem("--Select--", "0"); ddlFee.Items.Insert(0, LItem); ddlPaymentMode.Items.Insert(0, LItem); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); if (tblLoanApp.Rows.Count > 0) { txtUpdatedLoanAmt.Text = tblLoanApp[0].datLoanAmount.ToString("c").Replace("$", ""); txtUpddateDisburseAmt.Text = tblLoanApp[0].datDisburseAmount.ToString("c").Replace("$", ""); } txtLoanAmt.Value = Convert.ToString(loanApp.GetLoanAmount(MySessionManager.AppID, MySessionManager.ClientID)).ToString(); if (!(Request.QueryString["fedit"] == null)) { type = "update"; id = Convert.ToInt32(Request.QueryString["fedit"]); if (!(this.editskip.Value == "2")) { loadfee(id); } } else if (!(Request.QueryString["fdelete"] == null)) { try { string id = Request.QueryString["fdelete"]; updateLoanAmount("delete", 0, 0, Convert.ToInt32(id)); util.deleteItem("tbl_fees", id); Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "fdelete")); } catch { } } }
protected void Page_Load(object sender, EventArgs e) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); lblbranch.InnerText = util.displayValue("tbl_teams", loanApp.GetLoanAppBranch(MySessionManager.AppID, MySessionManager.ClientID).ToString()); mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter(); try { lblTotal.Text = tempHolder.GetTransTotalAmount(MySessionManager.AppID).ToString(); } catch (Exception ex) { lblTotal.Text = "0.00"; } if (tblLoanApp.Rows.Count > 0) { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); lbltotalamt.InnerText = tblLoanApp[0].datLoanAmount.ToString("c").Replace("$", ""); lbldate.InnerText = DateTime.Now.ToLongDateString(); lblClient.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString(); } if (!(this.editskip.Value == "2")) { } if (!(Request.QueryString["trdelete"] == null)) { try { string id = Request.QueryString["trdelete"]; tempHolder.DeleteTransactionDetails(Convert.ToInt32(id), MySessionManager.AppID); Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "trdelete")); } catch { } } }
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 setDropdownlist(DropDownList ddl,string value) //{ // if (value == "") // { // ListItem Litem = new ListItem("--Select--","0"); // ddl.Items.Add(Litem); // //ddl.DataBind(); // } // else // { // ddl.SelectedIndex = ddl.Items.IndexOf(ddl.Items.FindByValue(value)); // } //} public void InsertAppTrail() { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); int pastUser = Convert.ToInt32(loanApp.GetPreviousUsersID(MySessionManager.AppID)); TimeSpan TimeDiff =(DateTime.Now - tblLoanApp[0].datMoveTime); string moveTime = TimeDiff.Days + " days " + TimeDiff.Hours + " hours" + TimeDiff.Minutes + " minutes and " + TimeDiff.Seconds+" seconds"; int stage = Convert.ToInt32(loanApp.getApplicationStatus(MySessionManager.AppID)); try { LoanDSTableAdapters.ApplicationTrailTableAdapter AppTrail = new LoanDSTableAdapters.ApplicationTrailTableAdapter(); AppTrail.InsertAppTrail(MySessionManager.AppID, pastUser, MySessionManager.CurrentUser.UserID, tblLoanApp[0].datMoveTime, stage, moveTime); loanApp.SetNewUserAndTime(MySessionManager.CurrentUser.UserID, DateTime.Now, MySessionManager.AppID); } catch (Exception ex) { } }
public void createAccount(decimal AmtOut1) { //LoanAccountDS. LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); LoanDS.LoanApplicationsDataTable tblLoanApp = loanApp.GetLoanApplication(MySessionManager.AppID.ToString()); mainDS.ClientDataTable tblClient = client.GetClientProfile(MySessionManager.ClientID); decimal interestrate = Convert.ToDecimal(tblLoanApp[0].datInterestRate.ToString()); decimal IntAmt = (Convert.ToDecimal(AmtOut1) * (interestrate / 100)); interestamt = IntAmt; decimal AmtOut = Convert.ToDecimal(AmtOut1); decimal FinRptBalance_monthly = IntAmt + AmtOut; DateTime enddate = addMonth(DateTime.Now, Convert.ToInt32(tblLoanApp[0].datDuration.ToString())); if ((tblClient.Rows.Count > 0) || (tblLoanApp.Rows.Count > 0)) { LoanAccountDSTableAdapters.GetLoanAccountTableAdapter account = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); account.InsertLoanAccount(createAccountNumber(MySessionManager.ClientID), Convert.ToDecimal(tblLoanApp[0].datFees.ToString()), MySessionManager.ClientID, MySessionManager.AppID, Convert.ToInt32(tblLoanApp[0].datTeamID.ToString()), DateTime.Now, enddate, Convert.ToInt32(tblLoanApp[0].datInterestRate), Convert.ToInt32(tblLoanApp[0].datDuration.ToString()), 0, IntAmt, AmtOut, FinRptBalance_monthly, MySessionManager.CurrentUser.UserID, FinRptBalance_monthly, DateTime.Now, DateTime.Now, Convert.ToInt32(tblLoanApp[0].datPurpose.ToString()), IntAmt, Convert.ToInt32(tblLoanApp[0].datRefreshedID.ToString()), Convert.ToInt32(tblLoanApp[0].datCreditTeamID.ToString()), tblClient[0].datClientName.ToString(), Convert.ToInt32(tblLoanApp[0].datLoanType.ToString())); } LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountDataTable tblLoanAc = loanAc.GetLoanAccount1(MySessionManager.AppID, MySessionManager.ClientID); if (tblLoanAc.Rows.Count > 0) { MySessionManager.AccountID = tblLoanAc[0].datID; MySessionManager.AppBranchID = tblLoanApp[0].datTeamID; } }
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); }