Exemplo n.º 1
0
 public IActionResult AddMovie(string id)
 {
     if (string.IsNullOrEmpty(id))
     {
         return(NotFound());
     }
     if (Top10Id == null || Top10Id == "")
     {
         var top          = AdministrationRepository.GetTop();
         var movieOnTop10 = new MovieOnTop10
         {
             MovieId        = id,
             Top10Id        = top.Top10Id,
             Top10          = top,
             MovieOnTop10Id = Guid.NewGuid().ToString()
         };
         AdministrationRepository.AddMovieOnTop10(movieOnTop10);
     }
     else
     {
         var movieOnTop10 = new MovieOnTop10
         {
             MovieId        = id,
             Top10Id        = Top10Id,
             MovieOnTop10Id = Guid.NewGuid().ToString()
         };
         AdministrationRepository.AddMovieOnTop10(movieOnTop10);
     }
     return(RedirectToAction("GetTop10"));
 }
 public void AddMovieOnTop10(MovieOnTop10 movieOnTop10)
 {
 }
Exemplo n.º 3
0
        public static void SeedDataBase(IServiceProvider serviceProvider)
        {
            var context = serviceProvider.GetRequiredService <CinePlusDBContext>();

            if (!context.MovieType.Any())
            {
                var type = new MovieType
                {
                    Name        = "Acción",
                    MovieTypeId = Guid.NewGuid().ToString()
                };
                context.MovieType.Add(type);
                context.SaveChanges();

                type = new MovieType
                {
                    Name        = "Terror",
                    MovieTypeId = Guid.NewGuid().ToString()
                };
                context.MovieType.Add(type);
                context.SaveChanges();

                type = new MovieType
                {
                    Name        = "Horror",
                    MovieTypeId = Guid.NewGuid().ToString()
                };
                context.MovieType.Add(type);
                context.SaveChanges();

                type = new MovieType
                {
                    Name        = "Comedia",
                    MovieTypeId = Guid.NewGuid().ToString()
                };
                context.MovieType.Add(type);
                context.SaveChanges();

                type = new MovieType
                {
                    Name        = "Drama",
                    MovieTypeId = Guid.NewGuid().ToString()
                };
                context.MovieType.Add(type);
                context.SaveChanges();

                type = new MovieType
                {
                    Name        = "Aventura",
                    MovieTypeId = Guid.NewGuid().ToString()
                };
                context.MovieType.Add(type);
                context.SaveChanges();
            }

            if (!context.Movie.Any())
            {
                var movie = new Movie
                {
                    Name        = "Rápido y Furioso I",
                    DateUpload  = DateTime.Now,
                    Description = "Película de Carrera de Autos, protagonizada por Paul Walker and Vin Diesel.",
                    Director    = "Rob Cohen",
                    MovieType   = context.MovieType.Where(x => x.Name == "Acción").FirstOrDefault(),
                    MovieTypeId = context.MovieType.Where(x => x.Name == "Acción").FirstOrDefault().MovieTypeId,
                    URL         = "https://localhost:44304/img/movie.jpg",
                    MovieId     = Guid.NewGuid().ToString()
                };
                context.Movie.Add(movie);
                context.SaveChanges();

                movie = new Movie
                {
                    Name        = "Titanic",
                    DateUpload  = DateTime.Now,
                    Description = "Película basada en hechos reales que relata los sucesos del zarpe, travesía y hundimiento del trasatlántico Titanic.",
                    Director    = "James Cameron",
                    MovieType   = context.MovieType.Where(x => x.Name == "Drama").FirstOrDefault(),
                    MovieTypeId = context.MovieType.Where(x => x.Name == "Drama").FirstOrDefault().MovieTypeId,
                    URL         = "https://localhost:44304/img/movie.jpg",
                    MovieId     = Guid.NewGuid().ToString()
                };
                context.Movie.Add(movie);
                context.SaveChanges();

                movie = new Movie
                {
                    Name        = "The Curse of La Llorona",
                    DateUpload  = DateTime.Now,
                    Description = "Es protagonizada por Linda Cardellini, Patricia Velásquez, Sean Patrick Thomas y Raymond Cruz.​ James Wan es el productor a través de su compañía Atomic Monster Productions.",
                    Director    = "Michael Chaves",
                    MovieType   = context.MovieType.Where(x => x.Name == "Terror").FirstOrDefault(),
                    MovieTypeId = context.MovieType.Where(x => x.Name == "Terror").FirstOrDefault().MovieTypeId,
                    URL         = "https://localhost:44304/img/movie.jpg",
                    MovieId     = Guid.NewGuid().ToString()
                };
                context.Movie.Add(movie);
                context.SaveChanges();

                movie = new Movie
                {
                    Name        = "Ocho Apellidos Bascos",
                    DateUpload  = DateTime.Now,
                    Description = "Relata la historia de amor entre una vasca y un sevillano a pesar de las diferencias políticas y culturales.",
                    Director    = "Emilio Martínez-Lázaro",
                    MovieType   = context.MovieType.Where(x => x.Name == "Comedia").FirstOrDefault(),
                    MovieTypeId = context.MovieType.Where(x => x.Name == "Comedia").FirstOrDefault().MovieTypeId,
                    URL         = "https://localhost:44304/img/movie.jpg",
                    MovieId     = Guid.NewGuid().ToString()
                };
                context.Movie.Add(movie);
                context.SaveChanges();

                movie = new Movie
                {
                    Name        = "Harry Potter I",
                    DateUpload  = DateTime.Now,
                    Description = "Relata la historia de un mago en la escuela de Howarts.",
                    Director    = "Chris Columbus",
                    MovieType   = context.MovieType.Where(x => x.Name == "Comedia").FirstOrDefault(),
                    MovieTypeId = context.MovieType.Where(x => x.Name == "Comedia").FirstOrDefault().MovieTypeId,
                    URL         = "https://localhost:44304/img/movie.jpg",
                    MovieId     = Guid.NewGuid().ToString()
                };
                context.Movie.Add(movie);
                context.SaveChanges();
            }

            if (!context.Top10.Any())
            {
                var top = new Top10
                {
                    Name    = "Las más vistas",
                    Top10Id = Guid.NewGuid().ToString()
                };
                context.Top10.Add(top);
                context.SaveChanges();
            }

            if (!context.MovieOnTop10.Any())
            {
                var movieOnTop10 = new MovieOnTop10
                {
                    MovieOnTop10Id = Guid.NewGuid().ToString(),
                    Top10          = context.Top10.Where(x => x.Name == "Las más vistas").FirstOrDefault(),
                    Top10Id        = context.Top10.Where(x => x.Name == "Las más vistas").FirstOrDefault().Top10Id,
                    Movie          = context.Movie.Where(x => x.Name == "Rápido y Furioso I").FirstOrDefault(),
                    MovieId        = context.Movie.Where(x => x.Name == "Rápido y Furioso I").FirstOrDefault().MovieId,
                };
                context.MovieOnTop10.Add(movieOnTop10);
                context.SaveChanges();

                movieOnTop10 = new MovieOnTop10
                {
                    MovieOnTop10Id = Guid.NewGuid().ToString(),
                    Top10          = context.Top10.Where(x => x.Name == "Las más vistas").FirstOrDefault(),
                    Top10Id        = context.Top10.Where(x => x.Name == "Las más vistas").FirstOrDefault().Top10Id,
                    Movie          = context.Movie.Where(x => x.Name == "Titanic").FirstOrDefault(),
                    MovieId        = context.Movie.Where(x => x.Name == "Titanic").FirstOrDefault().MovieId,
                };
                context.MovieOnTop10.Add(movieOnTop10);
                context.SaveChanges();

                movieOnTop10 = new MovieOnTop10
                {
                    MovieOnTop10Id = Guid.NewGuid().ToString(),
                    Top10          = context.Top10.Where(x => x.Name == "Las más vistas").FirstOrDefault(),
                    Top10Id        = context.Top10.Where(x => x.Name == "Las más vistas").FirstOrDefault().Top10Id,
                    Movie          = context.Movie.Where(x => x.Name == "The Curse of La Llorona").FirstOrDefault(),
                    MovieId        = context.Movie.Where(x => x.Name == "The Curse of La Llorona").FirstOrDefault().MovieId,
                };
                context.MovieOnTop10.Add(movieOnTop10);
                context.SaveChanges();

                movieOnTop10 = new MovieOnTop10
                {
                    MovieOnTop10Id = Guid.NewGuid().ToString(),
                    Top10          = context.Top10.Where(x => x.Name == "Las más vistas").FirstOrDefault(),
                    Top10Id        = context.Top10.Where(x => x.Name == "Las más vistas").FirstOrDefault().Top10Id,
                    Movie          = context.Movie.Where(x => x.Name == "Ocho Apellidos Bascos").FirstOrDefault(),
                    MovieId        = context.Movie.Where(x => x.Name == "Ocho Apellidos Bascos").FirstOrDefault().MovieId,
                };
                context.MovieOnTop10.Add(movieOnTop10);
                context.SaveChanges();

                movieOnTop10 = new MovieOnTop10
                {
                    MovieOnTop10Id = Guid.NewGuid().ToString(),
                    Top10          = context.Top10.Where(x => x.Name == "Las más vistas").FirstOrDefault(),
                    Top10Id        = context.Top10.Where(x => x.Name == "Las más vistas").FirstOrDefault().Top10Id,
                    Movie          = context.Movie.Where(x => x.Name == "Harry Potter I").FirstOrDefault(),
                    MovieId        = context.Movie.Where(x => x.Name == "Harry Potter I").FirstOrDefault().MovieId,
                };
                context.MovieOnTop10.Add(movieOnTop10);
                context.SaveChanges();
            }

            if (!context.Show.Any())
            {
                var room = new Room
                {
                    RoomId      = Guid.NewGuid().ToString(),
                    Name        = "Principal",
                    NoArmChairs = 200
                };
                var discount1 = new Discount
                {
                    DiscountId = Guid.NewGuid().ToString(),
                    Name       = "Estudiantes de la FEU",
                    Percent    = 50
                };
                var discount2 = new Discount
                {
                    DiscountId = "ninguno",
                    Name       = "Ninguno",
                    Percent    = 0
                };
                var show1 = new Show
                {
                    Room          = room,
                    RoomId        = room.RoomId,
                    DateTime      = DateTime.Now.AddHours(5),
                    Price         = 50,
                    PriceInPoints = 20,
                    ShowId        = Guid.NewGuid().ToString(),
                    Movie         = context.Movie.Where(x => x.Name == "Rápido y Furioso I").FirstOrDefault(),
                    MovieId       = context.Movie.Where(x => x.Name == "Rápido y Furioso I").FirstOrDefault().MovieId
                };
                var discountByShow1 = new DiscountsByShow
                {
                    Discount          = discount1,
                    DiscountId        = discount1.DiscountId,
                    DiscountsByShowId = Guid.NewGuid().ToString(),
                    Show   = show1,
                    ShowId = show1.ShowId
                };
                var discountByShow2 = new DiscountsByShow
                {
                    Discount          = discount2,
                    DiscountId        = discount2.DiscountId,
                    DiscountsByShowId = Guid.NewGuid().ToString(),
                    Show   = show1,
                    ShowId = show1.ShowId
                };

                context.Discount.Add(discount1);
                context.Discount.Add(discount2);
                context.Show.Add(show1);
                context.DiscountsByShow.Add(discountByShow1);
                context.DiscountsByShow.Add(discountByShow2);
                context.SaveChanges();

                var show2 = new Show
                {
                    Room          = room,
                    RoomId        = room.RoomId,
                    DateTime      = DateTime.Now.AddHours(5),
                    Price         = 20,
                    PriceInPoints = 20,
                    ShowId        = Guid.NewGuid().ToString(),
                    Movie         = context.Movie.Where(x => x.Name == "Titanic").FirstOrDefault(),
                    MovieId       = context.Movie.Where(x => x.Name == "Titanic").FirstOrDefault().MovieId
                };
                discountByShow1 = new DiscountsByShow
                {
                    Discount          = discount1,
                    DiscountId        = discount1.DiscountId,
                    DiscountsByShowId = Guid.NewGuid().ToString(),
                    Show   = show2,
                    ShowId = show2.ShowId
                };
                discountByShow2 = new DiscountsByShow
                {
                    Discount          = discount2,
                    DiscountId        = discount2.DiscountId,
                    DiscountsByShowId = Guid.NewGuid().ToString(),
                    Show   = show2,
                    ShowId = show2.ShowId
                };

                context.Show.Add(show2);
                context.DiscountsByShow.Add(discountByShow1);
                context.DiscountsByShow.Add(discountByShow2);
                context.SaveChanges();

                var show3 = new Show
                {
                    Room          = room,
                    RoomId        = room.RoomId,
                    DateTime      = DateTime.Now.AddHours(5),
                    Price         = 20,
                    PriceInPoints = 20,
                    ShowId        = Guid.NewGuid().ToString(),
                    Movie         = context.Movie.Where(x => x.Name == "The Curse of La Llorona").FirstOrDefault(),
                    MovieId       = context.Movie.Where(x => x.Name == "The Curse of La Llorona").FirstOrDefault().MovieId
                };
                discountByShow1 = new DiscountsByShow
                {
                    Discount          = discount1,
                    DiscountId        = discount1.DiscountId,
                    DiscountsByShowId = Guid.NewGuid().ToString(),
                    Show   = show3,
                    ShowId = show3.ShowId
                };
                discountByShow2 = new DiscountsByShow
                {
                    Discount          = discount2,
                    DiscountId        = discount2.DiscountId,
                    DiscountsByShowId = Guid.NewGuid().ToString(),
                    Show   = show3,
                    ShowId = show3.ShowId
                };

                context.Show.Add(show3);
                context.DiscountsByShow.Add(discountByShow1);
                context.DiscountsByShow.Add(discountByShow2);
                context.SaveChanges();

                var show4 = new Show
                {
                    Room          = room,
                    RoomId        = room.RoomId,
                    DateTime      = DateTime.Now.AddHours(5),
                    Price         = 20,
                    PriceInPoints = 20,
                    ShowId        = Guid.NewGuid().ToString(),
                    Movie         = context.Movie.Where(x => x.Name == "Ocho Apellidos Bascos").FirstOrDefault(),
                    MovieId       = context.Movie.Where(x => x.Name == "Ocho Apellidos Bascos").FirstOrDefault().MovieId
                };
                discountByShow1 = new DiscountsByShow
                {
                    Discount          = discount1,
                    DiscountId        = discount1.DiscountId,
                    DiscountsByShowId = Guid.NewGuid().ToString(),
                    Show   = show4,
                    ShowId = show4.ShowId
                };
                discountByShow2 = new DiscountsByShow
                {
                    Discount          = discount2,
                    DiscountId        = discount2.DiscountId,
                    DiscountsByShowId = Guid.NewGuid().ToString(),
                    Show   = show4,
                    ShowId = show4.ShowId
                };

                context.Show.Add(show4);
                context.DiscountsByShow.Add(discountByShow1);
                context.DiscountsByShow.Add(discountByShow2);
                context.SaveChanges();

                var show5 = new Show
                {
                    Room          = room,
                    RoomId        = room.RoomId,
                    DateTime      = DateTime.Now.AddHours(5),
                    Price         = 20,
                    PriceInPoints = 20,
                    ShowId        = Guid.NewGuid().ToString(),
                    Movie         = context.Movie.Where(x => x.Name == "Harry Potter I").FirstOrDefault(),
                    MovieId       = context.Movie.Where(x => x.Name == "Harry Potter I").FirstOrDefault().MovieId
                };
                discountByShow1 = new DiscountsByShow
                {
                    Discount          = discount1,
                    DiscountId        = discount1.DiscountId,
                    DiscountsByShowId = Guid.NewGuid().ToString(),
                    Show   = show5,
                    ShowId = show5.ShowId
                };
                discountByShow2 = new DiscountsByShow
                {
                    Discount          = discount2,
                    DiscountId        = discount2.DiscountId,
                    DiscountsByShowId = Guid.NewGuid().ToString(),
                    Show   = show5,
                    ShowId = show5.ShowId
                };

                context.Show.Add(show5);
                context.DiscountsByShow.Add(discountByShow1);
                context.DiscountsByShow.Add(discountByShow2);
                context.SaveChanges();

                for (int i = 0; i < 200; i++)
                {
                    var armChair = new ArmChair
                    {
                        ArmChairId = Guid.NewGuid().ToString(),
                        No         = i + 1
                    };
                    var armChairByRoom1 = new ArmChairByRoom
                    {
                        ArmChair         = armChair,
                        ArmChairByRoomId = Guid.NewGuid().ToString(),
                        ArmChairId       = armChair.ArmChairId,
                        Room             = room,
                        RoomId           = room.RoomId,
                        StateArmChair    = StateArmChair.ready,
                        ShowId           = show1.ShowId,
                        Show             = show1
                    };
                    var armChairByRoom2 = new ArmChairByRoom
                    {
                        ArmChair         = armChair,
                        ArmChairByRoomId = Guid.NewGuid().ToString(),
                        ArmChairId       = armChair.ArmChairId,
                        Room             = room,
                        RoomId           = room.RoomId,
                        StateArmChair    = StateArmChair.ready,
                        ShowId           = show2.ShowId,
                        Show             = show2
                    };
                    var armChairByRoom3 = new ArmChairByRoom
                    {
                        ArmChair         = armChair,
                        ArmChairByRoomId = Guid.NewGuid().ToString(),
                        ArmChairId       = armChair.ArmChairId,
                        Room             = room,
                        RoomId           = room.RoomId,
                        StateArmChair    = StateArmChair.ready,
                        ShowId           = show3.ShowId,
                        Show             = show3
                    };
                    var armChairByRoom4 = new ArmChairByRoom
                    {
                        ArmChair         = armChair,
                        ArmChairByRoomId = Guid.NewGuid().ToString(),
                        ArmChairId       = armChair.ArmChairId,
                        Room             = room,
                        RoomId           = room.RoomId,
                        StateArmChair    = StateArmChair.ready,
                        ShowId           = show4.ShowId,
                        Show             = show4
                    };
                    var armChairByRoom5 = new ArmChairByRoom
                    {
                        ArmChair         = armChair,
                        ArmChairByRoomId = Guid.NewGuid().ToString(),
                        ArmChairId       = armChair.ArmChairId,
                        Room             = room,
                        RoomId           = room.RoomId,
                        StateArmChair    = StateArmChair.ready,
                        ShowId           = show5.ShowId,
                        Show             = show5
                    };

                    context.ArmChair.Add(armChair);
                    context.ArmChairByRoom.Add(armChairByRoom1);
                    context.ArmChairByRoom.Add(armChairByRoom2);
                    context.ArmChairByRoom.Add(armChairByRoom3);
                    context.ArmChairByRoom.Add(armChairByRoom4);
                    context.ArmChairByRoom.Add(armChairByRoom5);
                    context.SaveChanges();
                }
            }
        }
Exemplo n.º 4
0
 public void AddMovieOnTop10(MovieOnTop10 movieOnTop10)
 {
     _context.MovieOnTop10.Add(movieOnTop10);
     _context.SaveChanges();
 }