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); }