public async Task <CollectionResult <Order> > Get(int customerId, int?top, int?skip)
{
var query = new GetManyOrdersQuery(customerId, top, skip);
var orders = await _queryDispatcher.ExecuteAsync <IEnumerable <Order>, GetManyOrdersQuery>(query);
return(new CollectionResult <Order>(orders, query.Skip, query.Top, HttpContext.RequestedUrl()));
}
public async Task <IEnumerable <Order> > Ask(GetManyOrdersQuery query)
{
using (var connection = _provider.GetConnection())
{
connection.Open();
return(await connection.QueryAsync <Order>(
@"SELECT o.Id, o.Price, o.CreatedDate
FROM Orders o
Where o.CustomerId=@CustomerId
ORDER BY Id DESC
OFFSET (@SKIP) ROWS
FETCH NEXT (@Top) ROWS ONLY;",
new
{
query.CustomerId,
query.Top,
query.Skip
}));
}
}
