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;
}
}
}
