public void Test_SaveAssignsIdToObject()
{
//Arrange
Student firstStudent = new Student("Jerry", "03/01/2012");
firstStudent.Save();
//Act
Student savedStudent = Student.GetAll()[0];
int result = savedStudent.GetId();
int testId = firstStudent.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 dateEquality = (this.GetDate() == newStudent.GetDate());
bool deptIdEquality = (this.GetDeptId() == newStudent.GetDeptId());
return(idEquality && nameEquality && dateEquality && deptIdEquality);
}
}
public void Test_Save_AssignsIdToObject()
{
//Arrange
Student testStudent = new Student("Joe", "2-12-2012", 2);
//Act
testStudent.Save();
Student savedStudent = Student.GetAll()[0];
int result = savedStudent.GetId();
int testId = testStudent.GetId();
//Assert
Assert.Equal(testId, result);
}
public void AddStudent(Student newStudent)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO major_track (course_id, student_id) VALUES (@CourseId, @StudentId);", conn);
SqlParameter idParam = new SqlParameter("@CourseId", this.GetId());
SqlParameter studentIdParam = new SqlParameter("@StudentId", newStudent.GetId());
cmd.Parameters.Add(idParam);
cmd.Parameters.Add(studentIdParam);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
