public JsonResult SaveSiteAnalytics()
{
string json = string.Empty;
SiteAnalytics query = new SiteAnalytics();
DateTime date;
int number = 0;
float number1 = 0;
try
{
if (!string.IsNullOrEmpty(Request.Params["sa_pageviews"]))
{
if (int.TryParse(Request.Params["sa_pageviews"], out number))
{
query.sa_pageviews = number;
}
}
if (!string.IsNullOrEmpty(Request.Params["sa_pages_session"]))
{
if (float.TryParse(Request.Params["sa_pages_session"], out number1))
{
query.sa_pages_session = number1;
}
}
if (!string.IsNullOrEmpty(Request.Params["sa_bounce_rate"]))
{
if (float.TryParse(Request.Params["sa_bounce_rate"], out number1))
{
query.sa_bounce_rate = number1;
}
}
if (!string.IsNullOrEmpty(Request.Params["sa_avg_session_duration"]))
{
if (float.TryParse(Request.Params["sa_avg_session_duration"], out number1))
{
query.sa_avg_session_duration = number1;
}
}
if (!string.IsNullOrEmpty(Request.Params["sa_id"]))
{
query.sa_id = Convert.ToInt32(Request.Params["sa_id"]);
}
if (DateTime.TryParse(Request.Params["sa_date"], out date))
{
query.s_sa_date = date.ToString("yyyy-MM-dd");
}
if (!string.IsNullOrEmpty(Request.Params["sa_session"]))
{
if (int.TryParse(Request.Params["sa_session"], out number))
{
query.sa_session = number;
}
}
if (!string.IsNullOrEmpty(Request.Params["sa_user"]))
{
if (int.TryParse(Request.Params["sa_user"], out number))
{
query.sa_user = number;
}
}
query.sa_create_user = (Session["caller"] as Caller).user_id;
query.sa_create_time=DateTime.Now;
_siteAnalytics = new SiteAnalyticsMgr(mySqlConnectionString);
query.sa_modify_user = query.sa_create_user;
query.sa_modify_time=query.sa_create_time;
if (query.sa_id == 0)
{
if (_siteAnalytics.InsertSiteAnalytics(query) > 0)
{
return Json(new { success = "true" });
}
else
{
return Json(new { success = "false" });
}
}
else
{
if (_siteAnalytics.UpdateSiteAnalytics(query) > 0)
{
return Json(new { success = "true" });
}
else
{
return Json(new { success = "false" });
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
return Json(new { success = "false" });
}
}
