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