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