protected void btnSave_Click(object sender, EventArgs e) { try { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); string clientname = client.GetClientsName(MySessionManager.ClientID).ToString(); InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter(); InvApp.UpdateInvestmentApp(txtName.Value, clientname, GetApplicationNo(), 0, Convert.ToInt32(ddlTerms.SelectedValue), Convert.ToDecimal(txtInvestmentAmt.Value), Convert.ToInt32(ddlType.SelectedValue), Convert.ToDecimal(txtRatePerAnnum.Value), Convert.ToInt32(ddlFrequencyInt.SelectedValue), Convert.ToInt32(ddlModeOfInv.SelectedValue), txtFunds.Value, Convert.ToInt32(ddlVerifed.SelectedValue), MySessionManager.InvAppID); loadInvestmentDetails(); } catch (Exception ex) { } Response.Redirect(Request.RawUrl.ToString()); }
public void loadClientInformation(int ClientID) { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); mainDS.ClientDataTable cinfo = client.GetClientProfile(ClientID); if (cinfo.Count > 0) { try { mainDS.ClientRow rinfo = cinfo[0]; lblClientName.InnerText = rinfo.datClientName.ToString(); lblClientNo.InnerText = rinfo.datClientNumber.ToString(); string ctype = "Individual"; if (rinfo.datClientType == 2) { ctype = "Corporate"; } lblClientType.InnerText = ctype; lblEmail.InnerText = rinfo.datEmailAddress; lblMobile.InnerText = rinfo.datMobileNumber1 + " " + rinfo.datMobileNumber2; lblNationality.InnerText = rinfo.datNationality.ToString(); lblPostalAddress.InnerText = rinfo.datPostalAddress; lblResAddress.InnerText = rinfo.datCurrentResidentialAddress; lblTelephone.InnerText = rinfo.datHomeTelephoneNumber; } catch (Exception ex) { } } }
public void getProfileType(int ClientID) { try { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); int?type = int.Parse(client.GetClientType(ClientID).ToString()); if (type == 1) { this.individualclientprofile.Visible = true; this.enterpriseclientprofile.Visible = false; this.coporateclientprofile.Visible = false; } else if (type == 2) { this.individualclientprofile.Visible = false; this.enterpriseclientprofile.Visible = false; this.coporateclientprofile.Visible = true; } else if (type == 3) { this.individualclientprofile.Visible = true; this.enterpriseclientprofile.Visible = false; this.coporateclientprofile.Visible = false; } } catch (Exception ex) { } }
public void getProfileType(int ClientID) { try { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); int? type = int.Parse(client.GetClientType(ClientID).ToString()); if (type == 1) { this.individualclientprofile.Visible = true; this.enterpriseclientprofile.Visible = false; this.coporateclientprofile.Visible = false; } else if (type == 2) { this.individualclientprofile.Visible = false; this.enterpriseclientprofile.Visible = false; this.coporateclientprofile.Visible = true; } else if (type == 3) { this.individualclientprofile.Visible = true; this.enterpriseclientprofile.Visible = false; this.coporateclientprofile.Visible = false; } } catch (Exception ex) { } }
protected void btnSave_Click(object sender, EventArgs e) { fullname = txtSurname.Value + ' ' + txtMiddlename.Value + ' ' + txtfirstname.Value; mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); int?objID = null; client.InsertClient(GenerateClientNumber(), 3, Convert.ToInt32(this.ddlTitle.SelectedValue), txtfirstname.Value.Trim(), txtMiddlename.Value.Trim(), txtSurname.Value.Trim(), fullname, txttelephone.Value.Trim(), txtMobileNo.Value.Trim(), txtEmail.Value.Trim(), txthomeAddress.Value.Trim(), ref objID); if (objID.Value > 0) { MySessionManager.ClientID = Convert.ToInt32(objID); } ShowMessageBox("New Enterprise has been created"); }
protected void btnSave_Click(object sender, EventArgs e) { fullname = txtSurname.Value + " " + txtMiddlename.Value + " " + txtfirstname.Value; mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); int? objID = null; client.InsertClient(GenerateClientNumber(), 1, Convert.ToInt32(this.ddlTitle.SelectedValue), txtfirstname.Value.Trim(), txtMiddlename.Value.Trim(), txtSurname.Value.Trim(), fullname, txttelephone.Value.Trim(), txtMobileNo.Value.Trim(), txtEmail.Value.Trim(), txthomeAddress.Value.Trim(), ref objID); if (objID.Value > 0) { MySessionManager.ClientID = Convert.ToInt32(objID); } ShowMessageBox("New Individual client has been created"); }
public string GenerateClientNumber() { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); int noClients = Convert.ToInt32(client.GetClientCount().ToString()); string ClientNo = "C" + (100000 + (noClients+1)).ToString(); return ClientNo; }
/// <summary> /// This function displays information about current application being worked /// </summary> public void showLoanAppInfo() { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter(); InvestmentDS.GetInvestmentAppDataTable tblInvApp = invApp.GetInvestmentApp(MySessionManager.InvAppID); if (tblInvApp.Rows.Count > 0) { try { this.lblapplicantName.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString(); this.lblClientNo.InnerText = client.GetClientNo(MySessionManager.ClientID).ToString(); if (tblInvApp[0].IsdatInvestmentAmountNull() == false) { this.lblInvestmentAmount.InnerText = tblInvApp[0].datInvestmentAmount.ToString("c").Replace("$", ""); } if (tblInvApp[0].IsdatInvestmentNameNull() == false) { this.lblInvestmentName.InnerText = tblInvApp[0].datInvestmentName.ToString(); } if (tblInvApp[0].IsdatTermsNull() == false) { this.lblTerm.InnerText = util.displayValue("opt_terms", tblInvApp[0].datTerms.ToString()) + " days"; } if (tblInvApp[0].IsdatApplicationNumberNull() == false) { this.lblAppNo.InnerText = tblInvApp[0].datApplicationNumber.ToString(); } if (tblInvApp[0].IsdatValueDateNull() == false) { this.lblValueDate.InnerText = tblInvApp[0].datValueDate.ToString("c").Replace("$", ""); } if (tblInvApp[0].IsdatInvestmentTypeNull() == false) { this.lblInvtype.InnerText = util.displayValue("opt_investment_types", tblInvApp[0].datInvestmentType.ToString()); } if (tblInvApp[0].IsdatFrequencyOfInterestPaymentNull() == false) { this.lblAccInterest.InnerText = tblInvApp[0].datFrequencyOfInterestPayment.ToString(); } } catch (Exception ex) { } } }
public void loadCompanyDetails(int clientID) { try { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); mainDS.ClientRow tblClient = client.GetClientProfile(MySessionManager.ClientID)[0]; LoanDSTableAdapters.CoporateInformationTableAdapter companyDetails = new LoanDSTableAdapters.CoporateInformationTableAdapter(); LoanDS.CoporateInformationDataTable tblCompanyDetails = companyDetails.GetCoporateInformation(MySessionManager.ClientID); if (tblCompanyDetails.Rows.Count > 0) { txtCompanyName.Value = tblCompanyDetails[0].datCompanyName.ToString(); txtCommencementDate.Text = tblCompanyDetails[0].datCommencementDate.ToShortDateString(); txtNatureofbusiness.Value = tblCompanyDetails[0].datNatureOfBusiness.ToString(); txtPhysicalAddress.Value = tblCompanyDetails[0].datPhysicalAddress.ToString(); txtRegistrationNumber.Text = tblCompanyDetails[0].datRegistrationNumber.ToString(); txtRegistrationDate.Text = tblCompanyDetails[0].datRegistrationDate.ToShortDateString(); txtYearsInBusiness.Value = tblCompanyDetails[0].datYearsInBusiness.ToString(); txtwebsite.Value = tblCompanyDetails[0].datWebsite.ToString(); txtVATNo.Value = tblCompanyDetails[0].datVATNumber.ToString(); txtTIN.Value = tblCompanyDetails[0].datTIN.ToString(); if (tblCompanyDetails[0].IsdatTelephoneNumber1Null() == false) { txtTel1.Value = tblCompanyDetails[0].datTelephoneNumber1.ToString(); } else if (tblClient.IsdatMobileNumber1Null() == false) { txtTel1.Value = tblClient.datMobileNumber1.ToString(); } if (tblCompanyDetails[0].IsdatTelephoneNumber2Null() == false) { txtTel2.Value = tblCompanyDetails[0].datTelephoneNumber2.ToString(); } else if (tblClient.IsdatMobileNumber2Null() == false) { txtTel2.Value = tblClient.datMobileNumber2.ToString(); } txtTel2.Value = tblCompanyDetails[0].datTelephoneNumber2.ToString(); txtFax.Value = tblCompanyDetails[0].datFaxNumber.ToString(); if (tblCompanyDetails[0].IsdatIndustryTypeNull() == false) { ddlIndustryType.SelectedValue = tblCompanyDetails[0].datIndustryType.ToString(); } //if (tblCompanyDetails[0].IsdatSectorNull()==false) { if(ddlIndustryType.SelectedValue = tblCompanyDetails[0].datSector.ToString(); } if (tblCompanyDetails[0].IsdatPremissesStatusNull() == false) { ddlPremisesStatus.SelectedValue = tblCompanyDetails[0].datPremissesStatus.ToString(); } if (tblCompanyDetails[0].IsdatIsRegisteredNull() == false) { ddlRegistered.SelectedValue = tblCompanyDetails[0].datIsRegistered.ToString(); } this.type.Value = "update"; this.editskip.Value = "2"; } } catch (Exception ex) { } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (!(txtfirstname.Value == "" || txtSurname.Value == "")) { int nochildren; if (txtNoChildren.Text == "") { nochildren = 0; } else { nochildren = Convert.ToInt32(txtNoChildren.Text); } // fetch the en-GB culture CultureInfo ukCulture = new CultureInfo("en-GB"); // pass the DateTimeFormat information to DateTime.Parse DateTime dt = DateTime.Parse(txtBirthdate.Text, ukCulture.DateTimeFormat); string clientname = txtfirstname.Value.Trim() + " " + txtMiddlename.Value.Trim() + " " + txtSurname.Value.Trim(); mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); client.UpdateClient(GenerateClientNumber(), Convert.ToInt32(ddlTitle.Text), txtfirstname.Value.Trim(), txtMiddlename.Value.Trim(), txtSurname.Value.Trim(), clientname, ddlNo1.Text, ddlNo2.Text, ddlidNo3.Text, txtidNo1.Value.Trim(), txtidNo2.Value.Trim(), txtidNo3.Value.Trim(), Convert.ToInt32(ddlNationality.SelectedValue), Convert.ToInt32(ddlRegion.SelectedValue), Convert.ToInt32(ddlMaritalStatus.SelectedValue), txtSpouse.Text, nochildren, Convert.ToInt32(ddlGender.SelectedValue), dt, txttelephone.Value.Trim(), txtOfficePhone.Value, txtMobileNo1.Value.Trim(), txtMobileNo2.Value.Trim(), txtfaxnumber.Value, txtEmail.Value.Trim(), Convert.ToInt32(ddlRecStatus.Text), txthomeAddress.Value.Trim(), txtpreviousAddress.Value.Trim(), txtPostalAddress.Value.Trim(), txtLandMark.Value.Trim(), MySessionManager.CurrentUser.UserID, MySessionManager.ClientID); this.editskip.Value = "1"; } }catch (Exception ex) {} }
public string GenerateClientNumber() { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); int noClients = Convert.ToInt32(MySessionManager.ClientID); string ClientNo = "C" + (100000 + noClients).ToString(); return(ClientNo); }
public string GenerateClientNumber() { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); int noClients = Convert.ToInt32(client.GetClientCount().ToString()); string ClientNo = "C" + (100000 + (noClients + 1)).ToString(); return(ClientNo); }
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; } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (!(txtfirstname.Value == "" || txtSurname.Value == "")) { int nochildren; if (txtNoChildren.Text == "") { nochildren = 0; } else { nochildren = Convert.ToInt32(txtNoChildren.Text); } // fetch the en-GB culture CultureInfo ukCulture = new CultureInfo("en-GB"); // pass the DateTimeFormat information to DateTime.Parse DateTime dt = DateTime.Parse(txtBirthdate.Text, ukCulture.DateTimeFormat); string clientname = txtfirstname.Value.Trim() + " " + txtMiddlename.Value.Trim() + " " + txtSurname.Value.Trim(); mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); client.UpdateClient(GenerateClientNumber(), Convert.ToInt32(ddlTitle.Text), txtfirstname.Value.Trim(), txtMiddlename.Value.Trim(), txtSurname.Value.Trim(), clientname, ddlNo1.Text, ddlNo2.Text, ddlidNo3.Text, txtidNo1.Value.Trim(), txtidNo2.Value.Trim(), txtidNo3.Value.Trim(), Convert.ToInt32(ddlNationality.SelectedValue), Convert.ToInt32(ddlRegion.SelectedValue), Convert.ToInt32(ddlMaritalStatus.SelectedValue), txtSpouse.Text, nochildren, Convert.ToInt32(ddlGender.SelectedValue), dt, txttelephone.Value.Trim(), txtOfficePhone.Value, txtMobileNo1.Value.Trim(), txtMobileNo2.Value.Trim(), txtfaxnumber.Value, txtEmail.Value.Trim(), Convert.ToInt32(ddlRecStatus.Text), txthomeAddress.Value.Trim(), txtpreviousAddress.Value.Trim(), txtPostalAddress.Value.Trim(), txtLandMark.Value.Trim(), MySessionManager.CurrentUser.UserID, MySessionManager.ClientID); this.editskip.Value = "1"; } }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); }
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()); } } }
public void showLoanAppInfo() { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); InvestmentDSTableAdapters.GetInvestmentAppTableAdapter invApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter(); InvestmentDS.GetInvestmentAppDataTable tblInvApp = invApp.GetInvestmentApp(MySessionManager.InvAppID); if (tblInvApp.Rows.Count > 0) { try { this.lblapplicantName.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString(); this.lblClientNo.InnerText = client.GetClientNo(MySessionManager.ClientID).ToString(); if (tblInvApp[0].IsdatInvestmentAmountNull() == false) { this.lblInvestmentAmount.InnerText = tblInvApp[0].datInvestmentAmount.ToString("c").Replace("$", ""); } if (tblInvApp[0].IsdatInvestmentNameNull() == false) { this.lblInvestmentName.InnerText = tblInvApp[0].datInvestmentName.ToString(); } if (tblInvApp[0].IsdatTermsNull() == false) { this.lblTerm.InnerText = util.displayValue("opt_terms", tblInvApp[0].datTerms.ToString()) + " days"; } if (tblInvApp[0].IsdatApplicationNumberNull() == false) { this.lblAppNo.InnerText = tblInvApp[0].datApplicationNumber.ToString(); } if (tblInvApp[0].IsdatValueDateNull() == false) { this.lblValueDate.InnerText = tblInvApp[0].datValueDate.ToString("c").Replace("$", ""); } if (tblInvApp[0].IsdatInvestmentTypeNull() == false) { this.lblInvtype.InnerText = util.displayValue("opt_investment_types", tblInvApp[0].datInvestmentType.ToString()); } if (tblInvApp[0].IsdatFrequencyOfInterestPaymentNull() == false) { this.lblAccInterest.InnerText = tblInvApp[0].datFrequencyOfInterestPayment.ToString(); } if (tblInvApp[0].IsdatValueDateNull() == false) { this.lblValueDate.InnerText = tblInvApp[0].datValueDate.ToString("dd-MM-yyyy"); } } catch (Exception ex) { } } }
public void loadPersonalInformation() { try { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); mainDS.ClientDataTable tblClient = client.GetClientProfile(MySessionManager.ClientID); if (tblClient.Rows.Count > 0) { this.editskip.Value = "2"; if (tblClient[0].IsdatFirstNameNull() == false) { txtfirstname.Value = tblClient[0].datFirstName.ToString(); } if (tblClient[0].IsdatSurnameNull() == false) { txtSurname.Value = tblClient[0].datSurname.ToString(); } if (tblClient[0].IsdatMiddleNameNull() == false) { txtMiddlename.Value = tblClient[0].datMiddleName.ToString(); } if (tblClient[0].IsdatIDType1Null() == false) { ddlNo1.SelectedValue = tblClient[0].datIDType1; } if (tblClient[0].IsdatIDType2Null() == false) { ddlNo2.SelectedValue = tblClient[0].datIDType2; } if (tblClient[0].IsdatIDType3Null() == false) { ddlidNo3.SelectedValue = tblClient[0].datIDType3; } if (tblClient[0].IsdatGenderNull() == false) { ddlGender.SelectedValue = tblClient[0].datGender.ToString(); } if (tblClient[0].IsdatTitleNull() == false) { ddlTitle.SelectedValue = tblClient[0].datTitle.ToString(); } if (tblClient[0].IsdatRegionNull() == false) { ddlRegion.SelectedValue = tblClient[0].datRegion.ToString(); } if (tblClient[0].IsdatMaritalStatusNull() == false) { ddlMaritalStatus.SelectedValue = tblClient[0].datMaritalStatus.ToString(); } if (tblClient[0].IsdatNationalityNull() == false) { ddlNationality.SelectedValue = tblClient[0].datNationality.ToString(); } if (tblClient[0].IsdatResidentialStatusNull() == false) { ddlRecStatus.SelectedValue = tblClient[0].datResidentialStatus.ToString(); } if (tblClient[0].IsdatIDValue1Null() == false) { txtidNo1.Value = tblClient[0].datIDValue1.ToString(); } if (tblClient[0].IsdatIDValue2Null() == false) { txtidNo2.Value = tblClient[0].datIDValue2.ToString(); } if (tblClient[0].IsdatIDValue3Null() == false) { txtidNo3.Value = tblClient[0].datIDValue3.ToString(); } // if (tblClient[0].IsdatResidentialStatusNull() == false) { ddlRecStatus.SelectedValue = tblClient[0].datResidentialStatus.ToString(); } if (tblClient[0].IsdatSpouseNull() == false) { txtSpouse.Text = tblClient[0].datSpouse.ToString(); } if (tblClient[0].IsdatNoChildrenNull() == false) { txtNoChildren.Text = tblClient[0].datNoChildren.ToString(); } if (tblClient[0].IsdatMobileNumber1Null() == false) { txtMobileNo1.Value = tblClient[0].datMobileNumber1.ToString(); } if (tblClient[0].IsdatMobileNumber2Null() == false) { txtMobileNo2.Value = tblClient[0].datMobileNumber2.ToString(); } if (tblClient[0].IsdatOfficeTelephoneNumberNull() == false) { txtOfficePhone.Value = tblClient[0].datOfficeTelephoneNumber.ToString(); } if (tblClient[0].IsdatPostalAddressNull() == false) { txtPostalAddress.Value = tblClient[0].datPostalAddress.ToString(); } if (tblClient[0].IsdatNearestLandMarkNull() == false) { txtLandMark.Value = tblClient[0].datNearestLandMark.ToString(); } if (tblClient[0].IsdatCurrentResidentialAddressNull() == false) { txthomeAddress.Value = tblClient[0].datCurrentResidentialAddress.ToString(); } if (tblClient[0].IsdatPreviousResidentialAddressNull() == false) { txtpreviousAddress.Value = tblClient[0].datPreviousResidentialAddress.ToString(); } if (tblClient[0].IsdatHomeTelephoneNumberNull() == false) { txttelephone.Value = tblClient[0].datHomeTelephoneNumber.ToString(); } if (tblClient[0].IsdatFaxNumberNull() == false) { txtfaxnumber.Value = tblClient[0].datFaxNumber.ToString(); } if (tblClient[0].IsdatEmailAddressNull() == false) { txtEmail.Value = tblClient[0].datEmailAddress.ToString(); } if (tblClient[0].IsdatDateOfBirthNull() == false) { txtBirthdate.Text = tblClient[0].datDateOfBirth.ToString("dd-MM-yyyy"); } } } 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 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 btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { fullname = txtcompanyname.Value; mainDSTableAdapters.ClientTableAdapter clients = new mainDSTableAdapters.ClientTableAdapter(); int? objID = null; clients.InsertClient(GenerateClientNumber(), 2, 0, this.txtInFullname.Value.Trim(), "", "", this.fullname, txttelno.Value.Trim(), "", "", txtphysicalAddress.Value.Trim(), ref objID); if (objID.Value > 0) { // this.lblinfo.Text = "Client Profile Created Successfully..."; MySessionManager.ClientID = Convert.ToInt32(objID); LoanDSTableAdapters.IntiatorTableAdapter initiator = new LoanDSTableAdapters.IntiatorTableAdapter(); initiator.InsertInitiator(null, MySessionManager.ClientID, txtInFullname.Value, "", txtMobileno.Value.Trim(), null, txtEmail.Value.Trim(), null, null); } else { } } }
public void showAccountInfomartion() { try { LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountRow tblLoanAcc = loanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID))[0]; mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); lblAccNo.InnerText = " " + tblLoanAcc.datAccountNumber.ToString(); lblClienttName.InnerText = " " + tblLoanAcc.datClientFullName.ToString(); lblEmail.InnerText = " " + tblLoanAcc.datIssueDate.ToString("d MMMM yyyy"); lblloantype.InnerText = " " + util.displayValue("opt_loan_types", tblLoanAcc.datLoanType.ToString()); lblAmtOutstanding.InnerText = " " + tblLoanAcc.datOutstandingAmount.ToString("c").Replace("$", ""); lblloanAmount.InnerText = " " + tblLoanAcc.datInitialAmount.ToString("c").Replace("$", ""); lblClientNo.InnerText = " " + client.GetClientNo(tblLoanAcc.datClientID); lblDuration.InnerText = " " + tblLoanAcc.datDuration.ToString()+" month(s)"; lblIntRate.InnerText = " " + tblLoanAcc.datInterestRate.ToString("c").Replace("$", "") + "%"; } catch (Exception ex) { } }
public void showAccountInfomartion() { try { LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountRow tblLoanAcc = loanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID))[0]; mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); lblAccNo.InnerText = " " + tblLoanAcc.datAccountNumber.ToString(); lblClienttName.InnerText = " " + tblLoanAcc.datClientFullName.ToString(); lblEmail.InnerText = " " + tblLoanAcc.datIssueDate.ToString("d MMMM yyyy"); lblloantype.InnerText = " " + util.displayValue("opt_loan_types", tblLoanAcc.datLoanType.ToString()); lblAmtOutstanding.InnerText = " " + tblLoanAcc.datOutstandingAmount.ToString("c").Replace("$", ""); lblloanAmount.InnerText = " " + tblLoanAcc.datInitialAmount.ToString("c").Replace("$", ""); lblClientNo.InnerText = " " + client.GetClientNo(tblLoanAcc.datClientID); lblDuration.InnerText = " " + tblLoanAcc.datDuration.ToString() + " month(s)"; lblIntRate.InnerText = " " + tblLoanAcc.datInterestRate.ToString("c").Replace("$", "") + "%"; } catch (Exception ex) { } }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { fullname = txtcompanyname.Value; mainDSTableAdapters.ClientTableAdapter clients = new mainDSTableAdapters.ClientTableAdapter(); int?objID = null; clients.InsertClient(GenerateClientNumber(), 2, 0, this.txtInFullname.Value.Trim(), "", "", this.fullname, txttelno.Value.Trim(), "", "", txtphysicalAddress.Value.Trim(), ref objID); if (objID.Value > 0) { // this.lblinfo.Text = "Client Profile Created Successfully..."; MySessionManager.ClientID = Convert.ToInt32(objID); LoanDSTableAdapters.IntiatorTableAdapter initiator = new LoanDSTableAdapters.IntiatorTableAdapter(); initiator.InsertInitiator(null, MySessionManager.ClientID, txtInFullname.Value, "", txtMobileno.Value.Trim(), null, txtEmail.Value.Trim(), null, null); } else { } } }
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) { InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter(); InvestmentDS.GetInvestmentAppDataTable tblInvApp = InvApp.GetInvestmentApp(MySessionManager.InvAppID); mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter(); try { lblTotal.Text = tempHolder.GetTransTotalAmount(MySessionManager.AppID).ToString(); } catch (Exception ex) { lblTotal.Text = "0.00"; } if (tblInvApp.Rows.Count > 0) { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); lbltotalamt.InnerText = tblInvApp[0].datInvestmentAmount.ToString("c").Replace("$", ""); lbldate.InnerText = DateTime.Now.ToLongDateString(); lblClient.InnerText = client.GetClientsName(MySessionManager.ClientID).ToString(); lblbranch.InnerText = util.displayValue("tbl_teams", InvApp.GetInvBranch(MySessionManager.InvAppID).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 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 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 gvClients_RowDataBound(object sender, GridViewRowEventArgs e) { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); if (e.Row.RowType == DataControlRowType.DataRow) { int terms=0; InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter InvAcc = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); InvestmentAccountDS.GetInvAccountDataTable tblInvAcc = InvAcc.GetInvAccount(Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex].Value)); string enpValue = MyEncryption.Encrypt(this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString(), "12345678910"); DateTime dt =DateTime.Parse(gvClients.DataKeys[e.Row.RowIndex]["datValueDate"].ToString()); e.Row.Cells[0].Text = client.GetClientsName(Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex]["datClientID"].ToString())).ToString(); e.Row.Cells[4].Text = util.displayValue("opt_investment_types", gvClients.DataKeys[e.Row.RowIndex]["datInvestmentType"].ToString()); terms = Convert.ToInt32(util.displayValue("opt_terms", gvClients.DataKeys[e.Row.RowIndex]["datFrequencyOfInterestPayment"].ToString())); int freq = Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex]["datFrequencyOfInterestPayment"].ToString()); Panel ItemBox = new Panel(); ItemBox.Attributes.Add("id", "div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString()); ItemBox.Attributes.Add("id", "div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString()); ItemBox.Attributes.Add("class", "ItemContainer"); ItemBox.Style.Add("display", "none"); string htmlContent = "<div class='col-md-9' style='padding-top:0'><label> Matured Interest(s) </label><br/>"; if (tblInvAcc[0].dat30 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=30&val=" + tblInvAcc[0].dat30.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 30).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat60 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=60&val=" + tblInvAcc[0].dat60.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 60).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat91 > 0 && freq == 2) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=91&val=" + tblInvAcc[0].dat91.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 90).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat121 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=121&val=" + tblInvAcc[0].dat121.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 121).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat151 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=151&val=" + tblInvAcc[0].dat151.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 151).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat182 > 0 && freq == 3) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=182&val=" + tblInvAcc[0].dat182.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 182).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat212 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=212&val=" + tblInvAcc[0].dat212.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 212).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat242 > 0 && freq ==1) { htmlContent += "<a href=../pages/invaccount/iinterestmaturity.aspx?id=" + enpValue + "&schID=242&val=" + tblInvAcc[0].dat242.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 242).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat273 > 0 && freq == 2) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=273&val=" + tblInvAcc[0].dat273.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 273).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat303 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=303&val=" + tblInvAcc[0].dat303.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 303).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat333 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=333&val=" + tblInvAcc[0].dat333.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 303).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat364 > 0 && freq == 4) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=364&val=" + tblInvAcc[0].dat364.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 364).ToString("dd/MM/yyyy") + " </a> <br/>"; } htmlContent += "</div>"; Literal ItemContent = new Literal(); ItemContent.Text = htmlContent; ItemBox.Controls.Add(ItemContent); HyperLink hyp = new HyperLink(); hyp.NavigateUrl = "javascript:showinfo('div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString() + "')"; hyp.Text = e.Row.Cells[0].Text; e.Row.Cells[0].Controls.Add(hyp); e.Row.Cells[0].Controls.Add(ItemBox); //HyperLink clientProfile = (HyperLink)e.Row.FindControl("hyperClientProfile"); //HyperLink Inv = (HyperLink)e.Row.FindControl("hyperInv"); } }
protected void gvClients_RowDataBound(object sender, GridViewRowEventArgs e) { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); if (e.Row.RowType == DataControlRowType.DataRow) { int terms = 0; InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter InvAcc = new InvestmentAccountDSTableAdapters.GetInvAccountTableAdapter(); InvestmentAccountDS.GetInvAccountDataTable tblInvAcc = InvAcc.GetInvAccount(Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex].Value)); string enpValue = MyEncryption.Encrypt(this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString(), "12345678910"); DateTime dt = DateTime.Parse(gvClients.DataKeys[e.Row.RowIndex]["datValueDate"].ToString()); e.Row.Cells[0].Text = client.GetClientsName(Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex]["datClientID"].ToString())).ToString(); e.Row.Cells[4].Text = util.displayValue("opt_investment_types", gvClients.DataKeys[e.Row.RowIndex]["datInvestmentType"].ToString()); terms = Convert.ToInt32(util.displayValue("opt_terms", gvClients.DataKeys[e.Row.RowIndex]["datFrequencyOfInterestPayment"].ToString())); int freq = Convert.ToInt32(gvClients.DataKeys[e.Row.RowIndex]["datFrequencyOfInterestPayment"].ToString()); Panel ItemBox = new Panel(); ItemBox.Attributes.Add("id", "div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString()); ItemBox.Attributes.Add("id", "div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString()); ItemBox.Attributes.Add("class", "ItemContainer"); ItemBox.Style.Add("display", "none"); string htmlContent = "<div class='col-md-9' style='padding-top:0'><label> Matured Interest(s) </label><br/>"; if (tblInvAcc[0].dat30 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=30&val=" + tblInvAcc[0].dat30.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 30).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat60 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=60&val=" + tblInvAcc[0].dat60.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 60).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat91 > 0 && freq == 2) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=91&val=" + tblInvAcc[0].dat91.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 90).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat121 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=121&val=" + tblInvAcc[0].dat121.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 121).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat151 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=151&val=" + tblInvAcc[0].dat151.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 151).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat182 > 0 && freq == 3) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=182&val=" + tblInvAcc[0].dat182.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 182).ToString("dd/MM/yyyy") + "</a> <br/>"; } if (tblInvAcc[0].dat212 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=212&val=" + tblInvAcc[0].dat212.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 212).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat242 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/iinterestmaturity.aspx?id=" + enpValue + "&schID=242&val=" + tblInvAcc[0].dat242.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 242).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat273 > 0 && freq == 2) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=273&val=" + tblInvAcc[0].dat273.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 273).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat303 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=303&val=" + tblInvAcc[0].dat303.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 303).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat333 > 0 && freq == 1) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=333&val=" + tblInvAcc[0].dat333.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 303).ToString("dd/MM/yyyy") + " </a> <br/>"; } if (tblInvAcc[0].dat364 > 0 && freq == 4) { htmlContent += "<a href=../pages/invaccount/interestmaturity.aspx?id=" + enpValue + "&schID=364&val=" + tblInvAcc[0].dat364.ToString() + ">Int. Maturity for " + addDaysElapsed(dt, 364).ToString("dd/MM/yyyy") + " </a> <br/>"; } htmlContent += "</div>"; Literal ItemContent = new Literal(); ItemContent.Text = htmlContent; ItemBox.Controls.Add(ItemContent); HyperLink hyp = new HyperLink(); hyp.NavigateUrl = "javascript:showinfo('div" + this.gvClients.DataKeys[e.Row.RowIndex].Value.ToString() + "')"; hyp.Text = e.Row.Cells[0].Text; e.Row.Cells[0].Controls.Add(hyp); e.Row.Cells[0].Controls.Add(ItemBox); //HyperLink clientProfile = (HyperLink)e.Row.FindControl("hyperClientProfile"); //HyperLink Inv = (HyperLink)e.Row.FindControl("hyperInv"); } }
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; mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter(); mTemp.GetTransactionDetailsDataTable tblTempHolder = tempHolder.GetAccTransactions(Convert.ToInt32(MySessionManager.AccountID)); 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; amtDeductable = amtDeductable + tblTempHolder[i].datDebit; ops = 1; } else if (tblTempHolder[i].datCredit > 0) { datCreditAc = tblTempHolder[i].datAccountID; amt = tblTempHolder[i].datCredit; amtDeductable = amtDeductable - 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.CurrentUser.BranchID, tblTempHolder[i].datCredit, tblTempHolder[i].datDebit, datCreditAc, datDebitAc, 0, MySessionManager.CurrentUser.UserID); } mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountDataTable tblLoaonAcc = loanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID)); LoanAccountDSTableAdapters.GetAllLoanRepaymentsTableAdapter repayment = new LoanAccountDSTableAdapters.GetAllLoanRepaymentsTableAdapter(); if (tblLoaonAcc.Rows.Count > 0) { repayment.InsertLoanRepayment(receiptNo(), DateTime.Now, tblLoaonAcc[0].datID, tblLoaonAcc[0].datAccountNumber.ToString(), client.GetClientNo(Convert.ToInt32(MySessionManager.AccountID)), tblLoaonAcc[0].datIssueDate, tblLoaonAcc[0].datInterestRate, MySessionManager.cash, MySessionManager.bank, (MySessionManager.cash + MySessionManager.bank), fees, tblLoaonAcc[0].datLoanType, tblLoaonAcc[0].datPurpose, tblLoaonAcc[0].datTeamID, MySessionManager.CurrentUser.UserID); } loanAcc.UpdateNewAmtOutstanding(amtDeductable, Convert.ToInt32(MySessionManager.AccountID)); decimal outstanding = Convert.ToDecimal(loanAcc.GetAmtOutstanding(Convert.ToInt32(MySessionManager.AccountID))); if (outstanding <= 0) { loanAcc.UpdateCloseAccount(Convert.ToInt32(MySessionManager.AccountID)); } tempHolder.DeleteTempTransByAccID(Convert.ToInt32(MySessionManager.AccountID)); }
protected void btnSave_Click(object sender, EventArgs e) { try { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); string clientname = client.GetClientsName(MySessionManager.ClientID).ToString(); InvestmentDSTableAdapters.GetInvestmentAppTableAdapter InvApp = new InvestmentDSTableAdapters.GetInvestmentAppTableAdapter(); InvApp.UpdateInvestmentApp(txtName.Value, clientname, GetApplicationNo(), 0, Convert.ToInt32(ddlTerms.SelectedValue), Convert.ToDecimal(txtInvestmentAmt.Value), Convert.ToInt32(ddlType.SelectedValue), Convert.ToDecimal(txtRatePerAnnum.Value), Convert.ToInt32(ddlFrequencyInt.SelectedValue), Convert.ToInt32(ddlModeOfInv.SelectedValue), txtFunds.Value, Convert.ToInt32(ddlVerifed.SelectedValue), MySessionManager.InvAppID); loadInvestmentDetails(); } catch (Exception ex) { } Response.Redirect(Request.RawUrl .ToString()); }
public string GenerateClientNumber() { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); int noClients = Convert.ToInt32(MySessionManager.ClientID); string ClientNo = "C" + (100000 + noClients).ToString(); return ClientNo; }
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 = } }
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 loadPersonalInformation() { try { mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); mainDS.ClientDataTable tblClient = client.GetClientProfile(MySessionManager.ClientID); if (tblClient.Rows.Count > 0) { this.editskip.Value = "2"; if (tblClient[0].IsdatFirstNameNull() == false) { txtfirstname.Value = tblClient[0].datFirstName.ToString(); } if (tblClient[0].IsdatSurnameNull() == false) { txtSurname.Value = tblClient[0].datSurname.ToString(); } if (tblClient[0].IsdatMiddleNameNull() == false) { txtMiddlename.Value = tblClient[0].datMiddleName.ToString(); } if (tblClient[0].IsdatIDType1Null() == false) { ddlNo1.SelectedValue = tblClient[0].datIDType1; } if (tblClient[0].IsdatIDType2Null() == false) { ddlNo2.SelectedValue = tblClient[0].datIDType2; } if (tblClient[0].IsdatIDType3Null() == false) { ddlidNo3.SelectedValue = tblClient[0].datIDType3; } if (tblClient[0].IsdatGenderNull() == false) { ddlGender.SelectedValue = tblClient[0].datGender.ToString(); } if (tblClient[0].IsdatTitleNull() == false) { ddlTitle.SelectedValue = tblClient[0].datTitle.ToString(); } if (tblClient[0].IsdatRegionNull() == false) { ddlRegion.SelectedValue = tblClient[0].datRegion.ToString(); } if (tblClient[0].IsdatMaritalStatusNull() == false) { ddlMaritalStatus.SelectedValue = tblClient[0].datMaritalStatus.ToString(); } if (tblClient[0].IsdatNationalityNull() == false) { ddlNationality.SelectedValue = tblClient[0].datNationality.ToString(); } if (tblClient[0].IsdatResidentialStatusNull() == false) { ddlRecStatus.SelectedValue = tblClient[0].datResidentialStatus.ToString(); } if (tblClient[0].IsdatIDValue1Null() == false) { txtidNo1.Value = tblClient[0].datIDValue1.ToString(); } if (tblClient[0].IsdatIDValue2Null() == false) { txtidNo2.Value = tblClient[0].datIDValue2.ToString(); } if (tblClient[0].IsdatIDValue3Null() == false) { txtidNo3.Value = tblClient[0].datIDValue3.ToString(); } if (tblClient[0].IsdatResidentialStatusNull() == false) { ddlRecStatus.SelectedValue = tblClient[0].datResidentialStatus.ToString(); } if (tblClient[0].IsdatSpouseNull() == false) { txtSpouse.Text = tblClient[0].datSpouse.ToString(); } if (tblClient[0].IsdatNoChildrenNull() == false) { txtNoChildren.Text = tblClient[0].datNoChildren.ToString(); } if (tblClient[0].IsdatMobileNumber1Null() == false) { txtMobileNo1.Value = tblClient[0].datMobileNumber1.ToString(); } if (tblClient[0].IsdatMobileNumber2Null() == false) { txtMobileNo2.Value = tblClient[0].datMobileNumber2.ToString(); } if (tblClient[0].IsdatOfficeTelephoneNumberNull() == false) { txtOfficePhone.Value = tblClient[0].datOfficeTelephoneNumber.ToString(); } if (tblClient[0].IsdatPostalAddressNull() == false) { txtPostalAddress.Value = tblClient[0].datPostalAddress.ToString(); } if (tblClient[0].IsdatNearestLandMarkNull() == false) { txtLandMark.Value = tblClient[0].datNearestLandMark.ToString(); } if (tblClient[0].IsdatCurrentResidentialAddressNull() == false) { txthomeAddress.Value = tblClient[0].datCurrentResidentialAddress.ToString(); } if (tblClient[0].IsdatPreviousResidentialAddressNull() == false) { txtpreviousAddress.Value = tblClient[0].datPreviousResidentialAddress.ToString(); } if (tblClient[0].IsdatHomeTelephoneNumberNull() == false) { txttelephone.Value = tblClient[0].datHomeTelephoneNumber.ToString(); } if (tblClient[0].IsdatFaxNumberNull() == false) { txtfaxnumber.Value = tblClient[0].datFaxNumber.ToString(); } if (tblClient[0].IsdatEmailAddressNull() == false) { txtEmail.Value = tblClient[0].datEmailAddress.ToString(); } if (tblClient[0].IsdatDateOfBirthNull() == false) { txtBirthdate.Text = Convert.ToDateTime(tblClient[0].datDateOfBirth.ToString()).ToString("dd-MM-yyyy"); } } } 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); }
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) { MySessionManager.cash = 0; MySessionManager.bank = 0; decimal amtDeductable= 0; decimal fees = 0; decimal amt =0; int ops =0; mTempTableAdapters.GetTransactionDetailsTableAdapter tempHolder = new mTempTableAdapters.GetTransactionDetailsTableAdapter(); mTemp.GetTransactionDetailsDataTable tblTempHolder = tempHolder.GetAccTransactions(Convert.ToInt32( MySessionManager.AccountID)); 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; amtDeductable = amtDeductable + tblTempHolder[i].datDebit; ops = 1; } else if (tblTempHolder[i].datCredit > 0) { datCreditAc = tblTempHolder[i].datAccountID; amt = tblTempHolder[i].datCredit; amtDeductable = amtDeductable - 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.CurrentUser.BranchID, tblTempHolder[i].datCredit, tblTempHolder[i].datDebit, datCreditAc, datDebitAc, 0, MySessionManager.CurrentUser.UserID); } mainDSTableAdapters.ClientTableAdapter client = new mainDSTableAdapters.ClientTableAdapter(); LoanAccountDSTableAdapters.GetLoanAccountTableAdapter loanAcc = new LoanAccountDSTableAdapters.GetLoanAccountTableAdapter(); LoanAccountDS.GetLoanAccountDataTable tblLoaonAcc = loanAcc.GetLoanAccount(Convert.ToInt32(MySessionManager.AccountID)); LoanAccountDSTableAdapters.GetAllLoanRepaymentsTableAdapter repayment = new LoanAccountDSTableAdapters.GetAllLoanRepaymentsTableAdapter(); if(tblLoaonAcc.Rows.Count>0) { repayment.InsertLoanRepayment(receiptNo(), DateTime.Now, tblLoaonAcc[0].datID, tblLoaonAcc[0].datAccountNumber.ToString(), client.GetClientNo(Convert.ToInt32(MySessionManager.AccountID)), tblLoaonAcc[0].datIssueDate, tblLoaonAcc[0].datInterestRate, MySessionManager.cash, MySessionManager.bank, (MySessionManager.cash + MySessionManager.bank), fees, tblLoaonAcc[0].datLoanType, tblLoaonAcc[0].datPurpose, tblLoaonAcc[0].datTeamID, MySessionManager.CurrentUser.UserID); } loanAcc.UpdateNewAmtOutstanding(amtDeductable,Convert.ToInt32(MySessionManager.AccountID)); decimal outstanding=Convert.ToDecimal(loanAcc.GetAmtOutstanding(Convert.ToInt32(MySessionManager.AccountID))); if (outstanding <= 0) { loanAcc.UpdateCloseAccount(Convert.ToInt32(MySessionManager.AccountID)); } tempHolder.DeleteTempTransByAccID(Convert.ToInt32(MySessionManager.AccountID)); }
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 = } }