public UserDetail GetUserDetails(string UserName) { UserDetail queryUserDetails = new UserDetail(); using (AllSecurityDBEntities AS = new AllSecurityDBEntities()) { queryUserDetails = (from user in AS.UserDetails where user.UserName == UserName select user).FirstOrDefault(); } return queryUserDetails; }
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); }