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;
}
