public IActionResult AllGalleryPagination([FromBody] SearchAllPictureInputModel model,
int itemsPerPage = 1, int currentPage = 1)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var response = service.SearchAllPictures(model, itemsPerPage, currentPage);
return(Ok(response));
}
public List <SearchPictureOutputModel> SearchAllPictures(SearchAllPictureInputModel input)
{
var res = new List <SearchPictureOutputModel>();
using (IDbConnection db = new SqlConnection(Global.Connection))
{
res = db.Query <SearchPictureOutputModel>("sp_SearchPicture", input,
commandType: CommandType.StoredProcedure).ToList();
}
return(res);
}
public GalleryViewModel SearchAllPictures(SearchAllPictureInputModel model, int itemsPerPage, int currentPage)
{
var images = repo.SearchAllPictures(model);
Each(images, i => ConvertCategoriesToArr(i));
var totalItems = images.Count();
images = images
.Skip((currentPage - 1) * itemsPerPage)
.Take(itemsPerPage)
.OrderBy(i => i.CreatedAt)
.ToList();
var response = new GalleryViewModel
{
Images = images,
TotalItems = totalItems
};
return(response);
}
