public List <Movie> GetTitles() { FilmDBEntities2 db = new FilmDBEntities2(); List <Movie> Titles = db.Movies.ToList(); return(Titles); }
public Movie GetRandomMovie() { FilmDBEntities2 db = new FilmDBEntities2(); List <Movie> Titles = db.Movies.ToList(); var rand = new Random(); var movie = Titles.ElementAt(rand.Next(Titles.Count())); return(movie); }
public List <Movie> GetMoviesByCategory(string Category) { FilmDBEntities2 db = new FilmDBEntities2(); List <Movie> CatList = (from p in db.Movies where p.Category.Contains(Category) select p).ToList(); return(CatList); }
public List <string> GetCategoryList() { FilmDBEntities2 db = new FilmDBEntities2(); List <string> CatList = (from m in db.Movies where m.Category != null select m.Category).Distinct().ToList(); return(CatList); }
public Movie GetRandomMovieFromCat(string category) { FilmDBEntities2 db = new FilmDBEntities2(); List <Movie> MovieList = (from p in db.Movies where p.Category.Contains(category) select p).ToList(); var rand = new Random(); var movie = MovieList.ElementAt(rand.Next(MovieList.Count())); return(movie); }
public Movie GetMovieInfo(string title) { FilmDBEntities2 db = new FilmDBEntities2(); Movie movie = (from m in db.Movies where m.Title == title select m).Single(); return(movie); }
public Movie GetMovieInfoByKeyword(string title) { FilmDBEntities2 db = new FilmDBEntities2(); Movie movie = null; try { movie = (from m in db.Movies where m.Title.Contains(title) select m).Single(); } catch (Exception e) { Console.WriteLine("An error occurred: '{0}'", e); } return(movie); }
public List <Movie> GetRandomMovieListByQuantity(int quantity) { FilmDBEntities2 db = new FilmDBEntities2(); // db created List <Movie> Titles = db.Movies.ToList(); List <Movie> RandoMovieList = new List <Movie>(quantity); // new list created, based on quantity var rand = new Random(); for (int i = 0; i < quantity; i++) { Movie newmovie = Titles.ElementAt(rand.Next(Titles.Count())); if (RandoMovieList.Contains(newmovie)) { i--; } else { RandoMovieList.Add(newmovie); } } return(RandoMovieList); }