public async Task <PagedResults <Review> > GetAllAsync(ReviewPaging reviewPaging)
{
var results = new PagedResults <Review>();
using (var connection = new SqlConnection(_config.GetConnectionString("DefaultConnection")))
{
await connection.OpenAsync();
using (var multi = await connection.QueryMultipleAsync(
"Review_GetAll",
new
{
Offset = (reviewPaging.Page - 1) * reviewPaging.PageSize,
PageSize = reviewPaging.PageSize
},
commandType: CommandType.StoredProcedure))
{
results.Items = multi.Read <Review>();
results.TotalCount = multi.ReadFirst <int>();
}
}
return(results);
}
public async Task <ActionResult <PagedResults <Review> > > GetAll([FromQuery] ReviewPaging reviewPaging)
{
var reviews = await _reviewRepository.GetAllAsync(reviewPaging);
return(Ok(reviews));
}
