public void UpdateSchedulesDbTest()
{
MsDbUpdater msDbUpdater = new MsDbUpdater("name=StaffContextTests");
var AllClasses = getClassesListTest();
msDbUpdater.UpdateSchedulesDb(AllClasses);
}
public void CheckTimeTest()
{
TimeSpan now = DateTime.Now.TimeOfDay;
TimeSpan nowPlusMinute = now.Add(new TimeSpan(0, 1, 0));
TimeSpan nowMinusMinute = now.Add(new TimeSpan(0, -1, 0));
TimeChecker timeCheckerWithParam = new TimeChecker(nowMinusMinute, nowPlusMinute);
timeCheckerWithParam.CheckTime(new Action(delegate {
MsDbCleaner msDbCleaner = new MsDbCleaner("name=StaffContextTests");
MsDbUpdater msDbUpdater = new MsDbUpdater("name=StaffContextTests");
msDbCleaner.clearAllTablesBesidesPupils();
var AllStaff = new List <object[]>();
AllStaff = getStaffListTest();
var AllClasses = getClassesListTest();
msDbUpdater.UpdateMsDb(AllStaff, AllClasses);
}));
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 UpdateMsDbTest()
{
MsDbUpdater msDbUpdater = new MsDbUpdater("name=StaffContextTests");
var AllStaff = getStaffListTest();
var AllClasses = getClassesListTest();
msDbUpdater.UpdateMsDb(AllStaff, AllClasses);
EmptyChecker emptyChecker = new EmptyChecker("StaffContextTests");
Assert.IsTrue(false == emptyChecker.IsTableEmpty("Schedules"));
}
public void UpdateStaffDbTest()
{
MsDbUpdater msDbUpdater = new MsDbUpdater("name=StaffContextTests");
var AllStaff = getStaffListTest();
msDbUpdater.UpdateStaffDb(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 == "Сидоров Сидор Сидорович");
EmptyChecker emptyChecker = new EmptyChecker("StaffContextTests");
Assert.IsTrue(false == emptyChecker.IsTableEmpty("Schedules"));
}
public EljurBaseClass(Message Message, Config Config, Firebird Firebird, AllStaffAdder allStaffAdder, MsDbChecker MsDbChecker, MsDbUpdater MsDbUpdater, MsDbCleaner MsDbCleaner, EventHandlerEljur EventHandlerEljur)
{
this.message = new Message();
this.config = new Config();
this.firebird = new Firebird();
this.allStaffAdder = new AllStaffAdder();
this.msDbChecker = new MsDbChecker();
this.msDbUpdater = new MsDbUpdater();
this.msDbCleaner = new MsDbCleaner();
this.eventHandlerEljur = new EventHandlerEljur();
}
