//Methods

        public Class GetClass(string className)
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                return(db.Classes.Where(c => c.ClassName == className).FirstOrDefault());
            }
        }
        public void CheckAllInformationIsCorrectedWhenTeacherInformationIsEdited()
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                var newTeacher = new Teacher
                {
                    TeacherId = 5,
                    FirstName = "Jo",
                    LastName  = "Wong",
                    Email     = "*****@*****.**"
                };

                db.Teachers.Add(newTeacher);
                db.SaveChanges();
            }

            _crudManager.EditTeacher(5, "Alice", "Cheung", "*****@*****.**");

            using (var db = new ChineseSchoolAdminSystemContext())
            {
                var selectedTeacher = db.Teachers.Where(t => t.TeacherId == 5).FirstOrDefault();
                Thread.Sleep(2000);
                Assert.AreEqual("Alice", selectedTeacher.FirstName);
                Assert.AreEqual("Cheung", selectedTeacher.LastName);
                Assert.AreEqual("*****@*****.**", selectedTeacher.Email);
            }
        }
 public List <Class> RetrieveAllClasses()
 {
     using (var db = new ChineseSchoolAdminSystemContext())
     {
         return(db.Classes.ToList());
     }
 }
예제 #4
0
        public void NumberOfStudentsToDecreaseBy1WhenStudentIsDeleted()
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                var newStudent = new Student
                {
                    StudentId           = 7,
                    FirstName           = "Lauren",
                    LastName            = "Pang",
                    Age                 = 22,
                    Allergies           = "N/A",
                    ParentName          = "Emy",
                    ParentContactNumber = "07123123123",
                    ParentEmail         = "*****@*****.**",
                    ClassId             = 6
                };

                db.Students.Add(newStudent);
                db.SaveChanges();

                var numberOfStudentsBefore = db.Students.Count();
                _crudManager.DeleteStudent(7);
                var numberOfStudentsAfter = db.Students.Count();
                Assert.AreEqual(numberOfStudentsAfter, numberOfStudentsBefore - 1);
            }
        }
 public List <Teacher> RetrieveAllTeachers()
 {
     using (var db = new ChineseSchoolAdminSystemContext())
     {
         return(db.Teachers.ToList());
     }
 }
 public void DeleteTeacher(int teacherID)
 {
     using (var db = new ChineseSchoolAdminSystemContext())
     {
         var selectedTeacher = db.Teachers.Where(s => s.TeacherId == teacherID).FirstOrDefault();
         db.Teachers.Remove(selectedTeacher);
         db.SaveChanges();
     }
 }
 public void DeleteStudent(int studentID)
 {
     using (var db = new ChineseSchoolAdminSystemContext())
     {
         var selectedStudent = db.Students.Where(s => s.StudentId == studentID).FirstOrDefault();
         db.Students.Remove(selectedStudent);
         db.SaveChanges();
     }
 }
예제 #8
0
 public void NumberOfStudentsIncreasesBy1WhenNewStudentIsAdded()
 {
     using (var db = new ChineseSchoolAdminSystemContext())
     {
         var numberOfStudentsBefore = db.Students.Count();
         _crudManager.AddStudent(7, "Lauren", "Pang", 22, "N/A", "Emy Chung", "07123112233", "*****@*****.**", 6);
         var numberOfStudentsAfter = db.Students.Count();
         Assert.AreEqual(numberOfStudentsAfter, numberOfStudentsBefore + 1);
     }
 }
 public void NumberOfTeachersIncreasesBy1WhenNewTeacherIsAdded()
 {
     using (var db = new ChineseSchoolAdminSystemContext())
     {
         var numberOfTeachersBefore = db.Teachers.Count();
         _crudManager.AddTeacher(5, "Alice", "Cheung", "*****@*****.**");
         var numberOfTeachersAfter = db.Teachers.Count();
         Assert.AreEqual(numberOfTeachersAfter, numberOfTeachersBefore + 1);
     }
 }
 public List <Student> RetrieveAllStudents(string className)
 {
     using (var db = new ChineseSchoolAdminSystemContext())
     {
         return((from s in db.Students
                 join c in db.Classes on s.ClassId equals c.ClassId
                 where c.ClassName == className
                 select s).ToList());
     }
 }
        public void EditTeacher(int teacherID, string firstName, string lastName, string email)
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                SelectedTeacher           = db.Teachers.Where(t => t.TeacherId == teacherID).FirstOrDefault();
                SelectedTeacher.FirstName = firstName;
                SelectedTeacher.LastName  = lastName;
                SelectedTeacher.Email     = email;

                db.SaveChanges();
            }
        }
        public void AddTeacher(int teacherID, string firstName, string lastName, string email)
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                var newTeacher = new Teacher
                {
                    TeacherId = teacherID,
                    FirstName = firstName,
                    LastName  = lastName,
                    Email     = email
                };

                db.Teachers.Add(newTeacher);
                db.SaveChanges();
            }
        }
        public void CheckAllInformationIsCorrectedWhenNewTeacherIsAdded()
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                _crudManager.AddTeacher(5, "Alice", "Cheung", "*****@*****.**");

                var newTeacher = from t in db.Teachers
                                 where t.TeacherId == 5
                                 select t;
                foreach (var s in newTeacher)
                {
                    Assert.AreEqual("Alice", s.FirstName);
                    Assert.AreEqual("Cheung", s.LastName);
                    Assert.AreEqual("*****@*****.**", s.Email);
                }
            }
        }
        public void Teardown()
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                var selectedTeacher =
                    from c in db.Teachers
                    where c.TeacherId == 5
                    select c;


                foreach (var c in selectedTeacher)
                {
                    db.Teachers.Remove(c);
                }

                db.SaveChanges();
            }
        }
