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