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);
}
