public static async Task <List <MovieFirebase> > GetMoviesAsync(String uEmail)
{
moviesProjectContext context = new moviesProjectContext();
try
{
List <MovieFirebase> MovieList = new List <MovieFirebase>();
//query = "SELECT movieId FROM watchlist WHERE userEmail='" + uEmail + "'";
var movies = context.Watchlists.AsQueryable().Where(x => x.UserEmail.Equals(uEmail)).ToList();
foreach (Watchlist item in movies)
{
MovieFirebase movie = new MovieFirebase();
movie = await MovieMethods.GetMovie(item.MovieId);
MovieList.Add(movie);
}
return(MovieList);
}
catch (Exception e)
{
return(null);
}
}
async public static Task <MovieFirebase> GetMovie(int id)
{
Firebase fb = new Firebase();
FirestoreDb db = fb.db;
Query docQ = db.Collection("movies").WhereEqualTo("id", id);
QuerySnapshot snap = await docQ.GetSnapshotAsync();
MovieFirebase movie = new MovieFirebase();
foreach (DocumentSnapshot docsnap in snap)
{
movie = docsnap.ConvertTo <MovieFirebase>();
}
return(movie);
}
async public static Task <List <MovieFirebase> > GetNowPlaying(int page)
{
Firebase fb = new Firebase();
FirestoreDb db = fb.db;
Query docQ = db.Collection("movies").WhereGreaterThan("release_date", "2021-01-01").WhereLessThan("release_date", "2021-13-04").OrderByDescending("release_date").Limit(20).Offset(page * 20);
QuerySnapshot snap = await docQ.GetSnapshotAsync();
MovieFirebase movie = new MovieFirebase();
List <MovieFirebase> mlist = new List <MovieFirebase>();
foreach (DocumentSnapshot docsnap in snap)
{
movie = docsnap.ConvertTo <MovieFirebase>();
mlist.Add(movie);
}
return(mlist);
}
async public static Task <List <MovieFirebase> > GetTopRated(int page)
{
Firebase fb = new Firebase();
FirestoreDb db = fb.db;
Query docQ = db.Collection("movies").OrderByDescending("vote_count").OrderByDescending("vote_average").Limit(20).Offset(page * 20);
QuerySnapshot snap = await docQ.GetSnapshotAsync();
MovieFirebase movie = new MovieFirebase();
List <MovieFirebase> mlist = new List <MovieFirebase>();
foreach (DocumentSnapshot docsnap in snap)
{
movie = docsnap.ConvertTo <MovieFirebase>();
mlist.Add(movie);
}
return(mlist);
}
async public static Task <List <MovieFirebase> > SearchLangMovie(string lang, int page)
{
Firebase fb = new Firebase();
FirestoreDb db = fb.db;
Query docQ = db.Collection("movies").WhereEqualTo("original_language", lang).OrderByDescending("popularity").Limit(20).Offset(page * 20);
QuerySnapshot snap = await docQ.GetSnapshotAsync();
MovieFirebase movie = new MovieFirebase();
List <MovieFirebase> mlist = new List <MovieFirebase>();
foreach (DocumentSnapshot docsnap in snap)
{
movie = docsnap.ConvertTo <MovieFirebase>();
mlist.Add(movie);
}
return(mlist);
}
async public static Task <List <MovieFirebase> > SearchGerneMovie(int genre, int page)
{
Firebase fb = new Firebase();
FirestoreDb db = fb.db;
Query docQ = db.Collection("movies").WhereArrayContains("genre_ids", genre).OrderByDescending("popularity").Limit(20).Offset(page * 20);
QuerySnapshot snap = await docQ.GetSnapshotAsync();
MovieFirebase movie = new MovieFirebase();
List <MovieFirebase> mlist = new List <MovieFirebase>();
foreach (DocumentSnapshot docsnap in snap)
{
movie = docsnap.ConvertTo <MovieFirebase>();
mlist.Add(movie);
}
return(mlist);
}