public async Task <AjaxDataTable <CategoryDataTableRow> > GetCategoryDataTable(int Page, int Take, string Search, int OrderColIdx, string OrderDirection)
{
AjaxDataTableDTO <CategoryDataTableRowDTO> categoryAjaxDataTableDTO = await categoryDataTableRepository.GetCategoryDataTable(Page, Take, Search, OrderColIdx, OrderDirection);
AjaxDataTable <CategoryDataTableRow> categoryAjaxDataTable = new AjaxDataTable <CategoryDataTableRow>
{
Draw = categoryAjaxDataTableDTO.Draw,
RecordsFiltered = categoryAjaxDataTableDTO.RecordsFiltered,
RecordsTotal = categoryAjaxDataTableDTO.RecordsTotal,
Data = categoryAjaxDataTableDTO.Data.Select(x => new CategoryDataTableRow
{
Id = x.Id,
Name = x.Name
}).ToList()
};
return(categoryAjaxDataTable);
}
public async Task <AjaxDataTableDTO <CategoryDataTableRowDTO> > GetCategoryDataTable(int Page, int Take, string Search, int OrderColIdx, string OrderDirection)
{
var sp = DbUtil.StoredProcedureBuilder.WithSPName("mscategory_getallpaginated")
.AddParam(Page)
.AddParam(Take)
.AddParam(OrderDirection)
.AddParam(OrderColIdx)
.AddParam(Search)
.SP();
IEnumerable <CategoryDataTableRowDTO> categoryDataTableRows = await ExecSPToListAsync(sp);
AjaxDataTableDTO <CategoryDataTableRowDTO> categoryAjaxDataTable = new AjaxDataTableDTO <CategoryDataTableRowDTO>
{
Data = categoryDataTableRows.ToList(),
Draw = Page,
RecordsFiltered = categoryDataTableRows != null && categoryDataTableRows.Count() > 0 ? Convert.ToInt32(categoryDataTableRows.First().TotalRecord) : categoryDataTableRows.Count(),
RecordsTotal = categoryDataTableRows.Count()
};
return(categoryAjaxDataTable);
}
