//6.--works
public List <string> GetMovieCategories()
{
Lab29Entities2 ORM = new Lab29Entities2();
return(ORM.Movies.Where(x => x.Category != null).Select(x => x.Category).Distinct().ToList());
//Select(x => x.City).Distinct().ToList();
}
//7.--works
public string GetMovieInfo(string movietitle)
{
Lab29Entities2 ORM = new Lab29Entities2();
List <Movies> mov = ORM.Movies.Where(x => x.Title.ToLower() == movietitle.ToLower()).ToList();
return(mov[0].Description);
}
//1.--works
public List <Movies> GetMovies()
{
Lab29Entities2 ORM = new Lab29Entities2();
List <Movies> movies = ORM.Movies.ToList();
return(movies);
}
//4.--works
public string GetRandomByCat(string cat)
{
Lab29Entities2 ORM = new Lab29Entities2();
Random rnd = new Random();
int newrnd = rnd.Next(ORM.Movies.Where(x => x.Category == cat).Count());
List <Movies> mov = ORM.Movies.Where(x => x.Category == cat).ToList();
return(mov[newrnd].Title);
}
//3.--works
public string GetRandomMovie()
{
Lab29Entities2 ORM = new Lab29Entities2();
Random rnd = new Random();
int newrnd = rnd.Next(1, 10);
List <Movies> movies = ORM.Movies.ToList();
return(movies[newrnd].Title);
}
//5.--works
public List <Movies> GetRandomMovies(int quant)
{
Lab29Entities2 ORM = new Lab29Entities2();
Random rnd = new Random();
List <Movies> movies = ORM.Movies.ToList();
List <Movies> movielist = new List <Movies>();
if (quant > movies.Count())
{
for (int i = 0; i < quant; i++)
{
int nrand = rnd.Next(movies.Count());
movielist.Add(movies[nrand]);
movies.Remove(movies[nrand]);
}
}
return(movielist);
}
//8.--works
public List <Movies> GetMoviesByKeyword(string content)
{
Lab29Entities2 ORM = new Lab29Entities2();
return(ORM.Movies.Where(x => x.Title.ToString().Contains(content)).ToList());
}
//2.--works
public List <Movies> GetMoviesByCategory(string cat)
{
Lab29Entities2 ORM = new Lab29Entities2();
return(ORM.Movies.Where(x => x.Category == cat).ToList());
}
