public void Student_Delete_RemoveFromDatabase()
{
Student newStudent = new Student("Johnny English", "2001-09-21", 1);
newStudent.Save();
Student.Delete(newStudent.GetId());
Assert.Equal(0, Student.GetAll().Count);
}
public void Delete_DeletesStudentAssociationsFromDataBase_StudentList()
{
Course testCourse = new Course("Bio 111", "8am", 4);
testCourse.Save();
Student testStudent = new Student("Jim", new DateTime(2011, 12, 20));
testStudent.Save();
testStudent.AddCourse(testCourse);
testStudent.Delete();
List <Student> result = testCourse.GetStudents();
List <Student> test = new List <Student> {
};
Assert.Equal(test, result);
}
public void Test_Delete_DeletesStudentFromDatabase()
{
//Arrange
Student testStudent1 = new Student("Lucille Ball", DateTime.Today);
testStudent1.Save();
Student testStudent2 = new Student("Desi Arnez", DateTime.Today);
testStudent2.Save();
//Act
testStudent1.Delete();
List <Student> resultStudents = Student.GetAll();
List <Student> testStudentList = new List <Student> {
testStudent2
};
//Assert
Assert.Equal(testStudentList, resultStudents);
}
public void Test_DeleteStudent_DeleteStudentFromDatabase()
{
//Arrange
Student student1 = new Student("Britton", "2010-09-01");
student1.Save();
Student student2 = new Student("Melanie", "2011-01-01");
student2.Save();
//Act
student1.Delete();
List <Student> allStudents = Student.GetAll();
List <Student> expected = new List <Student> {
student2
};
//Assert
Assert.Equal(expected, allStudents);
}
public void Test_Delete_DeletesStudentAssociationsFromDatabase()
{
//Arrange
Course testCourse = new Course("History", "HIST100");
testCourse.Save();
string testName = "Bryant";
string testDate = "4/9/2014";
Student testStudent = new Student(testName, testDate);
testStudent.Save();
//Act
testStudent.AddCourse(testCourse);
testStudent.Delete();
List <Student> resultCourseStudents = testCourse.GetStudents();
List <Student> testCourseStudents = new List <Student> {
};
//Assert
Assert.Equal(testCourseStudents, resultCourseStudents);
}
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["/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]);
};
}
