public async Task <ActionResult> AuditUserLogin(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } List <LoginAuditViewModel> modelList = new List <LoginAuditViewModel>(); List <LoginAudits> loginEventList = db.LoginAudits.Where(l => l.UserId == id).ToList(); if (loginEventList != null) { foreach (var l in loginEventList) { LoginAuditViewModel model = new LoginAuditViewModel(); model.AuditEvent = l.AuditEvent; model.AuditId = l.AuditId; model.IpAddress = l.IpAddress; model.Timestamp = l.Timestamp; model.UserId = l.UserId; ApplicationUser user = await UserManager.FindByIdAsync(l.UserId); if (user != null) { model.UserName = user.UserName; } modelList.Add(model); } } ViewBag.LoginCount = loginEventList.Count(); return(View(modelList)); }
// GET: DataAudit public ActionResult Index() { var users = (from user in context.Users select new { UserId = user.Id, Username = user.UserName, Email = user.Email }).ToList().Select(p => new UsersInRoleViewModel() { UserId = p.UserId, Username = p.Username, Email = p.Email }); LoginAuditViewModel loginDataViewModel = new LoginAuditViewModel { UsersInRoleViewModels = users.ToList() }; return(View(loginDataViewModel)); }