public bool CreateNewSalaryPaymentFrequency(SalaryPaymentFrequency paymentFrequency,List<SalaryPaymentFrequencyDetail> paymentFrequencyDetail)
{
string QUERY = @"INSERT INTO [dbo].[BSalaryPaymentFrequency]
([RefId],[Status]
,[OpenAccounId]
,[CustomerId]
,[CustomerName]
,[Currency]
,[TotalDebitAmt]
,[Fequency]
,[Term]
,[EndDate]
,[OrderingCust]
,[NonFrequency]
,[CreatedBy]
,[CreatedDate])
VALUES(@RefId,@Status,@OpenAccounId,@CustomerId,@CustomerName,@Currency,@TotalDebitAmt
,@Fequency,@Term,@EndDate,@OrderingCust,@NonFrequency,@CreatedBy, getdate())";
UpdateSalaryPaymentFrequencyDetail(paymentFrequencyDetail, paymentFrequency.RefId);
using (var conn = new SqlConnection(DataProvider.ConnectionString))
{
paymentFrequency.Status = AuthoriseStatus.UNA.ToString();
return conn.Execute(QUERY, paymentFrequency) > 0;
}
}
private bool CommitPaymentFrequency()
{
var paymentFrequency = new SalaryPaymentFrequency();
BuildPaymentFrequency(paymentFrequency);
if (SavingAccountDAO.CheckSalaryPaymentFrequencyExist(paymentFrequency.RefId))
{
paymentFrequency.UpdatedBy = this.UserInfo.Username;
return SavingAccountDAO.UpdateSalaryPaymentFrequency(paymentFrequency, BuildListDetail());
}
else
{
paymentFrequency.CreatedBy = this.UserInfo.Username;
return SavingAccountDAO.CreateNewSalaryPaymentFrequency(paymentFrequency, BuildListDetail());
}
}
public bool UpdateSalaryPaymentFrequency(SalaryPaymentFrequency paymentFrequency, List<SalaryPaymentFrequencyDetail> paymentFrequencyDetail)
{
string QUERY = @"UPDATE [dbo].[BSalaryPaymentFrequency]
SET [Status] =@Status
,[NonFrequency] = @NonFrequency
,[OpenAccounId] = @OpenAccounId
,[CustomerId] = @CustomerId
,[CustomerName] = @CustomerName
,[Currency] = @Currency
,[TotalDebitAmt] = @TotalDebitAmt
,[Fequency] = @Fequency
,[Term] = @Term
,[EndDate] = @EndDate
,[OrderingCust] = @OrderingCust
,[UpdatedBy] = @UpdatedBy
,[UpdatedDate] = getdate()
WHERE [RefId] = @RefId";
UpdateSalaryPaymentFrequencyDetail(paymentFrequencyDetail, paymentFrequency.RefId);
using (var conn = new SqlConnection(DataProvider.ConnectionString))
{
paymentFrequency.Status = AuthoriseStatus.UNA.ToString();
return conn.Execute(QUERY, paymentFrequency) > 0;
}
}
private void BuildPaymentFrequency(SalaryPaymentFrequency paymentFrequency)
{
var accountPayment = rcbAccountPayment.SelectedItem;
paymentFrequency.RefId = tbDepositCode.Text;
paymentFrequency.OpenAccounId = accountPayment.Value;
paymentFrequency.CustomerId = accountPayment.Attributes["CustomerId"];
paymentFrequency.CustomerName = accountPayment.Attributes["CustomerName"];
paymentFrequency.Currency = lblCurrency.Text;
paymentFrequency.TotalDebitAmt = (decimal?)tbTotalDebitAmtShow.Value;
if (NonFrequency != "YES")
{
paymentFrequency.Fequency = rdpFrequency.SelectedDate;
paymentFrequency.Term = rcbTerm.SelectedValue;
}
paymentFrequency.EndDate = rdpEndDate.SelectedDate;
paymentFrequency.OrderingCust = tbOrderingCust.Text;
paymentFrequency.NonFrequency = NonFrequency;
}
