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