public static Student Find(int id) { SqlConnection conn = DB.Connection(); SqlDataReader rdr = null; conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM students WHERE id = @StudentId;", conn); SqlParameter studentIdParameter = new SqlParameter(); studentIdParameter.ParameterName = "@StudentId"; studentIdParameter.Value = id.ToString(); cmd.Parameters.Add(studentIdParameter); rdr = cmd.ExecuteReader(); int foundStudentId = 0; string foundStudentName = null; DateTime? foundStudentEnrollmentDate = null; while(rdr.Read()) { foundStudentName = rdr.GetString(0); foundStudentEnrollmentDate = rdr.GetDateTime(1); foundStudentId = rdr.GetInt32(2); } Student foundStudent = new Student(foundStudentName, foundStudentEnrollmentDate, foundStudentId); if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return foundStudent; }
public void Test_AddMajor_DisplaysAddedMajors() { Student testStudent = new Student("Bob", enrollmentDate); testStudent.Save(); Department testDepartment = new Department("History"); testDepartment.Save(); testStudent.AddMajor(testDepartment.GetId()); List<Department> resultList = testStudent.GetMajors(); List<Department> expectedList= new List<Department>{testDepartment}; Assert.Equal(expectedList, resultList); }
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_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 Test_DropMajor_DropsSelectedMajor() { Student testStudent = new Student("Bob", enrollmentDate); testStudent.Save(); Department testDepartment1 = new Department("Chinese"); testDepartment1.Save(); testStudent.AddMajor(testDepartment1.GetId()); Department testDepartment2 = new Department("Spanish"); testDepartment2.Save(); testStudent.AddMajor(testDepartment2.GetId()); testStudent.DropMajor(testDepartment1.GetId()); List<Department> resultList = testStudent.GetMajors(); List<Department> expectedList= new List<Department>{testDepartment2}; Assert.Equal(expectedList, resultList); }
public void Test_Save_SavesToDatabase() { //Arrange Student testStudent = new Student("Chad", enrollmentDate); //Act testStudent.Save(); List<Student> result = Student.GetAll(); List<Student> testList = new List<Student>{testStudent}; //Assert Assert.Equal(testList, result); }
public void Test_Save_AssignsIdToObject() { //Arrange Student testStudent = new Student("Chad", enrollmentDate); //Act testStudent.Save(); Student savedStudent = Student.GetAll()[0]; int result = savedStudent.GetId(); int testId = testStudent.GetId(); //Assert Assert.Equal(testId, result); }
public void Test_Find_FindsStudentInDatabase() { //Arrange Student testStudent = new Student("Chad", enrollmentDate); testStudent.Save(); //Act Student foundStudent = Student.Find(testStudent.GetId()); //Assert Assert.Equal(testStudent, foundStudent); }
public void Test_Equal_ReturnsTrueIfNamesAndEnrollmentDatesAreTheSame() { //Arrange, Act Student firstStudent = new Student("Chad", enrollmentDate); Student secondStudent = new Student("Chad", enrollmentDate); //Assert Assert.Equal(firstStudent, secondStudent); }
public static List<Student> GetAll() { List<Student> allStudents = new List<Student>{}; SqlConnection conn = DB.Connection(); SqlDataReader rdr = null; conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM students ORDER BY enrollment_date;", conn); rdr = cmd.ExecuteReader(); while(rdr.Read()) { string studentDescription = rdr.GetString(0); DateTime? studentDate = rdr.GetDateTime(1); int studentId = rdr.GetInt32(2); Student newStudent = new Student(studentDescription, studentDate, studentId); allStudents.Add(newStudent); } if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return allStudents; }