public ActionResult Teams(int courseId) { DatabaseRepository db = new DatabaseRepository(); List<Project> projects = db.GetProjects(courseId); List<User> users = db.GetUsersWithoutTeams(courseId); List<User> members = db.GetUsersWithTeams(courseId); var viewModel = new TeamsProjectsAndUsers() { projects = projects, users = users, members = members }; return View(viewModel); }
public ActionResult Create(TeamsProjectsAndUsers course) { DatabaseRepository db = new DatabaseRepository(); int[] allProjectIds = course.teams.Where(t => t.projectId != 0).Select(t => t.projectId).ToArray(); int[] populatedProjectIds = course.teams.Where(t => t.userIds != null && t.projectId != 0).Select(t => t.projectId).ToArray(); if (allProjectIds.Any()) { db.DeleteAllMembers(allProjectIds); if (!string.IsNullOrEmpty(course.projectManager)) { string projectManagerId = course.projectManager.Split(',').First(); db.InsertProjectManager(projectManagerId, populatedProjectIds); } db.InsertTeamMembers(course.teams.ToList()); } return RedirectToAction("Index"); }