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); }