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 dgvAttendeeSeminar_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dgvAttendeeSeminar.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.Equals("Delete")) { DialogResult dialogResult = MessageBox.Show("Are you sure?", "Confirm deletion", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { int attendeeId = Convert.ToInt32(dgvAttendeeSeminar.Rows[e.RowIndex].Cells["AttendeeId"].Value); int seminarId = Convert.ToInt32(dgvAttendeeSeminar.Rows[e.RowIndex].Cells["SeminarId"].Value); AttendeeSeminar attendeeSeminar = dbContext.AttendeeSeminars.Where(a => a.AttendeeId == attendeeId).Where(a => a.SeminarId == seminarId).Single(); dbContext.AttendeeSeminars.Remove(attendeeSeminar); dbContext.SaveChanges(); MessageBox.Show("Attendee removed from the seminar!!!"); loadDGV(); return; } } }