public MySQLAuditoriumEvent(AuditoriumEvent evt) { AuditoriumEventId = evt.AuditoriumEventId; Name = evt.Name; CalendarId = evt.Calendar.CalendarId; RingId = evt.Ring.RingId; AuditoriumId = evt.Auditorium.AuditoriumId; }
public AuditoriumEventView(AuditoriumEvent evt) { AuditoriumEventId = evt.AuditoriumEventId; Name = evt.Name; Calendar = evt.Calendar.Date.ToString("d.M.yyyy"); Ring = evt.Ring.Time.ToString("H:mm"); Auditorium = evt.Auditorium.Name; }
private void add_Click(object sender, EventArgs e) { if (useDataSet.Checked) { var dow = startDate.Value.DayOfWeek; var calendarList = new List<Calendar>(); var date = startDate.Value; do { if (date.DayOfWeek == dow) { var calendar = _repo.GetFirstFiltredCalendar(c => c.Date.Date == date.Date); if (calendar == null) { MessageBox.Show("Не найдена дата: " + date.ToString("d.m.Y"), "Oops"); return; } var newEvent = new AuditoriumEvent { Name = eventName.Text, Calendar = calendar, Ring = _repo.GetRing((int)eventTime.SelectedValue), Auditorium = _repo.GetAuditorium((int)eventAuditorium.SelectedValue) }; _repo.AddAuditoriumEvent(newEvent); } date = date.AddDays(1); } while(date <= finishDate.Value); } else { var calendar = _repo.GetFirstFiltredCalendar(c => c.Date.Date == eventDate.Value.Date); if (calendar == null) { MessageBox.Show("Не найдена дата", "Oops"); return; } var newEvent = new AuditoriumEvent { Name = eventName.Text, Calendar = calendar, Ring = _repo.GetRing((int)eventTime.SelectedValue), Auditorium = _repo.GetAuditorium((int)eventAuditorium.SelectedValue) }; _repo.AddAuditoriumEvent(newEvent); } RefreshView(); }
public void UpdateAuditoriumEvent(AuditoriumEvent ae) { using (var context = new ScheduleContext(ConnectionString)) { var curAE = context.AuditoriumEvents.FirstOrDefault(evt => evt.AuditoriumEventId == ae.AuditoriumEventId); curAE.Name = ae.Name; curAE.Calendar = context.Calendars.FirstOrDefault(c => c.CalendarId == ae.Calendar.CalendarId); curAE.Ring = context.Rings.FirstOrDefault(r => r.RingId == ae.Ring.RingId); curAE.Auditorium = context.Auditoriums.FirstOrDefault(a => a.AuditoriumId == ae.Auditorium.AuditoriumId); context.SaveChanges(); } }
public AuditoriumEvent AddAuditoriumEvent(AuditoriumEvent ae) { using (var context = new ScheduleContext(ConnectionString)) { ae.AuditoriumEventId = 0; ae.Calendar = context.Calendars.FirstOrDefault(c => c.CalendarId == ae.Calendar.CalendarId); ae.Ring = context.Rings.FirstOrDefault(r => r.RingId == ae.Ring.RingId); ae.Auditorium = context.Auditoriums.FirstOrDefault(a => a.AuditoriumId == ae.Auditorium.AuditoriumId); context.AuditoriumEvents.Add(ae); context.SaveChanges(); return ae; } }