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