private void dg_AttendeeSchedule_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int id = Convert.ToInt32(dg_AttendeeSchedule.Rows[e.RowIndex].Cells["AttendeeId"].Value);
if (dg_AttendeeSchedule.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
string command = dg_AttendeeSchedule.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
if (command.ToLower() == "delete")
{
try
{
if (MessageBox.Show("Do you want to delete", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
var attendees = db.Attendees.Where(rm => rm.AttendeeId == id).FirstOrDefault();
db.Attendees.Remove(attendees);
db.SaveChanges();
MessageBox.Show("Attendee Successfully deleted");
LoadAttendee();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void dgvEvent_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int id = Convert.ToInt32(dg_Event.Rows[e.RowIndex].Cells["EventId"].Value);
if (dg_Event.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
string command = dg_Event.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
if (command.ToLower() == "delete")
{
try
{
if (MessageBox.Show("Do you want to delete", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
var Event = db.Events.Where(ev => ev.EventId == id).Include(ev => ev.AttendeeEvents).Include(ev => ev.Room).FirstOrDefault();
db.Events.Remove(Event);
db.SaveChanges();
MessageBox.Show("Event Successfully deleted");
LoadEvent();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (command.ToLower() == "edit")
{
AddEvent addEvent = new AddEvent(id);
addEvent.Show();
}
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);
if (dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
string command = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
if (command.ToLower() == "delete")
{
try
{
if (MessageBox.Show("Are you sure to Delete", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
var seminar = db.Seminars.Where(ss => ss.Id == id).Include(s => s.AudiencePerSeminars).Include(s => s.PresentersPerSeminars).Include(s => s.RoomStallLocation).FirstOrDefault();
//db.Entry(seminar).State = EntityState.Deleted;
db.Seminars.Remove(seminar);
db.SaveChanges();
MessageBox.Show("Seminar Successfully deleted");
LoadSeminars();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (command.ToLower() == "edit")
{
AddSeminar addSeminar = new AddSeminar(id);
addSeminar.Show();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!CheckInput(txt_OldPassword))
{
throw new Exception("Please enter Old password");
}
if (!CheckInput(txt_NewPassword))
{
throw new Exception("Please enter New password");
}
var check = db.Attendees.Single(up => up.Password == txt_OldPassword.Text);
if (check != null)
{
if (txt_RenewPassword.Text == txt_NewPassword.Text)
{
var update = (from a in db.Attendees where a.AttendeeId == Loggeduser select a).First();
update.Password = txt_NewPassword.Text;
db.SaveChanges();
MessageBox.Show("Updated successfully");
}
else
{
MessageBox.Show("Incorrect Re-Password");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!CheckInput(txt_Name))
{
throw new Exception("Please enter Name");
}
if (!CheckInput(txt_Email))
{
throw new Exception("Please enter Email");
}
if (!CheckInput(txt_AttendDays))
{
throw new Exception("Please enter Attend days");
}
var check = db.Attendees.Single(up => up.Password == txt_ConfirmPassword.Text);
if (check != null)
{
var update = (from a in db.Attendees where a.AttendeeId == Loggeduser select a).First();
update.Email = txt_Email.Text;
update.Name = txt_Name.Text;
update.TypeTicket = cmb_Ticket.Text.ToString();
update.AttendDays = Convert.ToInt32(txt_AttendDays.Text);
db.SaveChanges();
MessageBox.Show("Updated successfully");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!CheckInput(txt_Email))
{
throw new Exception("Please enter Email");
}
if (!CheckInput(txt_Name))
{
throw new Exception("Please enter Name");
}
if (!CheckInput(txt_AttendDays))
{
throw new Exception("Please enter Attend days");
}
Attendee attendee = new Attendee();
attendee.Name = txt_Name.Text;
attendee.Email = txt_Email.Text;
attendee.TypeTicket = cmb_TicketType.Text.ToString();
attendee.Password = "******";
attendee.AttendDays = Convert.ToInt32(txt_AttendDays.Text);
db.Attendees.Add(attendee);
db.SaveChanges();
MessageBox.Show("added successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (!CheckInput(txt_Location))
{
throw new Exception("Please enter Location");
}
if (!CheckInput(txt_Capacity))
{
throw new Exception("Please enter Capacity");
}
if (!CheckInput(txt_Resources))
{
throw new Exception("Please enter Resources");
}
Room room = new Room();
room.Location = txt_Location.Text;
room.Resources = txt_Resources.Text;
room.Capacity = Convert.ToInt32(txt_Capacity.Text);
db.Rooms.Add(room);
db.SaveChanges();
MessageBox.Show("Room added successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void dg_Room_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int id = Convert.ToInt32(dg_Room.Rows[e.RowIndex].Cells["RoomId"].Value);
if (dg_Room.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
string command = dg_Room.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
if (command.ToLower() == "delete")
{
try
{
if (MessageBox.Show("Do you want to delete", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
var Room = db.Rooms.Where(r => r.RoomId == id).FirstOrDefault();
db.Rooms.Remove(Room);
db.SaveChanges();
MessageBox.Show("Room Successfully deleted");
LoadRoom();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (command.ToLower() == "edit")
{
AddRoom addRoom = new AddRoom();
addRoom.Show();
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Sure to delete account", "Delete Account?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
var attendee = db.Attendees.Where(a => a.AttendeeId == Loggeduser).Include(a => a.PresenterSeminars).Include(a => a.AudienceSeminars).Include(a => a.AttendeeEvents).Include(a => a.AttendeeStalls).FirstOrDefault();
db.Attendees.Remove(attendee);
db.SaveChanges();
Loggeduser = 0;
Login User = new Login();
MessageBox.Show("Account deleted successfully");
User.Show();
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ConventionSystemContext db = new ConventionSystemContext();
Attendee attendee = new Attendee();
attendee.Name = textBox1.Text;
attendee.Email = textBox2.Text;
attendee.TicketType = textBox3.Text;
attendee.DaysOfAttend = Convert.ToInt32(textBox4.Text);
db.Attendees.Add(attendee);
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
Seminar seminar = new Seminar();
seminar.Title = txtTitle.Text;
seminar.SeminarDateTime = GetSeminarStartDateTime();
seminar.RoomSize = Convert.ToInt32(txtRoomSize.Text);
seminar.Duration = Convert.ToInt32(txtDuration.Text);
db.Seminars.Add(seminar);
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
Attendee attendee = new Attendee();
attendee.Name = txtName.Text;
attendee.Email = txtEmail.Text;
attendee.Password = txtPassword.Text;
attendee.TicketType = cbTicketType.SelectedItem.ToString();
attendee.DaysOfAttend = Convert.ToInt32(txtAttendDays.Text);
db.Attendees.Add(attendee);
db.SaveChanges();
MessageBox.Show("Added successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSignup_Click(object sender, EventArgs e)
{
try
{
if (!CheckInput(txt_Email))
{
throw new Exception("Please enter Email");
}
if (!CheckInput(txt_Name))
{
throw new Exception("Please enter name");
}
if (!CheckInput(txt_Password))
{
throw new Exception("Please enter password");
}
if (!CheckInput(txt_AttendDays))
{
throw new Exception("Please enter attend days");
}
if (txt_Password.Text == txt_Repassword.Text)
{
Attendee attendee = new Attendee();
attendee.Name = txt_Name.Text;
attendee.Email = txt_Email.Text;
attendee.Password = txt_Password.Text;
attendee.TypeTicket = cmb_TicketType.Text.ToString();
attendee.AttendDays = Convert.ToInt32(txt_AttendDays.Text);
db.Attendees.Add(attendee);
db.SaveChanges();
MessageBox.Show("Account created successfully");
}
else
{
MessageBox.Show("Incorrect Repassword");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!CheckInputs(txtTitle))
{
throw new Exception("Please enter Title");
}
//if (!CheckInputs(txtRoomSize))
//{
// throw new Exception("Please enter Room Size");
//}
if (!CheckInputs(txtDuration))
{
throw new Exception("Please enter Duration");
}
Seminar seminar;
List <AudiencePerSeminar> audiencePerSeminars = new List <AudiencePerSeminar>();
List <PresentersPerSeminar> presentersPerSeminars = new List <PresentersPerSeminar>();
if (seminarId > 0)
{
seminar = db.Seminars.Find(seminarId);
audiencePerSeminars = seminar.AudiencePerSeminars;
presentersPerSeminars = seminar.PresentersPerSeminars;
}
else
{
seminar = new Seminar();
//audiencePerSeminars = new List<AudiencePerSeminar>();
//presentersPerSeminars = new List<PresentersPerSeminar>();
if (CheckSeminarExists(GetSeminarStartDateTime(), GetSeminarEndDateTime()))
{
throw new Exception("There is already a seminar in this time");
}
}
seminar.Title = txtTitle.Text;
seminar.SeminarDateTime = GetSeminarStartDateTime();
seminar.RoomStallLocationId = Convert.ToInt32(cbRoom.SelectedValue);
//seminar.RoomStallLocation = db.RoomStallLocations.Find(Convert.ToInt32(cbRoom.SelectedValue));
seminar.Duration = Convert.ToInt32(txtDuration.Text);
foreach (int id in attendeeIds)
{
AudiencePerSeminar audiencePerSeminar = new AudiencePerSeminar();
audiencePerSeminar.Attendee = db.Attendees.Find(id);
audiencePerSeminar.Seminar = seminar;
var attendee = audiencePerSeminars.Where(aps => aps.AttendeeId == id).FirstOrDefault();
if (attendee == null)
{
audiencePerSeminars.Add(audiencePerSeminar);
}
}
foreach (int id in presenterIds)
{
PresentersPerSeminar presentersPerSeminar = new PresentersPerSeminar();
presentersPerSeminar.Presenter = db.Attendees.Find(id);
presentersPerSeminar.Seminar = seminar;
var presenter = presentersPerSeminars.Where(aps => aps.AttendeeId == id).FirstOrDefault();
if (presenter == null)
{
presentersPerSeminars.Add(presentersPerSeminar);
}
}
//if (audiencePerSeminars.Count < 1)
//{
// throw new Exception("Please add Audience");
//}
//if (presentersPerSeminars.Count < 1)
//{
// throw new Exception("Please add Presenter");
//}
seminar.AudiencePerSeminars = audiencePerSeminars;
if (seminar.AudiencePerSeminars.Count > db.RoomStallLocations.Find(cbRoom.SelectedValue).Capacity)
{
throw new Exception("Room Capacity is Full");
}
seminar.PresentersPerSeminars = presentersPerSeminars;
if (seminarId > 0)
{
db.Seminars.Attach(seminar);
}
else
{
db.Seminars.Add(seminar);
}
db.SaveChanges();
MessageBox.Show("Seminar successfully added");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnAddEvent_Click(object sender, EventArgs e)
{
try
{
if (!CheckInput(txt_StallCode))
{
throw new Exception("Please enter Title");
}
if (!CheckInput(txt_Duration))
{
throw new Exception("Please enter Duration");
}
if (!CheckInput(txt_StallSize))
{
throw new Exception("Please enter Description");
}
if (!CheckInput(txt_StallType))
{
throw new Exception("Please enter Description");
}
Stall stalls;
List <AttendeePerStall> attendeestalls = new List <AttendeePerStall>();
if (StallId > 0)
{
stalls = db.Stalls.Find(StallId);
attendeestalls = stalls.AttendeeStalls;
}
else
{
stalls = new Stall();
if (CheckStalls(getStallStartDateTime(), getStallEndDateTime()))
{
throw new Exception("Time is already booked for another stall");
}
}
stalls.StallCode = txt_StallCode.Text;
stalls.StallType = txt_StallType.Text;
stalls.Size = Convert.ToInt32(txt_StallSize.Text);
stalls.StartingTime = getStallStartDateTime();
stalls.RoomId = Convert.ToInt32(cmb_Room.SelectedValue);
stalls.Duration = Convert.ToInt32(txt_Duration.Text);
foreach (int id in attendeeIds)
{
AttendeePerStall attendeeStall = new AttendeePerStall();
attendeeStall.Exhibitor = db.Attendees.Find(id);
attendeeStall.Stall = stalls;
var attendeeCheck = attendeestalls.Where(sa => sa.AttendeeId == id).FirstOrDefault();
if (attendeeCheck == null)
{
attendeestalls.Add(attendeeStall);
}
}
if (attendeestalls.Count < 1)
{
throw new Exception("Please add Exhibitor");
}
stalls.AttendeeStalls = attendeestalls;
if (Convert.ToInt32(txt_StallSize.Text) > db.Rooms.Find(cmb_Room.SelectedValue).Capacity)
{
throw new Exception("Stall size cannot be greater than room capacity");
}
if (stalls.AttendeeStalls.Count > db.Rooms.Find(cmb_Room.SelectedValue).Capacity)
{
throw new Exception("Max room capacity");
}
if (StallId > 0)
{
db.Stalls.Attach(stalls);
}
else
{
db.Stalls.Add(stalls);
}
db.SaveChanges();
MessageBox.Show("Stall successfully added");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnAddEvent_Click(object sender, EventArgs e)
{
try
{
if (!CheckInput(txt_Title))
{
throw new Exception("Please enter Title");
}
if (!CheckInput(txt_Duration))
{
throw new Exception("Please enter Duration");
}
if (!CheckInput(txt_Description))
{
throw new Exception("Please enter Description");
}
Event events;
List <AttendeePerEvent> attendeeEvents = new List <AttendeePerEvent>();
if (EventId > 0)
{
events = db.Events.Find(EventId);
attendeeEvents = events.AttendeeEvents;
}
else
{
events = new Event();
if (CheckEvents(getEventStartDateTime(), getEventEndDateTime()))
{
throw new Exception("Time is already booked for another event");
}
}
events.EventTitle = txt_Title.Text;
events.EventDate = getEventStartDateTime();
events.RoomId = Convert.ToInt32(cmb_Room.SelectedValue);
events.Duration = Convert.ToInt32(txt_Duration.Text);
foreach (int id in attendeeIds)
{
AttendeePerEvent attendeeEvent = new AttendeePerEvent();
attendeeEvent.Attendee = db.Attendees.Find(id);
attendeeEvent.Event = events;
var attendeeCheck = attendeeEvents.Where(ae => ae.AttendeeId == id).FirstOrDefault();
if (attendeeCheck == null)
{
attendeeEvents.Add(attendeeEvent);
}
}
if (attendeeEvents.Count < 1)
{
throw new Exception("Please add Attendee");
}
events.AttendeeEvents = attendeeEvents;
if (events.AttendeeEvents.Count > db.Rooms.Find(cmb_Room.SelectedValue).Capacity)
{
throw new Exception("Max room capacity");
}
if (EventId > 0)
{
db.Events.Attach(events);
}
else
{
db.Events.Add(events);
}
db.SaveChanges();
MessageBox.Show("Event successfully added");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnAddSeminar_Click(object sender, EventArgs e)
{
try
{
if (!CheckInput(txt_Title))
{
throw new Exception("Please enter Title");
}
if (!CheckInput(txt_Duration))
{
throw new Exception("Please enter Duration");
}
Seminar seminar;
List <AudiencePerSeminar> audienceSeminars = new List <AudiencePerSeminar>();
List <PresenterPerSeminar> presenterSeminars = new List <PresenterPerSeminar>();
if (seminarId > 0)
{
seminar = db.Seminars.Find(seminarId);
audienceSeminars = seminar.AudienceSeminars;
presenterSeminars = seminar.PresenterSeminars;
}
else
{
seminar = new Seminar();
if (CheckSeminar(getSeminarStartDateTime(), getSeminarEndDateTime()))
{
throw new Exception("Time is already booked for another seminar");
}
}
seminar.SeminarTitle = txt_Title.Text;
seminar.SeminarStartTime = getSeminarStartDateTime();
seminar.RoomId = Convert.ToInt32(cmb_Room.SelectedValue);
seminar.Duration = Convert.ToInt32(txt_Duration.Text);
foreach (int id in attendeeIds)
{
AudiencePerSeminar audienceSeminar = new AudiencePerSeminar();
audienceSeminar.Attendee = db.Attendees.Find(id);
audienceSeminar.Seminar = seminar;
var attendeeCheck = audienceSeminars.Where(au => au.AttendeeId == id).FirstOrDefault();
if (attendeeCheck == null)
{
audienceSeminars.Add(audienceSeminar);
}
}
foreach (int id in presenterIds)
{
PresenterPerSeminar presenterSeminar = new PresenterPerSeminar();
presenterSeminar.Presenter = db.Attendees.Find(id);
presenterSeminar.Seminar = seminar;
var presenter = presenterSeminars.Where(pa => pa.AttendeeId == id).FirstOrDefault();
if (presenter == null)
{
presenterSeminars.Add(presenterSeminar);
}
}
if (audienceSeminars.Count < 1)
{
throw new Exception("Please add Audience");
}
if (presenterSeminars.Count < 1)
{
throw new Exception("Please add Presenter");
}
seminar.AudienceSeminars = audienceSeminars;
if (seminar.AudienceSeminars.Count > db.Rooms.Find(cmb_Room.SelectedValue).Capacity)
{
throw new Exception("Max room capacity");
}
seminar.PresenterSeminars = presenterSeminars;
if (seminarId > 0)
{
db.Seminars.Attach(seminar);
}
else
{
db.Seminars.Add(seminar);
}
db.SaveChanges();
MessageBox.Show("Seminar successfully added");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
