static int SpecialScript0()
{
var teacher = TeacherService.Read(new Teacher()
{
Name = "Random Teacher", PassportData = 555190
}, 1, 0).First();
var speciality = SpecialityService.Read(new Speciality()
{
Name = "Random Speciality"
}, 1, 0).First();
DateTime startTime = DateTime.Now;
Timetable model = new Timetable()
{
TeacherId = teacher.Id, SpecialityId = speciality.Id
};
var models = TimetableService.Read(model);
foreach (var timetable in models)
{
Console.WriteLine("{0}: {1} {2} {3} {4}", timetable.Id, timetable.ExamDate.Value.ToString("dd.MM.yyyy"), timetable.Lesson, timetable.TeacherId, timetable.SpecialityId);
}
DateTime finishTime = DateTime.Now;
return((int)(finishTime - startTime).TotalMilliseconds);
}
static int UpdateScript2()
{
var teacher = TeacherService.Read(new Teacher()
{
Name = "Random Teacher", PassportData = 555190
}, 1, 0).First();
var speciality = SpecialityService.Read(new Speciality()
{
Name = "Random Speciality"
}, 1, 0).First();
// Предполагается, что действия до создания модели - это моделирование выбора пользователя
var models = TimetableService.Read(new Timetable()
{
TeacherId = teacher.Id, SpecialityId = speciality.Id
});
DateTime startTime = DateTime.Now;
foreach (var model in models)
{
model.ClassroomId = 1;
TimetableService.Update(model);
}
DateTime finishTime = DateTime.Now;
return((int)(finishTime - startTime).TotalMilliseconds);
}
static int SpecialScript1()
{
DateTime date = new DateTime(2020, 5, 14).Date;
DateTime startTime = DateTime.Now;
var timetables = TimetableService.Read(new Timetable()
{
ExamDate = date
});
foreach (var time in timetables)
{
Console.WriteLine("{0}: {1} - {2} ", time.Id, time.ExamDate.Value.ToString("dd.MM.yyyy"), time.TeacherId);
}
DateTime finishTime = DateTime.Now;
return((int)(finishTime - startTime).TotalMilliseconds);
}
static int ReadScript2()
{
var teacher = TeacherService.Read(new Teacher()
{
Name = "Random Teacher", PassportData = 456278
}, 1, 0).First();
// Предполагается, что действия до создания модели - это моделирование выбора пользователя
Timetable model = new Timetable()
{
TeacherId = teacher.Id
};
DateTime startTime = DateTime.Now;
var models = TimetableService.Read(model);
DateTime finishTime = DateTime.Now;
foreach (var timetable in models)
{
Console.WriteLine("{0} {1}", timetable.ExamDate.Value.ToString("dd.MM.yyyy"), timetable.Lesson);
}
return((int)(finishTime - startTime).TotalMilliseconds);
}
static int ReadScript1()
{
Speciality speciality = SpecialityService.Read(new Speciality()
{
Name = "Random Speciality"
}, 1, 0).First();
// Предполагается, что действия до создания модели - это моделирование выбора пользователя
Timetable time = new Timetable()
{
SpecialityId = speciality.Id
};
DateTime startTime = DateTime.Now;
Timetable model = TimetableService.Read(time, 1, 0).First();
var count = DB.Timetables.Count(t => model.SpecialityId == speciality.Id);
DateTime finishTime = DateTime.Now;
Console.WriteLine("{0}: {1}", model.SpecialityId, count);
return((int)(finishTime - startTime).TotalMilliseconds);
}
static int DeleteScript2()
{
var speciality = SpecialityService.Read(new Speciality()
{
Name = "Random Speciality"
}, 1, 0).First();
// Предполагается, что действия до создания модели - это моделирование выбора пользователя
var models = TimetableService.Read(new Timetable()
{
SpecialityId = speciality.Id
});
DateTime startTime = DateTime.Now;
foreach (var model in models)
{
TimetableService.Delete(model);
}
DateTime finishTime = DateTime.Now;
return((int)(finishTime - startTime).TotalMilliseconds);
}
