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