예제 #15
0
        public void Teardown()
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                var selectedStudent =
                    from c in db.Students
                    where c.StudentId == 7
                    select c;


                foreach (var c in selectedStudent)
                {
                    db.Students.Remove(c);
                }

                db.SaveChanges();
            }
        }
        public void EditStudent(int studentID, string firstName, string lastName, int age, string allergies,
                                string parentName, string parentContactNumber, string parentEmail, int classID)
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                SelectedStudent                     = db.Students.Where(s => s.StudentId == studentID).FirstOrDefault();
                SelectedStudent.FirstName           = firstName;
                SelectedStudent.LastName            = lastName;
                SelectedStudent.Age                 = age;
                SelectedStudent.Allergies           = allergies;
                SelectedStudent.ParentName          = parentName;
                SelectedStudent.ParentContactNumber = parentContactNumber;
                SelectedStudent.ParentEmail         = parentEmail;
                SelectedStudent.ClassId             = classID;

                db.SaveChanges();
            }
        }
        public void NumberOfTeachersDecreasesBy1WhenTeacherisDeleted()
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                var newTeacher = new Teacher
                {
                    TeacherId = 5,
                    FirstName = "Jo",
                    LastName  = "Wong",
                    Email     = "*****@*****.**"
                };

                db.Teachers.Add(newTeacher);
                db.SaveChanges();

                var numberOfTeachersBefore = db.Teachers.Count();
                _crudManager.DeleteTeacher(5);
                var numberOfTeachersAfter = db.Teachers.Count();
                Assert.AreEqual(numberOfTeachersAfter, numberOfTeachersBefore - 1);
            }
        }
        public void AddStudent(int studentID, string firstName, string lastName, int age, string allergies,
                               string parentName, string parentContactNumber, string parentEmail, int classID)
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                var newStudent = new Student
                {
                    StudentId           = studentID,
                    FirstName           = firstName,
                    LastName            = lastName,
                    Age                 = age,
                    Allergies           = allergies,
                    ParentName          = parentName,
                    ParentContactNumber = parentContactNumber,
                    ParentEmail         = parentEmail,
                    ClassId             = classID
                };

                db.Students.Add(newStudent);
                db.SaveChanges();
            }
        }
예제 #19
0
        public void CheckAllInformationIsCorrectedWhenNewStudentIsAdded()
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                _crudManager.AddStudent(7, "Lauren", "Pang", 22, "N/A", "Emy Chung", "07123112233", "*****@*****.**", 6);

                var newStudent = from s in db.Students
                                 where s.StudentId == 7
                                 select s;
                foreach (var s in newStudent)
                {
                    Assert.AreEqual("Lauren", s.FirstName);
                    Assert.AreEqual("Pang", s.LastName);
                    Assert.AreEqual(22, s.Age);
                    Assert.AreEqual("N/A", s.Allergies);
                    Assert.AreEqual("Emy Chung", s.ParentName);
                    Assert.AreEqual("07123112233", s.ParentContactNumber);
                    Assert.AreEqual("*****@*****.**", s.ParentEmail);
                    Assert.AreEqual(6, s.ClassId);
                }
            }
        }
예제 #20
0
        public void CheckAllInformationIsCorrectedWhenStudentInformationIsEdited()
        {
            using (var db = new ChineseSchoolAdminSystemContext())
            {
                var newStudent = new Student
                {
                    StudentId           = 7,
                    FirstName           = "Olivia",
                    LastName            = "Pang",
                    Age                 = 22,
                    Allergies           = "N/A",
                    ParentName          = "Emy",
                    ParentContactNumber = "07123123123",
                    ParentEmail         = "*****@*****.**",
                    ClassId             = 6
                };

                db.Students.Add(newStudent);
                db.SaveChanges();
            }

            _crudManager.EditStudent(7, "Lauren", "Chu", 20, "Nuts", "Tony Chu", "07789778899", "*****@*****.**", 5);

            using (var db = new ChineseSchoolAdminSystemContext())
            {
                var selectedStudent = db.Students.Where(s => s.StudentId == 7).FirstOrDefault();
                Thread.Sleep(2000);
                Assert.AreEqual("Lauren", selectedStudent.FirstName);
                Assert.AreEqual("Chu", selectedStudent.LastName);
                Assert.AreEqual(20, selectedStudent.Age);
                Assert.AreEqual("Nuts", selectedStudent.Allergies);
                Assert.AreEqual("Tony Chu", selectedStudent.ParentName);
                Assert.AreEqual("07789778899", selectedStudent.ParentContactNumber);
                Assert.AreEqual("*****@*****.**", selectedStudent.ParentEmail);
                Assert.AreEqual(5, selectedStudent.ClassId);
            }
        }