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 displayedRedirects = redirectService.Search(sSearch, sortColumnIndex, sortDirection, param.iDisplayStart, param.iDisplayLength, out iTotalRecords, out iTotalDisplayRecords); var result = from p in displayedRedirects select new[] { p.Id.ToString(), p.Name.ToString(), p.OldUrl, p.NewUrl, p.IsActive.ToString(), string.Empty }; return(Json(new { sEcho = param.sEcho, iTotalRecords = iTotalRecords, iTotalDisplayRecords = iTotalDisplayRecords, aaData = result.ToList() })); }