// Insert Movie public bool InsertRentedMovie(RentedMoviesDataTbl data) { SqlCommand cmd = DataBaseConnection.OpenConnection().CreateCommand(); cmd.CommandText = "RentThisMovieNow"; 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().GetTotalDays(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 } RentedMoviesDataTbl rmdata = new RentedMoviesDataTbl(); rmdata.MovieId = int.Parse(MovieId); rmdata.CustId = int.Parse(CustId); rmdata.RentDate = IssueDate; rmdata.ReturnDate = ReturnDate; rmdata.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); } }