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()); } }
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); }
public StudentService(PTSchoolDbContext db, IMapper mapper) { this.db = db; this.mapper = mapper; }
public ClassService(PTSchoolDbContext db, IMapper mapper) { this.db = db; this.mapper = mapper; }
public TeacherService(PTSchoolDbContext db, IMapper mapper) { this.db = db; this.mapper = mapper; }
public TictactoeService(PTSchoolDbContext db, IMapper mapper) { this.db = db; this.mapper = mapper; }