public JsonResult IndexAjax(DataTableJS data)
{
var itmes = _service.GetIQueryableItems().ToList();
String search = null;
if (data.search != null && data.search["value"] != null)
{
search = data.search["value"];
}
var column = data.order[0]["column"];
var dir = data.order[0]["dir"];
string columnName = ((String[])data.columns[int.Parse(column)]["data"])[0];
var queryFilter =
_service.GetIQueryableItems()
.Where(
T => T.Active == 1 &&
(search == "" || (search != null &&
(T.KeySearch.ToLower().Contains(search.ToLower())))));
if (dir == "asc")
{
queryFilter = queryFilter.OrderByField(columnName, true);
}
else
{
queryFilter = queryFilter.OrderByField(columnName, false);
}
data.recordsTotal = _service.GetIQueryableItems().Where(T => T.Active == 1).Count();
data.recordsFiltered = queryFilter.Count();
data.data = queryFilter.Skip(data.start)
.Take(data.length == -1 ? data.recordsTotal : data.length)
.ToList();
return(Json(data, JsonRequestBehavior.AllowGet));
}
