protected void Page_Load(object sender, EventArgs e) { SelectedPerson = Person; StarsService starsService = new StarsService(starsProjectContext); var starsList = starsService.Queryable().Where(a => a.PersonAliasId == SelectedPerson.PrimaryAliasId.Value).OrderByDescending(a => a.TransactionDateTime).ToList(); gStars.DataSource = starsList; gStars.DataBind(); }
protected void BindGrid() { StarsService starsService = new StarsService(_starsProjectContext); DateTime selectedDate = mypMonth.SelectedDate ?? DateTime.Now; var selectedDateBefore = selectedDate.SundayDate().AddDays(-6); var selectedDateAfter = selectedDate.AddMonths(1).SundayDate().AddDays(-6); var starsList = starsService.Queryable() .Where(x => x.TransactionDateTime > selectedDateBefore && x.TransactionDateTime < selectedDateAfter) .GroupBy(x => x.PersonAlias.Person, (x, y) => new { Person = x, Sum = y.Sum(z => z.Value) }) .ToList() .Select(x => new { x.Person, x.Sum, Campus = x.Person.GetCampus() }); //Filter Campuses var selectedCampuses = cpCampus.SelectedValues; if (selectedCampuses.Count > 0) { starsList = starsList.Where(x => x.Campus == null || selectedCampuses.Contains(x.Campus.Name)).ToList(); } //Get Sum of stars var startsList = starsList.Select(g => { var personLoc = g.Person.GetHomeLocation(); return(new { Month = selectedDate.Month, g.Person.Id, g.Person, g.Sum, g.Campus, PersonZip = personLoc != null ? personLoc.PostalCode : "" }); }); //Filter Star Levels int starsValueFilter = 0; if (!string.IsNullOrWhiteSpace(ddlStars.SelectedValue)) { starsValueFilter = ddlStars.SelectedValue.AsInteger(); startsList = startsList.Where(a => a.Sum >= starsValueFilter && a.Sum < starsValueFilter + 10); } //Order the list startsList = startsList.OrderBy(g => g.Campus != null ? g.Campus.Name : "").ThenBy(g => g.PersonZip).ThenBy(g => g.Person.LastName).ThenBy(g => g.Person.FirstName); //Bind list to grid gStars.DataSource = startsList.ToList(); gStars.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { PersonAliasService personAliasService = new PersonAliasService(rockContext); StarsService starsService = new StarsService(starsProjectContext); var starsList = starsService.Queryable().GroupBy(a => a.PersonAlias.Person).Select(g => new { Person = g.Key, Sum = g.Sum(a => a.Value) }).ToList(); gStars.DataSource = starsList; gStars.DataBind(); }
protected void BindGrid() { StarsService starsService = new StarsService(_starsProjectContext); //Get Sum of stars var startsList = from x in starsService.Queryable().ToList() where x.TransactionDateTime.Month == FilterMonth && x.TransactionDateTime.Year == FilterYear group x by x.PersonAlias.Person into g select new { Person = g.Key, PersonId = g.Key.Id, Sum = g.Sum(x => x.Value), Month = g.Select(x => x.TransactionDateTime.Month), PersonZip = g.Key.GetFamilies(_rockContext).FirstOrDefault().GroupLocations.FirstOrDefault().Location.PostalCode, PersonCampus = g.Key.GetFamilies(_rockContext).FirstOrDefault().Campus.Name }; //Filter Star Levels int starsValueFilter = 0; if (!ddlStars.SelectedValue.IsNullOrWhiteSpace()) { starsValueFilter = Convert.ToInt32(ddlStars.SelectedValue); startsList = startsList.AsQueryable().Where(a => a.Sum >= starsValueFilter && a.Sum < starsValueFilter + 10); } //Filter Campuses var selectedCampuses = cpCampus.SelectedValues; if (selectedCampuses.Count > 0) { var starsListWithCampus = (from x in startsList.ToList() let firstOrDefault = x.Person.GetFamilies(_rockContext).FirstOrDefault() where firstOrDefault != null && selectedCampuses.Contains(firstOrDefault.Campus.Name) select x); startsList = starsListWithCampus; } //Order the list startsList = startsList.OrderBy(g => g.PersonCampus).ThenBy(g => g.PersonZip).ThenBy(g => g.Person.LastName).ThenBy(g => g.Person.FirstName); //Bind list to grid gStars.DataSource = startsList.ToList(); gStars.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SelectedPerson = Person; StarsService starsService = new StarsService(starsProjectContext); var starsList = starsService.Queryable().GroupBy(a => a.PersonAlias.Id) .Select(g => new { Person = g.Key, Sum = g.Sum(a => a.Value) } ).Where(ab => ab.Person == SelectedPerson.PrimaryAliasId.Value).ToList(); var starsListThisMonth = starsService.Queryable() .Where(a => a.TransactionDateTime.Month == DateTime.Now.Month && a.TransactionDateTime.Year == DateTime.Now.Year) .GroupBy(a => a.PersonAlias.Id) .Select(g => new { Person = g.Key, Sum = g.Sum(a => a.Value) } ).Where(ab => ab.Person == SelectedPerson.PrimaryAliasId.Value).ToList(); var starsListLastMonth = starsService.Queryable() .Where(a => a.TransactionDateTime.Month == DateTime.Now.Month - 1 && a.TransactionDateTime.Year == DateTime.Now.Year) .GroupBy(a => a.PersonAlias.Id) .Select(g => new { Person = g.Key, Sum = g.Sum(a => a.Value) } ).Where(ab => ab.Person == SelectedPerson.PrimaryAliasId.Value).ToList(); if (starsList.Any()) { hlStarsTotal.Text = starsList.FirstOrDefault().Sum.ToString() + " Stars All Time"; } else { hlStarsTotal.Text = "0 Stars All Time"; hlStarsTotal.LabelType = LabelType.Default; } if (starsListThisMonth.Any()) { hlStarsThisMonth.Text = starsListThisMonth.FirstOrDefault().Sum.ToString() + " Stars This Month"; } else { hlStarsThisMonth.Text = "0 Stars This Month"; hlStarsThisMonth.LabelType = LabelType.Default; } if (starsListLastMonth.Any()) { hlStarsLastMonth.Text = starsListLastMonth.FirstOrDefault().Sum.ToString() + " Stars Last Month"; } else { hlStarsLastMonth.Text = "0 Stars Last Month"; hlStarsLastMonth.LabelType = LabelType.Default; } }
protected void Page_Load(object sender, EventArgs e) { PersonAliasService personAliasService = new PersonAliasService(rockContext); StarsService starsService = new StarsService(starsProjectContext); var starsList = starsService.Queryable().GroupBy(a => a.PersonAlias.Person).Select(g => new { Person = g.Key, Sum = g.Sum(a => a.Value)}).ToList(); gStars.DataSource = starsList; gStars.DataBind(); }