Run Stored Proc in Global.asax End_Session or End_Application[Answered] RSS

• • Reply
  masterdineen

  Member

  35 Points

  375 Posts

  Run Stored Proc in Global.asax End_Session or End_Application

  Aug 14, 2019 07:38 PM|masterdineen|LINK

  Hello there.

  I am trying to run a sql stored proc within the Global.asax

  I have included the same stored proc c# in both End_Session & End_Application

  see below

  using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Web;
  using System.Web.Optimization;
  using System.Web.Routing;
  using System.Web.Security;
  using System.Web.SessionState;
  using System.Data.SqlClient;
  using System.Web.Services;
  
  namespace TestDropdowns
  {
      public class Global : HttpApplication
      {
  
  
          void Application_Start(object sender, EventArgs e)
          {
              // Code that runs on application startup
              RouteConfig.RegisterRoutes(RouteTable.Routes);
              BundleConfig.RegisterBundles(BundleTable.Bundles);
          }
  
          void End_Session(object sender, EventArgs e)
          {
  
              SqlConnection DBconnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DBstring_From_WebConFig"].ToString());
  
  
              String LogDesc = "Application has been terminated";
  
              SqlCommand InsertLog = new SqlCommand("[dbo].NewLog]", DBconnection);
  
              DBconnection.Open();
  
              InsertLog.CommandType = System.Data.CommandType.StoredProcedure;
  
              //InsertLog.Parameters.Add("@UserID", System.Data.SqlDbType.Int);
              //InsertLog.Parameters["@UserID"].Value = Index.UserID;
  
              InsertLog.Parameters.Add("1", System.Data.SqlDbType.Int);
              InsertLog.Parameters["@UserID"].Value = Index.UserID;
  
              InsertLog.Parameters.Add("@MachineName", System.Data.SqlDbType.NVarChar);
              InsertLog.Parameters["@MachineName"].Value = System.Environment.MachineName.ToString();
  
              InsertLog.Parameters.Add("@Webpage", System.Data.SqlDbType.NVarChar);
              InsertLog.Parameters["@Webpage"].Value = HttpContext.Current.Request.Url.AbsoluteUri.ToString();
  
              InsertLog.Parameters.Add("@Description", System.Data.SqlDbType.NVarChar);
              InsertLog.Parameters["@Description"].Value = LogDesc.ToString();
  
              InsertLog.ExecuteReader();
  
              DBconnection.Close();
  
          }
  
          void Application_End(object sender, EventArgs e)
  
          {
  
              SqlConnection DBconnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DBstring_From_WebConFig"].ToString());
  
  
              String LogDesc = "Application has been terminated";
  
              SqlCommand InsertLog = new SqlCommand("[dbo].NewLog]", DBconnection);
  
              DBconnection.Open();
  
              InsertLog.CommandType = System.Data.CommandType.StoredProcedure;
  
              //InsertLog.Parameters.Add("@UserID", System.Data.SqlDbType.Int);
              //InsertLog.Parameters["@UserID"].Value = Index.UserID;
  
              InsertLog.Parameters.Add("1", System.Data.SqlDbType.Int);
              InsertLog.Parameters["@UserID"].Value = Index.UserID;
  
              InsertLog.Parameters.Add("@MachineName", System.Data.SqlDbType.NVarChar);
              InsertLog.Parameters["@MachineName"].Value = System.Environment.MachineName.ToString();
  
              InsertLog.Parameters.Add("@Webpage", System.Data.SqlDbType.NVarChar);
              InsertLog.Parameters["@Webpage"].Value = HttpContext.Current.Request.Url.AbsoluteUri.ToString();
  
              InsertLog.Parameters.Add("@Description", System.Data.SqlDbType.NVarChar);
              InsertLog.Parameters["@Description"].Value = LogDesc.ToString();
  
              InsertLog.ExecuteReader();
  
              DBconnection.Close();
  
          }
  
  
  
      }
  }

  but when I look look at my logging table, I can see nothing has ran.

  could someone point me in the right direction please

  Regards

  Rob

• • Reply
  mgebhard

  All-Star

  53641 Points

  23994 Posts

  Re: Run Stored Proc in Global.asax End_Session or End_Application

  Aug 14, 2019 07:56 PM|mgebhard|LINK

  Looks like custom code.  I recommend testing your code to make sure it works.  Also what is Index.UserID and  InsertLog.ExecuteReader()?  Have you verified they work as expected?

  Keep in mind, if you want community debugging support you must post all the relevant code, including the actual procedure.

• • Reply
  masterdineen

  Member

  35 Points

  375 Posts

  Re: Run Stored Proc in Global.asax End_Session or End_Application

  Aug 14, 2019 09:30 PM|masterdineen|LINK

  I have just run the following which is the same inside my Global.asax under a button. and it works fine inserting a row into a sql table.

  SqlConnection DBconnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Risk_AssessmentConnectionString"].ToString());
  
  
              String LogDesc = "Application has been terminated";
  
              SqlCommand InsertLog = new SqlCommand("[dbo].[NewLog]", DBconnection);
  
              DBconnection.Open();
  
              InsertLog.CommandType = System.Data.CommandType.StoredProcedure;
  
              InsertLog.Parameters.Add("@UserID", System.Data.SqlDbType.Int);
              InsertLog.Parameters["@UserID"].Value = Index.UserID;
  
              InsertLog.Parameters.Add("@MachineName", System.Data.SqlDbType.NVarChar);
              InsertLog.Parameters["@MachineName"].Value = System.Environment.MachineName.ToString();
  
              InsertLog.Parameters.Add("@Webpage", System.Data.SqlDbType.NVarChar);
              InsertLog.Parameters["@Webpage"].Value = HttpContext.Current.Request.Url.AbsoluteUri.ToString();
  
              InsertLog.Parameters.Add("@Description", System.Data.SqlDbType.NVarChar);
              InsertLog.Parameters["@Description"].Value = LogDesc.ToString();
  
              InsertLog.ExecuteReader();
  
              DBconnection.Close();

  There must be some else I'm missing,  also can this be done via the Global file.??

• • Reply
  mgebhard

  All-Star

  53641 Points

  23994 Posts

  Re: Run Stored Proc in Global.asax End_Session or End_Application

  Aug 14, 2019 11:15 PM|mgebhard|LINK

  Oh I missed this.. HttpContext. anything is not going to work because there is not HttpContext.  AN HttpContext is created during a request.  Session_End is not related to a request.  Session_End fires when a user's Session times out.

  I assume the code throws an exception and why the record is not added.

• • Reply
  masterdineen

  Member

  35 Points

  375 Posts

  Re: Run Stored Proc in Global.asax End_Session or End_Application

  Aug 15, 2019 05:40 AM|masterdineen|LINK

  Thank you very much i shall try this later.
  
  Regards
  
  Rob