public List <movie> GetAllMovies() { moviesEntities ORM = new moviesEntities(); List <movie> allmovies = ORM.movies.ToList(); return(allmovies); }
public movie GetAMovieInCat(string category) { moviesEntities ORM = new moviesEntities(); List <movie> pickMovie = ORM.movies.Where(x => x.category.ToLower() == category.ToLower()).ToList(); Random r = new Random(); int selected = r.Next(0, pickMovie.Count - 1); return(pickMovie.ElementAt(selected)); }
public movie GetAMovie() { moviesEntities ORM = new moviesEntities(); List <movie> pickMovie = ORM.movies.ToList(); Random r = new Random(); int selected = r.Next(0, pickMovie.Count - 1); return(pickMovie.ElementAt(selected)); }
public List <movie> GetSomeMovies(int num) { moviesEntities ORM = new moviesEntities(); List <movie> pickMovie = ORM.movies.ToList(); Random r = new Random(); List <movie> randommovies = new List <movie>(); for (int i = 0; i < num; i++) { int selected = r.Next(0, pickMovie.Count - 1); randommovies.Add(pickMovie.ElementAt(selected)); } return(randommovies); }
public List <string> GetKey(string movie) { moviesEntities ORM = new moviesEntities(); return(ORM.movies.Where(x => x.title.Contains(movie.ToLower()) != false).Select(x => x.title + "is an a " + x.category + " film").Distinct().ToList()); }
public List <string> GetAllCategories() { moviesEntities ORM = new moviesEntities(); return(ORM.movies.Where(x => x.category != null).Select(x => x.category).Distinct().ToList());; }