public async Task <IActionResult> Index(int page = 1, int limit = 10, string name = "") { try { var queryCategorys = _db.Category.AsNoTracking().OrderByDescending(u => u.Id); if (!string.IsNullOrWhiteSpace(name)) { queryCategorys = queryCategorys.Where(u => u.CategoryName.Contains(name)).OrderByDescending(u => u.SortNo); } var categoryResult = await PaginatedList <Category> .CreatePaginatedAsync(queryCategorys, page, limit); ViewBag.PageIndex = categoryResult.PageIndex; ViewBag.PageTotal = categoryResult.PageTotal; ViewBag.PageCount = categoryResult.PageCount; ViewBag.HasPreViousPage = categoryResult.HasPreViousPage; ViewBag.HasNextPage = categoryResult.HasNextPage; if (!string.IsNullOrWhiteSpace(HttpContext.Request.QueryString.ToString())) { ViewBag.Query = HttpContext.Request.QueryString.ToString().Substring(0); } ViewBag.PageUrl = "/categorym"; ViewData["SearchName"] = name; var categoryMaps = _mapper.Map <List <Category>, List <CategoryDto> >(categoryResult); ViewBag.Categorys = new List <CategoryDto>(); if (categoryMaps.Count > 0) { ViewBag.Categorys = categoryMaps; } if (TempData["ErrorMessage"] != null) { ViewData["ErrorMessage"] = TempData["ErrorMessage"]; } } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; } finally { ViewData["CategoryM"] = "active"; } return(View()); }
public async Task <IActionResult> Index(int page = 1, int limit = 10, string title = "") { try { var queryPosts = _db.Post.AsNoTracking().OrderByDescending(u => u.Id); if (!string.IsNullOrWhiteSpace(title)) { queryPosts = queryPosts.Where(u => u.Title.Contains(title)).OrderByDescending(u => u.Id); } var postResult = await PaginatedList <Post> .CreatePaginatedAsync(queryPosts, page, limit); ViewBag.PageIndex = postResult.PageIndex; ViewBag.PageTotal = postResult.PageTotal; ViewBag.PageCount = postResult.PageCount; ViewBag.HasPreViousPage = postResult.HasPreViousPage; ViewBag.HasNextPage = postResult.HasNextPage; if (!string.IsNullOrWhiteSpace(HttpContext.Request.QueryString.ToString())) { ViewBag.Query = HttpContext.Request.QueryString.ToString().Substring(0); } ViewBag.PageUrl = "/postm"; ViewData["SearchTitle"] = title; var postMaps = _mapper.Map <List <Post>, List <PostDto> >(postResult); ViewBag.Posts = new List <PostDto>(); if (postMaps.Count > 0) { ViewBag.Posts = postMaps; } if (TempData["ErrorMessage"] != null) { ViewData["ErrorMessage"] = TempData["ErrorMessage"]; } } catch (Exception ex) { ViewData["ErrorMessage"] = ex.Message; } finally { ViewData["PostM"] = "active"; } return(View()); }