public static int CountAdsByStatus(AdStatus adStatus)
{
using (StatsDataAdapter db = new StatsDataAdapter())
{
return Convert.ToInt32(db.CountAdsByStatus((int)adStatus, null));
}
}
private static void ProcessSummaryNotification()
{
SiteSettings s = SiteSettings.GetSharedSettings();
DateTime lastNotification = ClassifiedsHttpApplication.LastNotificationSent;
bool sendSummary = false;
if (s.AdminNotification == AdminNotificationSetting.Hourly)
{
// the thread is called once an hour, so send the latest notifications
sendSummary = true;
}
else if (s.AdminNotification == AdminNotificationSetting.Daily)
{
// check when the last notification was sent
DateTime oneDayAgo = DateTime.Now.Subtract(TimeSpan.FromDays(-1));
if (oneDayAgo >= lastNotification)
{
sendSummary = true;
}
}
if (sendSummary)
{
int numPendingNew = 0, numPendingTotal = 0;
using (StatsDataAdapter db = new StatsDataAdapter())
{
numPendingNew = Convert.ToInt32(db.CountAdsByStatus((int)AdStatus.ActivationPending, lastNotification));
numPendingTotal = Convert.ToInt32(db.CountAdsByStatus((int)AdStatus.ActivationPending, null));
}
SendSummaryMail(numPendingNew, numPendingTotal);
ClassifiedsHttpApplication.LastNotificationSent = DateTime.Now;
}
}
public static Stats GetStatistics()
{
Stats stats = new Stats();
using (StatsDataAdapter db = new StatsDataAdapter())
{
stats._adsPending = Convert.ToInt32(db.CountAdsByStatus((int)AdStatus.ActivationPending, null));
stats._adsActive = Convert.ToInt32(db.CountAdsByStatus((int)AdStatus.Activated, null));
stats._adsDeleted = Convert.ToInt32(db.CountAdsByStatus((int)AdStatus.Deleted, null));
stats._adsTotal = Convert.ToInt32(db.CountAdsByStatus(null, null));
stats._responsesActiveAds = Convert.ToInt32(db.CountAdResponsesByStatus((int)AdStatus.Activated));
stats._responsesTotal = Convert.ToInt32(db.CountAdResponsesByStatus(null));
stats._usersNew = (int)db.CountMembersByDateRange(DateTime.Today.AddDays(0 - RecentMembersDays), DateTime.Now);
stats._usersTotal = (int)db.CountMembersByDateRange(null, null);
stats._categoriesTop = (int)db.CountTopCategories();
stats._locations = (int)db.CountLocations();
stats._lastGenerated = DateTime.Now;
}
return stats;
}
