private MediaType _medium; //Backing Field for medium //Constructor // Precondition: None // Postcondition: A library movie is instantiated and given a library itme attributes in addition to // a director, medium, and rating. public LibraryMovie(string theTitle, string thePublisher, int theCopyrightYear, int theLoanPeriod, string theCallNumber, double theDuration, string theDirector, MediaType theMedium, MPAARatings theRating) : base(theTitle, thePublisher, theCopyrightYear, theLoanPeriod, theCallNumber, theDuration) { Director = theDirector; Rating = theRating; }
// Parameter constructor public LibraryMovie(string theTitle, string thePublisher, int theCopyrightYear, string theCallNumber, int theLoanPeriod, double theDuration, string theDirector, MediaType medium, MPAARatings rating) : base(theTitle, thePublisher, theCopyrightYear, theCallNumber, theLoanPeriod, theDuration) { // validate via properties Director = theDirector; Medium = medium; Rating = rating; }
/// <summary> /// Gets the search results for display on the page /// </summary> public void OnGet() { //MPAARatings = Request.Query["MPAARatings"]; //SearchTerms = Request.Query["SearchTerms"]; //Genres = Request.Query["Genres"]; //Movies = MovieDatabase.Search(SearchTerms); //Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); //Movies = MovieDatabase.FilterByRottenTomatoes(Movies, TomMin, TomMax); //Movies = MovieDatabase.FilterByGenre(Movies, Genres); //Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); Movies = MovieDatabase.All; // Search movie titles for the SearchTerms if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.InvariantCultureIgnoreCase)); } // Filter by MPAA Rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } if (TomMax != null || TomMin != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating != null && (movie.RottenTomatoesRating <TomMax && movie.RottenTomatoesRating> TomMin)); } if (IMDBMax != null || IMDBMin != null) { Movies = Movies.Where(movie => movie.IMDBRating != null && (movie.IMDBRating <IMDBMax && movie.IMDBRating> IMDBMin)); } }
/// <summary> /// Gets the search results for display on the page /// </summary> public void OnGet(double?IMDBMin, double?IMDBMax) { /* * Movies = MovieDatabase.All; * * SearchTerms = Request.Query["SearchTerms"]; * MPAARatings = Request.Query["MPAARatings"]; * Genres = Request.Query["Genres"]; * * this.IMDBMin = IMDBMin; * this.IMDBMax = IMDBMax; */ Movies = MovieDatabase.All; // Search movie title for the SearchTerms if (SearchTerms != null) { Movies = Movies.Where(movie => { return(movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase)); }); } if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating)); } if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre)); } }
public void OnGet(double?IMDBMin, double?IMDBMax, double?RTMin, double?RTMax) { /* * this.IMDBMin = IMDBMin; * this.IMDBMax = IMDBMax; * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); * Movies = MovieDatabase.FilterByGenre(Movies, Genres); * Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); * Movies = MovieDatabase.FilterByRTRating(Movies, RTMin, RTMax); */ Movies = MovieDatabase.All; if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase)); } if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre) ); } }
public LibraryMovie(string title, string publisher, int copyrightYr, int loanPd, string callNum, double duration, string director, MediaType medium, MPAARatings rating) : base(title, publisher, copyrightYr, loanPd, callNum, duration) { Director = director; }
/// <summary> /// Gets the search results for display on the page /// </summary> public void OnGet(double?IMDBMin, double?IMDBMax, double?RTMin, double?RTMax) { //this.IMDBMin = IMDBMin; //this.IMDBMax = IMDBMax; //this.RTMax = RTMax; //this.RTMin = RTMin; //SearchTerms = Request.Query["SearchTerms"]; //MPAARatings = Request.Query["MPAARatings"]; //Genres = Request.Query["Genres"]; //Movies = MovieDatabase.Search(SearchTerms); //Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); //Movies = MovieDatabase.FilterByGenres(Movies, Genres); //Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); //Movies = MovieDatabase.FilterByRTRating(Movies, RTMin, RTMax); Movies = MovieDatabase.All; if (SearchTerms != null) { Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase)); //Movies = from movie in Movies // where movie.Title.Contains(SearchTerms, StringComparison.OrdinalIgnoreCase) // select movie; } if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating)); } if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre)); } if (IMDBMin == null && IMDBMax != null) { Movies = Movies.Where(movie => movie.IMDBRating <= IMDBMax); } if (IMDBMax == null && IMDBMin != null) { Movies = Movies.Where(movie => movie.IMDBRating >= IMDBMin); } if (IMDBMax != null && IMDBMin != null) { Movies = Movies.Where(movie => movie.IMDBRating >= IMDBMin && movie.IMDBRating <= IMDBMax); } if (RTMin == null && RTMin != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating <= RTMax); } if (RTMax == null && RTMin != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating >= RTMin); } if (RTMax != null && RTMin != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating >= RTMin && movie.RottenTomatoesRating <= RTMax); } }
private MediaType _movieMedium; // The movie's medium #endregion Fields #region Constructors // Precondition: None // Postcondition: The movie has been initialized with the specified // values for title, publisher, copyright year, loan period, // call number, duration, director, medium, and rating. The // item is not checked out. public LibraryMovie(String theTitle, String thePublisher, int theCopyrightYear, int theLoanPeriod, String theCallNumber, double theDuration, String theDirector, MediaType theMedium, MPAARatings theRating) : base(theTitle, thePublisher, theCopyrightYear, theLoanPeriod, theCallNumber, theDuration) { Director = theDirector; Medium = theMedium; Rating = theRating; }
private MPAARatings _rating; // the movie's rating // Precondition: theCopyrightYear >= 0 // theLoanPeriod >= 0 // theDuration >= 0 // theTitle,theDirector, and theCallNumber may not be null or empty // Postcondition: The library movie item has been initialized with the specified // values for title, publisher, copyright year, loan period, call number, // duration. The item is not checked out public LibraryMovie(string theTitle, string thePublisher, int theCopyrightYear, string theCallNumber, int theLoanPeriod, double theDuration, string theDirector, MediaType theMedium, MPAARatings theRating) : base(theTitle, thePublisher, theCopyrightYear, theCallNumber, theLoanPeriod, theDuration) { Medium = theMedium; Director = theDirector; Rating = theRating; ReturnToShelf(); // Make sure movie is not checked out }
public void OnGet() { Movies = MovieDatabase.All; if (SearchTerms != null) { Movies = MovieDatabase.All.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase)); } if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating)); } if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre)); } if (IMDBMin != null || IMDBMax != null) { if (IMDBMin == null) { Movies = Movies.Where(movie => movie.IMDBRating <= IMDBMax); } else if (IMDBMax == null) { Movies = Movies.Where(movie => movie.IMDBRating >= IMDBMin); } else { Movies = Movies.Where(movie => movie.IMDBRating >= IMDBMin && movie.IMDBRating <= IMDBMax); } } if (RTMin != null || RTMax != null) { if (RTMin == null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating <= RTMax); } else if (RTMax == null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating >= RTMin); } else { Movies = Movies.Where(movie => movie.RottenTomatoesRating >= RTMin && movie.RottenTomatoesRating <= RTMax); } } }
/* * /// <summary> * /// The current search terms * /// </summary> * [BindProperty] * public string SearchTerms { get; set; } = ""; * * /// <summary> * /// The filtered MPAA Ratings * /// </summary> * [BindProperty] * public string[] MPAARatings { get; set; } * * /// <summary> * /// The filtered genres * /// </summary> * [BindProperty] * public string[] Genres { get; set; } * * /// <summary> * /// The minimum IMDB Rating * /// </summary> * [BindProperty] * public double? IMDBMin { get; set; } * * /// <summary> * /// The maximum IMDB Rating * /// </summary> * [BindProperty] * public double? IMDBMax { get; set; } */ public void OnGet(double?IMDBMin, double?IMDBMax) { /* * MPAARatings = Request.Query["MPAARatings"]; * String terms = Request.Query["SearchTerms"]; * Movies = MovieDatabase.Search(SearchTerms); */ //var MPAARatings = Request.Query["MPAARatings"]; /* * //SearchTerms = Request.Query["SearchTerms"]; * MPAARatings = Request.Query["MPAARatings"]; * //IMDBMin = double.Parse(Request.Query["IMDBMin"]); * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); * */ /* * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); * Movies = MovieDatabase.FilterByGenre(Movies, Genres); * Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); */ /* * // Nullable conversion workaround * this.IMDBMin = IMDBMin; * this.IMDBMax = IMDBMax; * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); * Movies = MovieDatabase.FilterByGenre(Movies, Genres); * Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); */ //search movie titles for the search terms Movies = MovieDatabase.All; if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase)); //.Select(movie => movie.Title) //Movies = from movie in Movies //where movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase) //select movie; } //filter by mpaa rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(Movie => Movie.MPAARating != null && MPAARatings.Contains(Movie.MPAARating)); } }
public SelectList GetAllRatingsWithID(int id) { string MPAAStringToDisplay = Enum.GetName(typeof(AllMPAARatings), id); MPAARatings MPAARatingsToDisplay = (MPAARatings)Enum.Parse(typeof(MPAARatings), MPAAStringToDisplay); var MPAASelectList = new SelectList(Enum.GetValues(typeof(AllMPAARatings)).Cast <AllMPAARatings>().Select(v => new SelectListItem { Text = v.ToString(), Value = ((int)v).ToString() }).ToList(), "Value", "Text", ((int)MPAARatingsToDisplay + 1)); return(MPAASelectList); }
public void OnGet() { Movies = MovieDatabase.All; if (SearchTerms != null) { Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.InvariantCultureIgnoreCase)); } if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating)); } }
/// <summary> /// Gets the search results for display on the page /// </summary> public void OnGet(double?IMDBMin, double?IMDBMax, double?RottenMin, double?RottenMax) { // Nullable conversion workaround SearchTerms = Request.Query["SearchTerms"]; MPAARatings = Request.Query["MPAARatings"]; Genres = Request.Query["Genres"]; this.IMDBMin = IMDBMin; this.IMDBMax = IMDBMax; this.RottenMin = RottenMin; this.RottenMax = RottenMax; Movies = MovieDatabase.All; // Search movie titles for the SearchTerms if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.InvariantCultureIgnoreCase) ); } // Filter by MPAA Rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre) ); } if (IMDBMin != null && IMDBMax != null) { Movies = Movies.Where(movie => movie.IMDBRating <= IMDBMax && movie.IMDBRating >= IMDBMin ); } if (RottenMax != null && RottenMin != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating <= RottenMax && movie.RottenTomatoesRating >= RottenMin ); } }
public async Task <IActionResult> Edit(int id, [Bind("MovieID,MovieNumber,Title,Overview,Tagline,RunTime,Year,Revenue,Actors,MPAARating")] Movie movie, int SelectedGenre, int SelectedMPAARating) { if (id != movie.MovieID) { return(View("Error2", new String[] { "Could not find this movie. Please Try Again." })); } if (SelectedGenre == 0 || SelectedMPAARating == 0) { ModelState.AddModelError("DropdownError", "Please verify that you have specified one Genre and one MPAA Rating."); ViewBag.AllGenres = GetAllGenres(); ViewBag.AllMPAARatings = GetAllRatings(); return(View(movie)); } if (ModelState.IsValid && SelectedGenre > 0 && SelectedMPAARating > 0) { try { Genre dbGenre = _context.Genres.Find(SelectedGenre); movie.Genre = dbGenre; string MPAAStringToDisplay = Enum.GetName(typeof(AllMPAARatings), SelectedMPAARating); MPAARatings MPAARatingsToDisplay = (MPAARatings)Enum.Parse(typeof(MPAARatings), MPAAStringToDisplay); movie.MPAARating = MPAARatingsToDisplay; _context.Update(movie); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MovieExists(movie.MovieID)) { return(View("Error2", new String[] { "Could not find this movie. Please Try Again." })); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewBag.AllGenres = GetAllGenres(); ViewBag.AllMPAARatings = GetAllRatings(); return(View(movie)); }
/// <summary> /// Does the response initialization for incoming GET requests /// </summary> public void OnGet(double?IMDBMin, double?IMDBMax, int?RottenMin, int?RottenMax) { // Nullable conversion workaround /* * this.IMDBMin = IMDBMin; * this.IMDBMax = IMDBMax; * this.RottenMin = RottenMin; * this.RottenMax = RottenMax; * MPAARatings = Request.Query["MPAARatings"]; * Genres = Request.Query["Genres"]; * * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); * Movies = MovieDatabase.FilterByGenre(Movies, Genres); * Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); * Movies = MovieDatabase.FilterByRottenTomatoesRating(Movies, RottenMin, RottenMax); */ Movies = MovieDatabase.All; // Filter search terms if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase)); } // Filter MPAA rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating)); } // Filter Genre if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre)); } // Filter IMDB rating if (IMDBMax != null && IMDBMin != null) { Movies = Movies.Where(movie => movie.IMDBRating != null && movie.IMDBRating >= IMDBMin && movie.IMDBRating <= IMDBMax); } // Filter Rotten Tomatoes rating if (RottenMax != null && RottenMin != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating != null && movie.RottenTomatoesRating >= RottenMin && movie.RottenTomatoesRating <= RottenMax); } }
public void OnGet() { Movies = MovieDatabase.All; //Search movie title for the search terms. if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase)); } //filter through MPAARatings if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } //Filter through genres if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre) ); } // Filter through IMDB Ratings if (IMDBMin == null && IMDBMax != null) { Movies = Movies.Where(movie => movie.IMDBRating != null && IMDBMax >= movie.IMDBRating ); } if (IMDBMin != null && IMDBMax == null) { Movies = Movies.Where(movie => movie.IMDBRating != null && IMDBMin <= movie.IMDBRating ); } if (IMDBMin != null && IMDBMax != null) { Movies = Movies.Where(movie => movie.IMDBRating != null && IMDBMin <= movie.IMDBRating && IMDBMax >= movie.IMDBRating ); } }
/// <summary> /// Does the response initialization for incoming GET requests /// </summary> public void OnGet(double?IMDBMin, double?IMDBMax, double?RTMin, double?RTMax) { Movies = MovieDatabase.All; // Search movie titles for the SearchTerms if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.InvariantCultureIgnoreCase)); } // Filter by MPAA Rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating)); } // Filter by Genre if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre)); } //Filter by IMDB Rating if (IMDBMin != null || IMDBMax != null) { Movies = Movies.Where(movie => movie.IMDBRating != null && (IMDBMin != null && IMDBMax == null && movie.IMDBRating >= IMDBMin) || (IMDBMin == null && IMDBMax != null && movie.IMDBRating <= IMDBMax) || (IMDBMin != null && IMDBMax != null && movie.IMDBRating >= IMDBMin && movie.IMDBRating <= IMDBMax)); } //Filter by Rotten Tomatoes if (RTMin != null || RTMax != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating != null && (RTMin != null && RTMax == null && movie.RottenTomatoesRating >= RTMin) || (RTMin == null && RTMax != null && movie.RottenTomatoesRating <= RTMax) || (RTMin != null && RTMax != null && movie.RottenTomatoesRating >= RTMin && movie.RottenTomatoesRating <= RTMax)); } }
/// <summary> /// Does the response initialization for incoming GET requests /// </summary> public void OnGet() { /* * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); * Movies = MovieDatabase.FilterByGenre(Movies, Genres); * Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); * Movies = MovieDatabase.FilterByRottenTomatoesRating(Movies, RottenTomatoesMin, RottenTomatoesMax); */ Movies = MovieDatabase.All; // Search movie titles for the SearchTerms if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase) ); } // Filter by MPAA Rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre) ); } if (IMDBMin != null || IMDBMax != null) { Movies = Movies.Where(movie => movie.IMDBRating != null && movie.IMDBRating >= IMDBMin || movie.IMDBRating <= IMDBMax ); } if (RottenTomatoesMin != null || RottenTomatoesMax != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating != null && movie.RottenTomatoesRating >= RottenTomatoesMin || movie.RottenTomatoesRating <= RottenTomatoesMax ); } }
/// <summary> /// Gets the search results for display on the page /// </summary> public void OnGet(double?IMDBMin, double?IMDBMax) { // Nullable conversion workaround /* * this.IMDBMin = IMDBMin; * this.IMDBMax = IMDBMax; * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); * Movies = MovieDatabase.FilterByGenre(Movies, Genres); * Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); */ Movies = MovieDatabase.All; //search movie titles for the SearchTerms if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.InvariantCultureIgnoreCase)); } //Filter by MPAA rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating)); } //Filter by Genres if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre)); } //filter by price neither not null if (IMDBMax != null && IMDBMin != null) { Movies = Movies.Where(movie => movie.IMDBRating <= IMDBMax && movie.IMDBRating >= IMDBMin); } //Filter by Price max not null else if (IMDBMax != null) { Movies = Movies.Where(movie => movie.IMDBRating <= IMDBMax); } //filter by price min not null else if (IMDBMin != null) { Movies = Movies.Where(movie => movie.IMDBRating <= IMDBMin); } }
/// <summary> /// Gets the search results for display on the page /// </summary> public void OnGet() { Movies = MovieDatabase.All; // Search movie titles for the SearchTerms if (SearchTerms != null) { Movies = from movie in Movies where movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.InvariantCultureIgnoreCase) select movie; } // Filter by MPAA Rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } }
public async Task <IActionResult> Create([Bind("MovieID,MovieNumber,Title,Overview,Tagline,RunTime,Year,Genre,Revenue,Actors,MPAARating")] Movie movie, int SelectedGenre, int SelectedMPAARating) { if (SelectedGenre == 0 || SelectedMPAARating == 0) { ModelState.AddModelError("DropdownError", "Please verify that you have specified one Genre and one MPAA Rating."); ViewBag.AllGenres = GetAllGenres(); ViewBag.AllMPAARatings = GetAllRatings(); return(View(movie)); } if (ModelState.IsValid && SelectedGenre > 0 && SelectedMPAARating > 0) { //Find the next Movie Number from the utilities class movie.MovieNumber = Utilities.GenerateNextMovieNumber.GetNextMovieNumber(_context); Genre dbGenre = _context.Genres.Find(SelectedGenre); movie.Genre = dbGenre; string MPAAStringToDisplay = Enum.GetName(typeof(AllMPAARatings), SelectedMPAARating); MPAARatings MPAARatingsToDisplay = (MPAARatings)Enum.Parse(typeof(MPAARatings), MPAAStringToDisplay); movie.MPAARating = MPAARatingsToDisplay; _context.Add(movie); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewBag.AllGenres = GetAllGenres(); ViewBag.AllMPAARatings = GetAllRatings(); return(View(movie)); }
/// <summary> /// Gets the search results for display on the page /// </summary> public void OnGet(double?IMDBMin, double?IMDBMax) { this.IMDBMin = IMDBMin; this.IMDBMax = IMDBMax; Movies = MovieDatabase.All; // Search movie titles for the SearchTerms if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.InvariantCultureIgnoreCase)); } // Filter by MPAA Rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); Movies = MovieDatabase.FilterByGenre(Movies, Genres); Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); }
/// <summary> /// Gets the search results for display on the page /// </summary> public void OnGet(double?IMDBMini, double?IMDBMaxi, double?RTMaxi, double?RTMini) { /* * //# Nullable conversion workaround * * this.IMDBMin = IMDBMini; * this.IMDBMax = IMDBMaxi; * //this.SearchTerms = SearchTerms; * // this.MPAARatings = MPAARatings; * //this.Genres = Genres; * this.RTMax = RTMaxi; * this.RTMin = RTMini; * SearchTerms = Request.Query["SearchTerms"]; * MPAARatings = Request.Query["MPAARatings"]; * Genres = Request.Query["Genres"]; * Movies = MovieDatabase.All; * * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); * Movies = MovieDatabase.FilterByGenre(Movies, Genres); * Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); * Movies = MovieDatabase.FilterByRTRating(Movies, RTMin, RTMax); */ Movies = MovieDatabase.All; if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase)); } //genre if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre)); } // Filter by MPAA Rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } //imdb if (IMDBMax != null && IMDBMax != 0) { Movies = Movies.Where(movie => movie.IMDBRating <= IMDBMax); } if (IMDBMin != null && IMDBMin != 0) { Movies = Movies.Where(movie => movie.IMDBRating >= IMDBMin); } if (IMDBMax != null && IMDBMax != 0 && IMDBMin != null && IMDBMin != 0) { Movies = Movies.Where(movie => movie.IMDBRating >= IMDBMin && movie.IMDBRating <= IMDBMax); } //rotten if (RTMax != null && RTMax != 0) { Movies = Movies.Where(movie => movie.RottenTomatoesRating <= RTMax); } if (RTMin != null && RTMin != 0) { Movies = Movies.Where(movie => movie.RottenTomatoesRating >= RTMin); } if (RTMax != null && RTMax != 0 && RTMin != null && RTMin != 0) { Movies = Movies.Where(movie => movie.RottenTomatoesRating >= RTMin && movie.RottenTomatoesRating <= RTMax); } }
//constructor public LibraryMovie(string theTitle, string thePublisher, int theCopyrightYear, int theLoanPeriod, string theCallNumber, double theDuration, string director, MediaType medium, MPAARatings rating) : base(theTitle, thePublisher, theCopyrightYear, theLoanPeriod, theCallNumber, theDuration) { director = _director; medium = _medium; rating = _rating; }
public void OnPost() { //Filterable Database Movies = MovieDatabase.All; //Search movie titles for the SearchTerms if (SearchTerms != null) { Movies = Movies.Where( movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase) ); } //Filter by MPAA Rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where( movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } //Filter by Genre if (Genres != null && Genres.Length != 0) { Movies = Movies.Where( movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre) ); } //Filter by IMDB Rating if (IMDBMin != null && IMDBMax != null) { Movies = Movies.Where( movie => movie.IMDBRating >= IMDBMin && movie.IMDBRating <= IMDBMax ); } else if (IMDBMin == null && IMDBMax != null) { Movies = Movies.Where( movie => movie.IMDBRating <= IMDBMax ); } else { Movies = Movies.Where( movie => movie.IMDBRating >= IMDBMin ); } //Filter by Rotten Tomatoes if (RottenMin != null && RottenMax != null) { Movies = Movies.Where( movie => movie.RottenTomatoesRating >= RottenMin && movie.RottenTomatoesRating <= RottenMax ); } else if (IMDBMin == null && IMDBMax != null) { Movies = Movies.Where( movie => movie.RottenTomatoesRating <= RottenMax ); } else { Movies = Movies.Where( movie => movie.RottenTomatoesRating >= RottenMin ); } }
/// <summary> /// Does the response initialization for incoming GET requests /// </summary> public void OnGet(double?IMDBMin, double?IMDBMax, double?RottenTomatoesMin, double?RottenTomatoesMax) { SearchTerms = Request.Query["SearchTerms"]; MPAARatings = Request.Query["MPAARatings"]; Genres = Request.Query["Genres"]; // Nullable conversion workaround this.IMDBMin = IMDBMin; this.IMDBMax = IMDBMax; this.RottenTomatoesMax = RottenTomatoesMax; this.RottenTomatoesMin = RottenTomatoesMin; Movies = MovieDatabase.All; //Search movie titles for search terms if (SearchTerms != null) { //Movies = MovieDatabase.All.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.InvariantCultureIgnoreCase)); Movies = from movie in Movies where movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.InvariantCultureIgnoreCase) select movie; } //Filter by MPAARating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } //Filter by Genre if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre) ); } //Movies = MovieDatabase.FilterByGenre(Movies, Genres); //Filter by IMDBRating if (IMDBMin != null) { Movies = Movies.Where(movie => movie.IMDBRating >= IMDBMin); } if (IMDBMax != null) { Movies = Movies.Where(movie => movie.IMDBRating <= IMDBMax); } //Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); //Filter by Rotten Tomatoes if (RottenTomatoesMax != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating <= RottenTomatoesMax); } if (RottenTomatoesMin != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating >= RottenTomatoesMin); } //Movies = MovieDatabase.FilterByRottenTomatoesRating(Movies, RottenTomatoesMin, RottenTomatoesMax); }
public async Task <IActionResult> DisplayReportResultsAsync(ReportSearchViewModel rsvm) { //Initial query LINQ var query = from m in _context.Ticket select m; query = query.Include(m => m.Showing).ThenInclude(m => m.Movie).Include(m => m.Order).ThenInclude(m => m.Purchaser); //If statements corresponding to each input form control if (rsvm.SelectedStartingDate != null) //For date { DateTime datSelectedStartingDate = rsvm.SelectedStartingDate ?? new DateTime(1900, 1, 1); query = query.Where(m => m.Showing.ShowingDate >= datSelectedStartingDate); } if (rsvm.SelectedEndingDate != null) //For date { DateTime datSelectedEndingDate = rsvm.SelectedEndingDate ?? new DateTime(1900, 1, 1); query = query.Where(m => m.Showing.ShowingDate <= datSelectedEndingDate); } if (rsvm.SelectedMovie != 0) //For movie name { Movie movie = _context.Movies.Find(rsvm.SelectedMovie); query = query.Where(m => m.Showing.Movie == movie); } if (rsvm.SelectedMPAARating != 0) //For MPAARating { string MPAAStringToDisplay = Enum.GetName(typeof(AllMPAARatings), rsvm.SelectedMPAARating); MPAARatings MPAARatingsToDisplay = (MPAARatings)Enum.Parse(typeof(MPAARatings), MPAAStringToDisplay); query = query.Where(m => m.Showing.Movie.MPAARating == MPAARatingsToDisplay); } if (rsvm.SelectedTime != null) //For showing time ******** { DateTime timSelectedTime = rsvm.SelectedTime ?? new DateTime(1900, 1, 1); if (rsvm.SelectedSearchType == AllSearchTypes.GreaterThan) { ModelState.AddModelError("NotSelected", "Please choose either before or after for your selected time."); //Populate view bag with list of categories ViewBag.AllMPAARatings = GetAllRatings(); ViewBag.AllMovies = GetAllMovies(); return(View("ReportSearch", rsvm)); } switch (rsvm.SelectedSearchType) { case AllSearchTypes.Before: query = query.Where(m => m.Showing.StartTime.TimeOfDay <= timSelectedTime.TimeOfDay); break; case AllSearchTypes.After: query = query.Where(m => m.Showing.StartTime.TimeOfDay >= timSelectedTime.TimeOfDay); break; default: break; } } TryValidateModel(rsvm); if (ModelState.IsValid == false) { //re-populate ViewBag to have list of all categories & MPAA Ratings ViewBag.AllMPAARatings = GetAllRatings(); ViewBag.AllMovies = GetAllMovies(); //View is returned with error messages return(View("ReportSearch", rsvm)); } //Execute query List <Ticket> SelectedTickets = query.Include(m => m.Showing).ThenInclude(m => m.Movie).Include(m => m.Order).ThenInclude(m => m.Purchaser).ToList();//.Where(r => r.TicketStatus == "Active").ToList(); ReportViewModel rvm = new ReportViewModel(); if (rsvm.TotalRevenue != false) { rvm.TotalRevenue = SelectedTickets.Where(t => t.TicketStatus == "Active").Sum(r => r.TotalCost); } if (rsvm.TotalSeatsSold != false) { rvm.TotalSeatsSold = SelectedTickets.Where(t => t.TicketStatus == "Active").Count(); } if (rsvm.ByCustomers != false) { IList <AppUser> users = await _userManager.GetUsersInRoleAsync("Customer"); users = users.Where(u => u.OrdersPurchased != null).ToList(); rvm.AppUsers = (List <AppUser>)users; foreach (AppUser user in rvm.AppUsers) { user.Tickets = SelectedTickets.Where(t => t.Order.Purchaser.UserName == user.UserName).ToList(); } //rvm.Tickets = SelectedTickets; } if (rsvm.PPTickets != false) { rvm.PopcornPointTickets = SelectedTickets.Where(r => r.Order.PaidWithPopcornPoints == true && r.TicketStatus == "Active").ToList(); } return(View("ReportSearchResults", rvm)); }
/// <summary> /// Gets the search results for display on the page /// </summary> public void OnGet() { /* * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); * Movies = MovieDatabase.FilterByGenre(Movies, MajorGenre); * Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); * Movies = MovieDatabase.FilterByRottenTomatoesRating(Movies, RTMin, RTMax);*/ Movies = MovieDatabase.All; //Search movie titles for SearchTerms if (SearchTerms != null) { //Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.InvariantCultureIgnoreCase)); Movies = from movie in Movies where movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.InvariantCultureIgnoreCase) select movie; } //Filter by MPAA Rating if (MPAARatings != null && MPAARatings.Length != 0) { Movies = from movie in Movies where movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) select movie; } //Filter by Genre if (MajorGenre != null && MajorGenre.Count() != 0) { Movies = from movie in Movies where movie.MajorGenre != null && MajorGenre.Contains(movie.MajorGenre) select movie; } //Filter by IMDB Rating if (IMDBMin == null && IMDBMax != null) { Movies = from movie in Movies where movie.IMDBRating <= IMDBMax select movie; } if (IMDBMin != null && IMDBMax == null) { Movies = from movie in Movies where movie.IMDBRating >= IMDBMin select movie; } if (IMDBMin != null && IMDBMax != null) { Movies = from movie in Movies where movie.IMDBRating >= IMDBMin && movie.IMDBRating <= IMDBMax select movie; } //Filter by Rotten Tomatoes Rating if (RTMin == null && RTMax != null) { Movies = from movie in Movies where movie.RottenTomatoesRating <= RTMax select movie; } if (RTMin != null && RTMax == null) { Movies = from movie in Movies where movie.RottenTomatoesRating >= RTMin select movie; } if (RTMin != null && RTMax != null) { Movies = from movie in Movies where movie.RottenTomatoesRating >= RTMin && movie.RottenTomatoesRating <= RTMax select movie; } }
/// <summary> /// Gets the search results for display on the page /// </summary> public void OnGet(double?IMDBMin, double?IMDBMax, int?RottenMin, int?RottenMax) { this.IMDBMin = IMDBMin; this.IMDBMax = IMDBMax; this.RottenMin = RottenMin; this.RottenMax = RottenMax; SearchTerms = Request.Query["SearchTerms"]; MPAARatings = Request.Query["MPAARatings"]; Genres = Request.Query["Genres"]; Movies = MovieDatabase.All; if (SearchTerms != null) { Movies = MovieDatabase.All.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase) ); } if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre) ); } if (!(IMDBMin == null && IMDBMax == null)) { if (IMDBMin == null && IMDBMax != null) { Movies = Movies.Where(movie => movie.IMDBRating <= IMDBMax ); } else if (IMDBMin != null && IMDBMax == null) { Movies = Movies.Where(movie => movie.IMDBRating >= IMDBMin ); } else { Movies = Movies.Where(movie => movie.IMDBRating >= IMDBMin && movie.IMDBRating <= IMDBMax ); } } if (Genres != null && Genres.Length != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre) ); } if (!(RottenMin == null && RottenMax == null)) { if (RottenMin == null && RottenMax != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating <= RottenMax ); } else if (RottenMin != null && RottenMax == null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating >= RottenMin ); } else { Movies = Movies.Where(movie => movie.RottenTomatoesRating >= RottenMin && movie.RottenTomatoesRating <= RottenMax ); } } /* * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); * Movies = MovieDatabase.FilterByGenre(Movies, Genres); * Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); * Movies = MovieDatabase.FilterByRottenTomatoesRating(Movies, RottenMin, RottenMax); */ }
/// <summary> /// Posts the search results for display on the page /// </summary> /// <param name="IMDBMin">The minimum IMDB Rating</param> /// <param name="IMDBMax">The maximum IMDB Rating</param> /// <param name="RottenMin">The minimum Rotten Tomatoes Rating</param> /// <param name="RottenMax">The maximum Rotten Tomatoes Rating</param> public void OnPost() { /* * Movies = MovieDatabase.Search(SearchTerms); * Movies = MovieDatabase.FilterByMPAARating(Movies, MPAARatings); * Movies = MovieDatabase.FilterByGenre(Movies, Genres); * Movies = MovieDatabase.FilterByIMDBRating(Movies, IMDBMin, IMDBMax); * Movies = MovieDatabase.FilterByRottenTomatoesRating(Movies, RottenMin, RottenMax); */ Movies = MovieDatabase.All; // Search movie titles for the SearchTerms if (SearchTerms != null) { Movies = Movies.Where(movie => movie.Title != null && movie.Title.Contains(SearchTerms, StringComparison.CurrentCultureIgnoreCase) ); } // Filter by MPAA Ratings if (MPAARatings != null && MPAARatings.Length != 0) { Movies = Movies.Where(movie => movie.MPAARating != null && MPAARatings.Contains(movie.MPAARating) ); } // Filter by Genre if (Genres != null && Genres.Count() != 0) { Movies = Movies.Where(movie => movie.MajorGenre != null && Genres.Contains(movie.MajorGenre) ); } // Filter by IMBD Rating if (IMDBMax != null || IMDBMin != null) { // Min is null if (IMDBMin == null) { Movies = Movies.Where(movie => movie.IMDBRating <= IMDBMax ); } // Max is null if (IMDBMax == null) { Movies = Movies.Where(movie => movie.IMDBRating >= IMDBMin ); } // Both are specified if (IMDBMax != null && IMDBMin != null) { Movies = Movies.Where(movie => movie.IMDBRating >= IMDBMin && movie.IMDBRating <= IMDBMax ); } } // Filter by RottenTomatoes Rating if (RottenMax != null || RottenMin != null) { // Min is null if (RottenMin == null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating <= RottenMax ); } // Max is null if (RottenMax == null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating >= RottenMin ); } // Both are specified if (RottenMax != null && RottenMin != null) { Movies = Movies.Where(movie => movie.RottenTomatoesRating >= RottenMin && movie.RottenTomatoesRating <= RottenMax ); } } }