/// <summary> /// Generate the all page report summary to create a line chart /// </summary> /// <param name="pageReportType"></param> /// <param name="dateFrom"></param> /// <param name="dateTo"></param> /// <returns></returns> public static PageReportSummary GeneratePageReport(PageReportType pageReportType, DateTime dateFrom, DateTime dateTo, string selectedPage = "") { dateFrom = new DateTime(dateFrom.Year, dateFrom.Month, dateFrom.Day, 0, 0, 1); dateTo = new DateTime(dateTo.Year, dateTo.Month, dateTo.Day, 23, 59, 59); PageReportSummary PageReportSummary = new PageReportSummary(); //add 3 lists to represent the all categories if (string.IsNullOrWhiteSpace(selectedPage) || "all".Equals(selectedPage)) { PageReportSummary.PageReportSeriesList.Add(new PageReportSeries { name = "Page Views", data = new List <int>() }); PageReportSummary.PageReportSeriesList.Add(new PageReportSeries { name = "Website Visits", data = new List <int>() }); PageReportSummary.PageReportSeriesList.Add(new PageReportSeries { name = "Unique Website Visits", data = new List <int>() }); } else { PageReportSummary.PageReportSeriesList.Add(new PageReportSeries { name = "Page Views", data = new List <int>() }); } List <PageView> PageViewList = ReportDAO.LoadPageViews(dateFrom, dateTo, selectedPage); if (PageViewList != null && PageViewList.Count > 0) { while (dateFrom <= dateTo) { string DateTimeFormat = GetDateTimeCategoryToString(pageReportType); string Category = dateFrom.ToString(DateTimeFormat); PageReportSummary.MasterCategoryList.Add(Category); if (string.IsNullOrWhiteSpace(selectedPage) || "all".Equals(selectedPage)) { ProcessAllPageReportRow(PageReportSummary, PageViewList, DateTimeFormat, Category); } else { ProcessSpecificPageReportRow(PageReportSummary, PageViewList, DateTimeFormat, Category); } dateFrom = IncreaseDateTime(pageReportType, dateFrom); } ProcessBasicStatistics(PageReportSummary, PageViewList); ProcessBrowserSummary(PageReportSummary, PageViewList); ProcessOperatingSystemSummary(PageReportSummary, PageViewList); } return(PageReportSummary); }
public PageReportCache(string cacheKey, DateTime lastAccessedUtc, PageReportSummary pageReport, string selectedPageType, PageReportType pageReportType, DateTime dateFrom, DateTime dateTo) { CacheKey = cacheKey; LastAccessedUtc = lastAccessedUtc; ReportSummary = pageReport; SelectedPageType = selectedPageType; PageReportType = pageReportType; DateFrom = dateFrom; DateTo = dateTo; }
public PageReportCache(string cacheKey, DateTime lastAccessedUtc, PageReportSummary pageReport, string selectedPageType, PageReportType pageReportType, DateTime dateFrom, DateTime dateTo) { CacheKey = cacheKey; LastAccessedUtc = lastAccessedUtc; ReportSummary = pageReport; SelectedPageType = selectedPageType; PageReportType = pageReportType; DateFrom = dateFrom; DateTo = dateTo; }
/// <summary> /// Get the to string used for date time to string /// </summary> /// <param name="pageReportType"></param> /// <returns></returns> private static string GetDateTimeCategoryToString(PageReportType pageReportType) { switch (pageReportType) { case PageReportType.HOURLY: return "h tt"; case PageReportType.DAY: return "MMM dd"; case PageReportType.MONTH: return "MMM yyyy"; } return ""; }
/// <summary> /// Generate the all page report summary to create a line chart /// </summary> /// <param name="pageReportType"></param> /// <param name="dateFrom"></param> /// <param name="dateTo"></param> /// <returns></returns> public static PageReportSummary GeneratePageReport(PageReportType pageReportType, DateTime dateFrom, DateTime dateTo, string selectedPage = "") { dateFrom = new DateTime(dateFrom.Year, dateFrom.Month, dateFrom.Day, 0, 0, 1); dateTo = new DateTime(dateTo.Year, dateTo.Month, dateTo.Day, 23, 59, 59); PageReportSummary PageReportSummary = new PageReportSummary(); //add 3 lists to represent the all categories if (string.IsNullOrWhiteSpace(selectedPage) || "all".Equals(selectedPage)) { PageReportSummary.PageReportSeriesList.Add(new PageReportSeries { name = "Page Views", data = new List<int>() }); PageReportSummary.PageReportSeriesList.Add(new PageReportSeries { name = "Website Visits", data = new List<int>() }); PageReportSummary.PageReportSeriesList.Add(new PageReportSeries { name = "Unique Website Visits", data = new List<int>() }); } else { PageReportSummary.PageReportSeriesList.Add(new PageReportSeries { name = "Page Views", data = new List<int>() }); } List<PageView> PageViewList = ReportDAO.LoadPageViews(dateFrom, dateTo, selectedPage); if (PageViewList != null && PageViewList.Count > 0) { while (dateFrom <= dateTo) { string DateTimeFormat = GetDateTimeCategoryToString(pageReportType); string Category = dateFrom.ToString(DateTimeFormat); PageReportSummary.MasterCategoryList.Add(Category); if (string.IsNullOrWhiteSpace(selectedPage) || "all".Equals(selectedPage)) { ProcessAllPageReportRow(PageReportSummary, PageViewList, DateTimeFormat, Category); } else { ProcessSpecificPageReportRow(PageReportSummary, PageViewList, DateTimeFormat, Category); } dateFrom = IncreaseDateTime(pageReportType, dateFrom); } ProcessBasicStatistics(PageReportSummary, PageViewList); ProcessBrowserSummary(PageReportSummary, PageViewList); ProcessOperatingSystemSummary(PageReportSummary, PageViewList); } return PageReportSummary; }
/// <summary> /// Get the to string used for date time to string /// </summary> /// <param name="pageReportType"></param> /// <returns></returns> private static string GetDateTimeCategoryToString(PageReportType pageReportType) { switch (pageReportType) { case PageReportType.HOURLY: return("h tt"); case PageReportType.DAY: return("MMM dd"); case PageReportType.MONTH: return("MMM yyyy"); } return(""); }
/// <summary> /// Increase the date from according to the page report type /// </summary> /// <param name="pageReportType"></param> /// <param name="dateFrom"></param> /// <returns></returns> private static DateTime IncreaseDateTime(PageReportType pageReportType, DateTime dateFrom) { switch (pageReportType) { case PageReportType.HOURLY: return(dateFrom.AddHours(1)); case PageReportType.DAY: return(dateFrom.AddDays(1)); case PageReportType.MONTH: return(dateFrom.AddMonths(1)); } return(dateFrom); }
public ActionResult Index(string selectedPageType, PageReportType? pageReportType, DateTime? dateFrom, DateTime? dateTo) { try { if (selectedPageType == null) { selectedPageType = string.Empty; } if (pageReportType == null) { pageReportType = PageReportType.DAY; } if (dateFrom == null) { dateFrom = DateTime.UtcNow.AddDays(-7); } if (dateTo == null) { dateTo = DateTime.UtcNow; } if (ChimeraWebsite.Helpers.AppSettings.AllowPageReportRecording) { ViewBag.PageReportSummary = ChimeraWebsite.Helpers.AppCache.GetPageReportSummary(selectedPageType, pageReportType.Value, dateFrom.Value, dateTo.Value); ViewBag.UniquePageTypes = Chimera.DataAccess.ReportDAO.LoadUniquePageTypes(); } ViewBag.NotificationList = DashboardNotificationDAO.LoadDashboardList(SiteContext.User.RoleList); } catch (Exception e) { CompanyCommons.Logging.WriteLog("ChimeraWebsite.Areas.Admin.Controllers.Dashboard() ", e); } ViewBag.selectedPageType = selectedPageType; ViewBag.pageReportType = pageReportType.Value; ViewBag.dateFrom = dateFrom.Value; ViewBag.dateTo = dateTo.Value; return View(); }
/// <summary> /// Check the app cache and see if this report cache has expired. /// </summary> /// <param name="selectedPageType"></param> /// <param name="pageReportType"></param> /// <param name="dateFrom"></param> /// <param name="dateTo"></param> /// <returns></returns> public static PageReportCache GetPageReportSummary(string selectedPageType, PageReportType pageReportType, DateTime dateFrom, DateTime dateTo) { string CacheKey = String.Format("{0}|{1}|{2}|{3}", selectedPageType.ToUpper(), pageReportType, dateFrom.ToString("MM/dd/yyyy"), dateTo.ToString("MM/dd/yyyy")); PageReportSummary ReportSummary = new PageReportSummary(); Dictionary <string, PageReportCache> PageReportDictionary = (Dictionary <string, PageReportCache>)HttpContext.Current.Application[PAGE_REPORT_APP_CACHE] ?? new Dictionary <string, PageReportCache>(); bool RunNewReport = false; if (PageReportDictionary.ContainsKey(CacheKey)) { if (PageReportDictionary[CacheKey].LastAccessedUtc <= DateTime.UtcNow) { RunNewReport = true; } else { ReportSummary = PageReportDictionary[CacheKey].ReportSummary; } } else { RunNewReport = true; } if (RunNewReport) { ReportSummary = PageReport.GeneratePageReport(pageReportType, dateFrom, dateTo, selectedPageType); PageReportDictionary[CacheKey] = new PageReportCache(CacheKey, DateTime.UtcNow.AddHours(1), ReportSummary, selectedPageType, pageReportType, dateFrom, dateTo); HttpContext.Current.Application[PAGE_REPORT_APP_CACHE] = PageReportDictionary; } return(PageReportDictionary[CacheKey]); }
/// <summary> /// Check the app cache and see if this report cache has expired. /// </summary> /// <param name="selectedPageType"></param> /// <param name="pageReportType"></param> /// <param name="dateFrom"></param> /// <param name="dateTo"></param> /// <returns></returns> public static PageReportCache GetPageReportSummary(string selectedPageType, PageReportType pageReportType, DateTime dateFrom, DateTime dateTo) { string CacheKey = String.Format("{0}|{1}|{2}|{3}", selectedPageType.ToUpper(), pageReportType, dateFrom.ToString("MM/dd/yyyy"), dateTo.ToString("MM/dd/yyyy")); PageReportSummary ReportSummary = new PageReportSummary(); Dictionary<string, PageReportCache> PageReportDictionary = (Dictionary<string, PageReportCache>)HttpContext.Current.Application[PAGE_REPORT_APP_CACHE] ?? new Dictionary<string, PageReportCache>(); bool RunNewReport = false; if (PageReportDictionary.ContainsKey(CacheKey)) { if (PageReportDictionary[CacheKey].LastAccessedUtc <= DateTime.UtcNow) { RunNewReport = true; } else { ReportSummary = PageReportDictionary[CacheKey].ReportSummary; } } else { RunNewReport = true; } if (RunNewReport) { ReportSummary = PageReport.GeneratePageReport(pageReportType, dateFrom, dateTo, selectedPageType); PageReportDictionary[CacheKey] = new PageReportCache(CacheKey, DateTime.UtcNow.AddHours(1), ReportSummary, selectedPageType, pageReportType, dateFrom, dateTo); HttpContext.Current.Application[PAGE_REPORT_APP_CACHE] = PageReportDictionary; } return PageReportDictionary[CacheKey]; }
/// <summary> /// Increase the date from according to the page report type /// </summary> /// <param name="pageReportType"></param> /// <param name="dateFrom"></param> /// <returns></returns> private static DateTime IncreaseDateTime(PageReportType pageReportType, DateTime dateFrom) { switch (pageReportType) { case PageReportType.HOURLY: return dateFrom.AddHours(1); case PageReportType.DAY: return dateFrom.AddDays(1); case PageReportType.MONTH: return dateFrom.AddMonths(1); } return dateFrom; }