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 setNotifications() { mainDSTableAdapters.NotificationCountTableAdapter tblCounter = new mainDSTableAdapters.NotificationCountTableAdapter(); mainDS.NotificationCountRow itemcount = tblCounter.NotificationCount(MySessionManager.CurrentUser.BranchID, MySessionManager.CurrentUser.UserID, MySessionManager.CurrentUser.TeamID)[0]; this.initassinfo.InnerText = itemcount.intialassessment.ToString(); this.preapprovedinfo.InnerText = itemcount.preapproval.ToString(); this.Approvedinfo.InnerText = itemcount.approvedloans.ToString(); this.Apprinfo.InnerText = (Convert.ToInt32(itemcount.approvalI.ToString()) + Convert.ToInt32(itemcount.approvalII.ToString()) + Convert.ToInt32(itemcount.approvalIII.ToString()) + Convert.ToInt32(itemcount.approvalIV.ToString()) + Convert.ToInt32(itemcount.approvalV.ToString())).ToString(); this.Appraisalinfo.InnerText = itemcount.appraisal.ToString(); this.legalinfo.InnerText = itemcount.legal.ToString(); this.riskinfo.InnerText = itemcount.risk.ToString(); //this.reviewinfo.InnerText = itemcount.cmreview.ToString(); this.disbinfo.InnerText = (Convert.ToInt32(itemcount.disbursementI.ToString()) + Convert.ToInt32(itemcount.disbursementII.ToString())).ToString(); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int status = Convert.ToInt32(loanApp.getApplicationStatus(MySessionManager.AppID)); if (status == 13) { this.disbinfo.InnerText = itemcount.disbursementI.ToString(); } else if (status == 14) { this.disbinfo.InnerText = itemcount.disbursementII.ToString(); } else if (status == 15) { this.disbinfo.InnerText = itemcount.disbursementIII.ToString(); } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); string stage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString()); string role = util.displayValue("opt_levels", MySessionManager.CurrentUser.RoleID.ToString()); string appStage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString()); LoanDSTableAdapters.CommentsTableAdapter comments = new LoanDSTableAdapters.CommentsTableAdapter(); LoanDS.CommentsDataTable tblComments = comments.GetSpecificComments(MySessionManager.AppID, MySessionManager.ClientID, appStage); if (!(tblComments.Rows.Count > 0)) { comments.InsertComment(role, stage, txtDescription.Value.Trim(), MySessionManager.ClientID, MySessionManager.AppID, MySessionManager.CurrentUser.UserID); this.editskip.Value = "1"; } else { int id = Convert.ToInt32(tblComments[0].datID.ToString()); comments.UpdateComment(txtDescription.Value.Trim(), id); this.editskip.Value = "1"; } } }
protected void btnFinalize_Click(object sender, EventArgs e) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID)); if (cmbAction.Text == "Forward Application") { try { int ctID = Convert.ToInt32(ddlCreditTeam.SelectedValue); util.UpdateApplicationStatus("Forward Application", AppStage); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.AssignCreditTeam(ctID, MySessionManager.AppID); Response.Redirect("~/pages/loanapplications.aspx", true); } catch (Exception ex) { } } else if (cmbAction.Text == "Send Back For Review") { util.UpdateApplicationStatus("Send Back For Review", AppStage); Response.Redirect("~/pages/loanapplications.aspx", true); } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); string stage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString()); string role = util.displayValue("opt_levels", MySessionManager.CurrentUser.RoleID.ToString()); string appStage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString()); LoanDSTableAdapters.CommentsTableAdapter comments = new LoanDSTableAdapters.CommentsTableAdapter(); LoanDS.CommentsDataTable tblComments = comments.GetSpecificComments(MySessionManager.AppID, MySessionManager.ClientID, appStage); if (!(tblComments.Rows.Count > 0)) { comments.InsertComment(role, stage, txtDescription.Value.Trim(), MySessionManager.ClientID, MySessionManager.AppID, MySessionManager.CurrentUser.UserID); this.editskip.Value = "1"; } else { int id = Convert.ToInt32(tblComments[0].datID.ToString()); comments.UpdateComment(txtDescription.Value.Trim(), id); this.editskip.Value = "1"; } } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { LoanDSTableAdapters.LoanFeesTableAdapter fee = new LoanDSTableAdapters.LoanFeesTableAdapter(); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); decimal amt = Convert.ToDecimal(txtAmt.Value.Trim()); int pmode = Convert.ToInt32(ddlPaymentMode.Text); if (!(type == "update")) { fee.InsertLoanFee(MySessionManager.ClientID, MySessionManager.AppID, Convert.ToInt32(ddlFee.Text), pmode, Convert.ToDecimal(txtPercentage.Value), amt); } else if (type == "update") { fee.UpdateLoanFees(Convert.ToInt32(ddlFee.Text), Convert.ToInt32(ddlPaymentMode.Text), Convert.ToDecimal(txtPercentage.Value), amt, id); } updateLoanAmount("add", amt, pmode, 0); Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "fedit")); } }
protected void btnFinalize_Click(object sender, EventArgs e) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID)); Utility utilClass = new Utility(); if (cmbAction.Text == "Forward Application") { ShowMessageBox("Are u sure on forwarding the application"); utilClass.UpdateApplicationStatus("Forward Application To Approval", AppStage); Response.Redirect("~/pages/loanapplications.aspx"); } else if (cmbAction.Text == "Forward To Risk") { utilClass.UpdateApplicationStatus("Forward To Risk", AppStage); Response.Redirect("~/pages/loanapplications.aspx"); } else if (cmbAction.Text == "Forward To Legal") { utilClass.UpdateApplicationStatus("Forward To Legal", AppStage); Response.Redirect("~/pages/loanapplications.aspx"); } else if (cmbAction.Text == "Send Back For Review") { utilClass.UpdateApplicationStatus("Send Back For Review", AppStage); Response.Redirect("~/pages/loanapplications.aspx"); } }
public void setUrls() { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int status = Convert.ToInt32(loanApp.getApplicationStatus(MySessionManager.AppID)); if (status == 13) { this.btnTransEntry.Visible = false; this.btnEditPV.Visible = false; this.btnPreparePV.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=2&ops=load"; } else if (status == 14) { this.btnPreparePV.Visible = false; this.btnTransEntry.Visible = false; this.btnEditPV.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=6&ops=load"; } else if (status == 15) { this.btnPreparePV.Visible = false; this.btnEditPV.Visible = false; this.btnTransEntry.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=5&ops=load"; this.divSubmit.Visible = false; } this.btnApplicationDetails.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=1&ops=load"; this.btnPVReport.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=3&ops=load"; this.btnSupDocs.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=4&ops=load"; }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { LoanDSTableAdapters.LoanFeesTableAdapter fee = new LoanDSTableAdapters.LoanFeesTableAdapter(); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); decimal amt = Convert.ToDecimal(txtAmt.Value.Trim()); int pmode = Convert.ToInt32(ddlPaymentMode.Text); if (!(type == "update")) { fee.InsertLoanFee(MySessionManager.ClientID, MySessionManager.AppID, Convert.ToInt32(ddlFee.Text), pmode, Convert.ToDecimal(txtPercentage.Value), amt); } else if (type == "update") { fee.UpdateLoanFees(Convert.ToInt32(ddlFee.Text), Convert.ToInt32(ddlPaymentMode.Text), Convert.ToDecimal(txtPercentage.Value), amt, id); } updateLoanAmount("add", amt, pmode, 0); Page.Response.Redirect(util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "fedit")); } }
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); } }
protected void btnSaveAlert_Click(object sender, EventArgs e) { string EncID = appID.Value.Trim(); int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910")); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.saveAlert(alertmsg.Value, DecID); }
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 RemoveAlert() { string msg = this.pAlertmsg.InnerText; LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.saveAlert("", MySessionManager.AppID); LoanDSTableAdapters.AlertLogsTableAdapter alertLog = new LoanDSTableAdapters.AlertLogsTableAdapter(); // LoanDS.AlertLogsDataTable tblAlertLog = alertLog. }
protected void Page_Load(object sender, EventArgs e) { try { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); this.ObjectDataSource2.SelectParameters["ClientID"].DefaultValue = loanApp.getClientID(MySessionManager.AppID).ToString(); this.rvPreagreement.DataBind(); this.rvPreagreement.LocalReport.Refresh(); } catch (Exception ex) { } }
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) { try { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); this.ObjectDataSource2.SelectParameters["ClientID"].DefaultValue = loanApp.getClientID(MySessionManager.AppID).ToString(); this.rvPreagreement.DataBind(); this.rvPreagreement.LocalReport.Refresh(); } catch (Exception ex) { } }
public bool setReview(int appid) { bool review = false; try { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); review = Convert.ToBoolean(loanApp.GetReviewStatus(appid)); } catch (Exception ex) { } return(review); }
protected void Page_Load(object sender, EventArgs e) { try { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); txtmonthly.Value = loanApp.GetAvMonthlyIncome(MySessionManager.AppID).ToString(); } catch (Exception ex) { } if (!(this.editskip.Value == "2")) { loadEmploymentDetails(); } }
protected void Page_Load(object sender, EventArgs e) { try { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); txtmonthly.Value = loanApp.GetAvMonthlyIncome(MySessionManager.AppID).ToString(); } catch (Exception ex) { } if (!(this.editskip.Value == "2")) { loadEmploymentDetails(); } }
public void UpdateIndividualClient() { //Get Clients profile information mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); mainDS.ClientRow tblClient = client.GetClientProfile(MySessionManager.ClientID)[0]; string Fullname = tblClient.datFirstName.ToString() + " " + tblClient.datMiddleName.ToString() + " " + tblClient.datSurname.ToString(); //Delete all initiators tied up the application LoanDSTableAdapters.IntiatorTableAdapter initiator = new LoanDSTableAdapters.IntiatorTableAdapter(); initiator.DeleteInitiator(MySessionManager.AppID, MySessionManager.ClientID); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.UpdateClientName(Fullname, MySessionManager.ClientID); }
protected void btnFinalize_Click(object sender, EventArgs e) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID)); Utility utilClass = new Utility(); if (cmbAction.Text == "Forward Application") { utilClass.UpdateApplicationStatus("Forward Application", AppStage); Response.Redirect("~/pages/loanapplications.aspx"); } else if (cmbAction.Text == "Decline Application") { } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { // pass the DateTimeFormat information to DateTime.Parse DateTime myDateTime = DateTime.Parse(txtFirstPaymentDate.Text, ukCulture.DateTimeFormat); try { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); string clientname = client.GetClientsName(MySessionManager.ClientID).ToString(); int noyrs = 0; if (!int.TryParse(txtNoYrs.Value, out noyrs)) txtNoYrs.Value = "0"; LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.Update_IntialInterview(MySessionManager.AppID, 0, Convert.ToInt32(ddlLoanType.Text), txtNatureOfBusiness.Value, ddlTypeOfBusiness.Text, noyrs, Convert.ToDecimal(txtAveMonthlyIncome.Value), appCode.Value.Trim(), Convert.ToDecimal(txtLoanAmount.Value.Trim()), Convert.ToDecimal(txtLoanAmount.Value.Trim()), Convert.ToDecimal(txtLoanAmount.Value.Trim()), clientname, Convert.ToInt32(txtDuration.Value.Trim()), Convert.ToInt32(ddlloanpurpose.Text), Convert.ToDecimal(txtInterestrate.Value.Trim()), myDateTime, Convert.ToInt32(ddlFrequency.Text), Convert.ToInt32(ddlInterestRate.Text), ""); this.editskip.Value = "1"; //loadLoanDetails(MySessionManager.AppID); } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); } } }
protected void btnApply_Click(object sender, EventArgs e) { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); string EncID = this.ckey.Value; //Request.QueryString["id"]; int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910")); int cType = Convert.ToInt32(client.GetClientType(DecID)); if (ddlProducts.SelectedValue == "1") { int lType = 0; if (cType == 1) { lType = 1; } else if (cType == 2) { lType = 2; } else if (cType == 3) { lType = 4; } LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); string clientname = client.GetClientsName(DecID).ToString(); loanApp.InsertNewApplication(DecID, clientname, lType, MySessionManager.CurrentUser.BranchID, MySessionManager.CurrentUser.UserID); ShowMessageBox("Loan Application for " + clientname + " submited successfully"); } else if (ddlProducts.SelectedValue == "2") { string clientname = client.GetClientsName(DecID).ToString(); InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invapp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter(); invapp.InsertInvestmentApplication(DecID, clientname, 1, MySessionManager.CurrentUser.BranchID); ShowMessageBox("Investment Application for " + clientname + " submited successfully"); } }
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 btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { // pass the DateTimeFormat information to DateTime.Parse DateTime myDateTime = DateTime.Parse(txtFirstPaymentDate.Text, ukCulture.DateTimeFormat); try { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); string clientname = client.GetClientsName(MySessionManager.ClientID).ToString(); int noyrs = 0; if (!int.TryParse(txtNoYrs.Value, out noyrs)) { txtNoYrs.Value = "0"; } LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.Update_IntialInterview(MySessionManager.AppID, 0, Convert.ToInt32(ddlLoanType.Text), txtNatureOfBusiness.Value, ddlTypeOfBusiness.Text, noyrs, Convert.ToDecimal(txtAveMonthlyIncome.Value), appCode.Value.Trim(), Convert.ToDecimal(txtLoanAmount.Value.Trim()), Convert.ToDecimal(txtLoanAmount.Value.Trim()), Convert.ToDecimal(txtLoanAmount.Value.Trim()), clientname, Convert.ToInt32(txtDuration.Value.Trim()), Convert.ToInt32(ddlloanpurpose.Text), Convert.ToDecimal(txtInterestrate.Value.Trim()), myDateTime, Convert.ToInt32(ddlFrequency.Text), Convert.ToInt32(ddlInterestRate.Text), ""); this.editskip.Value = "1"; //loadLoanDetails(MySessionManager.AppID); } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); } } }
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 { } } }
public string setUrls(int AppID) { Utility util = new Utility(); string url = ""; LoanDSTableAdapters.LoanApplicationsTableAdapter loanapp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int status = Convert.ToInt32(loanapp.getApplicationStatus(AppID).ToString()); if (status == 2) { url = "~/pages/loanapplication/initialassesment.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status == 3) { url = "~/pages/loanapplication/preapproved.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status == 4) { url = "~/pages/loanapplication/appraisals.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status == 5) { url = "~/pages/loanapplication/risk.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status == 6) { url = "~/pages/loanapplication/legal.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status > 6 || status < 12) { url = "~/pages/loanapplication/approvals.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status == 12) { url = "~/pages/loanapplication/approvedloans.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status > 12 || status < 16) { url = "~/pages/loanapplication/disbursement.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } return(url); }
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) { } } }
public void setApprovalLimit(int level) { double values = 0.0; double loanAmt = 0.0; mainDSTableAdapters.GetApprovalLevelTableAdapter dslevel = new mainDSTableAdapters.GetApprovalLevelTableAdapter(); values = Convert.ToDouble(dslevel.GetApprovalLimit(level)); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanAmt = Convert.ToDouble(loanApp.GetLoanAmount(MySessionManager.AppID, MySessionManager.ClientID)); if (values < loanAmt) { cmbAction.Items[1].Enabled = false; } else { cmbAction.Items[1].Enabled = true; } }
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 { } } }
public void loadComments() { LoanDSTableAdapters.CommentsTableAdapter comments = new LoanDSTableAdapters.CommentsTableAdapter(); LoanDS.CommentsDataTable tblComments = comments.GetComments(MySessionManager.AppID, MySessionManager.ClientID); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); if (tblComments.Rows.Count > 0) { string appStage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString()); string stage = ""; foreach (LoanDS.CommentsRow r in tblComments) { stage = r.datStage; if (stage == appStage) { id = r.datID; txtDescription.Value = r.datDescription.ToString(); } } this.editskip.Value = "2"; } }
public void loadComments() { LoanDSTableAdapters.CommentsTableAdapter comments = new LoanDSTableAdapters.CommentsTableAdapter(); LoanDS.CommentsDataTable tblComments = comments.GetComments(MySessionManager.AppID, MySessionManager.ClientID); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); if (tblComments.Rows.Count > 0) { string appStage = util.displayValue("opt_application_status", loanApp.getApplicationStatus(MySessionManager.AppID).ToString()); string stage=""; foreach(LoanDS.CommentsRow r in tblComments) { stage = r.datStage; if (stage == appStage) { id = r.datID; txtDescription.Value =r.datDescription.ToString(); } } this.editskip.Value = "2"; } }
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 { } } }
public void UpdateCompanyClientName(string ClientName) { //Copy the Initiator Details From the Clients Table mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); mainDS.ClientRow tblClient = client.GetClientProfile(MySessionManager.ClientID)[0]; string Fullname = tblClient.datFirstName.ToString() + tblClient.datMiddleName.ToString() + tblClient.datSurname.ToString(); LoanDSTableAdapters.IntiatorTableAdapter initiator = new LoanDSTableAdapters.IntiatorTableAdapter(); initiator.InsertInitiator(MySessionManager.AppID, MySessionManager.ClientID, Fullname, null, tblClient.datMobileNumber1.ToString(), tblClient.datHomeTelephoneNumber.ToString(), tblClient.datEmailAddress.ToString(), tblClient.datFaxNumber.ToString(), tblClient.datCurrentResidentialAddress.ToString()); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.UpdateClientName(ClientName, MySessionManager.ClientID); }
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 { } } }
protected void btnApply_Click(object sender, EventArgs e) { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); string EncID = this.ckey.Value; //Request.QueryString["id"]; int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910")); int cType = Convert.ToInt32(client.GetClientType(DecID)); if (ddlProducts.SelectedValue == "1") { int lType=0; if (cType == 1) { lType = 1; } else if (cType == 2) { lType = 2; } else if (cType == 3) { lType = 4; } LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); string clientname = client.GetClientsName(DecID).ToString(); loanApp.InsertNewApplication(DecID, clientname, lType, MySessionManager.CurrentUser.BranchID, MySessionManager.CurrentUser.UserID); ShowMessageBox("Loan Application for " + clientname + " submited successfully"); } else if(ddlProducts.SelectedValue=="2") { string clientname = client.GetClientsName(DecID).ToString(); InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invapp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter(); invapp.InsertInvestmentApplication(DecID, clientname, 1, MySessionManager.CurrentUser.BranchID); ShowMessageBox("Investment Application for " + clientname + " submited successfully"); } }
protected void RemoveAlert() { string msg = this.pAlertmsg.InnerText; LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.saveAlert("", MySessionManager.AppID); LoanDSTableAdapters.AlertLogsTableAdapter alertLog = new LoanDSTableAdapters.AlertLogsTableAdapter(); // LoanDS.AlertLogsDataTable tblAlertLog = alertLog. }
public bool setReview(int appid) { bool review=false; try { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); review = Convert.ToBoolean(loanApp.GetReviewStatus(appid)); } catch (Exception ex) { } return review; }
protected void btnSaveAlert_Click(object sender, EventArgs e) { string EncID = appID.Value.Trim(); int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910")); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.saveAlert(alertmsg.Value, DecID); }
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; } }
protected void Page_Load(object sender, EventArgs e) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); setNotifications(); if (!(this.IsPostBack)) { setUrls(); } #region QueryStringBlock if (Request.QueryString["id"] == null) { } else { string EncID = Request.QueryString["id"]; int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910")); MySessionManager.AppID = DecID; //int DecID = Convert.ToInt32(EncID); MySessionManager.ClientID = Convert.ToInt32(loanApp.getClientID(MySessionManager.AppID)); } LoanType = Convert.ToInt32(loanApp.GetLoanType(MySessionManager.AppID, MySessionManager.ClientID)); setLoanTypeTabs(LoanType); showLoanAppInfo(); if (!(Request.QueryString["ops"] == null)) { if (!(Request.QueryString["tab"] == null)) { if (!(Request.QueryString["tab"] == "")) currentTab = int.Parse(Request.QueryString["tab"]); else currentTab = Convert.ToInt32(MySessionManager.CurrentTab); ops = Request.QueryString["ops"].ToString(); setTab(currentTab); MySessionManager.CurrentTab = currentTab.ToString(); MySessionManager.OpsTab = "load"; string urlpath = util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab"); urlpath = util.RemoveQueryStringByKey(urlpath, "ops"); Response.Redirect(urlpath); } else { if (!(Request.QueryString["tab"] == "")) currentTab = int.Parse(Request.QueryString["tab"]); else if (LoanType == 2 || LoanType == 3) currentTab = 2; else currentTab = 0; ops = "load"; setTab(currentTab); MySessionManager.CurrentTab = currentTab.ToString(); MySessionManager.OpsTab = "load"; util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab"); util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ops"); } } else { ops = MySessionManager.OpsTab.ToString(); //For handling the tabs if (!(MySessionManager.CurrentTab == "")) currentTab = int.Parse(MySessionManager.CurrentTab); else if (LoanType == 2 || LoanType == 3) { currentTab = 2; MySessionManager.CurrentTab = currentTab.ToString(); } else { currentTab = 0; MySessionManager.CurrentTab = currentTab.ToString(); } setTab(currentTab); } #endregion if ((!(util.alert() == "")) && (MySessionManager.skipAlert == 0)) { this.pAlertmsg.InnerText = util.alert(); // Define the name and type of the client scripts on the page. String csname1 = "PopupScript"; String csname2 = "ButtonClickScript"; Type cstype = this.GetType(); // Get a ClientScriptManager reference from the Page class. ClientScriptManager cs = Page.ClientScript; // Check to see if the startup script is already registered. if (!cs.IsStartupScriptRegistered(cstype, csname1)) { String cstext1 = "alertMessage();"; cs.RegisterStartupScript(cstype, csname1, cstext1, true); } MySessionManager.skipAlert = 1; } }
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) { if (MySessionManager.AppID > 0) { this.itemLoanApp.Visible = true; this.ItemLoanAccount.Visible = false; LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); MySessionManager.ClientID = Convert.ToInt32(loanApp.getClientID(MySessionManager.AppID)); try { mainDSTableAdapters.GetApplicationInfoTableAdapter appinfo = new mainDSTableAdapters.GetApplicationInfoTableAdapter(); mainDS.GetApplicationInfoDataTable tblAppInfo = appinfo.GetApplicationInfo(MySessionManager.AppID); if (tblAppInfo.Rows.Count > 0) { this.btnEditApp.HRef = setUrls(MySessionManager.AppID); this.btnViewAppTracker.HRef = "~/pages/applicationtracker.aspx?id=" + MyEncryption.Encrypt(MySessionManager.AppID.ToString(), "12345678910"); if(tblAppInfo[0].IsdatLoanAmountNull()==false){this.lnAmt.InnerText = tblAppInfo[0].datLoanAmount.ToString("c").Replace("$", "");} if (tblAppInfo[0].IsdatLoanTypeNull() == false) { this.lnType.InnerText = tblAppInfo[0].datLoanType.ToString(); } if (tblAppInfo[0].IsdatApplicationStatusNull() == false) { this.lnAppStatus.InnerText = tblAppInfo[0].datApplicationStatus.ToString(); } if (tblAppInfo[0].IsdatDurationNull() == false) { this.lnDuration.InnerText = tblAppInfo[0].datDuration.ToString() + " month(s)"; } if (tblAppInfo[0].IsdatBranchNull() == false) { this.lnAppBranch.InnerText = tblAppInfo[0].datBranch.ToString(); } if (tblAppInfo[0].IsdatApplicationDateNull() == false) { this.lnAppDate.InnerText = tblAppInfo[0].datApplicationDate.ToLongDateString(); } } } catch (Exception ex) { } } else if(MySessionManager.AccountID > 0) { this.ItemLoanAccount.Visible = true; this.itemLoanApp.Visible = false; LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); MySessionManager.ClientID = Convert.ToInt32(loanAcc.GetClientIDFromAcc(Convert.ToInt32(MySessionManager.AccountID))); try { mainDSTableAdapters.GetLoanAccountInfoTableAdapter accinfo = new mainDSTableAdapters.GetLoanAccountInfoTableAdapter(); mainDS.GetLoanAccountInfoDataTable tblAccInfo = accinfo.GetLoanAccountInfo(Convert.ToInt32(MySessionManager.AccountID)); if (tblAccInfo.Rows.Count > 0) { if (tblAccInfo[0].IsdatOutstandingAmountNull() == false) { this.lnOutstanding.InnerText = tblAccInfo[0].datOutstandingAmount.ToString("c").Replace("$", ""); } if (tblAccInfo[0].IsdatStartDateNull() == false) { this.lnStartDate.InnerText = tblAccInfo[0].datStartDate.ToLongDateString(); } if (tblAccInfo[0].IsdatEndDateNull() == false) { this.lnEndDate.InnerText = tblAccInfo[0].datEndDate.ToLongDateString(); } if (tblAccInfo[0].IsdatBranchNull() == false) { this.lnAccBranch.InnerText = tblAccInfo[0].datBranch.ToString(); } this.btnTransactions.HRef = "~/pages/transactions.aspx?id" + MyEncryption.Encrypt(MySessionManager.AccountID.ToString(), "12345678910") + "&action=entry"; this.btnViewStatement.HRef = "~/pages/loanaccount/loanaccountdetails.aspx?id" + MyEncryption.Encrypt(MySessionManager.AccountID.ToString(), "12345678910") + "&action=2"; this.btnMonitorAccount.HRef = "~/pages/loanaccount/loanaccountdetails.aspx?id" + MyEncryption.Encrypt(MySessionManager.AccountID.ToString(), "12345678910") + "&action=1"; } } catch (Exception ex) { } } try { mainDSTableAdapters.GetClientInfoTableAdapter clientInfo = new mainDSTableAdapters.GetClientInfoTableAdapter(); mainDS.GetClientInfoDataTable tblClientInfo = clientInfo.GetClientInfo(MySessionManager.ClientID); if (tblClientInfo.Rows.Count > 0) { if (tblClientInfo[0].IsdatClientNameNull() == false) { clientname.InnerText = tblClientInfo[0].datClientName.ToString(); } if (tblClientInfo[0].IsdatClientNumberNull() == false) {clientNo.InnerText = tblClientInfo[0].datClientNumber.ToString();} if (tblClientInfo[0].IsdatMobileNumber1Null() == false) { clMobile.InnerText = tblClientInfo[0].datMobileNumber1.ToString(); } } } catch (Exception ex) { } }
public string setUrls(int AppID) { Utility util = new Utility(); string url = ""; LoanDSTableAdapters.LoanApplicationsTableAdapter loanapp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int status = Convert.ToInt32(loanapp.getApplicationStatus(AppID).ToString()); if (status ==2){ url = "~/pages/loanapplication/initialassesment.aspx?id="+MyEncryption.Encrypt(AppID.ToString(),"12345678910");} else if (status ==3) { url = "~/pages/loanapplication/preapproved.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status ==4) { url = "~/pages/loanapplication/appraisals.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status == 5) { url = "~/pages/loanapplication/risk.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status ==6) { url = "~/pages/loanapplication/legal.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status > 6 || status < 12) { url = "~/pages/loanapplication/approvals.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status == 12) { url = "~/pages/loanapplication/approvedloans.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } else if (status > 12 || status < 16) { url = "~/pages/loanapplication/disbursement.aspx?id=" + MyEncryption.Encrypt(AppID.ToString(), "12345678910"); } return url; }
protected void btnFinalize_Click(object sender, EventArgs e) { MySessionManager.cash = 0; MySessionManager.bank = 0; decimal amtDeductable = 0; decimal fees = 0; decimal amt = 0; int ops = 0; LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int status = Convert.ToInt32(loanApp.getApplicationStatus(MySessionManager.AppID)); util.UpdateApplicationStatus("Forward Application", status); createAccount(); mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter(); mTemp.GetTransactionDetailsDataTable tblTempHolder = tempHolder.GetTempTransactions(MySessionManager.AppID); LoanDSTableAdapters.FinancialTransactionsTableAdapter fintrans = new LoanDSTableAdapters.FinancialTransactionsTableAdapter(); int rows = tblTempHolder.Rows.Count; for (int i = 0; i < rows; i++) { int?datDebitAc = null; int?datCreditAc = null; if (tblTempHolder[i].datDebit > 0) { datDebitAc = tblTempHolder[i].datAccountID; amt = tblTempHolder[i].datDebit; ops = 1; } else if (tblTempHolder[i].datCredit > 0) { datCreditAc = tblTempHolder[i].datAccountID; amt = tblTempHolder[i].datCredit; ops = 2; } // if (tblTempHolder[i].datPaymentMethod == 1) { getAmtForPaymentMode(amt, "cash", ops); } else if (tblTempHolder[i].datPaymentMethod == 2) { getAmtForPaymentMode(amt, "bank", ops); } fintrans.InsertFinancialTransaction(MySessionManager.AppID, MySessionManager.ClientID, tblTempHolder[i].datAccountID, Convert.ToInt32(MySessionManager.AccountID), tblTempHolder[i].datDescription, batch(), tblTempHolder[i].datPaymentMethod, MySessionManager.AppBranchID, tblTempHolder[i].datCredit, tblTempHolder[i].datDebit, datCreditAc, datDebitAc, 0, MySessionManager.CurrentUser.UserID); } saveDisburse(Convert.ToInt32(MySessionManager.AccountID), MySessionManager.cash, MySessionManager.bank); saveCreditTransaction(Convert.ToInt32(MySessionManager.AccountID), batch(), interestamt, "1", 1); saveDebitTransaction(Convert.ToInt32(MySessionManager.AccountID), batch(), interestamt, "1", 0); interest_payment_dates(MySessionManager.AppID, Convert.ToInt32(MySessionManager.AccountID), DateTime.Now, 12); Response.Redirect("~/pages/loanapplications.aspx"); }
protected void btnFinalize_Click(object sender, EventArgs e) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID)); if (cmbAction.Text == "Forward Application") { try { int ctID = Convert.ToInt32(ddlCreditTeam.SelectedValue); util.UpdateApplicationStatus("Forward Application", AppStage); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.AssignCreditTeam(ctID, MySessionManager.AppID); Response.Redirect("~/pages/loanapplications.aspx", true); } catch (Exception ex) { } } else if (cmbAction.Text == "Send Back For Review") { util.UpdateApplicationStatus("Send Back For Review", AppStage); Response.Redirect("~/pages/loanapplications.aspx", true); } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { try { // this.dtCompare.Visible = true; // fetch the en-GB culture CultureInfo ukCulture = new CultureInfo("en-GB"); // pass the DateTimeFormat information to DateTime.Parse DateTime myDateTime = DateTime.Parse(txtFirstPaymentDate.Text, ukCulture.DateTimeFormat); mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); string clientname = client.GetClientsName(MySessionManager.ClientID).ToString(); int noyrs = 0; if (!int.TryParse(txtNoYrs.Value, out noyrs)) { txtNoYrs.Value = "0"; } LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.Update_IntialInterview(MySessionManager.AppID, 0, Convert.ToInt32(ddlLoanType.Text), txtNatureOfBusiness.Value, ddlTypeOfBusiness.Text, noyrs, Convert.ToDecimal(txtAveMonthlyIncome.Value), appCode.Value.Trim(), Convert.ToDecimal(txtLoanAmount.Value.Trim()), Convert.ToDecimal(txtLoanAmount.Value.Trim()), Convert.ToDecimal(txtLoanAmount.Value.Trim()), clientname, Convert.ToInt32(txtDuration.Value.Trim()), Convert.ToInt32(ddlloanpurpose.Text), Convert.ToDecimal(txtInterestrate.Value.Trim()), myDateTime, Convert.ToInt32("0"), Convert.ToInt32(ddlInterestRate.Text), ""); this.editskip.Value = "2"; //loadLoanDetails(MySessionManager.AppID); } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); } #region Obsolete //try //{ // mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); // string clientname = client.GetClientName(MySessionManager.ClientID)[0].datClientName.ToString(); //int noofyrs = 0; //DateTime dt = DateTime.Parse(txtFirstPaymentDate.Text); //if (!(txtNoYrs.Value=="")) //{ // noofyrs = Convert.ToInt32(txtNoYrs.Value.Trim()); //} //LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); //loanApp.Update_IntialInterview(MySessionManager.AppID, // 0, // Convert.ToInt32(ddlLoanType.Text), // txtNatureOfBusiness.Value.Trim(), // ddlTypeOfBusiness.Text, // Convert.ToInt32 (noofyrs), // Convert.ToDecimal(txtAveMonthlyIncome.Value.Trim()), // GenerateAppNumber(), // Convert.ToDecimal(txtLoanAmount.Value.Trim()), // 0, // 0, // clientname, // Convert.ToInt32(txtDuration.Value.Trim()), // Convert.ToInt32(ddlloanpurpose.Text), // Convert.ToDecimal(txtInterestrate.Value.Trim()), // dt, // Convert.ToInt32(ddlFrequency.Text), // Convert.ToInt32(ddlInterestRate.Text), // ""); //} //catch //{ //} #endregion } else { // this.vIntialAssesment.ErrorMessage = } }
protected void btnFinalize_Click(object sender, EventArgs e) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID)); Utility utilClass = new Utility(); if (cmbAction.Text == "Forward To Credit Team") { utilClass.UpdateApplicationStatus("Forward To Credit Team", AppStage); Response.Redirect("~/pages/loanapplications.aspx"); } else if (cmbAction.Text == "Send Back For Review") { utilClass.UpdateApplicationStatus("Send Back For Review", AppStage); Response.Redirect("~/pages/loanapplications.aspx"); } }
protected void btnFinalize_Click(object sender, EventArgs e) { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp1 = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int AppStage = Convert.ToInt32(loanApp1.getApplicationStatus(MySessionManager.AppID)); Utility utilClass = new Utility(); if (cmbAction.Text == "Forward Application") { ShowMessageBox("Are u sure on forwarding the application"); utilClass.UpdateApplicationStatus("Forward Application To Approval", AppStage); Response.Redirect("~/pages/loanapplications.aspx"); } else if (cmbAction.Text == "Forward To Risk") { utilClass.UpdateApplicationStatus("Forward To Risk", AppStage); Response.Redirect("~/pages/loanapplications.aspx"); } else if (cmbAction.Text == "Forward To Legal") { utilClass.UpdateApplicationStatus("Forward To Legal", AppStage); Response.Redirect("~/pages/loanapplications.aspx"); } else if (cmbAction.Text == "Send Back For Review") { utilClass.UpdateApplicationStatus("Send Back For Review", AppStage); Response.Redirect("~/pages/loanapplications.aspx"); } }
public void UpdateCompanyClientName(string ClientName) { //Copy the Initiator Details From the Clients Table mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); mainDS.ClientRow tblClient = client.GetClientProfile(MySessionManager.ClientID)[0]; string Fullname = tblClient.datFirstName.ToString()+ tblClient.datMiddleName.ToString()+ tblClient.datSurname.ToString(); LoanDSTableAdapters.IntiatorTableAdapter initiator = new LoanDSTableAdapters.IntiatorTableAdapter(); initiator.InsertInitiator (MySessionManager.AppID, MySessionManager.ClientID, Fullname, null, tblClient.datMobileNumber1.ToString(), tblClient.datHomeTelephoneNumber.ToString(), tblClient.datEmailAddress.ToString(), tblClient.datFaxNumber.ToString(), tblClient.datCurrentResidentialAddress.ToString()); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.UpdateClientName(ClientName, MySessionManager.ClientID); }
public void loadTab(int id,string ops) { try { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanType = Convert.ToInt32(loanApp.GetLoanType(MySessionManager.AppID, MySessionManager.ClientID)); if (LoanType == 1) { for (int j = 0; j < indie.Length; j++) { if (indie[j] == id) { if (ops == "Next") { int m = j + 1; setTab(indie[m]); MySessionManager.CurrentTab = indie[m].ToString(); } else if (ops == "Previous") { if (j > 0) { int m = j - 1; setTab(m); MySessionManager.CurrentTab = indie[m].ToString(); } } } } } else if (LoanType == 2 || LoanType == 3) { for (int j = 0; j < cor.Length; j++) { if (cor[j] == id) { if (ops == "Next") { int m = j + 1; setTab(cor[m]); MySessionManager.CurrentTab = cor[m].ToString(); } else if (ops == "Previous") { if (j > 0) { int m = j - 1; setTab(cor[m]); MySessionManager.CurrentTab = cor[m].ToString(); } } } } } else if (LoanType == 4) { for (int j = 0; j < ent.Length; j++) { if (ent[j] == id) { if (ops == "Next") { int m = j + 1; setTab(ent[m]); MySessionManager.CurrentTab = ent[m].ToString(); } else if (ops == "Previous") { if (j > 0) { int m = j - 1; setTab(ent[m]); MySessionManager.CurrentTab = ent[m].ToString(); } } } } } } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { setUrls(); if (MySessionManager.CurrentUser == null) { Response.Redirect("~/logout.aspx"); } LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); try { mainDSTableAdapters.NotificationCountTableAdapter tblCounter = new mainDSTableAdapters.NotificationCountTableAdapter(); mainDS.NotificationCountRow itemcount = tblCounter.NotificationCount(MySessionManager.CurrentUser.BranchID, MySessionManager.CurrentUser.UserID, MySessionManager.CurrentUser.TeamID)[0]; this.pendingRecInfo.InnerText = (Convert.ToInt32(itemcount.receipts.ToString())).ToString(); this.pendingDisInfo.InnerText = (Convert.ToInt32(itemcount.disbursementI.ToString()) + Convert.ToInt32(itemcount.disbursementII.ToString()) + Convert.ToInt32(itemcount.disbursementIII.ToString())).ToString(); } catch (Exception ex) { } setPanelsOff(); showLoanAppInfo(); #region QueryStringSection if (Request.QueryString["id"] == null) { } else { string EncID = Request.QueryString["id"]; int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910")); MySessionManager.AppID = DecID; MySessionManager.ClientID = Convert.ToInt32(loanApp.getClientID(MySessionManager.AppID)); } if (!(Request.QueryString["ops"] == null)) { if (!(Request.QueryString["tab"] == null)) { if (!(Request.QueryString["tab"] == "")) currentTab = int.Parse(Request.QueryString["tab"]); else currentTab = Convert.ToInt32(MySessionManager.CurrentTab); ops = Request.QueryString["ops"].ToString(); setPanels(currentTab); MySessionManager.CurrentTab = currentTab.ToString(); MySessionManager.OpsTab = "load"; string urlpath = util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab"); urlpath = util.RemoveQueryStringByKey(urlpath, "ops"); Response.Redirect(urlpath); } else { if (!(Request.QueryString["tab"] == "")) currentTab = int.Parse(Request.QueryString["tab"]); else currentTab = 0; ops = "load"; setPanels(currentTab); MySessionManager.CurrentTab = currentTab.ToString(); MySessionManager.OpsTab = "load"; util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab"); util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ops"); } } else { ops = MySessionManager.OpsTab.ToString(); //For handling the tabs if (!(MySessionManager.CurrentTab == "")) currentTab = int.Parse(MySessionManager.CurrentTab); else currentTab = 0; setPanels(currentTab); } #endregion if ((!(util.alert() == "")) && (MySessionManager.skipAlert == 0)) { this.pAlertmsg.InnerText = util.alert(); // Define the name and type of the client scripts on the page. String csname1 = "PopupScript"; String csname2 = "ButtonClickScript"; Type cstype = this.GetType(); // Get a ClientScriptManager reference from the Page class. ClientScriptManager cs = Page.ClientScript; // Check to see if the startup script is already registered. if (!cs.IsStartupScriptRegistered(cstype, csname1)) { String cstext1 = "alertMessage();"; cs.RegisterStartupScript(cstype, csname1, cstext1, true); } MySessionManager.skipAlert = 1; } }
protected void Page_Load(object sender, EventArgs e) { if (MySessionManager.CurrentUser == null) { Response.Redirect("~/logout.aspx"); } LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); setNotifications(); showLoanAppInfo(); setUrls(); if (Request.QueryString["id"] == null) { } else { string EncID = Request.QueryString["id"]; int DecID = Convert.ToInt32(MyEncryption.Decrypt(EncID, "12345678910")); MySessionManager.AppID = DecID; MySessionManager.ClientID = Convert.ToInt32(loanApp.getClientID(MySessionManager.AppID)); showLoanAppInfo(); } if (!(Request.QueryString["ops"] == null)) { if (!(Request.QueryString["tab"] == null)) { if (!(Request.QueryString["tab"] == "")) { currentTab = int.Parse(Request.QueryString["tab"]); } else { currentTab = Convert.ToInt32(MySessionManager.CurrentTab); } ops = Request.QueryString["ops"].ToString(); setTab(); MySessionManager.CurrentTab = currentTab.ToString(); MySessionManager.OpsTab = "load"; string urlpath = util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab"); urlpath = util.RemoveQueryStringByKey(urlpath, "ops"); Response.Redirect(urlpath); } else { if (!(Request.QueryString["tab"] == "")) { currentTab = int.Parse(Request.QueryString["tab"]); } else { currentTab = 0; } ops = "load"; setTab(); MySessionManager.CurrentTab = currentTab.ToString(); MySessionManager.OpsTab = "load"; util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "tab"); util.RemoveQueryStringByKey(HttpContext.Current.Request.Url.AbsoluteUri, "ops"); } } else { ops = MySessionManager.OpsTab.ToString(); //For handling the tabs if (!(MySessionManager.CurrentTab == "")) { currentTab = int.Parse(MySessionManager.CurrentTab); } else { currentTab = 0; } setTab(); } if ((!(util.alert() == "")) && (MySessionManager.skipAlert == 0)) { this.pAlertmsg.InnerText = util.alert(); // Define the name and type of the client scripts on the page. String csname1 = "PopupScript"; String csname2 = "ButtonClickScript"; Type cstype = this.GetType(); // Get a ClientScriptManager reference from the Page class. ClientScriptManager cs = Page.ClientScript; // Check to see if the startup script is already registered. if (!cs.IsStartupScriptRegistered(cstype, csname1)) { String cstext1 = "alertMessage();"; cs.RegisterStartupScript(cstype, csname1, cstext1, true); } MySessionManager.skipAlert = 1; } }
public void createNewApp() { LoanAccountDSTableAdapters.GetLoanAccountTableAdapter LoanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountRow tblLoanAcc = LoanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID))[0]; string AppID; string AppNewID = ""; try { LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter RefreshAccount = new LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter(); LoanAccountDS.GetAccountRefreshmentRecordDataTable tblRefreshAccount = RefreshAccount.GetAccountRefreshmentRecord(Convert.ToInt32(MySessionManager.AccountID)); if (tblRefreshAccount.Rows.Count>0) { MySessionManager.AppID = tblRefreshAccount[0].datNewAppID; } else { int? getAppID = null; AppID = tblLoanAcc.datApplicationID.ToString(); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); LoanAccountDSTableAdapters.AccountRefreshmentTableAdapter LoanAccRefreshment = new LoanAccountDSTableAdapters.AccountRefreshmentTableAdapter(); string appNo = loanApp.GetLoanApplicationNo(Convert.ToInt32(AppID)).ToString() + "-00"; LoanAccRefreshment.InsertNewRefreshApp(MySessionManager.ClientID, tblLoanAcc.datClientFullName.ToString(), Convert.ToInt32(ddlLoanType.SelectedValue), appNo, Convert.ToDecimal(txtLoanAmount.Text), Convert.ToDecimal(txtLoanAmount.Text), Convert.ToDecimal(txtLoanAmount.Text), Convert.ToInt32(txtDuration.Text), 1, Convert.ToDecimal(txtIntRate.Text), DateTime.Now, Convert.ToDateTime(txtFirstPaymentDate.Text), 0, Convert.ToInt32(ddlInterestRateType.SelectedValue), Convert.ToInt32(AppID), Convert.ToInt32(ddlCT.SelectedValue), Convert.ToInt32(tblLoanAcc.datTeamID), ref getAppID); AppNewID = getAppID.ToString(); LoanAccRefreshment.InsertCopyAssets(AppID, AppNewID); LoanAccRefreshment.InsertCopyAuditors(AppID, AppNewID); LoanAccRefreshment.InsertCopyBankers(AppID, AppNewID); LoanAccRefreshment.InsertCopyChecklist(AppID, AppNewID); LoanAccRefreshment.InsertCopyCollaterals(AppID, AppNewID); LoanAccRefreshment.InsertCopyComments(AppID, AppNewID); LoanAccRefreshment.InsertCopyCorporateInfo(AppID, AppNewID); LoanAccRefreshment.InsertCopyCreditInformation(AppID, AppNewID); LoanAccRefreshment.InsertCopyEnterprises(AppID, AppNewID); LoanAccRefreshment.InsertCopyFees(AppID, AppNewID); LoanAccRefreshment.InsertCopyFinancials(AppID, AppNewID); LoanAccRefreshment.InsertCopyGuarantor(AppID, AppNewID); LoanAccRefreshment.InsertCopyIncomeExpense(AppID, AppNewID); LoanAccRefreshment.InsertCopyIntiator(AppID, AppNewID); LoanAccRefreshment.InsertCopyLegalReports(AppID, AppNewID); LoanAccRefreshment.InsertCopyNextOfKin(AppID, AppNewID); LoanAccRefreshment.InsertCopyNoOfEmployees(AppID, AppNewID); LoanAccRefreshment.InsertCopyOwnership(AppID, AppNewID); LoanAccRefreshment.InsertCopyPaymentPlan(AppID, AppNewID); LoanAccRefreshment.InsertCopyPDC(AppID, AppNewID); LoanAccRefreshment.InsertCopyPreApprovalReports(AppID, AppNewID); LoanAccRefreshment.InsertCopyReligion(AppID, AppNewID); LoanAccRefreshment.InsertCopyReports(AppID, AppNewID); LoanAccRefreshment.InsertCopyRiskReport(AppID, AppNewID); LoanAccRefreshment.InsertCopySpouse(AppID, AppNewID); LoanAccRefreshment.InsertCopySupportingDocuments(AppID, AppNewID); LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter loanAcRef = new LoanAccountDSTableAdapters.GetAccountRefreshmentRecordTableAdapter(); loanAcRef.InsertAccountRefreshment(Convert.ToInt32(MySessionManager.AccountID), Convert.ToInt32(AppID)); loanAcRef.UpdateNewAppID(Convert.ToInt32(AppNewID), Convert.ToInt32(MySessionManager.AccountID)); MySessionManager.AppID = Convert.ToInt32(AppNewID); } } catch (Exception ex) { } }
public void UpdateIndividualClient() { //Get Clients profile information mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); mainDS.ClientRow tblClient = client.GetClientProfile(MySessionManager.ClientID)[0]; string Fullname = tblClient.datFirstName.ToString()+" "+tblClient.datMiddleName.ToString()+" "+ tblClient.datSurname.ToString(); //Delete all initiators tied up the application LoanDSTableAdapters.IntiatorTableAdapter initiator = new LoanDSTableAdapters.IntiatorTableAdapter(); initiator.DeleteInitiator(MySessionManager.AppID, MySessionManager.ClientID); LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); loanApp.UpdateClientName(Fullname, MySessionManager.ClientID); }
public void setUrls() { LoanDSTableAdapters.LoanApplicationsTableAdapter loanApp = new LoanDSTableAdapters.LoanApplicationsTableAdapter(); int status = Convert.ToInt32(loanApp.getApplicationStatus(MySessionManager.AppID)); if (status == 13) { this.btnTransEntry.Visible = false; this.btnEditPV.Visible = false; this.btnPreparePV.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=2&ops=load"; } else if (status == 14) { this.btnPreparePV.Visible = false; this.btnTransEntry.Visible = false; this.btnEditPV.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=6&ops=load"; } else if (status == 15) { this.btnPreparePV.Visible = false; this.btnEditPV.Visible = false; this.btnTransEntry.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=5&ops=load"; this.divSubmit.Visible = false; } this.btnApplicationDetails.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri+"&tab=1&ops=load"; this.btnPVReport.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=3&ops=load"; this.btnSupDocs.PostBackUrl = HttpContext.Current.Request.Url.AbsoluteUri + "&tab=4&ops=load"; }