public static SiteHitCounter AddSiteHitCounter(SiteHitCounter obj) { //Accessing DB Layer DbCommand dbCommand = db.GetStoredProcCommand("prInsSiteHitCounter"); //Adding Input parameters db.AddInParameter(dbCommand, "VisitorBrowser", DbType.String, obj.VisitorBrowser); db.AddInParameter(dbCommand, "IPAddress", DbType.String, obj.IPAddress); db.AddOutParameter(dbCommand, "RespCode", DbType.Int32, 100); db.AddOutParameter(dbCommand, "RespMsg", DbType.String, 500); try { // Execute db.ExecuteNonQuery(dbCommand); //Set Output for AddAdvert obj.RespCode = Convert.ToInt32(db.GetParameterValue(dbCommand, "RespCode")); obj.RespDesc = db.GetParameterValue(dbCommand, "RespMsg").ToString(); } catch (Exception ex) { obj.RespCode = 1; obj.RespDesc = ex.ToString(); } return(obj); }
/// <summary> /// Function to show hit counter /// </summary> private void ShowHitCounter() { ulong HitCount; SiteHitCounter obj = new SiteHitCounter(); string PageName = System.Web.HttpContext.Current.Request.Url.AbsolutePath; if (PageName.IndexOf("/content/") == -1 && !IsPostBack) { obj = SiteHitCounterAction.AddSiteHitCounter(obj); } obj = SiteHitCounterAction.GetSiteHitCount(); // Get the hit counter and make it update every 7 hits HitCount = obj.HitCount; HitCount = HitCount - (HitCount % 7); lblHitCounter.Text = "Site Hit Count since launch: " + HitCount.ToString("###,###,###,###"); }
public static SiteHitCounter GetSiteHitCount() { SiteHitCounter obj = new SiteHitCounter(); obj.HitCount = 0; //Accessing DB Layer DbCommand dbCommand = db.GetStoredProcCommand("prSelSiteHitCount"); try { obj.HitCount = Convert.ToUInt64(db.ExecuteScalar(dbCommand)); } catch (Exception ex) { obj.RespCode = 1; obj.RespDesc = ex.ToString(); } return(obj); }
public static SiteHitCounter AddSiteHitCounter(SiteHitCounter obj) { return(SiteHitCounterLayer.AddSiteHitCounter(obj)); }