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