public JsonResult Search(GridSettings gridSettings) { AnnouncementSearchFilter filter = new AnnouncementSearchFilter(); if (gridSettings.IsSearch) { filter.Title = gridSettings.Where.rules.Any(r => r.field == "Title") ? gridSettings.Where.rules.FirstOrDefault(r => r.field == "Title").data : string.Empty; } int totalRecords = 0; var anss = announcementService.Search(filter, gridSettings.SortColumn, gridSettings.SortOrder, gridSettings.PageSize, gridSettings.PageIndex, out totalRecords); var jsonData = new { total = totalRecords / gridSettings.PageSize + 1, page = gridSettings.PageIndex, records = totalRecords, rows = ( from a in anss select new { ID = a.ID, Title = a.Title, InsertDate = a.InsertDate, EditDate = a.LastUpdatedDate, Author = a.Author.FullName } ) }; JsonResult result = Json(jsonData); return(result); }
public IEnumerable<Announcement> Search(AnnouncementSearchFilter filter, string sortColumn, string sortOrder, int pageSize, int pageIndex, out int totalRecords) { IEnumerable<Announcement> anns = context.Announcements; if (!string.IsNullOrEmpty(filter.Title)) { anns = anns.Where(t => t.Title.ToLower().Contains(filter.Title.ToLower())); } totalRecords = anns.Count(); return anns.OrderByDescending(item => item.InsertDate).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); }
public IEnumerable <Announcement> Search(AnnouncementSearchFilter filter, string sortColumn, string sortOrder, int pageSize, int pageIndex, out int totalRecords) { IEnumerable <Announcement> anns = context.Announcements; if (!string.IsNullOrEmpty(filter.Title)) { anns = anns.Where(t => t.Title.ToLower().Contains(filter.Title.ToLower())); } totalRecords = anns.Count(); return(anns.OrderByDescending(item => item.InsertDate).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList()); }
public JsonResult Search(GridSettings gridSettings) { AnnouncementSearchFilter filter = new AnnouncementSearchFilter(); if (gridSettings.IsSearch) { filter.Title = gridSettings.Where.rules.Any(r => r.field == "Title") ? gridSettings.Where.rules.FirstOrDefault(r => r.field == "Title").data : string.Empty; } int totalRecords = 0; var anss = announcementService.Search(filter, gridSettings.SortColumn, gridSettings.SortOrder, gridSettings.PageSize, gridSettings.PageIndex, out totalRecords); var jsonData = new { total = totalRecords / gridSettings.PageSize + 1, page = gridSettings.PageIndex, records = totalRecords, rows = ( from a in anss select new { ID = a.ID, Title = a.Title, InsertDate = a.InsertDate, EditDate = a.LastUpdatedDate, Author = a.Author.FullName } ) }; JsonResult result = Json(jsonData); return result; }