public JsonResult Report_Value_PageViews(string _From, string _To)
{
string sBaseULR = HttpContext.Request.Url.Scheme + "://" + HttpContext.Request.Url.Authority + "/";
string sCurrentURL = HttpContext.Request.UrlReferrer.OriginalString.ToString();
var oResponse = Json(new { RESPONSE = "ERROR" });
try
{
if (oSystem.OpenDataConnection())
{
if (oSystem.GetCurrentUser())
{
if (oSystem.CheckScreenAccessRights(iAccessRolesAllowed))
{
AriesCMS.Helpers.SitAnalytics oAnalytics = new Helpers.SitAnalytics();
DateTime dtFrom = DateTime.Now.AddDays(-1);
DateTime dtTo = DateTime.Now;
try
{
dtFrom = DateTime.Parse(_From);
}
catch
{
}
try
{
dtTo = DateTime.Parse(_To);
}
catch
{
}
List <AriesCMS.Helpers.SitAnalytics.SiteAnalytics> dbData = oAnalytics.Get_Views_ByDate(dtFrom, dtTo, oSystem.cnCon);
string _ValueYesterday = "0";
string _ValueToday = "0";
if (dbData != null)
{
if (dbData.Count > 0)
{
try
{
_ValueYesterday = dbData[0].Value;
}
catch
{
_ValueYesterday = "0";
}
try
{
_ValueToday = dbData[1].Value;
}
catch
{
_ValueToday = "0";
}
}
}
#region Set default empty values to prevent javascript chart issues if the values are empty
if (String.IsNullOrEmpty(_ValueYesterday))
{
_ValueYesterday = "0";
}
if (String.IsNullOrEmpty(_ValueToday))
{
_ValueToday = "0";
}
#endregion
oResponse = Json(new { RESPONSE = "SUCCESS", PVYesterday = _ValueYesterday, PVToday = _ValueToday });
}
}
}
}
catch (Exception s)
{
}
oSystem.CloseDataConnection();//Forms
return(oResponse);
}
public JsonResult Report_ChartData_SiteVisits(string _From, string _To)
{
string sBaseULR = HttpContext.Request.Url.Scheme + "://" + HttpContext.Request.Url.Authority + "/";
string sCurrentURL = HttpContext.Request.UrlReferrer.OriginalString.ToString();
var oResponse = Json(new { RESPONSE = "ERROR" });
try
{
if (oSystem.OpenDataConnection())
{
if (oSystem.GetCurrentUser())
{
if (oSystem.CheckScreenAccessRights(iAccessRolesAllowed))
{
AriesCMS.Helpers.SitAnalytics oAnalytics = new Helpers.SitAnalytics();
DateTime dtFrom = DateTime.Now.AddDays(-1);
DateTime dtTo = DateTime.Now;
try
{
dtFrom = DateTime.Parse(_From);
}
catch
{
}
try
{
dtTo = DateTime.Parse(_To);
}
catch
{
}
List <AriesCMS.Helpers.SitAnalytics.SiteAnalytics> dbData = oAnalytics.Get_PageVisits_ByDate(dtFrom, dtTo, oSystem.cnCon);
//string sLabels = "January, February, March, April, May, June, July, August, September, October, November, December";
//string sLabelValues = "1,2,3,4,5,6,7,8,9,10,11,12";
string sLabels = "";
string sLabelValues = "";
if (dbData != null)
{
if (dbData.Count > 0)
{
for (int i = 0; i < dbData.Count; i++)
{
if (i > 0)
{
sLabels += "," + dbData[i].Label;
//sLabels += "," + dbData[i].Value2.Replace("View of ", "");
sLabelValues += "," + dbData[i].Value;
}
else
{
sLabels += "," + dbData[i].Label;
//sLabels = dbData[i].Value2.Replace("View of ", "");
sLabelValues = dbData[i].Value;
}
}
}
}
#region Set default empty values to prevent javascript chart issues if the values are empty
if (String.IsNullOrEmpty(sLabels))
{
sLabels = "none";
}
if (String.IsNullOrEmpty(sLabelValues))
{
sLabelValues = "0";
}
#endregion
oResponse = Json(new { RESPONSE = "SUCCESS", CDataLabels = sLabels, CDataValues = sLabelValues });
}
}
}
}
catch (Exception s)
{
}
oSystem.CloseDataConnection();
return(oResponse);
}
