public IActionResult CreateRoom(CreateRoomRequest request) { if (ModelState.IsValid) { Room room = new Room { Name = request.Name, NoArmChairs = request.ArmChairs, RoomId = Guid.NewGuid().ToString() }; AdministrationRepository.AddRoom(room); for (int i = 0; i < request.ArmChairs; i++) { ArmChair armChair = new ArmChair { ArmChairId = Guid.NewGuid().ToString(), No = i + 1 }; ArmChairByRoom armChairByRoom = new ArmChairByRoom { ArmChairId = armChair.ArmChairId, RoomId = room.RoomId, ArmChairByRoomId = Guid.NewGuid().ToString(), StateArmChair = StateArmChair.ready }; AdministrationRepository.AddArmChair(armChair); AdministrationRepository.AddArmChairByRoom(armChairByRoom); } return(RedirectToAction("GetRooms")); } foreach (var error in ModelState.Values) { foreach (var item in error.Errors) { Logger.LogError(item.ErrorMessage); } } return(RedirectToAction("GetRooms")); }
public void AddArmChairByRoom(ArmChairByRoom armChairByRoom) { }
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(); } } }
public void AddArmChairByRoom(ArmChairByRoom armChairByRoom) { _context.ArmChairByRoom.Add(armChairByRoom); _context.SaveChanges(); }
public void UpdateArmChairByRoom(ArmChairByRoom armChairByRoom) { _context.ArmChairByRoom.Update(armChairByRoom); _context.SaveChanges(); }
public void AddArmChairByRoom(ArmChairByRoom armChairByRoom) { throw new NotImplementedException(); }
public void UpdateArmChairByRoom(ArmChairByRoom armChairByRoom) { }
public List <Pay> GetPayByUserIdAndPayCartId(string userId, string payCartId) { string newPayCartId = Guid.NewGuid().ToString(); string PayId = Guid.NewGuid().ToString(); string discoutID = Guid.NewGuid().ToString(); string movieID = Guid.NewGuid().ToString(); string movieTypeID = Guid.NewGuid().ToString(); string room1ID = Guid.NewGuid().ToString(); string room2ID = Guid.NewGuid().ToString(); string showID = Guid.NewGuid().ToString(); string armChairID = Guid.NewGuid().ToString(); string armChairByRoomID = Guid.NewGuid().ToString(); string userBoughtArmChairID = Guid.NewGuid().ToString(); User user = new User { Role = Roles.Client, Name = "Valid", LastName = ":)" }; PayCart payCart = new PayCart() { User = user, CardHash = "zwxXyz", DateTime = DateTime.Now, PayCartId = newPayCartId, PayedMoney = 1, PayedPoints = 1, UserId = Guid.NewGuid().ToString() }; MovieType movieType1 = new MovieType() { MovieTypeId = Guid.NewGuid().ToString(), Name = "Crime" }; Movie movie = new Movie() { MovieId = movieID, DateUpload = DateTime.Now, Name = "The Godfather", Description = "An organized crime dynasty's aging patriarch transfers control of his clandestine empire to his reluctant son.", Director = "Francis Ford Coppola", URL = "https://localhost:44304/img/movie.jpg", MovieType = movieType1, MovieTypeId = movieTypeID }; Room room1 = new Room() { RoomId = room1ID, Name = "2B", NoArmChairs = 1 }; Room room2 = new Room() { RoomId = room2ID, Name = "A1", NoArmChairs = 2 }; Show show = new Show() { ShowId = showID, DateTime = DateTime.Now, Movie = movie, MovieId = movieID, Price = 1, PriceInPoints = 1, Room = room1, RoomId = room1ID }; ArmChair armChair = new ArmChair() { ArmChairId = armChairID, No = 2 }; ArmChairByRoom armChairByRoom = new ArmChairByRoom() { ArmChairByRoomId = armChairByRoomID, ArmChairId = armChairID, ArmChair = armChair, RoomId = room2ID, Room = room2, StateArmChair = StateArmChair.ready, Show = show, ShowId = show.ShowId }; UserBoughtArmChair userBoughtArmChair = new UserBoughtArmChair() { UserBoughtArmChairId = userBoughtArmChairID, ArmChairByRoomId = armChairByRoomID, ArmChairByRoom = armChairByRoom, ShowId = showID, Show = show, UserId = userId, User = user }; Discount discount1 = new Discount() { DiscountId = discoutID, Name = "Black Friday", Percent = 15 }; Pay pay = new Pay() { PayId = PayId, PayCartId = newPayCartId, DiscountId = discoutID, Discount = discount1, PayCart = payCart, UserBougthArmChairId = userBoughtArmChairID, UserBoughtArmChair = userBoughtArmChair }; List <Pay> pays = new List <Pay>(); pays.Add(pay); return(pays); }