/// <summary> /// Adds a new rating and comment to the database for the selected movie. /// </summary> private void AddRating() { //Variable Declarations. LimelightBusiness business = new LimelightBusiness(repository); try { //Insert the new movie review. business.AddRating((int)cmbRating.SelectedValue, (int)lstMovieList.SelectedValue, txtComment.Text); //Refresh the list of movies. movies = business.GetAllMovies(); } catch (Exception ex) { //Handle the exception. ApplicationUtilities.CatchExceptions(ex); return; } //Re-display the movie information on the form. DisplayMovieInfo(); cmbRating.SelectedIndex = 0; txtComment.Text = ""; }
/// <summary> /// Fills the ratings combobox with the various rating levels. /// </summary> private void FillRatingsList() { //Variable Declarations. DataSet movieRatings; LimelightBusiness business = new LimelightBusiness(repository); //Get the movie titles from the database. try { movieRatings = business.GetAllRatingTitles(); } catch (Exception ex) { ApplicationUtilities.CatchExceptions(ex); return; } //Add the genre titles to the ratings combobox. DataRow emptyDataRow = movieRatings.Tables[0].NewRow(); emptyDataRow[0] = 0; emptyDataRow[1] = "Select A Rating"; movieRatings.Tables[0].Rows.InsertAt(emptyDataRow, 0); cmbRating.DataSource = movieRatings.Tables[0]; cmbRating.ValueMember = "RatingID"; cmbRating.DisplayMember = "RatingTitle"; }
private void ViewRecords_Load(object sender, EventArgs e) { //Variable Declarations. LimelightBusiness business = new LimelightBusiness(repository); //Fill the list of movies and reviews. try { movies = business.GetAllMovies(); } catch (Exception ex) { ApplicationUtilities.CatchExceptions(ex); return; } //Fill the movie titles listbox. FillMovieList(); lstMovieList.SelectedIndex = -1; //Fill the ratings combobox. FillRatingsList(); //Clear the controls on the form. ResetForm(); }
/// <summary> /// Adds the information about the new movie to the database. /// </summary> private void AddNewMovie() { //Variable Declarations. Movie newMovie = new Movie(); LimelightBusiness business = new LimelightBusiness(repository); //Take the image from the picture box and store in a byte array. MemoryStream ms = new MemoryStream(); pbMoviePoster.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] moviePoster = ms.GetBuffer(); //Set the information entered by the user into a movie object. newMovie.Title = txtMovieTitle.Text; newMovie.Synopsis = txtMovieSynopsis.Text; newMovie.ReleaseDate = dtpReleaseDate.Value; newMovie.GenreID = (int)cmbGenre.SelectedValue; //Insert the new movie information into the database. try { //Insert the new movie information into the database. business.AddMovie(newMovie, moviePoster); //Tell the user the information was added successfully. MessageBox.Show("The Information has been Added Successfully!!"); } catch (Exception ex) { //Handle an exceptions thrown. throw ex; } }
/// <summary> /// Deletes the selected movie from the database. /// </summary> private void DeleteAMovie() { //Variable Declarations. LimelightBusiness business = new LimelightBusiness(repository); try { //Delete the selected movie. business.DeleteMovie((int)lstMovieList.SelectedValue); } catch (Exception ex) { //Handle the exception. ApplicationUtilities.CatchExceptions(ex); } }
/// <summary> /// Fills the movie listbox with a list of titles for all movies in the database. /// </summary> private void FillMovieList() { //Variable Declarations. DataSet movieTitles; //AccessRepository repository = new AccessRepository(); LimelightBusiness business = new LimelightBusiness(repository); //Get the movie titles from the database. //using (repositoy) //{ // movieTitles = repository.GetAllMovieTitles(); //} movieTitles = business.GetAllMovieTitles(); lstMovieList.DataSource = movieTitles.Tables[0]; lstMovieList.ValueMember = "MovieID"; lstMovieList.DisplayMember = "Title"; }
/// <summary> /// Updates the movie information in the database. /// </summary> private void UpdateMovieInfo() { //Variable Declarations. //AccessRepository repository = new AccessRepository(); LimelightBusiness business = new LimelightBusiness(repository); //Find the movie information based on the ID value of the movie title selected. foreach (Movie movie in movies) { //Check the movie object with the matching MovieID. if (movie.MovieID == (int)lstMovieList.SelectedValue) { //Update the information for the movie selected in the movie list. movie.Title = txtMovieTitle.Text; movie.Synopsis = txtMovieSynopsis.Text; movie.ReleaseDate = dtpReleaseDate.Value; movie.GenreID = (int)cmbGenre.SelectedValue; movie.GenreTitle = cmbGenre.Text; movie.MoviePoster = new Bitmap(pbMoviePoster.Image); //Take the image from the picture box and store in a byte array. MemoryStream ms = new MemoryStream(); pbMoviePoster.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] moviePoster = ms.GetBuffer(); //Update the movie info. try { //Insert the new movie information into the database. business.UpdateMovie(movie, moviePoster); //Tell the user the information has ben updated successfully. MessageBox.Show("The information has been updated successsfully."); } catch (Exception ex) { throw ex; } break; } } }
/// <summary> /// Fills the movie listbox with a list of titles for all movies in the database. /// </summary> private void FillMovieList() { //Variable Declarations. DataSet movieTitles; LimelightBusiness business = new LimelightBusiness(repository); //Get the movie titles from the database. try { movieTitles = business.GetAllMovieTitles(); } catch (Exception ex) { ApplicationUtilities.CatchExceptions(ex); return; } //Fill the movie listbox with the movie titles. lstMovieList.DataSource = movieTitles.Tables[0]; lstMovieList.ValueMember = "MovieID"; lstMovieList.DisplayMember = "Title"; }
private void Search_Load(object sender, EventArgs e) { //Variable Declarations. LimelightBusiness business = new LimelightBusiness(repository); //Fill the list of movies and reviews. try { movies = business.GetAllMovies(); } catch (Exception ex) { ApplicationUtilities.CatchExceptions(ex); return; } //Fill the genres combobox. FillGenreList(); //Clear the controls on the form. ResetForm(); }
private void btnSearchMovie_Click(object sender, EventArgs e) { //Variable Declarations. LimelightBusiness business = new LimelightBusiness(repository); List <Movie> results = new List <Movie>(); //Validate the title if it is being used as a search criteria. if (chkSearchTitle.Checked == true) { try { business.ValidateSearchTitle(txtSearchTitle.Text); } catch (Exception ex) { //Handle an exceptions thrown. ApplicationUtilities.CatchExceptions(ex); return; } } //Validate the release date range if it is being used as a search criteria. if (chkSearchReleaseDate.Checked == true) { try { business.ValidateSearchDates(dtpSearchDateFrom.Value, dtpSearchDateTo.Value); } catch (Exception ex) { //Handle an exceptions thrown. ApplicationUtilities.CatchExceptions(ex); return; } } //Validate the release date range if it is being used as a search criteria. if (chkSearchGenre.Checked == true) { try { business.ValidateSearchGenre(cmbGenre.Text); } catch (Exception ex) { //Handle an exceptions thrown. ApplicationUtilities.CatchExceptions(ex); return; } } //Search for the movies. //xxx(); //Search for the movies with that match the entered criteria. results = SortMovies(SearchForMovies()); //Add the movie titles from the search result to the movie list box. lstMovieList.Items.Clear(); foreach (Movie movie in results) { lstMovieList.Items.Add(movie.Title); } }