public ActionResult Users(string sortOrder, string searchString) { ViewBag.Message = "View/Edit all Users."; ViewBag.UserFNameSortParam = String.IsNullOrEmpty(sortOrder) ? "fname_desc" : ""; ViewBag.UserLNameSortParam = sortOrder == "LName" ? "lname_desc" : "LName"; ViewBag.UserMailSortParam = sortOrder == "Mail" ? "mail_desc" : "Mail"; List <SelectListItem> items = new List <SelectListItem>(); items.Add(new SelectListItem { Text = "Active", Value = "0" }); items.Add(new SelectListItem { Text = "Inactive", Value = "1" }); ViewBag.ActiveList = items; UsersDataHandler dataSource = new UsersDataHandler(); ICollection <User> data = dataSource.GetAllUsers(); if (!string.IsNullOrEmpty(searchString)) { data = data.Where(s => s.firstName.Contains(searchString) || s.lastName.Contains(searchString)).ToList(); } switch (sortOrder) { case "fname_desc": data = data.OrderByDescending(s => s.firstName).ToList(); break; case "LName": data = data.OrderBy(s => s.lastName).ToList(); break; case "lname_desc": data = data.OrderByDescending(s => s.lastName).ToList(); break; case "Mail": data = data.OrderBy(s => s.emailID).ToList(); break; case "mail_desc": data = data.OrderByDescending(s => s.emailID).ToList(); break; default: data = data.OrderBy(s => s.firstName).ToList(); break; } ModelState.Clear(); return(View(data)); }
public ActionResult Users(string sortOrder, string searchString, User user, string ActiveList) { ViewBag.Message = "View/Edit all Users."; ViewBag.UserFNameSortParam = String.IsNullOrEmpty(sortOrder) ? "fname_desc" : ""; ViewBag.UserLNameSortParam = sortOrder == "LName" ? "lname_desc" : "LName"; ViewBag.UserMailSortParam = sortOrder == "Mail" ? "mail_desc" : "Mail"; List <SelectListItem> items = new List <SelectListItem>(); items.Add(new SelectListItem { Text = "Active", Value = "0" }); items.Add(new SelectListItem { Text = "Inactive", Value = "1" }); ViewBag.ActiveList = items; ErrorModel context = new ErrorModel(); User thisUser = context.Users.FirstOrDefault(x => x.emailID == user.emailID); try { using (ApplicationDbContext db = new ApplicationDbContext()) { var usertoSave = db.Users.ToList().FirstOrDefault(m => m.Email == thisUser.emailID); if (ActiveList == "1") { usertoSave.LockoutEndDateUtc = DateTime.MaxValue; thisUser.activeStatus = "inactive"; thisUser.userType = thisUser.userType; } else { usertoSave.LockoutEndDateUtc = null; thisUser.activeStatus = "active"; thisUser.userType = thisUser.userType; } db.SaveChanges(); } context.SaveChanges(); } catch (Exception ex) { string s = ex.InnerException.Message; } UsersDataHandler dataSource = new UsersDataHandler(); ICollection <User> data = dataSource.GetAllUsers(); if (!String.IsNullOrEmpty(searchString)) { data = data.Where(s => s.firstName.Contains(searchString) || s.lastName.Contains(searchString)).ToList(); } switch (sortOrder) { case "fname_desc": data = data.OrderByDescending(s => s.firstName).ToList(); break; case "LName": data = data.OrderBy(s => s.lastName).ToList(); break; case "lname_desc": data = data.OrderByDescending(s => s.lastName).ToList(); break; case "Mail": data = data.OrderBy(s => s.emailID).ToList(); break; case "mail_desc": data = data.OrderByDescending(s => s.emailID).ToList(); break; default: data = data.OrderBy(s => s.firstName).ToList(); break; } ModelState.Clear(); return(View(data)); }