public async Task <IActionResult> MyCommunityGroupArticlesList(EventListSearchFilter 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.Id = _claimAccessor.UserId; model.PageLimit = length; model.PageNumber = start; model.SearchValue = searchValue; model.OrderBy = sortColumn + " " + sortColumnDirection; var data = await _communityGroupArticleService.getUserCommunityGroupArticlesListAsync(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 <IActionResult> CommunityGroupEvents(string Id) { EventListSearchFilter filter = new EventListSearchFilter { CommunityGroupsId = Id, PageLimit = "100", PageNumber = "0", OrderBy = "EFromDate desc", SearchValue = "" }; return(PartialView("_communityGroupEvents", await _communitiesForGoodService.getActiveCommunityGroupEventsListAsync(filter))); }
public async Task <IList <CommunityGroupArticlesList> > getUserCommunityGroupArticlesListAsync(EventListSearchFilter model) { IList <CommunityGroupArticlesList> list = new List <CommunityGroupArticlesList>(); await _context.LoadStoredProc("GetUserCommunityGroupArticlesList") .WithSqlParam("UserId", model.Id) .WithSqlParam("CommunityGroupsId", model.CommunityGroupsId) .WithSqlParam("Start", model.PageNumber) .WithSqlParam("PageLimit", model.PageLimit) .WithSqlParam("OrderBy", model.OrderBy) .WithSqlParam("SearchValue", model.SearchValue) .ExecuteStoredProcAsync((handler) => { list = handler.ReadToList <CommunityGroupArticlesList>(); // do something with your results. }); return(list); }