/// <summary> /// Gets number of visitors for the last week based on statistics with given staticstics type. /// </summary> /// <param name="siteId">ID of the site</param> /// <param name="statisticsCode">Statistics code</param> /// <exception cref="ArgumentException"><paramref name="statisticsCode"/> is null or empty.</exception> /// <returns>Visitors count</returns> private int GetVisitCount(int siteId, string statisticsCode) { if (string.IsNullOrEmpty(statisticsCode)) { throw new ArgumentException("statisticsCode"); } var statistics = StatisticsInfoProvider.GetStatistics() .OnSite(siteId) .Column("StatisticsID") .WhereEquals("StatisticsCode", statisticsCode); var hits = HitsDayInfoProvider.GetHitsDays() .WhereIn("HitsStatisticsID", statistics) .WhereGreaterThan("HitsStartTime", DateTime.Now.AddDays(-7).Date) .Column(new AggregatedColumn(AggregationType.Sum, "HitsCount")); int count = 0; if (!DataHelper.DataSourceIsEmpty(hits)) { count = ValidationHelper.GetInteger(hits.Tables[0].Rows[0][0], 0); } return(count); }
/// <summary> /// Fills drop drop down field for deleted objects /// </summary> private void FillObjectsToDelete() { drpDeleteObjects.Items.Clear(); SortedList list = new SortedList(); // Get available statistics for current site DataSet ds = StatisticsInfoProvider.GetStatistics("StatisticsSiteID = " + CMSContext.CurrentSiteID + " AND StatisticsCode NOT LIKE '%;%'", null, 0, "DISTINCT StatisticsCode"); // Check whether exists at least one statistic if (!DataHelper.DataSourceIsEmpty(ds)) { // Loop thru all statistics foreach (DataRow dr in ds.Tables[0].Rows) { // Statistic codename string codeName = ValidationHelper.GetString(dr["StatisticsCode"], String.Empty); // Statistic dispaly name string displayName = GetString("analytics_codename." + codeName); // If resource string is not available use codename if (displayName.EqualsCSafe("analytics_codename." + codeName, true)) { displayName = codeName; } if (!list.Contains(displayName)) { // Add to the list collection list.Add(displayName, new ListItem(displayName, codeName)); } else { // If display name already in collection - add special display name list.Add(displayName + codeName, new ListItem(displayName + " (" + codeName + ")", codeName)); } } // Add A/B and M/V testing list.Add(GetString("analytics_codename.abtest"), new ListItem(GetString("analytics_codename.abtest"), "abtest")); list.Add(GetString("analytics_codename.mvtest"), new ListItem(GetString("analytics_codename.mvtest"), "mvtest")); // Add values from sorted list foreach (ListItem li in list.Values) { drpDeleteObjects.Items.Add(li); } } // Add default (all) value drpDeleteObjects.Items.Insert(0, new ListItem(GetString("general.selectall"), "")); }
/// <summary> /// Fills drop drop down field for deleted objects /// </summary> private void FillObjectsToDelete() { drpDeleteObjects.Items.Clear(); SortedList list = new SortedList(); var statistics = StatisticsInfoProvider.GetStatistics() .Column("StatisticsCode") .Distinct() .WhereEquals("StatisticsSiteID", SiteContext.CurrentSiteID) .WhereNotContains("StatisticsCode", ";"); foreach (var statisticsInfo in statistics) { // Statistic codename string codeName = statisticsInfo.StatisticsCode; // Statistic dispaly name string displayName = GetString("analytics_codename." + codeName); // If resource string is not available use codename if (displayName.EqualsCSafe("analytics_codename." + codeName, true)) { displayName = codeName; } if (!list.Contains(displayName)) { // Add to the list collection list.Add(displayName, new ListItem(displayName, codeName)); } else { // If display name already in collection - add special display name list.Add(displayName + codeName, new ListItem(displayName + " (" + codeName + ")", codeName)); } } // Add A/B and M/V testing list.Add(GetString("analytics_codename.abtest"), new ListItem(GetString("analytics_codename.abtest"), "abtest")); list.Add(GetString("analytics_codename.mvtest"), new ListItem(GetString("analytics_codename.mvtest"), "mvtest")); // Add values from sorted list foreach (ListItem li in list.Values) { drpDeleteObjects.Items.Add(li); } // Add default (all) value drpDeleteObjects.Items.Insert(0, new ListItem(GetString("general.selectall"), "")); }