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)
            {
                if (Utilities.IsValid(txtManagerEmail.Text))
                {
                    if (!Venue.checkVenueName(txtName.Text))
                    {
                        Venue myVenue = new Venue();

                        myVenue.setVenueID(Convert.ToInt32(txtID.Text));
                        myVenue.setVenueName(txtName.Text);
                        myVenue.setStreet(txtStreet.Text);
                        myVenue.setTown(txtTown.Text);
                        myVenue.setCounty(txtCounty.Text);
                        myVenue.setManagerName(txtManagerName.Text);
                        myVenue.setManagerEmail(txtManagerEmail.Text);
                        myVenue.setManagerMobile(txtManagerMobile.Text);
                        myVenue.setMaxCapacity(Convert.ToInt32(txtMaxCapacity.Text));

                        myVenue.AddVenue();
                        MessageBox.Show("All Done!");
                        grdAddVenue.DataSource = Venue.getActiveVenuesMini().Tables["avm"];
                    }
                    else
                    {
                        MessageBox.Show("Venue with this name already exists.");
                        return;
                    }
                }
                else
                {
                    MessageBox.Show("Email format not valid.");
                    return;
                }
            }
        }