public void Test_SaveAssignsIdToObject()
{
//Arrange
Student testStudent = new Student("Nicole");
testStudent.Save();
//Act
Student savedStudent = Student.GetAll()[0];
int result = savedStudent.GetId();
int testId = testStudent.GetId();
//Assert
Assert.Equal(testId, result);
}
public override bool Equals(System.Object otherStudent)
{
if (!(otherStudent is Student))
{
return(false);
}
else
{
Student newStudent = (Student)otherStudent;
bool idEquality = this.GetId() == newStudent.GetId();
bool nameEquality = this.GetName() == newStudent.GetName();
bool enrollmentDateEquality = this.GetEnrollmentDate() == newStudent.GetEnrollmentDate();
bool departmentIdEqualtiy = this.GetDepartmentId() == newStudent.GetDepartmentId();
return(idEquality && nameEquality && enrollmentDateEquality);
}
}
public void Test_Save_AssignsIdToStudentObject()
{
//Arrange
Student testStudent = new Student("Britton", "2010-09-01");
testStudent.Save();
//Act
Student savedStudent = Student.GetAll()[0];
int result = savedStudent.GetId();
int testId = testStudent.GetId();
//Assert
Assert.Equal(testId, result);
}
public void Test_Add_AddStudentToDepartment()
{
//Arrange
Department testDepartment = new Department("English");
testDepartment.Save();
Student testStudent = new Student("Britton", "2010-09-01", testDepartment.GetId());
testStudent.Save();
//Act
testDepartment.AddStudent(testStudent.GetId());
int result = testDepartment.GetId();
int expected = testStudent.GetDepartmentId();
//Assert
Assert.Equal(expected, result);
}
public void AddStudent_AddStudentToDepartment_true()
{
Department testDepartment = new Department("Business");
testDepartment.Save();
Student testStudent = new Student("Bill Jones", "March 30th");
testStudent.Save();
testDepartment.AddStudent(testStudent.GetId());
List <Student> testList = testDepartment.GetStudents();
List <Student> testList2 = new List <Student>()
{
testStudent
};
Assert.Equal(testList2, testList);
}
public void AddStudent_AddStudentToCourse_true()
{
Course testCourse = new Course("Real Analysis", "MTH327");
testCourse.Save();
Student testStudent = new Student("Poor Soul", "Tomorrow");
testStudent.Save();
testCourse.AddStudent(testStudent.GetId());
List <Student> testList = testCourse.GetStudents();
List <Student> testList2 = new List <Student>()
{
testStudent
};
Assert.Equal(testList2, testList);
}
public void Test_Add_AssignsStudentToACourse()
{
//Arrange
Course testCourse = new Course("English", "ENGL120");
testCourse.Save();
Student testStudent = new Student("Britton", "2010-09-01");
testStudent.Save();
//Act
testCourse.Add(testStudent.GetId());
List <Student> allStudents = testCourse.GetStudents();
List <Student> result = new List <Student> {
testStudent
};
//Assert
Assert.Equal(result, allStudents);
}
public void Test_GetMajorCourse_ReturnIfStudentsIsMajorRelated()
{
//Arrange
Department testDepartment = new Department("English");
testDepartment.Save();
Course testCourse = new Course("English", "ENGL120", testDepartment.GetId());
testCourse.Save();
Student testStudent = new Student("Britton", "2010-09-01", testDepartment.GetId());
testStudent.Save();
//Act
testCourse.Add(testStudent.GetId());
int result = testStudent.GetMajorCourse(testCourse.GetId());
int expected = 1;
//Assert
Assert.Equal(expected, result);
}
public void Test_GetCompleted_ReturnIfCourseIsCompleted()
{
//Arrange
Course testCourse1 = new Course("English", "ENGL120");
testCourse1.Save();
Course testCourse2 = new Course("Math", "MATH101");
testCourse2.Save();
Student testStudent = new Student("Britton", "2010-09-01");
testStudent.Save();
//Act
testStudent.Add(testCourse1.GetId());
testStudent.Add(testCourse2.GetId());
int result = testCourse1.GetCompleted(testStudent.GetId());
int expected = 0;
//Assert
Assert.Equal(expected, result);
}
public void AddStudent(Student newStudent)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO students_courses (student_id, course_id) VALUES (@StudentId, @CourseId);", conn);
SqlParameter studentIdParameter = new SqlParameter("@StudentId", newStudent.GetId());
cmd.Parameters.Add(studentIdParameter);
SqlParameter courseIdParameter = new SqlParameter("@CourseId", this.GetId());
cmd.Parameters.Add(courseIdParameter);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public void AddStudent(Student newStudent)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO courses_students (course_id, student_id) VALUES (@CourseId, @StudentId)", conn);
SqlParameter courseIdParameter = new SqlParameter();
courseIdParameter.ParameterName = "@CourseId";
courseIdParameter.Value = this.GetId();
cmd.Parameters.Add(courseIdParameter);
SqlParameter studentIdParameter = new SqlParameter();
studentIdParameter.ParameterName = "@StudentId";
studentIdParameter.Value = newStudent.GetId();
cmd.Parameters.Add(studentIdParameter);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public void UpdateName_UpdatesStudentName()
{
//Arrange
Student testStudent = new Student("Lucille Ball", DateTime.Today);
testStudent.Save();
Student expectedResult = new Student("Lucy Ball", testStudent.GetEnrollmentDate(), testStudent.GetId());
//Act
testStudent.UpdateName("Lucy Ball");
//Assert
Assert.Equal(expectedResult, testStudent);
}
public void Test_Find_FindsStudentInDatabase()
{
//Arrange
Student testStudent = new Student("Mow the lawn", new DateTime(2015, 1, 18));
testStudent.Save();
//Act
Student foundStudent = Student.Find(testStudent.GetId());
//Assert
Assert.Equal(testStudent, foundStudent);
}
public void Test_Save_AssignsIdToObject()
{
//Arrange
Student testStudent = new Student("Mow the lawn", new DateTime(2015, 1, 18));
//Act
testStudent.Save();
Student savedStudent = Student.GetAll()[0];
int result = savedStudent.GetId();
int testId = testStudent.GetId();
//Assert
Assert.Equal(testId, result);
}
