public IActionResult AjaxHandler(jQueryDataTableParamModel param)
{
string sSearch = "";
if (param.sSearch != null)
{
sSearch = param.sSearch;
}
var sortColumnIndex = Convert.ToInt32(Request.Query["iSortCol_0"]);
var sortDirection = Request.Query["sSortDir_0"]; // asc or desc
int iTotalRecords;
int iTotalDisplayRecords;
var displayedPages = slideService.Search(sSearch, sortColumnIndex, sortDirection, param.iDisplayStart, param.iDisplayLength, out iTotalRecords, out iTotalDisplayRecords);
var result = from p in displayedPages
select new[] {
p.Id.ToString(),
("<img src='" + p.Photo + "' width='100'>"),
p.Title.ToString(),
(!String.IsNullOrEmpty(p.SubTitle)?p.SubTitle.ToString():""),
p.AddedBy.ToString(),
p.AddedDate.ToString(),
string.Empty
};
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = iTotalRecords,
iTotalDisplayRecords = iTotalDisplayRecords,
aaData = result.ToList()
}));
}