예제 #1
0
        private static void MovieRatingByUser(MoviesEntities context, string userName)
        {
            string fileName = string.Format("rated-movies-by-{0}.json", userName);

            var userMovies = context.Movies
                .Where(m => m.Ratings.Any(r => r.User.Username == userName))
                .OrderBy(m => m.Title)
                .Select(m => new
                {
                    userName,
                    m.Title,
                    m.Ratings.FirstOrDefault(u => u.User.Username == userName).Stars,
                    Average = m.Ratings.Average(r => r.Stars)
                })
                .GroupBy(m => m.userName, (k, v) => new
                {
                    userName = k,
                    ratedMovies = v.Select(a => new
                    {
                        a.Title,
                        a.Stars,
                        a.Average
                    })
                });

            var json = JsonConvert.SerializeObject(userMovies, Formatting.Indented);
            File.WriteAllText(ExportPath + fileName, json);

            Console.WriteLine("File path: {0}", Path.GetFullPath(ExportPath + fileName));
        }
예제 #2
0
파일: Program.cs 프로젝트: nok32/SoftUni
        public static void Main()
        {
            var context = new MoviesEntities();

            Console.WriteLine("Users: {0}", context.Users.Count());
            Console.WriteLine("Countries: {0}", context.Countries.Count());
            Console.WriteLine("Movies: {0}", context.Movies.Count());
            Console.WriteLine("Ratings: {0}", context.Ratings.Count());
            Console.WriteLine("MoviesUsers: {0}", context.Users.Sum(u => u.FavouriteMovies.Count));
        }
예제 #3
0
        private static void ExportAdultMovies(MoviesEntities context)
        {
            string fileName = "adult-movies.json";

            var movies = context.Movies
                .Where(m => m.AgeRestriction == AgeRestriction.Adult)
                .OrderBy(m => m.Title)
                .ThenBy(m => m.Ratings.Count)
                .Select(m => new
                {
                    title = m.Title,
                    ratingsGiven = m.Ratings.Count
                });

            var json = JsonConvert.SerializeObject(movies, Formatting.Indented);

            File.WriteAllText(ExportPath + fileName, json);
            Console.WriteLine("File path: {0}", Path.GetFullPath(ExportPath + fileName));
        }
예제 #4
0
        public static void Main()
        {
            CheckExistingDirectory(ExportPath);
            var context = new MoviesEntities();
            context.Ratings.Count(); // use it execute all migration queries

            Console.WriteLine(Separator);
            Console.WriteLine("01. Adult movies:");
            ExportAdultMovies(context);
            Console.WriteLine(Separator);

            Console.WriteLine("02. Rated Movies by User - \"jmeyery\":");
            MovieRatingByUser(context, "jmeyery");
            Console.WriteLine(Separator);

            Console.WriteLine("03. Top 10 Favourite Movies:");
            TopTenFavouriteMovies(context);
            Console.WriteLine(Separator);
        }
예제 #5
0
        private static void TopTenFavouriteMovies(MoviesEntities context)
        {
            var movies = context.Movies
                .Where(m => m.AgeRestriction == AgeRestriction.Teen)
                .OrderByDescending(m => m.Users.Count)
                .ThenBy(m => m.Title)
                .Select(m => new
                {
                    isbn = m.Isbn,
                    title = m.Title,
                    favouritedBy = m.Users.Select(u => u.Username)
                })
                .Take(10);

            var json = JsonConvert.SerializeObject(movies, Formatting.Indented);
            string fileName = "top-10-favourite-movies.json";
            File.WriteAllText(ExportPath + fileName, json);

            Console.WriteLine("File path: {0}", Path.GetFullPath(ExportPath + fileName));
        }
 static void Main()
 {
     var db = new MoviesEntities();
     Console.WriteLine(db.Users.Count());
 }