public void FillOnlySchedulesTest()
{
MsDbFiller msDbFiller = new MsDbFiller("name=StaffContextTests");
var AllClasses = getClassesListTest();
msDbFiller.FillOnlySchedules(AllClasses);
EmptyChecker emptyChecker = new EmptyChecker("StaffContextTests");
Assert.IsTrue(false == emptyChecker.IsTableEmpty("Schedules"));
}
public void PrepareTest()
{
MsDbCleaner msDbCleaner = new MsDbCleaner("name=StaffContextTests");
msDbCleaner.clearTableDb("Pupils");
msDbCleaner.clearTableDb("Schedules");
msDbCleaner.clearTableDb("Events");
MsDbFiller msDbFiller = new MsDbFiller("name=StaffContextTests");
var AllStaff = getStaffListTest();
var AllClasses = getClassesListTest();
msDbFiller.FillMsDb(AllStaff, AllClasses);
}
public void FillMsDbTest()
{
PrepareTest();
MsDbFiller msDbFiller = new MsDbFiller("name=StaffContextTests");
var AllStaff = getStaffListTest();
var AllClasses = getClassesListTest();
msDbFiller.FillMsDb(AllStaff, AllClasses);
EmptyChecker emptyChecker = new EmptyChecker("StaffContextTests");
Assert.IsTrue(false == emptyChecker.IsTableEmpty("Schedules"));
Assert.IsTrue(false == emptyChecker.IsTableEmpty("Pupils"));
}
public void FillOnlyPupilsTest()
{
PrepareTest();
MsDbFiller msDbFiller = new MsDbFiller("name=StaffContextTests");
var AllStaff = getStaffListTest();
msDbFiller.FillOnlyPupils(AllStaff);
MsDbRequester msDbRequester = new MsDbRequester("name=StaffContextTests");
String FullFIO1 = msDbRequester.getFullFIOByPupilIdOld(5000);
String FullFIO2 = msDbRequester.getFullFIOByPupilIdOld(5001);
String FullFIO3 = msDbRequester.getFullFIOByPupilIdOld(5002);
Assert.IsTrue(FullFIO1 == "Иванов Иван Иванович");
Assert.IsTrue(FullFIO2 == "Петров Петр Петрович");
Assert.IsTrue(FullFIO3 == "Сидоров Сидор Сидорович");
}
public void IsTableExistTest()
{
Boolean IsTableExist = false;
ExistChecker existChecker = new ExistChecker("StaffContextTests");
MsDbFiller msDbFiller = new MsDbFiller("name=StaffContextTests");
var AllStaff = getStaffListTest();
var AllClasses = getClassesListTest();
msDbFiller.FillMsDb(AllStaff, AllClasses);
IsTableExist = existChecker.IsTableExist("Pupils");
Assert.IsTrue(IsTableExist == true);
IsTableExist = existChecker.IsTableExist("Events");
Assert.IsTrue(IsTableExist == true);
IsTableExist = existChecker.IsTableExist("Schedules");
Assert.IsTrue(IsTableExist == true);
MsDbCleaner msDbCleaner = new MsDbCleaner("name=StaffContextTests");
msDbCleaner.clearTableDb("Pupils");
msDbCleaner.clearTableDb("Schedules");
msDbCleaner.clearTableDb("Events");
}
