public void TestGetStudentCourseGrade() { DbCourses dbCourses = new DbCourses(); dbCourses.Insert("Test Course", "Test Course"); DbStudents dbStudents = new DbStudents(); dbStudents.Insert("Test Student", "Test Student", "Test Student"); DbViewStudent dbViewStudent = new DbViewStudent(); dbViewStudent.Enrol("Test Student", "Test Course"); dbViewStudent.UpdateGrade("Test Student", "Test Course", 20); ExpectedGrades expectedGrades = new ExpectedGrades(); ObjectResult result = (ObjectResult)gradesController.GetStudentCourseGrade("Test Student", "Test Course").Result; int? statusCode = result.StatusCode; Assert.Equal(200, statusCode); StudentGradesAPI actual = (StudentGradesAPI)result.Value; double? expectedgrade = expectedGrades.GetGrade("Test Student", "Test Course").grade; Assert.Equal(expectedgrade, actual.grade); dbViewStudent.Unenrol("Test Student", "Test Course"); dbCourses.Delete("Test Course"); dbStudents.Delete("Test Student", "Test Student", "Test Student"); }
public void TestGetAllStudentsGrades() { DbCourses dbCourses = new DbCourses(); dbCourses.Insert("Test Course", "Test Course"); ObjectResult result = (ObjectResult)gradesController.GetAllStudentsGrades("Test Course").Result; int? statusCode = result.StatusCode; Assert.Equal(200, statusCode); if (result.Value.GetType().Name == "String") { dbCourses.Delete("Test Course"); Assert.True(1 == 1, "That Course"); } else { List <AllStudentsInSingleCourse> actual = (List <AllStudentsInSingleCourse>)result.Value; ExpectedGrades expectedGrades = new ExpectedGrades(); List <AllStudentsInSingleCourse> expected = expectedGrades.AllStudentsInCourse("Test Course"); Assert.Equal(expected.Count, actual.Count); for (int i = 0; i < expected.Count; ++i) { Assert.Equal(expected[i].grade, actual[i].grade); } dbCourses.Delete("Test Course"); } }
private void FillComboBox() { DbCourses courses = new DbCourses(); foreach (Course course in courses.GetCourses()) { coursesComboBox.Items.Add(course.title); } }
public void TestGetCourses() { DbCourses courses = new DbCourses(); CoursesController coursesController = new CoursesController(courses); ExpectedCourses expectedCourses = new ExpectedCourses(); List <Course> expected = expectedCourses.GetCourses(); ObjectResult result = (ObjectResult)coursesController.Get().Result; int?statusCode = result.StatusCode; Assert.Equal(200, statusCode); List <Course> actual = (List <Course>)result.Value; Assert.Equal(expected.Count, actual.Count); for (int i = 0; i < expected.Count; ++i) { Assert.Equal(expected[i].title, actual[i].title); } }
public void TestUpdateGrade() { DbCourses dbCourses = new DbCourses(); dbCourses.Insert("Test Course", "Test Course"); DbStudents dbStudents = new DbStudents(); dbStudents.Insert("Test Student", "Test Student", "Test Student"); DbViewStudent dbViewStudent = new DbViewStudent(); dbViewStudent.Enrol("Test Student", "Test Course"); double actual = 5; gradesController.Post("Test Student", "Test Course", actual); ExpectedGrades expectedGrades = new ExpectedGrades(); double? expected = expectedGrades.GetGrade("Test Student", "Test Course").grade; Assert.Equal(expected, actual); dbViewStudent.Unenrol("Test Student", "Test Course"); dbCourses.Delete("Test Course"); dbStudents.Delete("Test Student", "Test Student", "Test Student"); }
public ActionResult <List <AllStudentsInSingleCourse> > GetAllStudentsGrades([Required] string course) { IEnumerable <AllStudentsInSingleCourse> result = viewStudent.AllStudentsInCourse(course); try { DbCourses temp = new DbCourses(); bool existCourse = temp.IsExistCourse(course); if (!existCourse) { return(StatusCode(400, System.String.Format("{0} course isn't exist.", course))); } if (result.Count() == 0) { return(StatusCode(200, System.String.Format("{0} course doesn't have any student.", course))); } return(Ok(viewStudent.AllStudentsInCourse(course))); } catch { return(StatusCode(500, "Server Error.")); } }