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");
        }
 private void AddButton_Click(object sender, RoutedEventArgs e)
 {
     if (!students.Insert(textBoxName.Text, textBoxSurname.Text, textBoxSsn.Text))
     {
         MessageBox.Show(String.Format("{0} is already exsit.", textBoxSsn.Text));
     }
     else
     {
         Display();
         MessageBox.Show(String.Format("{0} {1} successfully added.", textBoxName.Text, textBoxSurname.Text));
     }
 }
        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");
        }