using System.Text.Json; using System.Text.Json.Serialization; using tasks.Databases; namespace tasks; /// /// Here you should implement various database query methods for the IMovieDatabase interface. /// public static class DatabaseQueries { public static void RunQueries(this IMovieDatabase movieDatabase) { movieDatabase.ActorsFromFantasyMovies(); movieDatabase.LongestMovieByGenre(); movieDatabase.HighRatedMoviesWithCast(); movieDatabase.DistinctRolesCountPerActor(); movieDatabase.RecentMoviesWithAverageRating(); movieDatabase.AverageRatingByGenre(); movieDatabase.ActorsWhoNeverPlayedInThriller(); movieDatabase.Top3MoviesByRatingCount(); movieDatabase.MoviesWithoutRatings(); movieDatabase.MostVersatileActors(); } public static void ActorsFromFantasyMovies(this IMovieDatabase movieDatabase) { var movies = movieDatabase.Movies; var actors = movieDatabase.Actors; var ratings = movieDatabase.Ratings; var casts = movieDatabase.Casts; var queryResult = new object(); Console.WriteLine("Actors From Fantasy Movies"); DisplayQueryResults(queryResult); Console.WriteLine(); } public static void LongestMovieByGenre(this IMovieDatabase movieDatabase) { var movies = movieDatabase.Movies; var actors = movieDatabase.Actors; var ratings = movieDatabase.Ratings; var casts = movieDatabase.Casts; var queryResult = new object(); Console.WriteLine("Longest Movie By Genre"); DisplayQueryResults(queryResult); Console.WriteLine(); } public static void HighRatedMoviesWithCast(this IMovieDatabase movieDatabase) { var movies = movieDatabase.Movies; var actors = movieDatabase.Actors; var ratings = movieDatabase.Ratings; var casts = movieDatabase.Casts; var queryResult = new object(); Console.WriteLine("High Rated Movies With Cast"); DisplayQueryResults(queryResult); Console.WriteLine(); } public static void DistinctRolesCountPerActor(this IMovieDatabase movieDatabase) { var movies = movieDatabase.Movies; var actors = movieDatabase.Actors; var ratings = movieDatabase.Ratings; var casts = movieDatabase.Casts; var queryResult = new object(); Console.WriteLine("Distinct Roles Count Per Actor"); DisplayQueryResults(queryResult); Console.WriteLine(); } public static void RecentMoviesWithAverageRating(this IMovieDatabase movieDatabase) { var movies = movieDatabase.Movies; var actors = movieDatabase.Actors; var ratings = movieDatabase.Ratings; var casts = movieDatabase.Casts; var queryResult = new object(); Console.WriteLine("Recent Movies With Average Rating"); DisplayQueryResults(queryResult); Console.WriteLine(); } public static void AverageRatingByGenre(this IMovieDatabase movieDatabase) { var movies = movieDatabase.Movies; var actors = movieDatabase.Actors; var ratings = movieDatabase.Ratings; var casts = movieDatabase.Casts; var queryResult = new object(); Console.WriteLine("Average Rating By Genre"); DisplayQueryResults(queryResult); Console.WriteLine(); } public static void ActorsWhoNeverPlayedInThriller(this IMovieDatabase movieDatabase) { var movies = movieDatabase.Movies; var actors = movieDatabase.Actors; var ratings = movieDatabase.Ratings; var casts = movieDatabase.Casts; var queryResult = new object(); Console.WriteLine("Actors Who Never Played In Thriller"); DisplayQueryResults(queryResult); Console.WriteLine(); } public static void Top3MoviesByRatingCount(this IMovieDatabase movieDatabase) { var movies = movieDatabase.Movies; var actors = movieDatabase.Actors; var ratings = movieDatabase.Ratings; var casts = movieDatabase.Casts; var queryResult = new object(); Console.WriteLine("Top 3 Movies By Rating Count"); DisplayQueryResults(queryResult); Console.WriteLine(); } public static void MoviesWithoutRatings(this IMovieDatabase movieDatabase) { var movies = movieDatabase.Movies; var actors = movieDatabase.Actors; var ratings = movieDatabase.Ratings; var casts = movieDatabase.Casts; var queryResult = new object(); Console.WriteLine("Movies Without Ratings"); DisplayQueryResults(queryResult); Console.WriteLine(); } public static void MostVersatileActors(this IMovieDatabase movieDatabase) { var movies = movieDatabase.Movies; var actors = movieDatabase.Actors; var ratings = movieDatabase.Ratings; var casts = movieDatabase.Casts; var queryResult = new object(); Console.WriteLine("Most Versatile Actors"); DisplayQueryResults(queryResult); Console.WriteLine(); } public static void DisplayQueryResults(T query) { var options = new JsonSerializerOptions { WriteIndented = true }; options.Converters.Add(new JsonStringEnumConverter()); var json = JsonSerializer.Serialize(query, options); Console.WriteLine(json); } }