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 AddArmChair(ArmChair armChair)
{
}
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 UpdateArmChair(ArmChair armChair)
{
}
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);
}
public void AddArmChair(ArmChair armChair)
{
_context.ArmChair.Add(armChair);
_context.SaveChanges();
}
