public List <random_VM> GetRandom()
{
List <random_VM> vm = new List <random_VM>();
var query = from movies in _context.movies select movies;
foreach (var result in query)
{
random_VM VM = new random_VM();
VM.title = result.title;
VM.year = result.year;
VM.poster = result.poster;
VM.synopses = result.synopsis;
VM.Movie_id = result.movie_id;
VM.Director_name = result.director1.name;
VM.GreatnessRating = 0;
VM.GRating = "";
vm.Add(VM);
foreach (var rating in result.ratings)
{
int ratin = Convert.ToInt32((rating.imdbR + rating.metaR + rating.user_rating + rating.rottenR) / 4) * 10;
VM.GreatnessRating = Convert.ToDecimal((rating.imdbR + rating.metaR + rating.user_rating + rating.rottenR) / 4) * 10;
VM.GRating = ratin + "%";
}
}
return(vm.ToList());
}
public List <random_VM> GetRandom(Guid?userId)
{
List <random_VM> vm = new List <random_VM>();
var query = from movies in _context.movies select movies;
foreach (var result in query)
{
random_VM VM = new random_VM();
VM.title = result.title;
VM.year = result.year;
VM.poster = result.poster;
VM.synopses = result.synopsis;
VM.Movie_id = result.movie_id;
VM.Director_name = result.director1.name;
VM.GreatnessRating = 0;
VM.GRating = "";
vm.Add(VM);
foreach (var fav in result.users)
{
if (fav != null && fav.id == userId)
{
// VM.Fav_movies.Add(result.movie_id);
VM.isFav = true;
}
}
foreach (var toWatch in result.users1)
{
if (toWatch != null && toWatch.id == userId)
{
// VM.To_watch_movies.Add(result.movie_id);
VM.isToWatch = true;
}
}
foreach (var watched in result.user_watched_movies)
{
if (watched != null && watched.user_id == userId)
{
// VM.Watched_movies.Add(watched.movie_id);
VM.isWatched = true;
}
}
foreach (var rating in result.ratings)
{
int ratin = Convert.ToInt32((rating.imdbR + rating.metaR + rating.user_rating + rating.rottenR) / 4) * 10;
VM.GreatnessRating = Convert.ToDecimal((rating.imdbR + rating.metaR + rating.user_rating + rating.rottenR) / 4) * 10;
VM.GRating = ratin + "%";
}
}
return(vm.ToList());
}
