public JsonResult GetPagination(DataTableParameters parameters)
{
var search = parameters.Search.Value?.ToLower() ?? string.Empty;
var repo = new RepositoryBase <SubCategory>(_db);
var items = repo.GetItemsByExpression(w => w.CategoryId.HasValue && w.Name.Contains(search), x => x.Name, parameters.Start, parameters.Length, out var recordsTotal, x => x.Category).ToList();
var dtResult = new DataTableResultSet(parameters.Draw, recordsTotal);
var buttons = new ButtonsSubCategory();
foreach (var item in items.ToList())
{
dtResult.data.Add(new object[]
{
item.Name,
$"{item.Category?.Name ?? "Não informada"}",
buttons.ToPagination(item.SubCategoryId, item.ShowOnApp, Account.Current.Roles)
});
}
return(Json(dtResult, JsonRequestBehavior.AllowGet));
}
public JsonResult GetPagination(DataTableParameters parameters)
{
var search = parameters.Search.Value?.ToLower() ?? string.Empty;
var repo = new RepositoryBase <SubCategory>(_db);
var items = repo.GetItemsByExpression(w => w.CategoryId != null && w.Name.Contains(search), x => x.Category).ToList();
var dtResult = new DataTableResultSet(parameters.Draw, 10);
var buttons = new ButtonsSubCategory();
foreach (var item in items.ToList())
{
dtResult.data.Add(new[]
{
item.SubCategoryId.ToString(),
$"{item.Name}",
$"{item.Category?.Name ?? "Não informada"}",
buttons.ToPagination(item.SubCategoryId)
});
}
return(Json(dtResult, JsonRequestBehavior.AllowGet));
}
