public IEnumerable<NameCount> Baptisms()
{
var dt1 = Sunday.AddDays(-4);
var dt2 = Sunday.AddDays(2);
var q3 = from p in DbUtil.Db.People
where p.BaptismDate >= dt1 && p.BaptismDate <= dt2
group p by p.BaptismType.Description into g
orderby g.Key
select new NameCount
{
Name = g.Key,
Count = g.Count()
};
var list = q3.ToList();
TotalBaptisms = new NameCount
{
Name = "Total",
Count = q3.Sum(i => i.Count)
};
return list;
}
public IEnumerable<NameCount> Decisions()
{
var dt1 = Sunday.AddDays(-4);
var dt2 = Sunday.AddDays(2);
var q3 = from p in DbUtil.Db.People
where p.DecisionDate >= dt1 && p.DecisionDate < dt2.AddDays(1)
where (Campus ?? 0) == 0 || p.CampusId == Campus
group p by p.DecisionType.Description into g
orderby g.Key
select new NameCount
{
Name = g.Key,
Count = g.Count()
};
var list = q3.ToList();
TotalDecisions = new NameCount
{
Name = "Total",
Count = q3.Sum(i => i.Count)
};
return list;
}
public IEnumerable <NameCount> Decisions()
{
var dt1 = Sunday.AddDays(-4);
var dt2 = Sunday.AddDays(2);
var q3 = from p in DbUtil.Db.People
where p.DecisionDate >= dt1 && p.DecisionDate < dt2.AddDays(1)
where (Campus ?? 0) == 0 || p.CampusId == Campus
group p by p.DecisionType.Description into g
orderby g.Key
select new NameCount
{
Name = g.Key,
Count = g.Count()
};
var list = q3.ToList();
TotalDecisions = new NameCount
{
Name = "Total",
Count = q3.Sum(i => i.Count)
};
return(list);
}
