public ActionResult UserList() { List <AdminUserListModel> users = new List <AdminUserListModel>(); UserRolesHelper helper = new UserRolesHelper(db); foreach (var user in db.Users.ToList()) { var eachUser = new AdminUserListModel(); eachUser.roles = new List <string>(); eachUser.user = user; eachUser.roles = helper.ListUserRoles(user.Id).ToList(); users.Add(eachUser); } ApplicationDbContext context = new ApplicationDbContext(); var role2 = context.Roles.SingleOrDefault(u => u.Name == "Admin"); var admins = context.Users.Where(u => u.Roles.Any(r => (r.RoleId == role2.Id))); var role3 = context.Roles.SingleOrDefault(u => u.Name == "Project Manager"); var projectmanagers = context.Users.Where(u => u.Roles.Any(r => (r.RoleId == role3.Id))); var role4 = context.Roles.SingleOrDefault(u => u.Name == "Developer"); var developers = context.Users.Where(u => u.Roles.Any(r => (r.RoleId == role4.Id))); var role5 = context.Roles.SingleOrDefault(u => u.Name == "Submitter"); var submitters = context.Users.Where(u => u.Roles.Any(r => (r.RoleId == role5.Id))); var number2 = admins.Count(); var number3 = projectmanagers.Count(); var number4 = developers.Count(); var number5 = submitters.Count(); ViewBag.intNumber2 = number2; ViewBag.intNumber3 = number3; ViewBag.intNumber4 = number4; ViewBag.intNumber5 = number5; int[] projectTickets = { 1, 2, 3, 4, 5 }; ViewBag.intArray = projectTickets; return(View(users)); }
public ActionResult ViewAdmin() { AdminUserListModel listOfUsers = new AdminUserListModel(); listOfUsers.Users = userModule.GetAll(); listOfUsers.UserSitesString = new List <string>(); foreach (User user in listOfUsers.Users) { List <Site> sites = siteModule.GetSitesByUser(user); string tempString = string.Empty; foreach (Site site in sites) { tempString = tempString + site.Domain + ", "; } listOfUsers.UserSitesString.Add(tempString); } listOfUsers.Session = Session; return(View(listOfUsers)); }