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