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); }