private void btnAdd_Click(object sender, EventArgs e) { //using (dbContext = new ConventionManagerDbContext()) //{ MethodController methodController = new MethodController(); if (methodController.stallCapacityStatus((int)cbxStall.SelectedValue)) { AttendeeStall attendeeStall = new AttendeeStall() { AttendeeId = (int)cbxAttendee.SelectedValue, StallId = (int)cbxStall.SelectedValue, IsExhibitor = chkIsExhibitor.Checked }; Stall stall = dbContext.Stalls.Find(attendeeStall.StallId); if (methodController.attendeeStatus(attendeeStall.AttendeeId, stall.StallStartDate, stall.StallEndDate)) { dbContext.AttendeeStalls.Add(attendeeStall); try { dbContext.SaveChanges(); MessageBox.Show("Attendee added to the stall successfully!!!"); updateGBXStall((int)cbxStall.SelectedValue); loadDGV(); return; } catch (Exception ex) { MessageBox.Show("Duplicate entry!!!"); return; } } else { MessageBox.Show("Attendee busy on other event or seminar or stall"); } } else { MessageBox.Show("Stall full!!!"); return; } //} }
private void btnAdd_Click(object sender, EventArgs e) { //using (dbContext = new ConventionManagerDbContext()) //{ MethodController methodController = new MethodController(); if (methodController.roomCapacityStatus((int)cbxEvent.SelectedValue, true)) { AttendeeEvent attendeeEvent = new AttendeeEvent() { AttendeeId = (int)cbxAttendee.SelectedValue, EventId = (int)cbxEvent.SelectedValue }; Event _eve = dbContext.Events.Find(attendeeEvent.EventId); if (methodController.attendeeStatus(attendeeEvent.AttendeeId, _eve.EventStartDate, _eve.EventEndDate)) { dbContext.AttendeeEvents.Add(attendeeEvent); try { dbContext.SaveChanges(); MessageBox.Show("Attendee added to the event successfully!!!"); updateGBXEvent((int)cbxEvent.SelectedValue); loadDGV(); return; } catch (Exception ex) { MessageBox.Show("Duplicate entry!!!"); return; } } else { MessageBox.Show("Attendee busy on other event or seminar or stall"); } } else { MessageBox.Show("Booking full!!!"); return; } //} }
private void btnAdd_Click(object sender, EventArgs e) { //using (dbContext = new ConventionManagerDbContext()) //{ MethodController methodController = new MethodController(); if (methodController.roomCapacityStatus((int)cbxSeminar.SelectedValue, false)) { AttendeeSeminar attendeeSeminar = new AttendeeSeminar() { AttendeeId = (int)cbxAttendee.SelectedValue, SeminarId = (int)cbxSeminar.SelectedValue, IsPresenter = chkIsPresenter.Checked }; Seminar seminar = dbContext.Seminars.Find(attendeeSeminar.SeminarId); if (methodController.attendeeStatus(attendeeSeminar.AttendeeId, seminar.SeminarStartDate, seminar.SeminarEndDate)) { dbContext.AttendeeSeminars.Add(attendeeSeminar); try { dbContext.SaveChanges(); MessageBox.Show("Attendee added to the seminar successfully!!!"); updateGBXSeminar((int)cbxSeminar.SelectedValue); loadDGV(); return; } catch (Exception ex) { MessageBox.Show("Duplicate entry!!!"); return; } } else { MessageBox.Show("Attendee busy on other event or seminar or stall"); } } else { MessageBox.Show("Booking full!!!"); return; } //} }
private void btnAdd_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtName.Text)) { MessageBox.Show("Please enter event name!!!"); txtName.Focus(); return; } else if (String.IsNullOrEmpty(txtDescription.Text)) { MessageBox.Show("Please enter event description!!!"); txtDescription.Focus(); return; } else if (DateTime.Compare(dtpStartDate.Value, DateTime.Now) < 0) { MessageBox.Show("Invalid start date: Date crossed already!!!"); dtpStartDate.Focus(); return; } else if (DateTime.Compare(dtpStartDate.Value, dtpEndDate.Value) >= 0) { MessageBox.Show("End date must be after start date!!!"); dtpStartDate.Focus(); return; } else { if (btnAdd.Text.Equals("ADD")) { MethodController controller = new MethodController(); if (controller.roomStatus((int)cbxRoom.SelectedValue, dtpStartDate.Value, dtpEndDate.Value)) { _event = new Event(); } else { MessageBox.Show("Room unavailable in that time period!!!"); return; } } else if (btnAdd.Text.Equals("UPDATE")) { _event.EventId = eventCode; } _event.EventName = txtName.Text.Trim(); _event.EventDescription = txtDescription.Text.Trim(); _event.EventStartDate = dtpStartDate.Value; _event.EventEndDate = dtpEndDate.Value; _event.RoomId = Convert.ToInt32(cbxRoom.SelectedValue.ToString()); try { if (btnAdd.Text.Equals("ADD")) { dbContext.Events.Add(_event); } dbContext.SaveChanges(); MessageBox.Show(String.Format("Event {0} successfully!!!", btnAdd.Text.Equals("ADD") ? "added" : "updated")); btnAdd.Text = "ADD"; txtName.Clear(); txtDescription.Clear(); loadDGV(); dtpStartDate.Enabled = dtpEndDate.Enabled = cbxRoom.Enabled = true; txtName.Focus(); return; } catch (Exception ex) { MessageBox.Show(ex.Message); } } }