public ContentResult Posts(JqInViewModel jqParams) { var posts = _blogRepository.Posts(jqParams.page - 1, jqParams.rows, jqParams.sidx, jqParams.sord == "asc"); var totalPosts = _blogRepository.TotalPosts(false); var post = (from i in posts select new { id = i.id.ToString(), Urlslug = i.UrlSlug, Title = i.Title, CategoryId = i.Category.id, Body = i.Body, UrlSlug = i.UrlSlug, CreatedOn = i.CreatedOn, Published = i.Published, Header = i.Header } ).ToList(); var result = Content(JsonConvert.SerializeObject(new { page = jqParams.page, records = totalPosts, rows = post, total = Math.Ceiling(Convert.ToDouble(totalPosts) / jqParams.rows) }), "application/json"); return(result); }
/// <summary> /// Return the posts based on jqgrid input parameters as JSON. /// </summary> /// <param name="jqParams"></param> /// <returns></returns> public ContentResult Posts(JqInViewModel jqParams) { var posts = _blogRepository.Posts(jqParams.page - 1, jqParams.rows, jqParams.sidx, jqParams.sord == "asc"); var totalPosts = _blogRepository.TotalPosts(false); return(Content(JsonConvert.SerializeObject(new { page = jqParams.page, records = totalPosts, rows = posts, total = Math.Ceiling(Convert.ToDouble(totalPosts) / jqParams.rows) }, new CustomDateTimeConverter()), "application/json")); }
public ContentResult Projects(JqInViewModel jqParams) { var projects = _ganttService.GetProjects(jqParams.page - 1, jqParams.rows, jqParams.sidx, jqParams.sord == "asc"); int totalProjects = _ganttService.TotalProjects(); return(Content(JsonConvert.SerializeObject(new { page = jqParams.page, records = totalProjects, rows = projects, total = Math.Ceiling(Convert.ToDouble(totalProjects) / jqParams.rows) }, new CustomDateTimeConverter()), "application/json")); }