Пример #1
0
 public bool CreateNewArrearSavingAccount(ArrearSavingAccount arrearSavingAccount)
 {
     using (var conn = new SqlConnection(DataProvider.ConnectionString))
     {
         return conn.Execute(INSERT_ARREAR_SAVING_ACCOUNT, arrearSavingAccount) > 0;
     }
 }
Пример #2
0
 private void BuildArrearSavingAccount(ArrearSavingAccount arrearSavingAccount)
 {
     arrearSavingAccount.RefId = tbDepositCode.Text;
     arrearSavingAccount.Status = AuthoriseStatus.UNA.ToString();
     arrearSavingAccount.CustomerId = rcbCustomerID.SelectedValue;
     arrearSavingAccount.CustomerName = rcbCustomerID.SelectedItem.Text.Replace(arrearSavingAccount.CustomerId + " - ", "");
     arrearSavingAccount.AccCategory = rcbCategoryCode.SelectedValue;
     arrearSavingAccount.AccTitle = tbAccountName.Text;
     arrearSavingAccount.ShortTitle = tbShortName.Text;
     arrearSavingAccount.Currency = rcbCurrentcy.SelectedValue;
     arrearSavingAccount.ProductLineId = rcbProductLine.SelectedValue;
     arrearSavingAccount.JointACHolderId = rcbJointHolderID.SelectedValue;
     arrearSavingAccount.JointACHolderName = rcbJointHolderID.SelectedItem.Text.Replace(arrearSavingAccount.JointACHolderId + " - ", "");
     arrearSavingAccount.RelationshipId = rcbRelationCode.SelectedValue;
     arrearSavingAccount.RelationshipName = rcbRelationCode.SelectedItem.Text.Replace(arrearSavingAccount.RelationshipId + " - ", "");
     arrearSavingAccount.Note = tbNotes.Text;
     arrearSavingAccount.AccountOfferCode = rcbAccOfficer.SelectedValue;
     arrearSavingAccount.AZProductCode = rcbProductAZ.SelectedValue;
     arrearSavingAccount.AZPrincipal = radNumPrincipalAZ.Value.HasValue ? (decimal)radNumPrincipalAZ.Value : 0;
     arrearSavingAccount.AZValueDate = dtpValueDateAZ.SelectedDate;
     arrearSavingAccount.AZTerm = radTermAZ.SelectedValue;
     arrearSavingAccount.AZOriginalMaturityDate = dtpMaturityDateAZ.SelectedDate;
     arrearSavingAccount.AZInterestRate = tbInterestRateAZ.Value.HasValue ? (decimal)tbInterestRateAZ.Value : 0;
     arrearSavingAccount.AZWorkingAccount = rcbWorkingAccAZ.SelectedValue;
     arrearSavingAccount.AZMaturityInstr = lblMaturityInstrAZ.Text;
     arrearSavingAccount.AZRolloverPR = rcbRollOverPROnlyAZ.SelectedValue;
     arrearSavingAccount.TTNo = TTtbPaymentNo.Text;
     arrearSavingAccount.TTAccNo = TTlblAcctNo.Text;
     arrearSavingAccount.TTCurrency = TTrcbPaymentCcy.SelectedValue;
     arrearSavingAccount.TTForTeller = TTtbTeller.Text;
     arrearSavingAccount.TTDebitAccount = TTrcbDebitAmmount.SelectedValue;
     arrearSavingAccount.TTNarative = TTtbNarative.Text;
     arrearSavingAccount.TTDealRate = tbDealRate.Value.HasValue? (decimal?)tbDealRate.Value:null;
 }
Пример #3
0
 private bool CommitArrearSavingAccount()
 {
     var arrearSavingAccount = new ArrearSavingAccount();
     BuildArrearSavingAccount(arrearSavingAccount);
     if (SavingAccountDAO.CheckArrearSavingAccountExist(arrearSavingAccount.RefId))
     {
         arrearSavingAccount.UpdatedBy = this.UserInfo.Username;
         return SavingAccountDAO.UpdateArrearSavingAccount(arrearSavingAccount);
     }
     else
     {
         arrearSavingAccount.CreatedBy = this.UserInfo.Username;
         return SavingAccountDAO.CreateNewArrearSavingAccount(arrearSavingAccount);
     }
     //Response.Redirect(string.Format("Default.aspx?tabid={0}&mid={1}", TabId, ModuleId));
     //AutoLoadExtraInformationForTT(arrearSavingAccount);
     //StatusCommit.Value = 1.ToString();
 }
Пример #4
0
 private void AutoLoadExtraInformationForTT(ArrearSavingAccount arrearLoadAccount)
 {
     //TTtbTeller.Text = arrearLoadAccount.TTForTeller;
     //TTrcbDebitAmmount.Text = arrearLoadAccount.TTDebitAccount;
     //lblAccountLcy.Text = arrearLoadAccount.Currency;
     //lblCurrency.Text = arrearLoadAccount.Currency;
     //TTlblCustomerID.Text = arrearLoadAccount.CustomerId;
     //lblAccountNo.Text = arrearLoadAccount.RefId;
     //lblAccountLcy.Text = string.Format("{0:##,#}", arrearLoadAccount.AZPrincipal);
     //lblAmountInLCY.Text = string.Format("{0:##,#}", arrearLoadAccount.AZPrincipal);
     //lblAmmount.Text = "Ammount = " + arrearLoadAccount.AZPrincipal;
     //lblDate.Text = "Date   = " + (arrearLoadAccount.AZValueDate.HasValue ? arrearLoadAccount.AZValueDate.Value.ToString("yyyyMMdd") : DateTime.Now.ToString("yyyyMMdd"));
 }