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