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