private void DeleteCustomer_Click(object sender, EventArgs e) { if (NetworkingHelpers.GetUserRentedMovies(CustomerRowID) > 0) { DisplayError("This Customer has rented movies!"); } else { // Delete the customer from list using (SqlConnection conn = new SqlConnection(NetworkingHelpers.HostConfig())) { // Open Connection conn.Open(); string query = "DELETE FROM Customers WHERE CustomerID=@custID"; SqlCommand _cmd = new SqlCommand(query, conn); _cmd.Parameters.AddWithValue("@custID", CustomerRowID); _cmd.ExecuteNonQuery(); } // Update the list GetCustomersList(); ResetCustomersField(); } }
private void DeleteCustomer_Click(object sender, EventArgs e) { if (NetworkingHelpers.GetUserRentedMovies(CustomerRowID) > 0) { DisplayError("This Customer has rented movies!"); } else { // Delete the customer from list NetworkingHelpers.DeleteFromTable("Customers", "CustomerID", CustomerRowID.ToString()); // Update the list GetCustomersList(); ResetCustomersField(); } }