//for client paging blog single
public BlogPaging GetBlogPrevNext(string BlogID)
{
BlogPaging objDetails = new BlogPaging();
var parBlogID = new SqlParameter("@BlogID", BlogID);
objDetails = objDB.Database.SqlQuery <BlogPaging>("udspBlogsGetPaging @BlogID", parBlogID).FirstOrDefault();
return(objDetails);
}
public async Task <PagedResults <Blog> > GetAllAsync(BlogPaging blogPaging)
{
var results = new PagedResults <Blog>();
using (var connection = new SqlConnection(_config.GetConnectionString("DefaultConnection")))
{
await connection.OpenAsync();
using (var multi = await connection.QueryMultipleAsync("Blog_All",
new
{
Offset = (blogPaging.Page - 1) * blogPaging.PageSize,
PageSize = blogPaging.PageSize
},
commandType: CommandType.StoredProcedure
))
{
results.TotalCount = multi.ReadFirst <int>();
}
}
return(results);
}
public async Task <ActionResult <PagedResults <Blog> > > GetAll([FromQuery] BlogPaging blogPaging)
{
var blogs = await _blogRepository.GetAllAsync(blogPaging);
return(Ok(blogs));
}
