// Insert Movie public bool InsertRentedMovie(RentedMoviesData data) { SqlCommand cmd = DataBaseConnection.OpenConnection().CreateCommand(); cmd.CommandText = "RentThisMovie"; cmd.CommandType = CommandType.StoredProcedure; // store procedure cmd.Parameters.AddWithValue("@MovieID", data.MovieId); cmd.Parameters.AddWithValue("@CustID", data.CustId); cmd.Parameters.AddWithValue("@RentDate", data.RentDate); cmd.Parameters.AddWithValue("@ReturnDate", data.ReturnDate); cmd.Parameters.AddWithValue("@TotalRent", data.TotalRentAmount); bool ans = cmd.ExecuteNonQuery() > 0; cmd.Dispose(); return(ans); }
//Issue movie to selected customer private void BtnIssueMovie_Click(object sender, EventArgs e) { try { string CustId, MovieId, IssueDate, ReturnDate; int totalDays = 0; int temp = 0; int TotalRent = 0; CustId = DropDownSelectCustomer.SelectedValue.ToString(); MovieId = DropDownMovie.SelectedValue.ToString(); IssueDate = dtIsuue.Value.ToShortDateString(); ReturnDate = dtReturn.Value.ToShortDateString(); if (CustId == "" || CustId == "0" || CustId == null) { MessageBox.Show("Please select customer"); } else if (MovieId.Equals("") || MovieId == "0" || MovieId == null) { MessageBox.Show("Please select movie"); } else if (DateTime.Parse(IssueDate) > DateTime.Parse(ReturnDate)) { MessageBox.Show("Issue date can not be greater than retun date", "Alert"); } else if (IssueDate == ReturnDate) { totalDays = 1; temp = new Movies().CalculateMovieCost(int.Parse(MovieId)); // Getting rent amount for that movie TotalRent = totalDays * temp; // Calculate the Total Rent of issue movie } else { totalDays = new CalculateDays().TotalDays(IssueDate, ReturnDate); temp = new Movies().CalculateMovieCost(int.Parse(MovieId)); // Getting rent amount for that movie TotalRent = totalDays * temp; // Calculate the Total Rent of issue movie } RentedMoviesData rmdata = new RentedMoviesData { MovieId = int.Parse(MovieId), CustId = int.Parse(CustId), RentDate = IssueDate, ReturnDate = ReturnDate, TotalRentAmount = TotalRent }; if (new RentedMOvies().InsertRentedMovie(rmdata)) { TabControlSystem.SelectedTab = TabControlSystem.TabPages["RentedMovies"]; RentedMovieGridData(); MessageBox.Show("Movie rented successfully!"); } else { MessageBox.Show("Failed to rent this movie!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }