/// <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"), ""));
}