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