public bool CreateNewDiscountedAccount(DiscountedAccount discountedAccount)
{
string INSERT_DISCOUNTED_ACCOUNT = @"INSERT INTO [dbo].[BSAVING_ACC_DISCOUNTED]
([refId],[LDId],[Status],[WorkingAccId],[CustomerId],[AmmountLCY],[AmountFCY],[Narrative],[DealRate]
,[PaymentCCY],[ForTeller],[DebitAccount],[TDCustomerId],[TDJoinHolderId],[TDProductLineId],[TDCurrency]
,[TDAmmount],[TDValueDate],[TDBusDayDate],[TDTerm],[TDFinalMatDate],[TDInterestRate],[TDTotalIntamt],[TDWorkingAccountId],[TDWorkingAccountName]
,[TDAccountOfficerId],[DPDrAccountId],[DPDrAccountName],[DPAmountLCY],[DPAmountFCY],[DPNarrative],[DPPaymentCcy],[DPForTeller],[DPCreditAccount]
,[DPExchRate],[CreatedBy],[CreatedDate])
VALUES
(@refId,@LDId, @Status,@WorkingAccId,@CustomerId, @AmmountLCY, @AmountFCY, @Narrative, @DealRate
, @PaymentCCY, @ForTeller, @DebitAccount, @TDCustomerId, @TDJoinHolderId, @TDProductLineId, @TDCurrency
, @TDAmmount, @TDValueDate, @TDBusDayDate, @TDTerm, @TDFinalMatDate, @TDInterestRate, @TDTotalIntamt, @TDWorkingAccountId,@TDWorkingAccountName
, @TDAccountOfficerId, @DPDrAccountId,@DPDrAccountName, @DPAmountLCY, @DPAmountFCY, @DPNarrative, @DPPaymentCcy, @DPForTeller, @DPCreditAccount
, @DPExchRate, @CreatedBy, getdate())";
using (var conn = new SqlConnection(DataProvider.ConnectionString))
{
return conn.Execute(INSERT_DISCOUNTED_ACCOUNT, discountedAccount) > 0;
}
}
private bool CommitDiscountedAccount()
{
var discountedAccount = new DiscountedAccount();
BuilddiscountedAccount(discountedAccount);
if (SavingAccountDAO.CheckDiscountedAccountExist(discountedAccount.RefId))
{
discountedAccount.UpdatedBy = this.UserInfo.Username;
return SavingAccountDAO.UpdateDiscountedAccount(discountedAccount);
}
else
{
discountedAccount.CreatedBy = this.UserInfo.Username;
return SavingAccountDAO.CreateNewDiscountedAccount(discountedAccount);
}
}
public bool UpdateDiscountedAccount(DiscountedAccount discountedAccount)
{
string UPDATE_DISCOUNTED_ACCOUNT = @"UPDATE [dbo].[BSAVING_ACC_DISCOUNTED]
SET [LDId]=@LDId,[Status]= @Status,[WorkingAccId]=@WorkingAccId,[CustomerId]= @CustomerId,[AmmountLCY]= @AmmountLCY,[AmountFCY]= @AmountFCY,[Narrative]= @Narrative
,[DealRate]= @DealRate,[PaymentCCY]= @PaymentCCY,[ForTeller]= @ForTeller
,[DebitAccount]= @DebitAccount,[TDCustomerId]= @TDCustomerId,[TDJoinHolderId]= @TDJoinHolderId
,[TDProductLineId]= @TDProductLineId,[TDCurrency]= @TDCurrency,[TDAmmount]= @TDAmmount
,[TDValueDate]= @TDValueDate,[TDBusDayDate]= @TDBusDayDate,[TDTerm]= @TDTerm
,[TDFinalMatDate]= @TDFinalMatDate,[TDInterestRate]= @TDInterestRate,[TDTotalIntamt]= @TDTotalIntamt
,[TDWorkingAccountId]= @TDWorkingAccountId,[TDWorkingAccountName]= @TDWorkingAccountName,[TDAccountOfficerId]= @TDAccountOfficerId
,[DPDrAccountId]= @DPDrAccountId,[DPDrAccountName]= @DPDrAccountName
,[DPAmountLCY]= @DPAmountLCY,[DPAmountFCY]= @DPAmountFCY,[DPNarrative]= @DPNarrative
,[DPPaymentCcy]= @DPPaymentCcy,[DPForTeller]= @DPForTeller,[DPCreditAccount]= @DPCreditAccount
,[DPExchRate]= @DPExchRate,[UpdatedBy]= @UpdatedBy
,[UpdatedDate]= getdate() WHERE [refId] = @refId";
using (var conn = new SqlConnection(DataProvider.ConnectionString))
{
return conn.Execute(UPDATE_DISCOUNTED_ACCOUNT, discountedAccount) > 0;
}
}
private void BuilddiscountedAccount(DiscountedAccount discountedAccount)
{
discountedAccount.RefId = tbDepositCode.Text;
discountedAccount.LDId = LDid.Text;
discountedAccount.Status = AuthoriseStatus.UNA.ToString();
discountedAccount.WorkingAccId = rcbWorkingAccount.SelectedValue;
discountedAccount.CustomerId = tbcustomId.Text;
discountedAccount.AmmountLCY = rtbAccountLCY.Value.HasValue ? (decimal?)rtbAccountLCY.Value : null;
discountedAccount.AmountFCY = rtbAccountFCY.Value.HasValue ? (decimal?)rtbAccountFCY.Value : null;
discountedAccount.Narrative = rtbNarrative.Text;
discountedAccount.DealRate = rnbDealRate.Value.HasValue ? (decimal?)rnbDealRate.Value : null;
discountedAccount.PaymentCCY = rcbPaymentCCY.SelectedValue;
discountedAccount.ForTeller = rtbForTeller.Text;
discountedAccount.DebitAccount = rcbDebitAccount.SelectedValue;
discountedAccount.DPAmountLCY = !string.IsNullOrEmpty(ctxtAmountLCY.Text) ? (decimal?)Convert.ToDecimal(ctxtAmountLCY.Text) : null;
discountedAccount.TDCustomerId = lblCustomerNo.Text;
discountedAccount.TDJoinHolderId = rcbJoinHolder.SelectedValue;
discountedAccount.TDProductLineId = rcbProductLine.SelectedValue;
discountedAccount.TDCurrency = rcbCurrencyAmount.SelectedValue;
discountedAccount.TDValueDate = rdpValueDate.SelectedDate.HasValue? (DateTime?)rdpValueDate.SelectedDate.Value.Date:null;
//discountedAccount.TDBusDayDate = tbBusDayDef.Text;
discountedAccount.TDTerm = rtbTerm.SelectedValue;
discountedAccount.TDFinalMatDate = rdpFinalMatDate.SelectedDate.HasValue ? (DateTime?)rdpFinalMatDate.SelectedDate.Value.Date : null;
discountedAccount.TDInterestRate = rtbInterestRate.Value.HasValue ? (decimal?)rtbInterestRate.Value : null;
discountedAccount.TDTotalIntamt = string.IsNullOrEmpty(lblTotalInt.Text) ? null : (decimal?)Convert.ToDecimal(lblTotalInt.Text);
discountedAccount.TDWorkingAccountId = rtbWorkingAccountId.Text;
discountedAccount.TDWorkingAccountName = rtbWorkingAccountName.Text;
discountedAccount.TDAccountOfficerId = rcbAccountOfficer.SelectedValue;
discountedAccount.DPDrAccountId = rcbDrAccountId.Text;
discountedAccount.DPDrAccountName = rcbDrAccountName.Text;
discountedAccount.DPAmountFCY = !string.IsNullOrEmpty(ctxtAmountFCY.Text) ? (decimal?)Convert.ToDecimal(ctxtAmountFCY.Text):null;
discountedAccount.DPNarrative = "ID: [" + LDid.Text + "]-P: [" + rnbAmount.Value + "]-R: [" + rtbInterestRate.Value + "]-T: [" + rtbTerm.SelectedValue + "]";//lbNarrative.Text;
discountedAccount.DPPaymentCcy = rcbPaymentCcy2.SelectedValue;
discountedAccount.DPForTeller = txtForTeller.Text;
discountedAccount.DPCreditAccount = rcbCreditAccount.SelectedValue;
discountedAccount.DPExchRate = txtExchRate.Value.HasValue ? (decimal?)txtExchRate.Value : null;
if (discountedAccount.TDCurrency == "VND")
{
rtbAccountLCY.Enabled = true;
}
else
{
rtbAccountFCY.Enabled = true;
rnbDealRate.Enabled = true;
}
if (discountedAccount.TDCurrency == "VND")
{
discountedAccount.TDAmmount = discountedAccount.AmmountLCY;
}
else
{
discountedAccount.TDAmmount = discountedAccount.AmountFCY;
if (discountedAccount.AmountFCY.HasValue && discountedAccount.DealRate.HasValue)
{
discountedAccount.AmmountLCY = discountedAccount.AmountFCY * discountedAccount.DealRate;
}
if (discountedAccount.DPAmountFCY.HasValue && discountedAccount.DPExchRate.HasValue)
{
discountedAccount.DPAmountLCY = discountedAccount.DPAmountFCY.Value * discountedAccount.DPExchRate.Value;
}
}
}
