/// <summary> /// Binds the group members grid. /// </summary> protected void BindGrid() { using (var rockContext = new RockContext()) { var pageShortLinkService = new PageShortLinkService(rockContext); var qry = pageShortLinkService.Queryable().ToList() .Select(s => new ShortLinkRow(s)) .ToList() .AsQueryable(); SortProperty sortProperty = gShortLinks.SortProperty; if (sortProperty != null) { gShortLinks.DataSource = qry.Sort(sortProperty).ToList(); } else { gShortLinks.DataSource = qry.OrderBy(l => l.Token).ToList(); } gShortLinks.DataBind(); } }
/// <summary> /// Binds the group members grid. /// </summary> protected void BindGrid() { using (var rockContext = new RockContext()) { var pageShortLinkService = new PageShortLinkService(rockContext); var shortLinkQry = pageShortLinkService.Queryable(); string token = gfShortLink.GetUserPreference(FilterAttributeKeys.Token); if (!string.IsNullOrEmpty(token)) { shortLinkQry = shortLinkQry.Where(s => s.Token.Contains(token)); } int?siteId = gfShortLink.GetUserPreference(FilterAttributeKeys.Site).AsIntegerOrNull(); if (siteId.HasValue) { shortLinkQry = shortLinkQry.Where(s => s.SiteId == siteId.Value); } var qry = shortLinkQry.ToList() .Select(s => new ShortLinkRow(s)) .ToList() .AsQueryable(); SortProperty sortProperty = gShortLinks.SortProperty; if (sortProperty != null) { gShortLinks.DataSource = qry.Sort(sortProperty).ToList(); } else { gShortLinks.DataSource = qry.OrderBy(l => l.Token).ToList(); } gShortLinks.DataBind(); } }