public JsonResult GetMyBoards(int pageIndex = 0, int pageSize = 10) { var boardQuery = BoardDbContext.BoardItems.Where(p => p.UserId == 1) .OrderByDescending(p => p.Title); int totalRows = boardQuery.Count(); var result = boardQuery.Skip(pageSize * pageIndex).Take(pageSize).ToList(); foreach (var item in result) { item.BoardImageUrl = string.Format(@"/cdn/images/{0}?w={1}&h={2}", item.BoardImageUrl, 220, 220); } GetMyBoardsResponse response = new GetMyBoardsResponse(); response.boards = result; response.totalItems = totalRows; return Json(response, JsonRequestBehavior.AllowGet); }
public JsonResult GetMyBoards(int pageIndex = 0, int pageSize = 10) { var boardQuery = BoardDbContext.BoardItems.Where(p => p.UserId == 1) .OrderByDescending(p => p.Title); int totalRows = boardQuery.Count(); var result = boardQuery.Skip(pageSize * pageIndex).Take(pageSize).ToList(); foreach (var item in result) { item.BoardImageUrl = string.Format(@"/cdn/images/{0}?w={1}&h={2}", item.BoardImageUrl, 220, 220); } GetMyBoardsResponse response = new GetMyBoardsResponse(); response.boards = result; response.totalItems = totalRows; return(Json(response, JsonRequestBehavior.AllowGet)); }