public List <Movy> ListMovies()
{
MovieDatabaseEntities1 ORM = new MovieDatabaseEntities1();
return(ORM.Movies.ToList());
}
public Movy RandomPick()
{
MovieDatabaseEntities1 ORM = new MovieDatabaseEntities1();
Random rnd = new Random();
List <Movy> MovieList = ORM.Movies.ToList();
return(MovieList[rnd.Next(0, MovieList.Count)]);
}
public Movy RandomPickSpecCategory(string cat)
{
MovieDatabaseEntities1 ORM = new MovieDatabaseEntities1();
//ORM.Movies.Where(c => c.Category == cat).ToList();
Random rnd = new Random();
List <Movy> MovieList = ORM.Movies.Where(c => c.Category == cat).ToList();
return(MovieList[rnd.Next(0, MovieList.Count)]);
}
public List <Movy> RandomNumofPics(int userInput)
{
MovieDatabaseEntities1 ORM = new MovieDatabaseEntities1();
Random rnd = new Random();
List <Movy> MovieList = ORM.Movies.ToList();
List <Movy> MovieL = new List <Movy>();
for (int i = 0; i < userInput; i++)
{
int result = rnd.Next(MovieList.Count());
MovieList.Add(MovieL[result]);
MovieL.RemoveAt(result);
}
return(MovieList);
}
public Movy MovieTitle(string name)
{
MovieDatabaseEntities1 ORM = new MovieDatabaseEntities1();
Movy result = ORM.Movies.Find(name);
if (result != null)
{
return(result);
}
else
{
Movy info = new Movy {
Title = "movie not found"
};
return(info);
}
}
public List <Movy> MovieKey(string userInput)
{
MovieDatabaseEntities1 ORM = new MovieDatabaseEntities1();
return(ORM.Movies.Where(c => c.Title.Contains(userInput)).ToList());
}
public List <string> ListCategories()
{
MovieDatabaseEntities1 ORM = new MovieDatabaseEntities1();
return(ORM.Movies.Select(c => c.Category).Distinct().ToList());
}
public List <Movy> ListMovieByCategory(string category)
{
MovieDatabaseEntities1 ORM = new MovieDatabaseEntities1();
return(ORM.Movies.Where(c => c.Category.Contains(category)).ToList());
}