public void AddCourse(Course newCourse) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO student_courses (student_id, course_id) VALUES (@StudentId, @CourseId);", conn); SqlParameter studentIdParameter = new SqlParameter(); studentIdParameter.ParameterName = "@StudentId"; studentIdParameter.Value = this.GetId(); cmd.Parameters.Add(studentIdParameter); SqlParameter courseIdParameter = new SqlParameter(); courseIdParameter.ParameterName = "@CourseId"; courseIdParameter.Value = newCourse.GetId(); cmd.Parameters.Add(courseIdParameter); cmd.ExecuteNonQuery(); if (conn != null) { conn.Close(); } }
public void Find_RetrievesCourseFromDB_() { Course newCourse = new Course("Math", "MTH101"); newCourse.Save(); Course result = Course.Find(newCourse.GetId()); Assert.Equal(newCourse, result); }
public void Test_Find_FindsCourseInDatabase() { //Arrange Course testCourse = new Course("CS101", 1); testCourse.Save(); //Act Course foundCourse = Course.Find(testCourse.GetId()); //Assert Assert.Equal(testCourse, foundCourse); }
public void Test_AddCourse_DisplaysAddedCourses() { Student testStudent2 = new Student("Bob", enrollmentDate); testStudent2.Save(); Course testCourse = new Course("CS101", 1); testCourse.Save(); testStudent2.AddCourse(testCourse.GetId()); List<Course> resultList = testStudent2.GetCourses(); List<Course> expectedList= new List<Course>{testCourse}; Assert.Equal(expectedList, resultList); }
public void Test_Find_ReturnCourseFromDatabase() { //Arrange Course testCourse = firstCourse; testCourse.Save(); //Act Course foundCourse = Course.Find(testCourse.GetId()); //Assert Assert.Equal(testCourse, foundCourse); }
public void Test_Save_AssignsIdToObject() { //Arrange Course testCourse = new Course("CS101", 1); //Act testCourse.Save(); Course savedCourse = Course.GetAll()[0]; int result = savedCourse.GetId(); int testId = testCourse.GetId(); //Assert Assert.Equal(testId, result); }
public override bool Equals(System.Object otherCourse) { if (!(otherCourse is Course)) { return(false); } else { Course newCourse = (Course)otherCourse; bool courseIdEquality = (this.GetId() == newCourse.GetId()); bool nameEquality = (this.GetName() == newCourse.GetName()); bool courseNumberEquality = (this.GetCourseNumber() == newCourse.GetCourseNumber()); return(courseIdEquality && nameEquality && courseNumberEquality); } }
public override bool Equals(Object otherCourse) { if (!(otherCourse is Course)) { return(false); } else { Course newCourse = (Course)otherCourse; bool idEquality = (this._id == newCourse.GetId()); bool nameEquality = (this._name == newCourse.GetName()); bool numberEquality = (this._number == newCourse.GetNumber()); return(idEquality && nameEquality && numberEquality); } }
public override bool Equals(System.Object otherCourse) { if (!(otherCourse is Course)) { return(false); } else { Course newCourse = (Course)otherCourse; bool idEquality = (this.GetId() == newCourse.GetId()); bool nameEquality = (this.GetName() == newCourse.GetName()); bool timeEquality = (this.GetTime() == newCourse.GetTime()); bool creditEqulity = (this.GetCredit() == newCourse.GetCredit()); return(idEquality && nameEquality && timeEquality && creditEqulity); } }
public override bool Equals(Object otherCourse) { if (!(otherCourse is Course)) { return(false); } else { Course newCourse = (Course)otherCourse; bool idEquality = _id == newCourse.GetId(); bool nameEquality = _name == newCourse.GetName(); bool courseEquality = _courseNumber == newCourse.GetCourseNumber(); bool courseDescription = _description == newCourse.GetDescription(); return(idEquality && nameEquality && courseEquality && courseDescription); } }
public void Test_DropCourse_DropsSelectedCourse() { Student testStudent = new Student("Bob", enrollmentDate); testStudent.Save(); Course testCourse1 = new Course("CS101", 1); testCourse1.Save(); testStudent.AddCourse(testCourse1.GetId()); Course testCourse2 = new Course("PHIL101", 2); testCourse2.Save(); testStudent.AddCourse(testCourse2.GetId()); testStudent.DropCourse(testCourse1.GetId()); List<Course> resultList = testStudent.GetCourses(); List<Course> expectedList= new List<Course>{testCourse2}; Assert.Equal(expectedList, resultList); }
public void AddCourse_AddCoursesForStudents_true() { Student newStudent = new Student("Joe", DateTime.Today); Course course1 = new Course("Math Party", "MTH505"); Course course2 = new Course("Intro", "CS101"); newStudent.Save(); course1.Save(); course2.Save(); List <Course> expectedList = new List <Course> { course1 }; newStudent.AddCourse(course1.GetId()); List <Course> result = newStudent.GetAllCourses(); Assert.Equal(result, expectedList); }