// for display datatable
public ActionResult GetDataTablesList(AppDataTablesRequest param)
{
try
{
var categoryList = _context.Category.ToList();
IEnumerable <Category> filteredCategoryList;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredCategoryList = categoryList.Where(cat => (cat.Name ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredCategoryList = categoryList;
}
var viewDataList = filteredCategoryList.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//var result = from cat in viewDataList
// select new[] { cat.Name, Convert.ToString(cat.CategoryId), };
var result = AppDataTablesResponse.CreateResponse(param, categoryList.Count(), filteredCategoryList.Count(), viewDataList);
return(Json(result));
}
catch (Exception)
{
throw;
}
}
// for display datatable
public ActionResult GetDataTables(AppDataTablesRequest param)
{
try
{
var categoryList = _context.Category.ToList();
IEnumerable <Category> filteredCategoryList;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredCategoryList = categoryList.Where(cat => (cat.Name ?? "").Contains(param.sSearch)).ToList();
}
else
{
filteredCategoryList = categoryList;
}
var viewOdjects = filteredCategoryList.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from cat in viewOdjects
select new[] { cat.Name, Convert.ToString(cat.CategoryId), };
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = categoryList.Count(),
iTotalDisplayRecords = filteredCategoryList.Count(),
aaData = result
}));
}
catch (Exception)
{
throw;
}
}
