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