public async Task <IActionResult> CommunitiesGroupsList(CustomeSearchFilter model) { var draw = Request.Form["draw"].FirstOrDefault(); var length = Request.Form["length"].FirstOrDefault(); // Skip number of Rows count var start = Request.Form["start"].FirstOrDefault(); // Sort Column Name var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"].FirstOrDefault(); // Sort Column Direction (asc, desc) var sortColumnDirection = Request.Form["order[0][dir]"].FirstOrDefault(); // Search Value from (Search box) var searchValue = Request.Form["search[value]"].FirstOrDefault(); model.PageLimit = length; model.PageNumber = start; model.SearchValue = searchValue; model.OrderBy = sortColumn + " " + sortColumnDirection; var data = await _communityGroupsService.getAdminCommunitiesGroupsList(model); int recordsTotal = 0; if (data.Count != 0) { recordsTotal = data.FirstOrDefault().TotalCount; } return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data })); }
public async Task <IList <CommunityTypesListViewModel> > getCommunitiesGroupsTypeList(CustomeSearchFilter model) { IList <CommunityTypesListViewModel> list = new List <CommunityTypesListViewModel>(); await _context.LoadStoredProc("GetAdminCommunitiesTypeList") .WithSqlParam("IsActive", model.IsPublish) .WithSqlParam("Start", model.PageNumber) .WithSqlParam("PageLimit", model.PageLimit) .WithSqlParam("OrderBy", model.OrderBy) .WithSqlParam("SearchValue", model.SearchValue) .ExecuteStoredProcAsync((handler) => { list = handler.ReadToList <CommunityTypesListViewModel>(); // do something with your results. }); return(list); }