private void btnMake_A_Booking_Click(object sender, EventArgs e)
{
this.Hide();
Bookings_Movies booking = new Bookings_Movies();
booking.ShowDialog();
}
private void btnDelete_AllBookings_Click(object sender, EventArgs e)
{
dt.Clear();
Main cinema = new Main();
string select_movies = "SELECT * FROM BOOKING WHERE Customer_ID = " + spinDeleteAll_Bookings.Value.ToString() + ";";
SqlCommand cmd;
try
{
string delete_all = "DELETE FROM BOOKING WHERE Customer_ID = " + spinDeleteAll_Bookings.Value.ToString();
cinema.conn = new SqlConnection(cinema.constr);
cinema.conn.Open();
cinema.com = new SqlCommand(select_movies, cinema.conn);
cmd = new SqlCommand(delete_all, cinema.conn);
cinema.adap = new SqlDataAdapter();
cinema.adap.SelectCommand = cinema.com;
cinema.adap.Fill(dt);
if (dt.Rows.Count > 0)
{
cmd.ExecuteNonQuery();
cinema.conn.Close();
DialogResult confirm_deletions = MessageBox.Show($"Bookings with Customer_ID {spinDeleteAll_Bookings.Value} deleted successfully!", "SUCCESS", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (confirm_deletions == DialogResult.OK)
{
this.Hide();
bookings.ShowDialog();
}
}
else
{
MessageBox.Show("Customer_ID does not exist", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception err)
{
MessageBox.Show(err.Message + " Failed to delete selected records...", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
