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);
}
