public bool CreateNewArrearSavingAccount(ArrearSavingAccount arrearSavingAccount)
{
using (var conn = new SqlConnection(DataProvider.ConnectionString))
{
return conn.Execute(INSERT_ARREAR_SAVING_ACCOUNT, arrearSavingAccount) > 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;
}
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();
}
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"));
}