public Action CreateLessons()
{
var startDate = JournalContext.Quarters.First(q => q.QuarterID == 0).StartDate;
var endDate = JournalContext.Quarters.First(q => q.QuarterID == 3).EndDate;
var dates = new Dictionary<DayOfWeek, List<DateTime>>();
var curDate = startDate;
while(curDate <= endDate)
{
List<DateTime> values;
if(!dates.TryGetValue(curDate.DayOfWeek, out values))
{
values = new List<DateTime>();
dates.Add(curDate.DayOfWeek, values);
}
values.Add(curDate);
curDate = curDate.AddDays(1);
}
var lessonTimes = JournalContext.LessonTimes.ToArray();
if (!JournalContext.SchoolConfigurations.Any(sc => sc.Key == ConfigurationTableHelper.Timetable))
{
foreach (var lesson in JournalContext.JournalLessons)
{
List<DateTime> values;
if (dates.TryGetValue(DateHelper.GetDayOfWeek(lesson.DayOfWeek), out values))
{
foreach (var date in values)
{
var starTime = lessonTimes[lesson.Order].StartTime;
DateTime lessonStartTime = date + new TimeSpan(starTime.Hour, starTime.Minute, starTime.Second); // время начала урока
var concreteLesson = JournalContext.ConcreteLessons.FirstOrDefault(c =>
c.LessonOrder == lesson.Order &&
c.DayOfWeek == lesson.DayOfWeek &&
c.Date == lessonStartTime &&
c.JournalID == lesson.JournalID);
if (concreteLesson == null)
{
concreteLesson = new ConcreteLesson();
concreteLesson.LessonOrder = lesson.Order;
concreteLesson.JournalID = lesson.JournalID;
concreteLesson.DayOfWeek = lesson.DayOfWeek;
concreteLesson.Date = lessonStartTime;
JournalContext.ConcreteLessons.InsertOnSubmit(concreteLesson);
}
foreach (var pupil in lesson.Journal.Pupils)
{
if (!JournalContext.ConcreteLessonPupilDetails.Any(c =>
c.ConcreteLesson.ID == concreteLesson.ID &&
c.Pupil.PupilID == pupil.PupilID)) // TODO: check this
{
var concreteLessonPupilDetails = new ConcreteLessonPupilDetails();
concreteLessonPupilDetails.ConcreteLesson = concreteLesson;
concreteLessonPupilDetails.PupilID = pupil.PupilID;
JournalContext.ConcreteLessonPupilDetails.InsertOnSubmit(concreteLessonPupilDetails);
}
}
}
}
}
}
try
{
//JournalContext.SchoolConfigurations.InsertOnSubmit(new SchoolConfiguration
//{
// Key = ConfigurationTableHelper.Timetable,
// Value = "Created"
//});
JournalContext.SubmitChanges();
}
catch (Exception e)
{
}
return null;
}
partial void DeleteConcreteLesson(ConcreteLesson instance);
partial void UpdateConcreteLesson(ConcreteLesson instance);
partial void InsertConcreteLesson(ConcreteLesson instance);
private void detach_JournalPupilOnLessons(ConcreteLesson entity)
{
this.SendPropertyChanging();
entity.JournalLesson = null;
}
partial void InsertConcreteLesson(ConcreteLesson instance)
{
if (!ConcreteLessons.Contains(instance))
ExecuteDynamicInsert(instance);
}
