private void btnConfirm_Click_1(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("Confirm this information?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { String date = ""; if (cboVenues.SelectedIndex >= 0) { if (cboYear.SelectedIndex >= 0) { String year = cboYear.Text; if (cboMonth.SelectedIndex >= 0) { String month = cboMonth.Text.Substring(0, 2); date = year + "-" + month; } else { date = year; } lblEvents.Visible = true; lblRevenue.Visible = true; lblSold.Visible = true; txtNoEvents.Visible = true; txtNoTicketsSold.Visible = true; txtRevenue.Visible = true; String venueName = cboVenues.Text; txtNoEvents.Text = Event.noEvents(date, Venue.getIDFromName(venueName)); txtNoTicketsSold.Text = Event.noTicketsSold(date, Venue.getIDFromName(venueName)); txtRevenue.Text = Event.totalRevenue(date, Venue.getIDFromName(venueName)); } else { MessageBox.Show("Please Select At Least The Year!"); return; } } else { MessageBox.Show("Please Select Venue!"); return; } } }
private void btnConfirm_Click(object sender, EventArgs e) { if (cboVenue.SelectedItem == null || txtTitle.Text == "" || txtTime.Text == "" || txtTicketsAvailable.Text == "" || txtPrice.Text == "") { MessageBox.Show("One or more fields have been left empty! Please enter all required details.", "Empty Field(s)", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } DialogResult dialogResult = MessageBox.Show("Confirm this information?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { try { Event myEvent = new Event(); myEvent.setEventID(Convert.ToInt32(txtID.Text)); String name = Convert.ToString(cboVenue.SelectedItem); myEvent.setVenueID(Venue.getIDFromName(name)); myEvent.setTitle(txtTitle.Text); myEvent.setDescription(txtDescription.Text); myEvent.setEventDate(dtpDate.Text); myEvent.setEventTime(txtTime.Text); myEvent.setTicketsAvailable(Convert.ToInt32(txtTicketsAvailable.Text)); myEvent.setPrice(Convert.ToDouble(txtPrice.Text)); myEvent.UpdateEvent(); MessageBox.Show("All Done!"); grdUpdateEvent.DataSource = Event.getActiveEventsMini().Tables["aem"]; } catch (Oracle.ManagedDataAccess.Client.OracleException) { MessageBox.Show("The price or time format you have entered is incorrect! " + "Try and put a decimal point in the price (eg. 120.00) or a colon (:) in the time box!"); } } }
private void cboVenues_SelectedIndexChanged(object sender, EventArgs e) { if (cboVenues.SelectedIndex == -1) { return; } Venue aVenue = new Venue(); aVenue.getAVenue(Venue.getIDFromName(cboVenues.Text)); txtID.Text = aVenue.getVenueID().ToString(); txtName.Text = aVenue.getVenueName().ToString(); txtCounty.Text = aVenue.getCounty().ToString(); txtTown.Text = aVenue.getTown().ToString(); txtStreet.Text = aVenue.getStreet().ToString(); txtManagerName.Text = aVenue.getManagerName().ToString(); txtManagerEmail.Text = aVenue.getManagerEmail().ToString(); txtManagerMobile.Text = aVenue.getManagerMobile().ToString(); txtMaxCapacity.Text = aVenue.getMaxCapacity().ToString(); grpBox.Visible = true; }
private void btnConfirm_Click(object sender, EventArgs e) { if (cboVenue.SelectedItem == null || txtTitle.Text == "" || txtTicketsAvailable.Text == "" || txtTime.Text == "" || txtPrice.Text == "") { MessageBox.Show("One or more fields have been left empty! Please enter all required details.", "Empty Field(s)", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } DialogResult dialogResult = MessageBox.Show("Confirm this information?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { if (!Event.checkEventTitle(txtTitle.Text, Venue.getIDFromName(cboVenue.SelectedItem.ToString()))) { String name = Convert.ToString(cboVenue.SelectedItem); Event myEvent = new Event(); DateTime dt1 = DateTime.Parse(dtpDate.Value.ToString("yyyy-MM-dd")); DateTime dt2 = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); if (dt1.Date >= dt2.Date) { myEvent.setEventID(Convert.ToInt32(txtID.Text)); myEvent.setVenueID(Venue.getIDFromName(name)); myEvent.setVenueName(name); myEvent.setTitle(Convert.ToString(txtTitle.Text)); myEvent.setDescription(Convert.ToString(txtDescription.Text)); myEvent.setEventDate(dtpDate.Value.ToString("yyyy-MM-dd")); myEvent.setEventTime(txtTime.Text); myEvent.setTicketsAvailable(Convert.ToInt32(txtTicketsAvailable.Text)); myEvent.setPrice(Convert.ToDouble(txtPrice.Text)); if (myEvent.isVenueFree(myEvent.getEventDate())) { int ticks = Venue.getMaxCapacity(cboVenue.Text); if (Convert.ToInt32(txtTicketsAvailable.Text) <= ticks) { try { myEvent.AddEvent(); MessageBox.Show("All Done!"); grdAddEvent.DataSource = Event.getActiveEventsMini().Tables["aem"]; txtID.Text = Convert.ToString(Event.getNextID()); txtTitle.Text = ""; txtDescription.Text = ""; dtpDate.Refresh(); txtTime.Text = ""; txtPrice.Text = ""; txtTicketsAvailable.Text = ""; } catch (Oracle.ManagedDataAccess.Client.OracleException) { MessageBox.Show("The price or time format you have entered is incorrect! " + "Try and put a decimal point in the price (eg. 120.00) or a colon (:) in the time box!"); } } else { MessageBox.Show("Cannot have more than " + ticks + " tickets for this venue!"); return; } } else { MessageBox.Show("This venue already has an event that day!"); return; } } else { MessageBox.Show("Event must be in the future!"); } } else { MessageBox.Show("Event with this title and venue already exists."); return; } } }