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