private void DeleteMovie_Click(object sender, EventArgs e)
{
if (NetworkingHelpers.GetMovieOnRent(MovieRowID) > 0)
{
DisplayError("Copy of this movie is Currently on Rent!");
}
else
{
NetworkingHelpers.DeleteFromTable("Movies", "MovieID", MovieRowID.ToString());
GetMoviesList();
}
}
private void DeleteMovie_Click(object sender, EventArgs e)
{
if (NetworkingHelpers.GetMovieOnRent(MovieRowID) > 0)
{
DisplayError("Copy of this movie is Currently on Rent!");
}
else
{
// Delete the customer from list
using (SqlConnection conn = new SqlConnection(NetworkingHelpers.HostConfig()))
{
// Open Connection
conn.Open();
string query = "DELETE FROM Movies WHERE MovieID=@movID";
SqlCommand _cmd = new SqlCommand(query, conn);
_cmd.Parameters.AddWithValue("@movID", MovieRowID);
_cmd.ExecuteNonQuery();
}
GetMoviesList();
}
}