public GetCustomerInvoicesDbQueryResult Handle(GetCustomerInvoicesDbQuery query) { Assert.IsNotNull(query); var request = ToExecuteReaderRequest(query, CancellationToken.None); return(ExecuteReader(request)); }
public Task <GetCustomerInvoicesDbQueryResult> HandleAsync(GetCustomerInvoicesDbQuery query, CancellationToken cancellationToken) { Assert.IsNotNull(query); var request = ToExecuteReaderRequest(query, cancellationToken); return(ExecuteReaderAsync(request)); }
private static ReadOnlyCollection <object> ToParameters(GetCustomerInvoicesDbQuery query) { var parameters = new SqlParameterCollectionBuilder(); parameters.Add("customerId", query.CustomerId); parameters.AddDate("invoiceDate", query.InvoiceDate); return(parameters.ToReadOnlyCollection()); }
public void TestMethod1() { using (var sqlConnection = SqlConnectionFactory.CreateSqlConnection()) { sqlConnection.Open(); var query = new GetCustomerInvoicesDbQuery(customerId: 1, invoiceDate: DateTime.Today); var queryHandler = new GetCustomerInvoicesDbQueryHandler(sqlConnection, transaction: null); var queryResult = queryHandler.Handle(query); } }
private ExecuteReaderRequest ToExecuteReaderRequest(GetCustomerInvoicesDbQuery query, CancellationToken cancellationToken) { var createCommandRequest = ToCreateCommandRequest(query); return(new ExecuteReaderRequest(createCommandRequest, CommandBehavior.Default, cancellationToken)); }
private CreateCommandRequest ToCreateCommandRequest(GetCustomerInvoicesDbQuery query) { var parameters = ToParameters(query); return(new CreateCommandRequest(CommandText, parameters, CommandType.Text, CommandTimeout, _transaction)); }