public async Task <IActionResult> Edit(int id, [Bind("ID,Number,BuildingID,SeatsAvailable,Details")] Room room) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Rooms.CanEdit) { if (id != room.ID) { return(NotFound()); } if (ModelState.IsValid) { if (DAL.UpdateRoom(room) > 0) { SessionVariables.SetSuccessMessage("Room edited successfully"); return(RedirectToAction(nameof(Index))); } else { SessionVariables.SetErrorMessage("Room edit failed"); } } } else { SessionVariables.SetErrorMessage("You do not have permission to edit rooms"); return(RedirectToAction("Index")); } ViewData["BuildingID"] = new SelectList(DAL.GetBuildings(), "ID", "Name", room.BuildingID); return(View(room)); }
public async Task <IActionResult> DeleteConfirmed(int id) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Users.CanDelete) { if (id == currentUser.ID) { SessionVariables.SetErrorMessage("You can't delete your own user"); return(RedirectToAction("Index")); } if (DAL.RemoveUser(id) > 0) { SessionVariables.SetSuccessMessage("User deleted successfully"); } else { SessionVariables.SetErrorMessage("User delete failed"); } return(RedirectToAction(nameof(Index))); } else { SessionVariables.SetErrorMessage("You do not have permission to delete users"); return(RedirectToAction("Index")); } }
public ActionResult Edit(int id, [Bind("ID,Name,Abbreviation")] Campus campus) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Campuses.CanEdit) { if (id != campus.ID) { return(NotFound()); } if (ModelState.IsValid) { if (DAL.UpdateCampus(campus) > 0) { SessionVariables.SetSuccessMessage("Campus edited successfully"); } else { SessionVariables.SetErrorMessage("Campus edit failed"); } return(RedirectToAction(nameof(Index))); } return(View(campus)); } else { SessionVariables.SetErrorMessage("You do not have permission to edit campuses"); return(RedirectToAction("Index")); } }
public ActionResult Create([Bind("ID,Name,Abbreviation")] Campus campus) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Campuses.CanAdd) { if (ModelState.IsValid) { if (DAL.AddCampus(campus) > 0) { SessionVariables.SetSuccessMessage("Campus created successfully"); } else { SessionVariables.SetErrorMessage("Campus create failed"); } return(RedirectToAction(nameof(Index))); } return(View(campus)); } else { SessionVariables.SetErrorMessage("You do not have permission to create campuses"); return(RedirectToAction("Index")); } }
// GET: Building/Edit/5 public async Task <IActionResult> Edit(int?id) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Buildings.CanEdit) { if (id == null) { return(NotFound()); } Building building = DAL.GetBuilding((int)id); if (building == null) { return(NotFound()); } ViewData["CampusID"] = new SelectList(DAL.GetCampuses(), "ID", "Name", building.CampusID); return(View(building)); } else { SessionVariables.SetErrorMessage("You do not have permission to edit buildings"); return(RedirectToAction("Index")); } }
// GET: User/Delete/5 public async Task <IActionResult> Delete(int?id) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Users.CanDelete) { if (id == null) { return(NotFound()); } if (id == currentUser.ID) { SessionVariables.SetErrorMessage("You can't delete your own user"); return(RedirectToAction("Index")); } User user = DAL.GetUser((int)id); if (user == null) { return(NotFound()); } return(View(user)); } else { SessionVariables.SetErrorMessage("You do not have permission to delete users"); return(RedirectToAction("Index")); } }
public async Task <IActionResult> Create([Bind("ID,Name,Abbreviation,CampusID")] Building building) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Buildings.CanAdd) { if (ModelState.IsValid) { if (DAL.AddBuilding(building) > 0) { SessionVariables.SetSuccessMessage("Building created successfully"); } else { SessionVariables.SetErrorMessage("Building create failed"); } return(RedirectToAction(nameof(Index))); } ViewData["CampusID"] = new SelectList(DAL.GetCampuses(), "ID", "Name", building.CampusID); return(View(building)); } else { SessionVariables.SetErrorMessage("You do not have permission to create buildings"); return(RedirectToAction("Index")); } }
public IActionResult Login() { if (!DAL.TestConnection()) { SessionVariables.SetErrorMessageStay("Unable to make a connection with the database. Please check with an administrator."); } User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Sections.CanView) { return(RedirectToAction("Index", "Section")); } return(View()); }
// GET: Campus/Create public ActionResult Create() { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Campuses.CanAdd) { return(View()); } else { SessionVariables.SetErrorMessage("You do not have permission to create campuses"); return(RedirectToAction("Index")); } }
public async Task <IActionResult> DeleteConfirmed(int id) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Courses.CanDelete) { DAL.RemoveCourse(id); return(RedirectToAction(nameof(Index))); } else { SessionVariables.SetErrorMessage("You do not have permission to delete courses"); return(RedirectToAction("Index")); } }
// GET: Campus public ActionResult Index() { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Campuses.CanView) { List <Campus> campuses = DAL.GetCampuses(); return(View(campuses)); } else { SessionVariables.SetErrorMessage("You do not have permission to view campuses"); return(RedirectToAction("Index", "Section")); } }
// GET: User/Create public IActionResult Create() { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Users.CanAdd) { ViewData["RoleID"] = new SelectList(DAL.GetRoles(), "ID", "Name"); return(View(new User())); } else { SessionVariables.SetErrorMessage("You do not have permission to create users"); return(RedirectToAction("Index")); } }
// GET: User public async Task <IActionResult> Index() { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Users.CanView) { List <User> users = DAL.GetUsers(); return(View(users)); } else { SessionVariables.SetErrorMessage("You do not have permission to view users"); return(RedirectToAction("Index", "Section")); } }
public async Task <IActionResult> Create([Bind("ID,DepartmentID,Title,Number,MinimumCredits,MaximumCredits,FixedCredits," + "IsFixedCredits,Description,IsCrossListed,IsCrossScheduled,CrossListedCourseID,CrossScheduledCourseID")] Course course) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Courses.CanAdd) { Course courseToCrossList = null; Course courseToCrossSchedule = null; if (ModelState.IsValid) { if (!course.IsCrossListed) { course.CrossListedCourseID = -1; } else { courseToCrossList = DAL.GetCourse(course.CrossListedCourseID); } int newCourseID = DAL.AddCourse(course); if (newCourseID > 0 && courseToCrossList != null && courseToCrossList.ID > 0) { courseToCrossList.CrossListedCourseID = newCourseID; DAL.UpdateCourse(courseToCrossList); } if (!course.IsCrossScheduled) { course.CrossScheduledCourseID = -1; } else { courseToCrossSchedule = DAL.GetCourse(course.CrossScheduledCourseID); } if (newCourseID > 0 && courseToCrossSchedule != null && courseToCrossSchedule.ID > 0) { courseToCrossSchedule.CrossScheduledCourseID = newCourseID; DAL.UpdateCourse(courseToCrossSchedule); } return(RedirectToAction(nameof(Index))); } return(View(course)); } else { SessionVariables.SetErrorMessage("You do not have permission to add courses"); return(RedirectToAction("Index")); } }
// GET: Course/Edit/5 public async Task <IActionResult> Edit(int?id) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Courses.CanEdit) { List <Department> departments = DAL.GetDepartments(); if (id == null) { return(NotFound()); } Course course = DAL.GetCourse((int)id); if (course == null) { return(NotFound()); } ViewData["DepartmentID"] = new SelectList(departments, "ID", "Abbreviation", course.DepartmentID); if (course.CrossListedCourseID > 0) { course.IsCrossListed = true; ViewData["CrossListedDepartmentID"] = new SelectList(departments, "ID", "Abbreviation", DAL.GetCourse(course.CrossListedCourseID).DepartmentID); } else { course.IsCrossListed = false; ViewData["CrossListedDepartmentID"] = new SelectList(departments, "ID", "Abbreviation"); } if (course.CrossScheduledCourseID > 0) { course.IsCrossScheduled = true; ViewData["CrossScheduledDepartmentID"] = new SelectList(departments, "ID", "Abbreviation", DAL.GetCourse(course.CrossScheduledCourseID).DepartmentID); } else { course.IsCrossScheduled = false; ViewData["CrossScheduledDepartmentID"] = new SelectList(departments, "ID", "Abbreviation"); } ViewData["CrossListedCourseNumbers"] = new SelectList(DAL.GetCourses(), "ID", "NumberAndTitle", course.CrossListedCourseID); ViewData["CrossScheduledCourseNumbers"] = new SelectList(DAL.GetCourses(), "ID", "NumberAndTitle", course.CrossScheduledCourseID); return(View(course)); } else { SessionVariables.SetErrorMessage("You do not have permission to edit courses"); return(RedirectToAction("Index")); } }
// GET: Room public async Task <IActionResult> Index() { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Rooms.CanView) { List <Room> rooms = DAL.GetRooms(); List <AcademicSemester> academicSemesters = DAL.GetAcademicSemesters(); List <int> years = new List <int>(); foreach (AcademicSemester academicSemester in academicSemesters) { if (!years.Contains(academicSemester.AcademicYear)) { years.Add(academicSemester.AcademicYear); } } Dictionary <int, List <Section> > roomSections = new Dictionary <int, List <Section> >(); List <Section> sections = DAL.GetSectionsByAcademicSemesterID(SessionVariables.GetSessionAcademicSemesterID(HttpContext)); foreach (Room room in rooms) { if (!roomSections.ContainsKey(room.ID)) { roomSections.Add(room.ID, new List <Section>()); } foreach (Section sc in sections) { if (sc.RoomID == room.ID && sc.Course != null) { roomSections[room.ID].Add(sc); } } } ViewData["AcademicSemesterYear"] = SessionVariables.GetSessionAcademicSemester(HttpContext).AcademicYear; ViewData["SemesterID"] = new SelectList(DAL.GetSemesters(), "ID", "Name", SessionVariables.GetSessionAcademicSemester(HttpContext).SemesterID); ViewData["AcademicYears"] = new SelectList(years, SessionVariables.GetSessionAcademicSemester(HttpContext).AcademicYear); ViewData["AcademicSemester"] = SessionVariables.GetSessionAcademicSemester(HttpContext).Display; ViewData["RoomSections"] = roomSections; return(View(rooms)); } else { SessionVariables.SetErrorMessage("You do not have permission to view rooms"); return(RedirectToAction("Index", "Section")); } }
// GET: Course/Create public IActionResult Create() { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Courses.CanAdd) { List <Department> departments = DAL.GetDepartments(); ViewData["DepartmentID"] = new SelectList(departments, "ID", "Abbreviation"); ViewData["CrossListedDepartmentID"] = new SelectList(departments, "ID", "Abbreviation"); ViewData["CrossScheduledDepartmentID"] = new SelectList(departments, "ID", "Abbreviation"); return(View(new Course())); } else { SessionVariables.SetErrorMessage("You do not have permission to add courses"); return(RedirectToAction("Index")); } }
// GET: Campus/Delete/5 public ActionResult Delete(int?id) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Campuses.CanDelete) { if (id == null) { return(NotFound()); } Campus campus = DAL.GetCampus((int)id); return(View(campus)); } else { SessionVariables.SetErrorMessage("You do not have permission to delete campuses"); return(RedirectToAction("Index")); } }
public async Task <IActionResult> Create([Bind("ID, Name", "Abbreviation")] Department department) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Departments.CanAdd) { if (ModelState.IsValid) { DAL.AddDepartment(department); return(RedirectToAction(nameof(Index))); } ViewData["DepartmentID"] = new SelectList(DAL.GetDepartments(), "ID", "Name"); return(View(department)); } else { SessionVariables.SetErrorMessage("You do not have permission to create departments"); return(RedirectToAction("Index")); } }
public ActionResult DeleteConfirmed(int id) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Campuses.CanDelete) { if (DAL.RemoveCampus(id) > 0) { SessionVariables.SetSuccessMessage("Campus deleted successfully"); } else { SessionVariables.SetErrorMessage("Campus delete failed"); } return(RedirectToAction(nameof(Index))); } else { SessionVariables.SetErrorMessage("You do not have permission to delete campuses"); return(RedirectToAction("Index")); } }
// GET: User/Details/5 public async Task <IActionResult> Details(int?id) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Users.CanView) { if (id == null) { return(NotFound()); } User user = DAL.GetUser((int)id); if (user == null) { return(NotFound()); } return(View(user)); } else { SessionVariables.SetErrorMessage("You do not have permission to view users"); return(RedirectToAction("Index", "Section")); } }
public async Task <IActionResult> DeleteConfirmed(int id) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Rooms.CanDelete) { if (DAL.RemoveRoom(id) > 0) { SessionVariables.SetSuccessMessage("Room deleted successfully"); return(RedirectToAction("Index")); } else { SessionVariables.SetErrorMessage("Room delete failed"); return(RedirectToAction("Index")); } } else { SessionVariables.SetErrorMessage("You do not have permission to delete rooms"); return(RedirectToAction("Index")); } }
// GET: Building/Delete/5 public async Task <IActionResult> Delete(int?id) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Buildings.CanDelete) { if (id == null) { return(NotFound()); } Building building = DAL.GetBuilding((int)id); if (building == null) { return(NotFound()); } return(View(building)); } else { SessionVariables.SetErrorMessage("You do not have permission to delete buildings"); return(RedirectToAction("Index")); } }
// GET: User/Edit/5 public async Task <IActionResult> Edit(int?id) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Users.CanEdit) { if (id == null) { return(NotFound()); } User user = DAL.GetUser((int)id); if (user == null) { return(NotFound()); } ViewData["RoleID"] = new SelectList(DAL.GetRoles(), "ID", "Name", user.RoleID); return(View(user)); } else { SessionVariables.SetErrorMessage("You do not have permission to edit users"); return(RedirectToAction("Index")); } }
public async Task <IActionResult> Edit(int id, [Bind("ID, Username, Password, RoleID")] User user) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Users.CanEdit) { if (id != user.ID) { return(NotFound()); } if (currentUser.ID == id && currentUser.RoleID != user.RoleID) { SessionVariables.SetErrorMessage("You cannot change your own role"); return(RedirectToAction("index")); } if (ModelState.IsValid) { if (DAL.UpdateUser(user) > 0) { SessionVariables.SetSuccessMessage("User edited successfully"); } else { SessionVariables.SetErrorMessage("User edit failed"); } return(RedirectToAction(nameof(Index))); } ViewData["RoleID"] = new SelectList(DAL.GetUsers(), "ID", "Name"); return(View(user)); } else { SessionVariables.SetErrorMessage("You do not have permission to edit users"); return(RedirectToAction("index")); } }
public async Task <IActionResult> Edit(int id, [Bind(" ID,DepartmentID,FixedCredits,MaximumCredits,MinimumCredits,Title,Number," + "IsFixedCredit,Description,IsCrossListed,IsCrossScheduled,CrossListedCourseID,CrossScheduledCourseID")] Course course) { User currentUser = SessionVariables.GetCurrentUser(HttpContext); if (currentUser != null && currentUser.Role != null && currentUser.Role.Courses.CanEdit) { Course courseToCrossList = null; Course courseToCrossSchedule = null; if (id != course.ID) { return(NotFound()); } if (ModelState.IsValid) { if (course.IsCrossListed) { courseToCrossList = DAL.GetCourse(course.CrossListedCourseID); if (courseToCrossList != null) { courseToCrossList.CrossListedCourseID = id; DAL.UpdateCourse(courseToCrossList); } } else { if (DAL.GetCourse(id).CrossListedCourseID > 0) { //have to get the course from the database because the cross list ID may or may not be the right one Course currentCourse = DAL.GetCourse(id); Course courseToRemoveCrossList = DAL.GetCourse(currentCourse.CrossListedCourseID); if (courseToRemoveCrossList != null) { courseToRemoveCrossList.CrossListedCourseID = -1; DAL.UpdateCourse(courseToRemoveCrossList); } } course.CrossListedCourseID = -1; } if (course.IsCrossScheduled) { courseToCrossSchedule = DAL.GetCourse(course.CrossScheduledCourseID); if (courseToCrossSchedule != null) { courseToCrossSchedule.CrossScheduledCourseID = id; DAL.UpdateCourse(courseToCrossSchedule); } } else { if (DAL.GetCourse(id).CrossScheduledCourseID > 0) { //have to get the course from the database because the cross list ID may or may not be the right one Course currentCourse = DAL.GetCourse(id); Course courseToRemoveCrossSchedule = DAL.GetCourse(currentCourse.CrossScheduledCourseID); if (courseToRemoveCrossSchedule != null) { courseToRemoveCrossSchedule.CrossScheduledCourseID = -1; DAL.UpdateCourse(courseToRemoveCrossSchedule); } } course.CrossScheduledCourseID = -1; } if (DAL.UpdateCourse(course) >= 0) { SessionVariables.SetSuccessMessage("Course edited"); } else { SessionVariables.SetErrorMessage("Course edit failed"); } return(RedirectToAction(nameof(Index))); } ViewData["DepartmentID"] = new SelectList(DAL.GetDepartments(), "ID", "Abbreviation", course.DepartmentID); return(View(course)); } else { SessionVariables.SetErrorMessage("You do not have permission to edit courses"); return(RedirectToAction("Index")); } }