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