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