public AuditoriumEvent(string name, Calendar calendar, Ring ring, Auditorium auditorium) { Name = name; Calendar = calendar; Ring = ring; Auditorium = auditorium; }
public TeacherWish(Teacher teacher, Calendar calendar, Ring ring, int wish) { Teacher = teacher; Calendar = calendar; Ring = ring; Wish = wish; }
public CalendarView(Calendar calendar) { CalendarId = calendar.CalendarId; Date = calendar.Date; State = calendar.State; if (Constants.CalendarStateDescription.ContainsKey(calendar.State)) { StateString = Constants.CalendarStateDescription[calendar.State]; } }
private void add_Click(object sender, EventArgs e) { if (_repo.FindCalendar(calendarDate.Value) != null) { MessageBox.Show("Эта дата уже есть."); return; } var newCalendar = new Calendar { Date = calendarDate.Value.Date }; _repo.AddCalendar(newCalendar); RefreshView(); }
private void button1_Click(object sender, EventArgs e) { var curDate = startDate.Value.Date; do { if (_repo.FindCalendar(curDate) == null) { var newCalendar = new Calendar { Date = curDate }; _repo.AddCalendar(newCalendar); } RefreshView(); curDate = curDate.AddDays(1); } while (curDate <= finishDate.Value.Date); }
private void Execute_Click(object sender, EventArgs e) { if (teacherForDisciplineBox.SelectedValue == null) { MessageBox.Show("Неправильно выбран TFD."); return; } var weekList = ScheduleRepository.WeeksStringToList(lessonWeeks.Text); var tfd = _repo.GetTeacherForDiscipline((int)teacherForDisciplineBox.SelectedValue); var disc = tfd.Discipline; var studentGroup = disc.StudentGroup; var sigFromGroup = _repo.GetFiltredStudentsInGroups(sing => sing.StudentGroup.StudentGroupId == studentGroup.StudentGroupId); var studentIdsInGroup = sigFromGroup.Select(studentsInGroupse => studentsInGroupse.Student.StudentId).ToList(); var studentGroupsIds = _repo.GetFiltredStudentsInGroups(sig => studentIdsInGroup.Contains(sig.Student.StudentId)).Select(sing => sing.StudentGroup.StudentGroupId).Distinct(); var ring = _repo.GetRing((int)ringsBox.SelectedValue); var calendarIdsList = new List<int>(); for (int i = 0; i < weekList.Count; i++) { var date = _repo.GetDateFromDowAndWeek((int)dayOfWeekBox.SelectedValue, weekList[i]); var calendar = _repo.FindCalendar(date); if (calendar != null) { calendarIdsList.Add(calendar.CalendarId); } } var groupsLessons = _repo .GetFiltredLessons( l => studentGroupsIds.Contains(l.TeacherForDiscipline.Discipline.StudentGroup.StudentGroupId) && calendarIdsList.Contains(l.Calendar.CalendarId) && l.Ring.RingId == ring.RingId && l.IsActive); if (groupsLessons.Count != 0) { MessageBox.Show("У студентов группы есть занятия."); return; } Dictionary<int, string> audWeekList = new Dictionary<int,string>(); audWeekList = Utilities.GetAudWeeksList(auditoriums.Text); for (int i = 0; i < weekList.Count; i++) { var lesson = new Lesson(); lesson.IsActive = isActive.Checked; lesson.TeacherForDiscipline = tfd; lesson.Ring = _repo.GetRing((int)ringsBox.SelectedValue); var date = _repo.GetDateFromDowAndWeek((int)dayOfWeekBox.SelectedValue, weekList[i]); var calendar = _repo.FindCalendar(date); if (calendar == null) { calendar = new Calendar(date); } lesson.Calendar = calendar; // Auditorium Auditorium aud; if (audList.SelectedIndex != -1) { aud = _repo.GetAuditorium((int)audList.SelectedValue); } else { if (audWeekList.Keys.Count == 1) { var lessonAud = audWeekList[0]; audWeekList.Clear(); foreach (var week in weekList) { audWeekList.Add(week, lessonAud); } } aud = _repo.FindAuditorium(audWeekList[weekList[i]]); if (aud == null) { _repo.AddAuditorium(new Auditorium(audWeekList[weekList[i]])); aud = _repo.FindAuditorium(audWeekList[weekList[i]]); } } lesson.Auditorium = aud; _repo.AddLesson(lesson, publicComment.Text, hiddenComment.Text); } this.Close(); }
public Calendar AddCalendar(Calendar calendar) { using (var context = new ScheduleContext(ConnectionString)) { calendar.CalendarId = 0; context.Calendars.Add(calendar); context.SaveChanges(); return calendar; } }
public void UpdateCalendar(Calendar calendar) { using (var context = new ScheduleContext(ConnectionString)) { var curCalendar = context.Calendars.FirstOrDefault(c => c.CalendarId == calendar.CalendarId); curCalendar.Date = calendar.Date; context.SaveChanges(); } }
public List<Auditorium> GetFreeAuditoriumAtTime(Calendar calendar, Ring ring) { using (var context = new ScheduleContext(ConnectionString)) { var occupiedAudIds = context.Lessons .Where(l => ((l.Calendar.CalendarId == calendar.CalendarId) && (l.Ring.RingId == ring.RingId))) .Select(l => l.Auditorium.AuditoriumId) .Distinct() .ToList(); var result = context.Auditoriums.Where(a => !occupiedAudIds.Contains(a.AuditoriumId)).ToList(); return result; } }
public MySQLCalendar(Calendar calendar) { CalendarId = calendar.CalendarId; Date = calendar.Date.ToString("yyyy-MM-dd"); }
public MySqlCalendar(Calendar calendar) { CalendarId = calendar.CalendarId; Date = calendar.Date.ToString("yyyy-MM-dd"); State = calendar.State; }