public async Task ReturnCorrectCollectionClassesLightServiceModelsByPage_When_ClassesExistInDb()
        {
            // Arrange
            var options = Utils.GetOptions(nameof(ReturnCorrectCollectionClassesLightServiceModelsByPage_When_ClassesExistInDb));

            Teacher teacher1 = Utils.CreateMockTeacher();
            Class   class1   = Utils.CreateMockClass(teacher1.Id);

            using (var arrangeContext = new PTSchoolDbContext(options))
            {
                arrangeContext.Teachers.Add(teacher1);
                arrangeContext.Classes.Add(class1);
                await arrangeContext.SaveChangesAsync();
            }

            // Act
            using (var actContext = new PTSchoolDbContext(options))
            {
                ClassService sut    = new ClassService(actContext, Utils.Mapper);
                var          result = await sut.GetAllClassesLightByPageAsync();

                // Assert
                Assert.AreEqual(1, result.Count());
            }
        }
示例#2
0
        static void Main(string[] args)
        {
            using var db = new PTSchoolDbContext(new DbContextOptionsBuilder <PTSchoolDbContext>()
                                                 .UseSqlServer("Server=PT\\SQLEXPRESS;Database=PTSchoolDatabase;Integrated Security=True;")
                                                 .Options);

            db.Database.Migrate();

            //// ADD 45 TEACHERS.
            //PTSchoolDbSeeder.SeedTeachers(db, 45);

            //// ADD 30 CLASSES FROM 8TH GRADE TO 12TH GRADE + CLASS NAMES FROM 'A' TO 'F'.
            //PTSchoolDbSeeder.SeedClasses(db);

            //// ADD STUDENTS TO THE 30 CLASSES.
            //PTSchoolDbSeeder.SeedStudents(db);

            //// ADD PARENTS.
            //PTSchoolDbSeeder.SeedParents(db);

            //// ADD STUDENT-PARENT.
            //PTSchoolDbSeeder.SeedParentsToStudentsRelation(db);

            //// ADD SUBJECTS.
            //PTSchoolDbSeeder.SeedSubjects(db);

            //// ADD CLUBS.
            //PTSchoolDbSeeder.SeedClubs(db);

            //// ADD SUBJECTS-TO-TEACHERS
            //PTSchoolDbSeeder.SeedTeachersToSubjectsRelation(db);

            //// ADD CLUBS-TO-TEACHERS
            //PTSchoolDbSeeder.SeedTeachersToClubsRelation(db);

            //// ADD STUDENTS-TO-CLUBS
            //PTSchoolDbSeeder.SeedStudentsToClubsRelation(db);

            //// ADD SUBJECTS-TO-CLASSES
            //PTSchoolDbSeeder.SeedSubjectsToClasses(db);

            //// ADD NOTES!
            //PTSchoolDbSeeder.SeedNotes(db);

            // ADD MARKS!
            //PTSchoolDbSeeder.SeedMarks(db);

            // ADD ROLES!
            PTSchoolDbSeeder.SeedRoles(db);
        }
示例#3
0
 public StudentService(PTSchoolDbContext db, IMapper mapper)
 {
     this.db     = db;
     this.mapper = mapper;
 }
示例#4
0
 public ClassService(PTSchoolDbContext db, IMapper mapper)
 {
     this.db     = db;
     this.mapper = mapper;
 }
示例#5
0
 public TeacherService(PTSchoolDbContext db, IMapper mapper)
 {
     this.db     = db;
     this.mapper = mapper;
 }
 public TictactoeService(PTSchoolDbContext db, IMapper mapper)
 {
     this.db     = db;
     this.mapper = mapper;
 }