public DataTable GetPeriodicSavingAccountByStatus(AuthoriseStatus status)
{
var table = new DataTable();
using (var conn = new SqlConnection(DataProvider.ConnectionString))
{
using (var command = new SqlCommand(QUERY_GET_PERIODIC_SAVING_ACCOUNT_BY_STATUS, conn))
{
command.Parameters.AddWithValue("Status", status.ToString());
using (var adapter = new SqlDataAdapter(command))
{
adapter.Fill(table);
}
}
return table;
}
}
// du lieu lay ve duoc dua vao Grid View, chua co thuoc tinh san nen phai tao them table, adapter, du lieu se lay tu table ==> adapter
public DataTable GetIndividualCustomerBySatus(AuthoriseStatus status)
{
var table = new DataTable();
using (var conn = new SqlConnection(DataProvider.ConnectionString))
{
using (var command = new SqlCommand(QUERY_GET_INDIVIDUAL_CUSTOMER_ACCOUNT_BY_STATUS, conn))
{
command.Parameters.AddWithValue("Status", status.ToString());
using (var adapter = new SqlDataAdapter(command))
{
adapter.Fill(table);
}
}
return table;
}
}
public DataTable GetDiscountedAccountByStatus(AuthoriseStatus status)
{
string GET_DISCOUNTED_ACCOUNT_BY_STATUS = @"SELECT [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] FROM [dbo].[BSAVING_ACC_DISCOUNTED] WHERE [Status] = @Status";
var table = new DataTable();
using (var conn = new SqlConnection(DataProvider.ConnectionString))
{
using (var command = new SqlCommand(GET_DISCOUNTED_ACCOUNT_BY_STATUS, conn))
{
command.Parameters.AddWithValue("Status", status.ToString());
using (var adapter = new SqlDataAdapter(command))
{
adapter.Fill(table);
}
}
return table;
}
}
