public SiteSummaryInfo GetSiteSummaryInfo() { SiteSummaryInfo siteInfo; siteInfo = new SiteSummaryInfo(); var indulgences = _db.Where(o => o is Indulgence).Select(o => o as Indulgence).ToList(); siteInfo.TotalDonated = indulgences.Sum(a => a.AmountDonated); siteInfo.TotalDonationCount = indulgences.Count(); var allAbsolvedSins = _db.Where(o => o is Sin).Select(o => o as Sin).ToList(); siteInfo.TotalAbsolvedSins = allAbsolvedSins.Count(); return(siteInfo); }
public SiteSummaryInfo GetSiteSummaryInfo() { SiteSummaryInfo siteInfo; siteInfo = new SiteSummaryInfo(); var indulgences = _db.Where(o => o is Indulgence).Select(o=>o as Indulgence).ToList(); siteInfo.TotalDonated = indulgences.Sum(a => a.AmountDonated); siteInfo.TotalDonationCount = indulgences.Count(); var allAbsolvedSins =_db.Where(o=>o is Sin).Select(o=>o as Sin).ToList(); siteInfo.TotalAbsolvedSins = allAbsolvedSins.Count(); return siteInfo; }
public SiteSummaryInfo GetSiteSummaryInfo() { SiteSummaryInfo siteInfo; siteInfo = new SiteSummaryInfo(); siteInfo.TotalDonated = _session.CreateCriteria<Indulgence>().SetProjection(Projections.Sum("AmountDonated")).UniqueResult<decimal>(); siteInfo.TotalDonationCount = _session.CreateCriteria<Indulgence>().Add(Restrictions.Eq("IsBlessed",true)).SetProjection(Projections.Count("AmountDonated")).UniqueResult<int>(); siteInfo.TotalAbsolvedSins = _session.CreateCriteria<Sin>().SetProjection(Projections.Count("Id")).UniqueResult<int>(); return siteInfo; }