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 AddScript2()
{
var teacher = TeacherService.Read(new Teacher()
{
Name = "Random Teacher", PassportData = 456278
}, 1, 0).First();
var speciality = SpecialityService.Read(new Speciality()
{
Name = "Random Speciality"
}, 1, 0).First();
Timetable[] models = new Timetable[30];
for (int i = 0; i < models.Length; i++)
{
models[i] =
new Timetable()
{
Lesson = 5,
ExamDate = DateTime.Now.AddDays(i),
TeacherId = teacher.Id,
SpecialityId = speciality.Id,
ClassroomId = 5,
DisciplineId = 5
};
}
DateTime startTime = DateTime.Now;
foreach (var model in models)
{
TimetableService.Create(model);
}
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 ReadScript0()
{
Speciality model = new Speciality()
{
Name = "Random Speciality"
};
DateTime startTime = DateTime.Now;
Speciality mod = SpecialityService.Read(model, 1, 0).First();
DateTime finishTime = DateTime.Now;
Console.WriteLine("{0}: {1}", mod.Id, mod.Name);
return((int)(finishTime - startTime).TotalMilliseconds);
}
static int UpdateScript1()
{
Speciality speciality = SpecialityService.Read(new Speciality()
{
Name = "Random Speciality"
}, 1, 0).First();
Timetable mod = new Timetable()
{
Id = speciality.Id, Lesson = 6
};
DateTime startTime = DateTime.Now;
TimetableService.Update(mod);
DateTime finishTime = DateTime.Now;
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);
}