private void btnConfirm_Click(object sender, EventArgs e)
{
if (txtManagerEmail.Text == "" || txtName.Text == "" || txtStreet.Text == "" || txtTown.Text == "" ||
txtCounty.Text == "" || txtManagerName.Text == "" || txtManagerMobile.Text == "" || txtMaxCapacity.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)
{
Venue myVenue = new Venue();
myVenue.setVenueID(Convert.ToInt32(txtID.Text));
myVenue.setVenueName(txtName.Text);
myVenue.setStreet(txtStreet.Text);
myVenue.setCounty(txtCounty.Text);
myVenue.setManagerName(txtManagerName.Text);
myVenue.setManagerEmail(txtManagerEmail.Text);
myVenue.setManagerMobile(txtManagerMobile.Text);
myVenue.setMaxCapacity(Convert.ToInt32(txtMaxCapacity.Text));
myVenue.UpdateVenue();
MessageBox.Show("All Done!");
grdVenues.DataSource = Venue.getActiveVenuesMini().Tables["avm"];
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Delete this venue?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
Venue myVenue = new Venue();
myVenue.setVenueID(Convert.ToInt32(txtID.Text));
myVenue.CancelVenue();
MessageBox.Show("Venue Removed! (Set to unavailable)");
grpBox.Visible = false;
loadVenues();
}
}
public Boolean isVenueFree(String date)
{
Venue ven = new Venue();
ven.setVenueID(this.venueID);
String sql = "SELECT COUNT(E.VENUEID) From Events E Join Venues V ON E.VenueID = V.VenueID WHERE EventDate = '" + date + "' AND E.VenueID = '" + this.getVenueID() + "'";
OracleConnection conn = new OracleConnection(DBConnect.oradb);
conn.Open();
OracleCommand cmd = new OracleCommand(sql, conn);
OracleDataAdapter da = new OracleDataAdapter(cmd);
Boolean result = false;
using (OracleDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int nxt = reader.GetInt32(0);
if (nxt == 0)
{
result = true;
}
else if (nxt >= 1)
{
result = false;
}
}
}
return(result);
}
