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