public void Add(int studentId) { int majorCourse = 0; SqlConnection conn = DB.Connection(); conn.Open(); if (this.GetDepartmentId() == Student.Find(studentId).GetDepartmentId()) { majorCourse = 1; } SqlCommand cmd = new SqlCommand("INSERT INTO courses_students (courses_id, students_id, completed, major) VALUES (@CourseId, @StudentId, @Completed, @Major);", conn); cmd.Parameters.Add(new SqlParameter("@CourseId", this.GetId())); cmd.Parameters.Add(new SqlParameter("@StudentId", studentId.ToString())); cmd.Parameters.Add(new SqlParameter("@Completed", "0")); cmd.Parameters.Add(new SqlParameter("@Major", majorCourse)); cmd.ExecuteNonQuery(); if (conn != null) { conn.Close(); } }
public HomeModule() { Get["/"] = _ => { return(View["index.cshtml", ModelMaker()]); }; Post["/add-department"] = _ => { Department newDepartment = new Department(Request.Form["department-name"]); newDepartment.Save(); return(View["index.cshtml", ModelMaker()]); }; Post["/add-course"] = _ => { Course newCourse = new Course(Request.Form["course-name"], Request.Form["course-number"], Request.Form["department-id"]); newCourse.Save(); return(View["index.cshtml", ModelMaker()]); }; Get["/students"] = _ => { Dictionary <string, object> model = ModelMaker(); model.Add("Students", Student.GetAll()); return(View["students.cshtml", model]); }; Post["students/{id}"] = parameters => { Student.Find(parameters.id).AddCourse(Request.Form["course-id"]); Dictionary <string, object> model = ModelMaker(); model.Add("Students", Student.GetAll()); return(View["students.cshtml", model]); }; Patch["students/{id}"] = parameters => { Student.Find(parameters.id).UpdateCourseGrade(Request.Form["course-id"], Request.Form["course-grade"]); Dictionary <string, object> model = ModelMaker(); model.Add("Students", Student.GetAll()); return(View["students.cshtml", model]); }; Delete["students/{studentId}/course/{id}"] = parameters => { Student.Find(parameters.studentId).DeleteCourse(parameters.id); Dictionary <string, object> model = ModelMaker(); model.Add("Students", Student.GetAll()); return(View["students.cshtml", model]); }; Post["/add-student"] = _ => { Student newStudent = new Student(Request.Form["student-name"], Request.Form["enrollment-date"], Request.Form["department-id"]); newStudent.Save(); Dictionary <string, object> model = ModelMaker(); model.Add("Students", Student.GetAll()); return(View["students.cshtml", model]); }; }
public void Test_Find_FindsStudentInDatabase() { Student testStudent = new Student("Jim", new DateTime(2011, 12, 20)); testStudent.Save(); Student foundStudent = Student.Find(testStudent.GetId()); Assert.Equal(testStudent, foundStudent); }
public void Test_Find_FindsStudentInDb() { Student newStudent = new Student("Jo Bob", testDate); newStudent.Save(); Student foundStudent = Student.Find(newStudent.Id); Assert.Equal(newStudent, foundStudent); }
public void Find_FindsStudentInDatabase_True() { Student testStudent = new Student("John", new DateTime(2017, 06, 13)); testStudent.Save(); Student foundStudent = Student.Find(testStudent.GetId()); Assert.Equal(testStudent, foundStudent); }
public void Student_Find_ReturnStudentObject() { Student newStudent = new Student("Johnny English", "2001-09-21", 1); newStudent.Save(); Student foundStudent = Student.Find(newStudent.GetId()); Assert.Equal(newStudent, foundStudent); }
public void Test_Find_FindsStudentInDatabase() { //Arrange Student testStudent = new Student("Lucille Ball", DateTime.Today); testStudent.Save(); //Act Student foundStudent = Student.Find(testStudent.GetId()); //Assert Assert.Equal(testStudent, foundStudent); }
public void Test_Find_FindsTaskinDatablase() { //Arrange Student testStudent = new Student("John"); testStudent.Save(); //Act Student foundStudent = Student.Find(testStudent.GetId()); //Asswert Assert.Equal(testStudent, foundStudent); }
public void Find_FindsStudentInDatabase_true() { //Arrange Student testStudent = new Student("Annie", "3/2/2014"); testStudent.Save(); //Act Student result = Student.Find(testStudent.Id); //Assert Assert.Equal(testStudent, result); }
public void Test_FindFindsStudentsInDatabase() { //Arrange Student testStudent = new Student("Britton", "2010-09-01"); testStudent.Save(); //Act Student result = Student.Find(testStudent.GetId()); //Assert Assert.Equal(testStudent, result); }
public void Find_SelectOneStudentFromDB_Equals() { //Arrange DateTime enrollmentDate = new DateTime(2016, 12, 13); Student newStudent = new Student("Brian", enrollmentDate); //Act newStudent.Save(); Student foundStudent = Student.Find(newStudent.GetId()); //Assert Assert.Equal(newStudent, foundStudent); }
public HomeModule() { Get["/"] = _ => { return(View["index.cshtml"]); }; Get["/courses"] = _ => { List <Course> allCourses = Course.GetAll(); return(View["courses.cshtml", allCourses]); }; Get["/majors"] = _ => { List <Major> allMajors = Major.GetAll(); return(View["majors.cshtml", allMajors]); }; Get["/students"] = _ => { List <Student> allStudents = Student.GetAll(); return(View["students.cshtml", allStudents]); }; Get["/students/form"] = _ => { List <Major> allMajors = Major.GetAll(); return(View["student_form.cshtml", allMajors]); }; Post["/student/form/submit"] = _ => { DateTime enrollmentDate = (DateTime)Request.Form["enrollment-date"]; Student newStudent = new Student(Request.Form["student-name"], enrollmentDate, Request.Form["major-name"]); newStudent.Save(); return(View["index.cshtml"]); }; Get["/student/{id}"] = parameters => { Dictionary <string, object> myDict = new Dictionary <string, object>(); Student foundStudent = Student.Find(parameters.id); string majorName = (Major.Find(foundStudent.MajorId)).Name; List <Major> allMajors = Major.GetAll(); myDict.Add("student", foundStudent); myDict.Add("majors", allMajors); myDict.Add("majorName", majorName); return(View["student_details.cshtml", myDict]); }; Patch["/student/form/edit/{id}"] = parameters => { Dictionary <string, object> myDict = new Dictionary <string, object>(); Student foundStudent = Student.Find(parameters.id); foundStudent.Edit(Request.Form["student-name"], Request.Form["enrollment-date"], Request.Form["major-name"]); string majorName = (Major.Find(foundStudent.MajorId)).Name; List <Major> allMajors = Major.GetAll(); myDict.Add("student", foundStudent); myDict.Add("majors", allMajors); myDict.Add("majorName", majorName); return(View["student_details.cshtml", myDict]); }; }
public HomeModule() { Get["/"] =_=> { return View["index.cshtml"]; }; Get["/students"]= _ => { List<Student> allStudents = Student.GetAll(); return View["students.cshtml", allStudents]; }; Post["/students"] = _ => { Student newStudent = new Student(Request.Form["student-name"], Request.Form["student-enrollment"]); newStudent.Save(); List<Student> allStudents = Student.GetAll(); return View["students.cshtml", allStudents]; }; Get["/courses"]= _ => { List<Course> allCourses = Course.GetAll(); return View["courses.cshtml", allCourses]; }; Post["/courses"] = _ => { Course newCourse = new Course(Request.Form["course-name"], Request.Form["course-number"]); newCourse.Save(); List<Course> allCourses = Course.GetAll(); return View["courses.cshtml", allCourses]; }; Get["/departments"]= _ => { List<Department> allDepartments = Department.GetAll(); return View["departments.cshtml", allDepartments]; }; Post["/departments"] = _ => { Department newDepartment = new Department(Request.Form["department-major"]); newDepartment.Save(); List<Department> allDepartments = Department.GetAll(); return View["departments.cshtml", allDepartments]; }; Get["/departments/{id}"] = parameter =>{ Department foundDepartment = Department.Find(parameter.id); List<string> courses = new List<string>{}; List<string> students = new List<string>{}; foreach(var course in foundDepartment.GetCourses()) { courses.Add(course.GetName()); }; foreach(var student in foundDepartment.GetStudents()) { students.Add(student.GetName()); }; Dictionary<string, List<string>> departmentDeets = new Dictionary<string, List<string>>{{"courses", courses}, {"students", students}}; return View["department.cshtml", departmentDeets]; }; Get["courses/{id}"] = parameters => { Dictionary<string, object> model = new Dictionary<string, object>(); Course SelectedCourse = Course.Find(parameters.id); List<Student> CourseStudents = SelectedCourse.GetStudents(); List<Student> AllStudents = Student.GetAll(); model.Add("course", SelectedCourse); model.Add("courseStudents", CourseStudents); model.Add("allStudents", AllStudents); return View["course.cshtml", model]; }; Get["students/{id}"] = parameters => { Dictionary<string, object> model = new Dictionary<string, object>(); Student SelectedStudent = Student.Find(parameters.id); List<Student> StudentCourses = SelectedStudent.GetCompletedCourses(); List<Student> AllStudents = Student.GetAll(); model.Add("student", SelectedStudent); model.Add("studentCourses", StudentCourses); model.Add("allStudents", AllStudents); return View["student.cshtml", model]; }; // Post["course/add_student"] = _ => { // Student student = Student.Find(Request.Form["student-id"]); // Course course = Course.Find(Request.Form["course-id"]); // course.AddStudent(student); // return View["course.cshtml"]; // }; // Post["student/add_course"] = _ => { // Student student = Student.Find(Request.Form["student-id"]); // Course course = Course.Find(Request.Form["course-id"]); // student.AddCourse(course); // return View["student.cshtml"]; // }; }
public HomeModule() { Get["/"] = _ => { return(View["index.cshtml"]); }; Get["/students"] = _ => { List <Student> allStudents = Student.GetAll(); return(View["students.cshtml", allStudents]); }; Get["/students/add_new"] = _ => { List <Course> allCourses = Course.GetAll(); return(View["new_student.cshtml", allCourses]); }; Post["/students/"] = _ => { string name = Request.Form["student-name"]; DateTime enrollmentDate = (DateTime)Request.Form["date"]; Student newStudent = new Student(name, enrollmentDate); newStudent.Save(); List <Student> allStudents = Student.GetAll(); return(View["students.cshtml", allStudents]); }; Get["/students/{id}"] = parameters => { Student newStudent = Student.Find(parameters.id); return(View["student.cshtml", newStudent]); }; Delete["/students/remove"] = _ => { int studentId = int.Parse(Request.Form["student-id"]); Student.DeleteStudent(studentId); List <Student> allStudents = Student.GetAll(); return(View["students.cshtml", allStudents]); }; Get["/courses"] = _ => { List <Course> allCourses = Course.GetAll(); return(View["courses.cshtml", allCourses]); }; Get["/courses/add_new"] = _ => { List <Student> allStudents = Student.GetAll(); return(View["new_course.cshtml", allStudents]); }; Post["/courses"] = _ => { string name = Request.Form["name"]; string number = Request.Form["number"]; string description = Request.Form["description"]; Course newCourse = new Course(name, number, description); newCourse.Save(); List <Course> allCourses = Course.GetAll(); return(View["courses.cshtml", allCourses]); }; Get["/courses/{id}"] = parameters => { Course foundCourse = Course.Find(parameters.id); return(View["course.cshtml", foundCourse]); }; Delete["/courses/remove"] = _ => { int courseId = int.Parse(Request.Form["course-id"]); Course.DeleteCourse(courseId); List <Course> allCourses = Course.GetAll(); return(View["courses.cshtml", allCourses]); }; }
public HomeModule() { Get["/"] = _ => { return(View["index.cshtml"]); }; Get["/courses"] = _ => { List <Course> allCourses = Course.GetAll(); return(View["all_courses.cshtml", allCourses]); }; Get["/courses/new"] = _ => { return(View["course_add.cshtml"]); }; Post["/courses"] = _ => { Course newCourse = new Course(Request.Form["course-name"], Request.Form["course-number"]); newCourse.Save(); List <Course> allCourses = Course.GetAll(); return(View["all_courses.cshtml", allCourses]); }; Get["/students"] = _ => { List <Student> allStudents = Student.GetAll(); return(View["all_students.cshtml", allStudents]); }; Get["/students/new"] = _ => { return(View["student_add.cshtml"]); }; Post["/students"] = _ => { Student newStudent = new Student(Request.Form["student-name"], Request.Form["enrollment-date"]); newStudent.Save(); List <Student> allStudents = Student.GetAll(); return(View["all_students.cshtml", allStudents]); }; Get["/courses/{id}/{number}"] = parameters => { Dictionary <string, object> model = new Dictionary <string, object> { }; Course SelectedCourse = Course.Find(parameters.id); var studentsInCourse = SelectedCourse.GetStudents(); var allStudents = Student.GetAll(); model.Add("course", SelectedCourse); model.Add("students", studentsInCourse); model.Add("allStudents", allStudents); return(View["course.cshtml", model]); }; Post["/courses/{id}/{number}"] = parameters => { Student newStudent = Student.Find(Request.Form["all-students"]); Course selectedCourse = Course.Find(parameters.id); selectedCourse.AddStudent(newStudent); Dictionary <string, object> model = new Dictionary <string, object> { }; var studentsInCourse = selectedCourse.GetStudents(); var allStudents = Student.GetAll(); model.Add("course", selectedCourse); model.Add("students", studentsInCourse); model.Add("allStudents", allStudents); return(View["course.cshtml", model]); }; Get["/students/{id}/{name}"] = parameters => { Dictionary <string, object> model = new Dictionary <string, object> { }; Student SelectedStudent = Student.Find(parameters.id); List <Course> studentCourses = SelectedStudent.GetCourses(); var allCourses = Course.GetAll(); model.Add("student", SelectedStudent); model.Add("courses", studentCourses); model.Add("allCourses", allCourses); return(View["student.cshtml", model]); }; Post["/students/{id}/{name}"] = parameters => { Course selectedCourse = Course.Find(Request.Form["all-courses"]); Student SelectedStudent = Student.Find(parameters.id); selectedCourse.AddStudent(SelectedStudent); Dictionary <string, object> model = new Dictionary <string, object> { }; var studentCourses = SelectedStudent.GetCourses(); var allCourses = Course.GetAll(); model.Add("student", SelectedStudent); model.Add("courses", studentCourses); model.Add("allCourses", allCourses); return(View["student.cshtml", model]); }; }
public HomeModule() { Get["/"] = _ => { return(View["/index.cshtml"]); }; Get["/courses"] = _ => { List <Course> allCourses = Course.GetAll(); return(View["all_courses.cshtml", allCourses]); }; Post["/courses"] = _ => { int StudentId = int.Parse(Request.Form["student"]); int CourseId = int.Parse(Request.Form["course"]); Course.Enroll(CourseId, StudentId); Course newCourse = Course.Find(CourseId); return(View["course.cshtml", newCourse]); }; Get["/unenroll"] = _ => { return(View["/registration.cshtml"]); }; Post["/unenroll"] = _ => { int StudentId = int.Parse(Request.Form["student"]); int CourseId = int.Parse(Request.Form["course"]); Course.UnEnroll(CourseId, StudentId); return(View["/registration.cshtml"]); }; Get["/courses/new"] = _ => { return(View["new_course_form.cshtml"]); }; Post["/courses/new"] = _ => { string courseName = Request.Form["course-name"]; string courseNumber = Request.Form["course-number"]; Course newCourse = new Course(courseName, courseNumber); newCourse.Save(); List <Course> allCourses = Course.GetAll(); return(View["all_courses.cshtml", allCourses]); }; Get["/courses/{id}"] = parameters => { Course foundCourse = Course.Find(parameters.id); return(View["course.cshtml", foundCourse]); }; Get["/students"] = _ => { List <Student> allStudents = Student.GetAll(); return(View["all_students.cshtml", allStudents]); }; Get["/students/new"] = _ => { return(View["new_student_form.cshtml"]); }; Post["/students/new"] = _ => { string studentName = Request.Form["student-name"]; DateTime enrollmentDate = (DateTime)Request.Form["enrollment-date"]; Student newStudent = new Student(studentName, enrollmentDate); newStudent.Save(); List <Student> allStudents = Student.GetAll(); return(View["all_students.cshtml", allStudents]); }; Get["/students/{id}"] = parameters => { Student foundStudent = Student.Find(parameters.id); return(View["student.cshtml", foundStudent]); }; Get["/register"] = _ => { List <Student> allStudents = Student.GetAll(); List <Course> allCourses = Course.GetAll(); Dictionary <string, object> model = new Dictionary <string, object>(); model.Add("students", allStudents); model.Add("courses", allCourses); return(View["registration.cshtml", model]); }; }
public HomeModule() { Get["/"] = _ => { return(View["index.cshtml"]); }; Get["/student/add"] = _ => { return(View["student_form.cshtml"]); }; Get["/course/add"] = _ => { return(View["course_form.cshtml"]); }; Post["/student/add"] = _ => { Student newStudent = new Student(Request.Form["name"], Request.Form["doe"]); newStudent.Save(); return(View["success.cshtml"]); }; Post["/course/add"] = _ => { Course newCourse = new Course(Request.Form["name"], Request.Form["time"], Request.Form["credits"]); newCourse.Save(); return(View["success.cshtml"]); }; Get["/student/all"] = _ => { List <Student> AllStudents = Student.GetAll(); return(View["student_all.cshtml", AllStudents]); }; Get["/course/all"] = _ => { List <Course> AllCourses = Course.GetAll(); return(View["course_all.cshtml", AllCourses]); }; Get["student/{id}"] = parameters => { Dictionary <string, object> model = new Dictionary <string, object>(); Student SelectedStudent = Student.Find(parameters.id); List <Course> StudentCourse = SelectedStudent.GetCourses(); List <Course> AllCourses = Course.GetAll(); model.Add("student", SelectedStudent); model.Add("studentCourse", StudentCourse); model.Add("allCourses", AllCourses); return(View["student.cshtml", model]); }; Get["course/{id}"] = parameters => { Dictionary <string, object> model = new Dictionary <string, object>(); Course SelectedCourse = Course.Find(parameters.id); List <Student> CourseStudent = SelectedCourse.GetStudents(); List <Student> AllStudents = Student.GetAll(); model.Add("course", SelectedCourse); model.Add("courseStudent", CourseStudent); model.Add("allStudents", AllStudents); return(View["course.cshtml", model]); }; Post["students/add_course"] = _ => { Course course = Course.Find(Request.Form["course-id"]); Student student = Student.Find(Request.Form["student-id"]); student.AddCourse(course); return(View["success.cshtml"]); }; Post["courses/add_student"] = _ => { Course course = Course.Find(Request.Form["course-id"]); Student student = Student.Find(Request.Form["student-id"]); course.AddStudent(student); return(View["success.cshtml"]); }; Get["/student/delete/{id}"] = parameters => { Student chosenStudent = Student.Find(parameters.id); return(View["student_delete.cshtml", chosenStudent]); }; Delete["/student/delete/{id}"] = parameters => { Student chosenStudent = Student.Find(parameters.id); chosenStudent.Delete(); return(View["success.cshtml"]); }; }
public HomeModule() { Get["/"] = _ => { return(View["index.cshtml"]); }; Get["/students"] = _ => { List <Student> allStudents = Student.GetAll(); return(View["students.cshtml", allStudents]); }; Post["/students"] = _ => { var newStudent = new Student(Request.Form["student"]); newStudent.Save(); var allStudents = Student.GetAll(); return(View ["students.cshtml", allStudents]); }; Get["/student/{studentId}"] = parameters => { Dictionary <string, object> model = new Dictionary <string, object>(); Student newStudent = Student.Find(parameters.studentId); List <Course> studentCourses = newStudent.GetCourses(); model.Add("student", newStudent); model.Add("all_courses", Course.GetAll()); model.Add("courses", studentCourses); return(View["student.cshtml", model]); }; Get["/courses"] = _ => { List <Course> allCourses = Course.GetAll(); return(View["courses.cshtml", allCourses]); }; Post["/courses"] = _ => { var newCourse = new Course(Request.Form["course"]); newCourse.Save(); var allCourses = Course.GetAll(); return(View ["courses.cshtml", allCourses]); }; Get["/course/{courseId}"] = parameters => { Dictionary <string, object> model = new Dictionary <string, object>(); Course newCourse = Course.Find(parameters.courseId); List <Student> courseStudents = newCourse.GetStudents(); model.Add("course", newCourse); model.Add("all_students", Student.GetAll()); model.Add("students", courseStudents); return(View["course.cshtml", model]); }; Get["/student/course_added"] = _ => { return(View["course_added.cshtml"]); }; Post["/student/course_added"] = _ => { Course course = Course.Find(Request.Form["course-list"]); Student student = Student.Find(Request.Form["student"]); student.AddCourse(course); return(View["course_added.cshtml"]); }; Post["/course/student_added"] = _ => { Course course = Course.Find(Request.Form["course-list"]); Student student = Student.Find(Request.Form["student"]); student.AddCourse(course); return(View["student_added.cshtml"]); }; }
public HomeModule() { Get["/"] = _ => { return(View["index.cshtml"]); }; Get["/courses"] = _ => { List <Course> allCourses = Course.GetAll(); return(View["courses.cshtml", allCourses]); }; Get["/students"] = _ => { List <Student> allStudents = Student.GetAll(); return(View["students.cshtml", allStudents]); }; Get["/students/new"] = _ => { return(View["student_form.cshtml"]); }; Post["/students/new"] = _ => { string studentName = Request.Form["student-name"]; string studentDate = Request.Form["student-date"]; Student newStudent = new Student(studentName, studentDate); newStudent.Save(); return(View["student.cshtml", newStudent]); }; Get["/courses/new"] = _ => { return(View["course_form.cshtml"]); }; Post["/courses/new"] = _ => { string courseName = Request.Form["course-name"]; string courseNumber = Request.Form["course-number"]; Course newCourse = new Course(courseName, courseNumber); newCourse.Save(); return(View["course.cshtml", newCourse]); }; Get["/student/{student_id}"] = parameters => { Student selectedStudent = Student.Find(parameters.student_id); return(View["student.cshtml", selectedStudent]); }; Get["/course/{course_id}"] = parameters => { Course selectedCourse = Course.Find(parameters.course_id); return(View["course.cshtml", selectedCourse]); }; Get["/course/{id}/students/add"] = parameters => { Dictionary <string, object> model = new Dictionary <string, object> (); Course selectedCourse = Course.Find(parameters.id); List <Student> currentStudents = selectedCourse.GetStudents(); List <Student> allStudents = Student.GetAll(); List <Student> availableStudents = new List <Student> { }; foreach (Student student in allStudents) { // If a student is already in the course it will return an index of 0 or above. if (currentStudents.IndexOf(student) < 0) { availableStudents.Add(student); } } model.Add("course", selectedCourse); model.Add("available-students", availableStudents); return(View["AddStudentToCourse.cshtml", model]); }; Post["/course/{id}/students/added"] = parameters => { int studentId = Request.Form["student-id"]; Student selectedStudent = Student.Find(studentId); Course selectedCourse = Course.Find(parameters.id); selectedCourse.AddStudent(selectedStudent); return(View["student_added.cshtml", selectedCourse]); }; Get["/student/{id}/courses/add"] = parameters => { Dictionary <string, object> model = new Dictionary <string, object> (); Student selectedStudent = Student.Find(parameters.id); List <Course> currentCourses = selectedStudent.GetCourses(); List <Course> allCourses = Course.GetAll(); List <Course> availableCourses = new List <Course> { }; foreach (Course course in allCourses) { // If the student is already enrolled in a course it will return an index of 0 or above. if (currentCourses.IndexOf(course) < 0) { availableCourses.Add(course); } } model.Add("student", selectedStudent); model.Add("available-courses", availableCourses); return(View["AddCourseToStudent.cshtml", model]); }; Post["/student/{id}/courses/added"] = parameters => { int courseId = Request.Form["course-id"]; Course selectedCourse = Course.Find(courseId); Student selectedStudent = Student.Find(parameters.id); selectedStudent.AddCourse(selectedCourse); return(View["course_added.cshtml", selectedStudent]); }; }
public HomeModule() { Get["/"] = _ => { return(View["index.cshtml"]); }; Get["/course/new"] = _ => { return(View["new-course-form.cshtml"]); }; Post["/course/new"] = _ => { Course newCourse = new Course(Request.Form["courseName"], Request.Form["courseNumber"]); newCourse.Save(); List <Course> allCourses = Course.GetAll(); return(View["courses.cshtml", allCourses]); }; Get["/courses"] = _ => { List <Course> allCourses = Course.GetAll(); return(View["courses.cshtml", allCourses]); }; Get["/student/new"] = _ => { return(View["new-student-form.cshtml"]); }; Post["/student/new"] = _ => { Student newStudent = new Student(Request.Form["studentName"], Request.Form["enrollmentDate"]); newStudent.Save(); List <Student> allStudents = Student.GetAll(); return(View["students.cshtml", allStudents]); }; Get["/course/{id}"] = parameters => { Course currentCourse = Course.Find(parameters.id); Dictionary <string, object> model = new Dictionary <string, object>(); List <Student> allStudents = Student.GetAll(); List <Student> courseStudents = currentCourse.GetAllStudents(); model.Add("course", currentCourse); model.Add("allStudents", allStudents); model.Add("courseStudents", courseStudents); return(View["course.cshtml", model]); }; Patch["/course/update/{id}"] = parameters => { Course currentCourse = Course.Find(parameters.id); currentCourse.UpdateName(Request.Form["newName"]); Dictionary <string, object> model = new Dictionary <string, object>(); List <Student> allStudents = Student.GetAll(); List <Student> courseStudents = currentCourse.GetAllStudents(); model.Add("course", currentCourse); model.Add("allStudents", allStudents); model.Add("courseStudents", courseStudents); return(View["course.cshtml", model]); }; Delete["/course/delete/{id}"] = parameters => { Course currentCourse = Course.Find(parameters.id); currentCourse.Delete(); List <Course> allCourses = Course.GetAll(); return(View["courses.cshtml", allCourses]); }; Post["/course/add_student"] = _ => { Course currentCourse = Course.Find(Request.Form["courseId"]); currentCourse.AddStudent(Request.Form["studentId"]); Dictionary <string, object> model = new Dictionary <string, object>(); List <Student> allStudents = Student.GetAll(); List <Student> courseStudents = currentCourse.GetAllStudents(); model.Add("course", currentCourse); model.Add("allStudents", allStudents); model.Add("courseStudents", courseStudents); return(View["course.cshtml", model]); }; Get["/student/{id}"] = parameters => { Student currentStudent = Student.Find(parameters.id); Dictionary <string, object> model = new Dictionary <string, object>(); List <Course> allCourses = Course.GetAll(); List <Course> studentCourses = currentStudent.GetAllCourses(); model.Add("student", currentStudent); model.Add("allCourses", allCourses); model.Add("studentCourses", studentCourses); return(View["student.cshtml", model]); }; Post["/student/add_course"] = _ => { Student currentStudent = Student.Find(Request.Form["studentId"]); currentStudent.AddCourse(Request.Form["courseId"]); Dictionary <string, object> model = new Dictionary <string, object>(); List <Course> allCourses = Course.GetAll(); List <Course> studentCourses = currentStudent.GetAllCourses(); model.Add("student", currentStudent); model.Add("allCourses", allCourses); model.Add("studentCourses", studentCourses); return(View["student.cshtml", model]); }; Delete["/student/delete/{id}"] = parameters => { Student currentStudent = Student.Find(parameters.id); currentStudent.Delete(); List <Student> allStudents = Student.GetAll(); return(View["students.cshtml", allStudents]); }; Get["/students"] = _ => { List <Student> allStudents = Student.GetAll(); return(View["students.cshtml", allStudents]); }; Patch["/student/update/{id}"] = parameters => { Student currentStudent = Student.Find(parameters.id); currentStudent.UpdateName(Request.Form["newName"]); Dictionary <string, object> model = new Dictionary <string, object>(); List <Course> allCourses = Course.GetAll(); List <Course> studentCourses = currentStudent.GetAllCourses(); model.Add("student", currentStudent); model.Add("allCourses", allCourses); model.Add("studentCourses", studentCourses); return(View["student.cshtml", model]); }; }