private void ReturnMovie_Click(object sender, EventArgs e) { NetworkingHelpers.DeleteFromTable("Rented", "RentalID", RentalRawID.ToString()); using (SqlConnection conn = new SqlConnection(NetworkingHelpers.HostConfig())) { // Open Connection conn.Open(); // Execute Query using (SqlCommand _cmd = new SqlCommand("UPDATE Movies SET MovieCopies=@copies WHERE MovieID=@id", conn)) { int copies = 0; SqlCommand _getCopies = new SqlCommand("SELECT MovieCopies FROM Movies WHERE MovieID=@id", conn); _getCopies.Parameters.AddWithValue("@id", MovieRowID); SqlDataReader reader = _getCopies.ExecuteReader(); while (reader.Read()) { copies = Convert.ToInt32(reader["MovieCopies"]); } reader.Close(); _cmd.Parameters.AddWithValue("@copies", copies + 1); _cmd.Parameters.AddWithValue("@id", MovieRowID); _cmd.ExecuteNonQuery(); } // Update Tables to keep the table data in sync with database GetMoviesList(); GetRentingList(); } }
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 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(); } }