private bool CommitPeriodicSavingAccount() { var periodicSavingAccount = new PeriodicSavingAccount(); BuildPeriodicSavingAccount(periodicSavingAccount); if (SavingAccountDAO.CheckPeriodicSavingAccountExist(periodicSavingAccount.RefId)) { periodicSavingAccount.UpdatedBy = this.UserInfo.Username; return SavingAccountDAO.UpdatePeriodicSavingAccount(periodicSavingAccount); } else { periodicSavingAccount.CreatedBy = this.UserInfo.Username; return SavingAccountDAO.CreateNewPeriodicSavingAccount(periodicSavingAccount); } }
public bool CreateNewPeriodicSavingAccount(PeriodicSavingAccount periodicSavingAccount) { using (var conn = new SqlConnection(DataProvider.ConnectionString)) { return conn.Execute(INSERT_PERIODIC_SAVING_ACCOUNT, periodicSavingAccount) > 0; } }
private void BuildPeriodicSavingAccount(PeriodicSavingAccount periodicSavingAccount) { periodicSavingAccount.RefId = tbDepositCode.Text; periodicSavingAccount.Status = AuthoriseStatus.UNA.ToString(); periodicSavingAccount.CustomerId = rcbCustomerID.SelectedValue; periodicSavingAccount.CustomerName = rcbCustomerID.SelectedItem.Text.Replace(periodicSavingAccount.CustomerId + " - ", ""); periodicSavingAccount.AccCategory = rcbCategoryCode.SelectedValue; periodicSavingAccount.AccTitle = tbAccountName.Text; periodicSavingAccount.ShortTitle = tbShortName.Text; periodicSavingAccount.Currency = rcbCurrentcy.SelectedValue; periodicSavingAccount.ProductLineId = rcbProductLine.SelectedValue; periodicSavingAccount.JointACHolderId = rcbJointHolderID.SelectedValue; periodicSavingAccount.JointACHolderName = rcbJointHolderID.SelectedItem.Text.Replace(periodicSavingAccount.JointACHolderId + " - ", ""); periodicSavingAccount.RelationshipId = rcbRelationCode.SelectedValue; periodicSavingAccount.RelationshipName = rcbRelationCode.SelectedItem.Text.Replace(periodicSavingAccount.RelationshipId + " - ", ""); periodicSavingAccount.Note = tbNotes.Text; periodicSavingAccount.AccountOfferCode = rcbAccOfficer.SelectedValue; periodicSavingAccount.AZProductCode = rcbProductAZ.SelectedValue; periodicSavingAccount.AZPrincipal = radNumPrincipalAZ.Value.HasValue ? (decimal)radNumPrincipalAZ.Value : 0; periodicSavingAccount.AZValueDate = dtpValueDateAZ.SelectedDate; periodicSavingAccount.AZTerm = radTermAZ.SelectedValue; periodicSavingAccount.AZOriginalMaturityDate = dtpMaturityDateAZ.SelectedDate; periodicSavingAccount.AZInterestRate = tbInterestRateAZ.Value.HasValue ? (decimal)tbInterestRateAZ.Value : 0; periodicSavingAccount.AZWorkingAccount = rcbWorkingAccAZ.SelectedValue; periodicSavingAccount.AZMaturityInstr = lblMaturityInstrAZ.Text; periodicSavingAccount.AZIsSchedule = rcbSchedules.SelectedValue; periodicSavingAccount.AZScheduleType = rcbSchTypeAZ.SelectedValue; periodicSavingAccount.AZFrequency = tbFrequencyAZ.Text; periodicSavingAccount.TTNo = TTtbPaymentNo.Text; periodicSavingAccount.TTAccNo = TTlblAcctNo.Text; periodicSavingAccount.TTCurrency = TTrcbPaymentCcy.SelectedValue; periodicSavingAccount.TTForTeller = TTtbTeller.Text; periodicSavingAccount.TTDebitAccount = TTrcbDebitAmmount.SelectedValue; periodicSavingAccount.TTNarative = TTtbNarative.Text; periodicSavingAccount.TTDealRate = (decimal?)tbDealRate.Value; }