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