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