public void InsertAuditData(AuditTB audittb) { using (var _context = new DatabaseContext()) { _context.AuditTB.Add(audittb); _context.SaveChanges(); } }
public void InsertAuditData(AuditTB audittb) { using (var _context = new DatabaseContext()) { _context.auditConcretes.Add(audittb); _context.SaveChanges(); //error we get here } }
public override void OnActionExecuting(ActionExecutingContext filterContext) { AuditTB objaudit = new AuditTB(); // Getting Action Name string actionName = filterContext.ActionDescriptor.ActionName; //Getting Controller Name string controllerName = filterContext.ActionDescriptor.ControllerDescriptor.ControllerName; var request = filterContext.HttpContext.Request; if (HttpContext.Current.Session["UserID"] != null) { objaudit.UserID = Convert.ToString(HttpContext.Current.Session["UserID"]); } else if (HttpContext.Current.Session["AdminUser"] != null) { objaudit.UserID = Convert.ToString(HttpContext.Current.Session["AdminUser"]); } else { objaudit.UserID = ""; } objaudit.SessionID = HttpContext.Current.Session.SessionID; // Application SessionID // User IPAddress objaudit.IPAddress = request.ServerVariables["HTTP_X_FORWARDED_FOR"] ?? request.UserHostAddress; objaudit.PageAccessed = Convert.ToString(filterContext.HttpContext.Request.Url); // URL User Requested objaudit.LoggedInAt = DateTime.Now; // Time User Logged In || And time User Request Method if (actionName == "LogOff") { objaudit.LoggedOutAt = DateTime.Now; // Time User Logged OUT } objaudit.LoginStatus = "A"; objaudit.ControllerName = controllerName; // ControllerName objaudit.ActionName = actionName; Uri myReferrer = request.UrlReferrer; if (myReferrer != null) { string actual = myReferrer.ToString(); if (actual != null) { objaudit.UrlReferrer = request.UrlReferrer.AbsolutePath; } } _IAudit.InsertAuditData(objaudit); }
internal static void InsertAudit(AuditTB objaudit) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { // string IP = Fetch_UserIP(); var para = new DynamicParameters(); para.Add("@ActionName", objaudit.ActionName); para.Add("@ControllerName", objaudit.ControllerName); para.Add("@IPAddress", objaudit.IPAddress); para.Add("@LoggedInAt", objaudit.LoggedInAt); para.Add("@LoggedOutAt", objaudit.LoggedOutAt); para.Add("@LoginStatus", objaudit.LoginStatus); para.Add("@PageAccessed", objaudit.PageAccessed); para.Add("@SessionID", objaudit.SessionID); para.Add("@UserID", objaudit.UserID); para.Add("@UsersAuditID", objaudit.UsersAuditID); con.Execute("usp_Audit", para, null, 0, CommandType.StoredProcedure); } }
public override void OnActionExecuting(ActionExecutingContext filterContext) { string actionName = filterContext.ActionDescriptor.ActionName; string controllerName = filterContext.ActionDescriptor.ControllerDescriptor.ControllerName; var request = filterContext.HttpContext.Request; AuditTB objaudit = new AuditTB(); if (HttpContext.Current.Session["UserID"] == null) { objaudit.UserID = 0; } else { objaudit.UserID = Convert.ToInt32(HttpContext.Current.Session["UserID"]); } objaudit.UsersAuditID = 0; objaudit.SessionID = HttpContext.Current.Session.SessionID; objaudit.IPAddress = request.ServerVariables["HTTP_X_FORWARDED_FOR"] ?? request.UserHostAddress; objaudit.PageAccessed = request.RawUrl; objaudit.LoggedInAt = DateTime.Now; if (actionName == "LogOff") { objaudit.LoggedOutAt = DateTime.Now; } objaudit.LoginStatus = "A"; objaudit.ControllerName = controllerName; objaudit.ActionName = actionName; AllSecurityDBEntities context = new AllSecurityDBEntities(); context.AuditTBs.Add(objaudit); context.SaveChanges(); //Finishes executing the Action as normal base.OnActionExecuting(filterContext); }