static void Main()
 {
     //set database
     Database.SetInitializer(new MigrateDatabaseToLatestVersion<MoviesEntities, Configuration>());
     var context = new MoviesEntities();
     var moviesCount = context.Movies.Count();
 }
Exemple #2
0
 public List <Actor> GetActors(Decimal?actorId = 0)
 {
     using (MoviesEntities db = new MoviesEntities())
     {
         var actorList = db.tblActors.Include("tblGender").Select(q => new Actor
         {
             _Id          = q.ActorId,
             _Name        = q.ActorName,
             _DateOfBirth = q.DateOfBirth,
             _Bio         = q.Bio,
             _Image       = new Image()
             {
                 ImageID   = q.ImageId,
                 ImagePath = q.tblImage.ImagePath,
                 Title     = q.tblImage.ImageTitle,
             },
             _Gender = new Gender()
             {
                 _Name = q.tblGender.GenderName,
                 _Id   = q.tblGender.GenderId,
             }
         }).ToList();
         if (actorId != 0)
         {
             actorList = actorList.Where(q => q._Id == actorId).ToList();
         }
         return(actorList);
     }
 }
        public bool Create(Movie movie)
        {
            ImageManager imageManager = new ImageManager();
            decimal      imageId      = imageManager.SaveImage(movie._Image.ImagePath, movie._Image.Title);

            try
            {
                if (imageId != 0)
                {
                    using (MoviesEntities db = new MoviesEntities())
                    {
                        tblMovy tMovie = new tblMovy();
                        UpdateMovieEntity(ref tMovie, movie);
                        tMovie.CreatedDateTime = DateTime.Now;
                        tMovie.ImageId         = imageId;
                        db.tblMovies.Add(tMovie);
                        db.SaveChanges();
                        MapMovieAndActors(tMovie.MovieId, movie._SelectedActors, db);
                    }
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception ex)
            {
                return(false);
            }
        }
Exemple #4
0
 /// <summary>
 /// Gets the password of a certain user
 /// </summary>
 public static string GetPasswordForUser(string username)
 {
     using (MoviesEntities db = new MoviesEntities())
     {
         return(db.Users.FirstOrDefault(u => u.Username.Equals(username, StringComparison.Ordinal)).Password);
     }
 }
Exemple #5
0
        [HttpGet] //4.
        public Movy RandomMovieCategory(string genre)
        {
            MoviesEntities ORM       = new MoviesEntities();
            Random         r         = new Random();
            List <Movy>    MovieList = ORM.Movies.ToList();

            return(ORM.Movies.[r.Next(0, MovieList.Count)]);
Exemple #6
0
        public List <Movy> GetAllMovies()
        {
            MoviesEntities db     = new MoviesEntities();
            List <Movy>    movies = db.Movies.ToList();

            return(movies);
        }
Exemple #7
0
 /// <summary>
 /// Verifies that a user with the matching username/password exists in the database
 /// </summary>
 public static bool Login(string username, string password)
 {
     using (MoviesEntities entities = new MoviesEntities())
     {
         return(entities.Users.Any(u => u.Username.Equals(username, StringComparison.OrdinalIgnoreCase) && u.Password == password));
     }
 }
Exemple #8
0
 /// <summary>
 /// Verifies that a user with the matching username exists in the database
 /// </summary>
 public static bool FindUser(string username)
 {
     using (MoviesEntities entities = new MoviesEntities())
     {
         return(entities.Users.Any(u => u.Username.Equals(username, StringComparison.OrdinalIgnoreCase)));
     }
 }
Exemple #9
0
        public List <string> GetListOfCategories()
        {
            MoviesEntities db = new MoviesEntities();

            string category = (from c in db.Movies
                               where c.Id == 1
                               select c.Category).Single();
            List <string> categories = new List <string>();

            categories.Add(category);

            for (int i = 1; i < db.Movies.Count(); i++)
            {
                string picked = (from c in db.Movies
                                 where c.Id == i
                                 select c.Category).Single();
                for (int x = 0; x < categories.Count; x++)
                {
                    if (!categories.Contains(picked))
                    {
                        categories.Add(picked);
                    }
                    else
                    {
                        continue;
                    }
                }
            }
            return(categories);
        }
Exemple #10
0
        public List <MovieList> GetRandomMovies(int id)
        {
            int              l            = 0;
            Random           rnd          = new Random();
            List <MovieList> RandomMovies = new List <MovieList>();

            while (l < id)
            {
                MoviesEntities db = new MoviesEntities();

                int ran = rnd.Next(1, 15);

                MovieList Movie = (from p in db.MovieLists
                                   where p.ID == (ran)
                                   select p).Single();

                if (RandomMovies.Contains(Movie))
                {
                    l--;
                }
                else
                {
                    RandomMovies.Add(Movie);

                    l++;
                }
            }

            return(RandomMovies);
        }
Exemple #11
0
        private static void MoviesAndRatings()
        {
            Console.WriteLine();
            using (MoviesEntities ctx = new MoviesEntities())
            {
                var movies = from m in ctx.Movies join g in ctx.Genres on m.GenreID equals g.GenreID select new {Rating = m.Rating, Title = m.Title, mGenre = g.TypeOfGenre, Length = m.LengthInMinutes, Desc = m.Description, Release = m.ReleaseDate, Dir = m.Director};

                foreach (var m in movies)
                {
                    Console.WriteLine("{0}", m.Title);
                    Console.WriteLine(new String('-', 30));
                    Console.WriteLine("Relased:{0} Director:{1} Genre:{2} Rating:{3} Length:{4} min", m.Release, m.Dir, m.mGenre, m.Rating, m.Length);
                    Console.WriteLine();
                    Console.WriteLine("Enter 1 to read a description or any key to continue.");
                    string input = Console.ReadLine();
                    if (input == "1")
                        Console.WriteLine("{0}", m.Desc);
                    Console.WriteLine();
                    Console.WriteLine("Enter 0 to return to Menu or press enter to see next movie.");
                    input = Console.ReadLine();
                    if (input == "0")
                        return;
                    //Console.ReadKey();
                }
            }
        }
 public string DeleteMovie(string movieId)
 {
     if (!String.IsNullOrEmpty(movieId))
     {
         try
         {
             int movieIds = Int32.Parse(movieId);
             using (MoviesEntities entity = new MoviesEntities())
             {
                 var mv = entity.Movies.Find(movieIds);
                 entity.Movies.Remove(mv);
                 entity.SaveChanges();
                 return("Selected movie record deleted successfully");
             }
         }
         catch (Exception)
         {
             return("Movie details not found");
         }
     }
     else
     {
         return("Invalid operation");
     }
 }
Exemple #13
0
        public bool Create(Actor actor)
        {
            ImageManager imageManager = new ImageManager();
            decimal      imageId      = imageManager.SaveImage(actor._Image.ImagePath, actor._Image.Title);

            try
            {
                if (imageId != 0)
                {
                    using (MoviesEntities db = new MoviesEntities())
                    {
                        tblActor tActor = new tblActor();
                        UpdateActorEntity(ref tActor, actor);
                        tActor.CreatedDateTime = DateTime.Now;
                        tActor.ImageId         = imageId;
                        db.tblActors.Add(tActor);
                        db.SaveChanges();
                    }
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception ex)
            {
                return(false);
            }
        }
        public List <Movie> GetMovies(Decimal?movieId = 0)
        {
            using (MoviesEntities db = new MoviesEntities())
            {
                var movieList = db.tblMovies.Include("tblActorMovies").Select(q => new
                {
                    Movie1 = new Movie
                    {
                        _Id            = q.MovieId,
                        _Name          = q.MovieName,
                        _YearOfRelease = q.YearOfRelease,
                        _Plot          = q.Plot,
                        _Image         = new Image()
                        {
                            ImageID   = q.ImageId,
                            ImagePath = q.tblImage.ImagePath,
                            Title     = q.tblImage.ImageTitle,
                        },

                        _ProducerName     = q.tblProducer.ProducerName,
                        _SelectedProducer = q.tblProducer.ProducerId,
                    },
                    _Actor = q.tblActorMovies.Select(r => new { r.ActorId, r.tblActor.ActorName })
                }).AsEnumerable().Select(p =>
                {
                    p.Movie1._Actors = p._Actor.ToDictionary(r => r.ActorId, r => r.ActorName);
                    return(p.Movie1);
                });
                if (movieId != 0)
                {
                    movieList = movieList.Where(q => q._Id == movieId).ToList();
                }
                return(movieList.ToList());
            }
        }
 public JsonResult GetAllMovies()
 {
     using (MoviesEntities entity = new MoviesEntities())
     {
         var movieList = entity.Movies.ToList();
         return(Json(movieList, JsonRequestBehavior.AllowGet));
     }
 }
 /// <summary>
 /// This method resets a user's password in the database
 /// </summary>
 /// <param name="password"></param>
 /// <param name="userId"></param>
 private void ResetUserPassword(string password, int userId)
 {
     using (MoviesEntities db = new MoviesEntities())
     {
         db.Users.FirstOrDefault(u => u.Id.Equals(userId)).Password = password;
         db.SaveChanges();
     }
 }
Exemple #17
0
        [HttpGet] //3.
        public Movy RandomMovie()
        {
            MoviesEntities ORM       = new MoviesEntities();
            Random         r         = new Random();
            List <Movy>    MovieList = ORM.Movies.ToList();

            return(MovieList[r.Next(0, MovieList.Count)]);
        }
Exemple #18
0
        public List <MovieList> GetMovies()
        {
            MoviesEntities db = new MoviesEntities();

            List <MovieList> Movies = db.MovieLists.ToList();

            return(Movies);
        }
Exemple #19
0
        public static void Main()
        {
            moviesContext = new MoviesEntities();

            ExportAdultMovies();
            ExportRatedMovieByUser("jmeyery");
            ExportTopTenFavouriteFilms();
        }
 // GET: Movie
 public ActionResult Index()
 {
     using (MoviesEntities entities = new MoviesEntities())
     {
         var list = entities.Movies.ToList();
         return(View(list));
     }
 }
Exemple #21
0
        public Movy GetRandomMovie()
        {
            MoviesEntities ORM = new MoviesEntities();

            List <Movy> movieLst = ORM.Movies.ToList();

            return(movieLst[randNum.Next(movieLst.Count)]);
        }
 public ActionResult Details(string id)
 {
     using (MoviesEntities entities = new MoviesEntities())
     {
         int val  = Int32.Parse(id);
         var user = entities.Actors.FirstOrDefault(x => x.Id == val);
         return(View(user));
     }
 }
Exemple #23
0
        public string[] GetMovieCategories()
        {
            MoviesEntities ORM = new MoviesEntities();

            string[] categories = (from m in ORM.Movies
                                   select m.Category).Distinct().OrderBy(Category => Category).ToArray();

            return(categories);
        }
Exemple #24
0
        public List <Movy> GetCategoryMovies(string category)
        {
            MoviesEntities db     = new MoviesEntities();
            List <Movy>    movies = (from c in db.Movies
                                     where c.Category == category
                                     select c).ToList();

            return(movies);
        }
Exemple #25
0
        public List <Movy> GetKeywordTitle(string keyword)
        {
            MoviesEntities db     = new MoviesEntities();
            List <Movy>    movies = (from c in db.Movies
                                     where c.Title.Contains(keyword)
                                     select c).ToList();

            return(movies);
        }
 public void UpdateProducer(Producer producer)
 {
     using (MoviesEntities db = new MoviesEntities())
     {
         tblProducer tProducer = db.tblProducers.Where(q => q.ProducerId == producer._Id).FirstOrDefault();
         UpdateEntity(ref tProducer, producer);
         db.SaveChanges();
     }
 }
        static void Main()
        {
            var moviesContext = new MoviesEntities();

            Console.WriteLine("Countries: {0}", moviesContext.Countries.Count());
            Console.WriteLine("Users: {0}", moviesContext.Users.Count());
            Console.WriteLine("Ratings: {0}", moviesContext.Ratings.Count());
            Console.WriteLine("Movies: {0}", moviesContext.Movies.Count());
        }
 public JsonResult GetMovieById(string id)
 {
     using (MoviesEntities entity = new MoviesEntities())
     {
         var movieId     = Convert.ToInt32(id);
         var searchMovie = entity.Movies.Find(movieId);
         return(Json(searchMovie, JsonRequestBehavior.AllowGet));
     }
 }
 public ActionResult EditActor(String id)
 {
     using (MoviesEntities entities = new MoviesEntities())
     {
         var Id   = Int32.Parse(id);
         var user = entities.Actors.FirstOrDefault(x => x.Id == Id);
         return(View(user));
     }
 }
Exemple #30
0
        public Movy GetRandomMovieByCat(string catName)
        {
            MoviesEntities ORM = new MoviesEntities();

            List <Movy> movieLst = (from m in ORM.Movies
                                    where m.Category == catName
                                    select m).ToList();

            return(movieLst[randNum.Next(movieLst.Count)]);
        }
 public ActionResult Add(Actor actor)
 {
     using (MoviesEntities entities = new MoviesEntities())
     {
         entities.Actors.Add(actor);
         entities.SaveChanges();
     }
     ViewBag.Added = " New Actor Has been Added ";
     return(View());
 }
Exemple #32
0
        public List <MovieList> GetMoviesByCategory(string id)
        {
            MoviesEntities db = new MoviesEntities();

            List <MovieList> Movies = (from p in db.MovieLists
                                       where p.Category.Contains(id)
                                       select p).ToList();

            return(Movies);
        }
        static void Main()
        {
            var context = new MoviesEntities();

            //1.	Adult Movies
            //Export all adult movies. Order them by title and by ratings received as secondary criteria.
            //Select each movie's title and the number of ratings received.

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

            string adultMoviesJson = JsonConvert.SerializeObject(adultMovies, Newtonsoft.Json.Formatting.Indented);
            File.WriteAllText("../../adult-movies.json", adultMoviesJson);

            // Query 2.Rated Movies by User:
            var ratedMoviesByUser = context.Users
                .Where(u => u.Username == "jmeyery")
                .Select(u => new
                {
                    username = u.Username,
                    ratedMovies = u.Ratings
                        .OrderBy(r => r.Movie.Title)
                        .Select(r => new
                        {
                            title = r.Movie.Title,
                            userRating = r.Stars,
                            averageRating = r.Movie.Ratings.Average(rStars => rStars.Stars)
                        })
                });
            string ratedMoviesByUserJson = JsonConvert.SerializeObject(ratedMoviesByUser, Newtonsoft.Json.Formatting.Indented);
            File.WriteAllText("../../rated-movies-by-jmeyery.json", ratedMoviesByUserJson);

            //// Query 3.Top 10 Favourite Movies:
            var favouriteMovies = context.Movies
                .Where(m => m.AgeRestriction == AgeRestriction.Teen)
                .OrderByDescending(m => m.UsersThatMovieIsFavourite.Count)
                .ThenBy(m => m.Title)
                .Take(10)
                .Select(m => new
                {
                    isbn = m.Isbn,
                    title = m.Title,
                    favouritedBy = m.UsersThatMovieIsFavourite.Select(u => u.Username)
                });

            string favouriteMoviesJson = JsonConvert.SerializeObject(favouriteMovies, Newtonsoft.Json.Formatting.Indented);
            File.WriteAllText("../../top-10-favourite-movies.json", favouriteMoviesJson);
        }
        public static void Main()
        {
            var context = new MoviesEntities();
            var js = new JavaScriptSerializer();

            ExportAdultMovies(context, js);

            ExportRatedMoviesByUser(context, js);

            ExportTopFavouriteMovies(context, js);
        }
        private static void ExportRatedMoviesByUser(MoviesEntities context, JavaScriptSerializer js)
        {
            var ratedMoviesByUser = context.Users
                .Select(u => new
                             {
                                 username = u.Username,
                                 ratedMovies = u.Movies.Where(m => m.Ratings.Count > 0) // no idea
                             });

            var output = js.Serialize(ratedMoviesByUser);
            //File.AppendAllText(@"..\..\Results\rated-movies-by-jmeyery.json", output);
            //Console.WriteLine("Export rated-movies-by-jmeyery.json complited!");
        }
 static void Main()
 {
     var db = new MoviesEntities();
     var movies = db.Movies.Where(m => m.AgeRestriction == AgeRestriction.Teen).Select(m => new
     {
         m.Isbn,
         m.Title,
         favouriteBy = m.Users.Select(u => u.Username)
     })
     .Take(10);
     foreach (var movie in movies)
     {
         Console.WriteLine(movie.Isbn + " " + movie.Title + " " + string.Join(", ", movie.favouriteBy));
     }
 }
        private static void ExportAdultMovies(MoviesEntities context, JavaScriptSerializer js)
        {
            var allAdultMovies = context.Movies
                .Where(m => m.AgeRestriction == AgeRestriction.Adult)
                .Select(m => new
                             {
                                 title = m.Title,
                                 ratingsGiven = m.Ratings.Count
                             })
                .OrderBy(m => m.title)
                .ThenBy(m => m.ratingsGiven);

            var output = js.Serialize(allAdultMovies);
            File.AppendAllText(@"..\..\Results\adult-movies.json", output);
            Console.WriteLine("Export adult-movies.json complited!");
        }
        private static void ExportTopFavouriteMovies(MoviesEntities context, JavaScriptSerializer js)
        {
            var topTenFavouriteTeenMovies = context.Movies
                .Where(m => m.AgeRestriction == AgeRestriction.Teen)
                .Select(m => new
                             {
                                 isbn = m.Isbn,
                                 title = m.Title,
                                 favouritedBy = m.Ratings.Count // no idea
                             })
                .OrderByDescending(m => m.favouritedBy)
                .ThenBy(m => m.title)
                .Take(10);

            var output = js.Serialize(topTenFavouriteTeenMovies);
            //File.AppendAllText(@"..\..\Results\top-10-favourite-movies.json", output);
            //Console.WriteLine("Export top-10-favourite-movies.json complited!");
        }
Exemple #39
0
 private static void ActorsAndMovies()
 {
     Console.WriteLine();
     using (MoviesEntities ctx = new MoviesEntities())
     {
         var actors = from a in ctx.Actors select a;
         foreach (var a in actors)
         {
             Console.WriteLine("{0} {1}", a.FirstName, a.LastName);
             Console.WriteLine(new String('-', 30));
             foreach(var m in a.Filmographies)
             {
                 Console.WriteLine("{0}", m.Movie.Title);
             }
             Console.WriteLine();
         }
     }
 }
 public PersonRepository()
 {
     db = new MoviesEntities();
 }
 public MoviesRepository()
 {
     db = new MoviesEntities();
     MoviesEntities asd = new MoviesEntities();
 }
Exemple #42
0
        private static void MovieSchedules()
        {
            Console.WriteLine();
            using (MoviesEntities ctx = new MoviesEntities())
            {
                var sched = from s in ctx.MovieSchedules join m in ctx.Movies on s.MovieID equals m.MovieID join t in ctx.Theaters on s.TheaterID equals t.TheaterID orderby t.NameOfTheater, s.StartDateAndTime descending select new { TheaterName = t.NameOfTheater, Time = s.StartDateAndTime, Title = m.Title };

                foreach (var s in sched)
                {
                    Console.WriteLine("{0} {1}\n{2}", s.TheaterName, s.Time, s.Title);
                    Console.WriteLine();
                }
            }
        }