Is there any way to implement Audit Trails for user actions in .Net MVC

\nI need to capture the user visited page and action performed on that page\n\nYou can implement an HttpModule which logs all the visited pages within your .NET MVC application.\nWith an HttpModule you have access to all the Request/Response properties, including Headers, Cookies, FormData parameters.\nnamespace MyApplication\n{\n public class DatabaseAuditHttpModule : IHttpModule\n {\n private class Properties\n {\n public string Url { get; set; }\n public string HttpMethod { get; set; }\n public int StatusCode { get; set; }\n \n // add other important HTTP properties\n }\n \n public void Init(HttpApplication context)\n {\n context.BeginRequest += BeginRequest;\n context.EndRequest += EndRequest;\n }\n\n private void BeginRequest(object sender, EventArgs e)\n {\n HttpContext ctx = HttpContext.Current;\n var request = ctx.Request;\n\n var requestHeaders = request.Unvalidated.Headers;\n var requestFormData = request.Unvalidated.Form;\n\n var properties = new Properties\n {\n Url = request.Url.ToString(),\n HttpMethod = request.HttpMethod\n };\n\n ctx.Items["X-Properties"] = properties;\n }\n\n\n private void EndRequest(object sender, EventArgs e)\n {\n HttpContext ctx = HttpContext.Current;\n\n // get the properties for the current HTTP request\n Properties properties = (Properties)HttpContext.Current.Items["X-Properties"];\n\n properties.StatusCode = ctx.Response.StatusCode;\n \n // TODO:\n // log these values in the database\n }\n\n public void Dispose()\n {\n\n }\n }\n}\n\nRegistering the HttpModule in Global.asax:\nnamespace MyApp.Mvc\n{\n public class MvcApplication : System.Web.HttpApplication\n {\n protected void Application_Start()\n {\n \n }\n \n // register DatabaseAuditHttpModule\n public static DatabaseAuditHttpModule AuditHttpModule = new DatabaseAuditHttpModule();\n \n public override void Init()\n {\n base.Init();\n \n AuditHttpModule.Init(this);\n }\n }\n}\n\nLogging stored procedures execution example:\npublic class DatabaseService\n{\n public static async Task ExecuteStoredProcedureAsync(string connectionString, string storedProcedureName, ILogger logger)\n {\n logger.LogTrace($"'{storedProcedureName}' Stored Procedure executing");\n long totalDuration = 0;\n\n Stopwatch sw = new Stopwatch();\n sw.Start();\n\n using(var connection = new SqlConnection(connectionString))\n {\n connection.Open();\n \n sw.Stop();\n totalDuration += sw.ElapsedMilliseconds;\n\n logger.LogTrace($"connection.Open() Duration:{sw.ElapsedMilliseconds}");\n\n sw.Restart();\n \n using (var command = SqlCommand(storedProcedureName, connection))\n {\n command.CommandType = CommandType.StoredProcedure;\n\n using (var reader = await command.ExecuteReaderAsync())\n {\n sw.Stop();\n totalDuration += sw.ElapsedMilliseconds;\n\n logger.LogTrace($"'{storedProcedureName}' Stored Procedure ExecuteReader Duration:{sw.ElapsedMilliseconds}");\n\n sw.Restart();\n\n do\n {\n while (await reader.ReadAsync())\n {\n // read the data\n }\n\n } while (await reader.NextResultAsync());\n }\n\n sw.Stop();\n totalDuration += sw.ElapsedMilliseconds;\n\n logger.LogTrace($"'{storedProcedureName}' Stored Procedure executed. Duration:{totalDuration}");\n\n return result;\n }\n }\n }\n}\n",