/// <summary>
/// Function that sets the bookingId on tickets to correct id.
/// </summary>
/// <param name="bookedSeats"></param>
/// <param name="room"></param>
/// <param name="showTime"></param>
/// <param name="phoneNumber"></param>
public void BookTickets(List <int> bookedSeats, int room, int showTime, string phoneNumber)
{
using (var movieContext = new MovieAppContext())
{
try
{
var listOfTickets = movieContext.Tickets.Where(ticket => ticket.RoomId == room)
.Where(ticket => ticket.ShowTimeId == showTime)
.ToList();
var customer = movieContext.Customers.Single(customer => customer.PhoneNumber == phoneNumber);
movieContext.Bookings.Add(new Booking {
MovieId = room, CustomerId = customer.Id
});
movieContext.SaveChanges();
var booking = movieContext.Bookings.OrderByDescending(booking => booking.Id).First();
foreach (var seat in bookedSeats)
{
foreach (var ticket in listOfTickets)
{
if (seat == ticket.SeatNumber)
{
ticket.BookingId = booking.Id;
}
movieContext.SaveChanges();
}
}
}
catch (Exception)
{
throw;
}
}
}
/// <summary>
/// Deletes the booking, if the customer has chosen to delete the booking.
/// It deletes the row in database table "Bookings" and
/// Sets the tickets bookingId to null
/// </summary>
/// <param name="bookingId"></param>
public void DeleteBooking(int bookingId)
{
using (var movieContext = new MovieAppContext())
{
try
{
var customerId = movieContext.Bookings.First(booking => booking.Id == bookingId).CustomerId;
var phoneNumber = movieContext.Customers.First(customer => customer.Id == customerId).PhoneNumber;
var tickets = movieContext.Tickets.Where(ticket => ticket.BookingId == bookingId).ToList();
foreach (var ticket in tickets)
{
ticket.BookingId = null;
}
var bookings = movieContext.Bookings.Where(booking => booking.Id == bookingId).ToList();
foreach (var booking in bookings)
{
movieContext.Bookings.Remove(booking);
}
movieContext.SaveChanges();
if (ListOfCustomerBookings(phoneNumber).Count == 0)
{
DeleteCustomer(phoneNumber);
}
movieContext.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
public void Execute(MovieList changedMovieList)
{
var movies = new List <Movie>();
foreach (var movie in changedMovieList.Movies)
{
movies.Add(_context.Movies.Find(movie.Id));
}
var movieList = _context.MovieLists.Find(changedMovieList.Id);
movieList.Name = changedMovieList.Name;
movieList.Movies.Clear();
movieList.Movies = movies;
_context.SaveChanges();
}
/// <summary>
/// Deletes customer if the customer doesn't have any bookings.
/// </summary>
/// <param name="phoneNumber"></param>
public void DeleteCustomer(string phoneNumber)
{
using (var movieContext = new MovieAppContext())
{
try
{
var customerList = movieContext.Customers.Where(customer => customer.PhoneNumber == phoneNumber).ToList();
foreach (var customer in customerList)
{
movieContext.Customers.Remove(customer);
}
movieContext.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
public void Execute(Movie changedMovie)
{
var movie = _context.Movies.Find(changedMovie.Id);
movie.Actors.Clear();
movie.Hashtags.Clear();
movie.MovieLists.Clear();
var actors = new List <Actor>();
foreach (var actor in changedMovie.Actors)
{
actors.Add(_context.Actors.Find(actor.Id));
}
var hashtags = new List <Hashtag>();
foreach (var hashtag in changedMovie.Hashtags)
{
hashtags.Add(_context.Hashtags.Find(hashtag.Id));
}
var movieLists = new List <MovieList>();
foreach (var movieList in changedMovie.MovieLists)
{
movieLists.Add(_context.MovieLists.Find(movieList.Id));
}
var director = _context.Directors.Find(changedMovie.DirectorId);
var genre = _context.Genres.Find(changedMovie.GenreId);
movie.Name = changedMovie.Name;
movie.Actors = actors;
movie.DirectorId = changedMovie.DirectorId;
movie.GenreId = changedMovie.GenreId;
movie.Hashtags = hashtags;
movie.MovieLists = movieLists;
_context.SaveChanges();
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new MovieAppContext(
serviceProvider.GetRequiredService <
DbContextOptions <MovieAppContext> >()))
{
// Look for any movies.
if (context.Movies.Any())
{
return; // DB has been seeded
}
context.Movies.AddRange(
new Movie {
title = "The Shawshank Redemption", year = 1994, description = "Framed in the 1940s for the double murder of his wife and her lover, upstanding banker Andy Dufresne begins a new life at the Shawshank prison, where he puts his accounting skills to work for an amoral warden. During his long stretch in prison, Dufresne comes to be admired by the other inmates -- including an older prisoner named Red -- for his integrity and unquenchable sense of hope.", rating = "R"
},
new Movie {
title = "The Godfather", year = 1972, description = "The story spans the years from 1945 to 1955 and chronicles the fictional Italian-American Corleone crime family. When organized crime family patriarch Vito Corleone barely survives an attempt on his life, his youngest son, Michael, steps in to take care of the would-be killers, launching a campaign of bloody revenge.", rating = "R"
},
new Movie {
title = "The Godfather: Part II", year = 1974, description = "The continuing saga of the Corleone crime family tells the story of a young Vito Corleone growing up in Sicily and in 1910s New York; and follows Michael Corleone in the 1950s as he attempts to expand the family business into Las Vegas, Hollywood and Cuba", rating = "R"
},
new Movie {
title = "The Dark Knight", year = 2008, description = "Batman raises the stakes in his war on crime. With the help of Lt. Jim Gordon and District Attorney Harvey Dent, Batman sets out to dismantle the remaining criminal organizations that plague the streets. The partnership proves to be effective, but they soon find themselves prey to a reign of chaos unleashed by a rising criminal mastermind known to the terrified citizens of Gotham as the Joker.", rating = "BG-13"
},
new Movie {
title = "Schindler's List", year = 1993, description = "Told from the perspective of businessman Oskar Schindler who saved over a thousand Jewish lives from the Nazis while they worked as slaves in his factory. Schindler’s List is based on a true story, illustrated in black and white and controversially filmed in many original locations.", rating = "R"
},
new Movie {
title = "12 Angry Men", year = 1957, description = "12 Angry Men is the 1957 film debut for director Sidney Lumet. An interpretion from a Broadway show, this film is about 12 jurors who must decide whether an 18-year-old is guilty of killing his father.", rating = "G"
},
new Movie {
title = "Pulp Fiction", year = 1994, description = " Pulp Fiction is a cult film by Director Quentin Tarantino with three interwoven plots with lots of violence, absurdity, and great music. The film is Tarantino’s most famous and the film that cemented his name and style in Hollywood.", rating = "R"
},
new Movie {
title = "The Lord of the Rings: The Return of the King", year = 2003, description = "Aragorn is revealed as the heir to the ancient kings as he, Gandalf and the other members of the broken fellowship struggle to save Gondor from Sauron's forces. Meanwhile, Frodo and Sam bring the ring closer to the heart of Mordor, the dark lord's realm.", rating = "PG-13"
},
new Movie {
title = "The Good, the Bad and the Ugly", year = 1974, description = "A bounty hunting scam joins two men in an uneasy alliance against a third in a race to find a fortune in gold buried in a remote cemetery.This is the third Italian-Western film of a trilogy from director Sergio Leone who gives Western films a new (bloody) color.", rating = "R"
},
new Movie {
title = "Fight Club", year = 1999, description = "A ticking-time-bomb insomniac and a slippery soap salesman channel primal male aggression into a shocking new form of therapy. Their concept catches on, with underground \"fight clubs\" forming in every town, until an eccentric gets in the way and ignites an out-of-control spiral toward oblivion.", rating = "R"
},
new Movie {
title = "The Lord of the Rings: The Fellowship of the Ring", year = 2001, description = "Young hobbit Frodo Baggins, after inheriting a mysterious ring from his uncle Bilbo, must leave his home in order to keep it from falling into the hands of its evil creator. Along the way, a fellowship is formed to protect the ringbearer and make sure that the ring arrives at its final destination: Mt. Doom, the only place where it can be destroyed.", rating = "BG-13"
},
new Movie {
title = "Star Wars: Episode V - The Empire Strikes Back", year = 1980, description = "The epic saga continues as Luke Skywalker, in hopes of defeating the evil Galactic Empire, learns the ways of the Jedi from aging master Yoda. But Darth Vader is more determined than ever to capture Luke. Meanwhile, rebel leader Princess Leia, cocky Han Solo, Chewbacca, and droids C-3PO and R2-D2 are thrown into various stages of capture, betrayal and despair.", rating = "BG"
},
new Movie {
title = "Forrest Gump", year = 1994, description = "A man with a low IQ has accomplished great things in his life and been present during significant historic events - in each case, far exceeding what anyone imagined he could do. Yet, despite all the things he has attained, his one true love eludes him. \"Forrest Gump\" is the story of a man who rose above his challenges, and who proved that determination, courage, and love are more important than ability.", rating = "BG-13"
},
new Movie {
title = "Inception", year = 2010, description = "Cobb, a skilled thief who commits corporate espionage by infiltrating the subconscious of his targets is offered a chance to regain his old life as payment for a task considered to be impossible: \"inception\", the implantation of another person's idea into a target's subconscious.", rating = "BG-13"
},
new Movie {
title = "The Lord of the Rings: The Two Towers", year = 2002, description = "Frodo and Sam are trekking to Mordor to destroy the One Ring of Power while Gimli, Legolas and Aragorn search for the orc-captured Merry and Pippin. All along, nefarious wizard Saruman awaits the Fellowship members at the Orthanc Tower in Isengard.", rating = "BG-13"
}
);
context.SaveChanges();
}
}
public void Execute(Actor actor)
{
_context.Actors.Add(actor);
_context.SaveChanges();
}
public void Execute(Director director)
{
_context.Directors.Add(director);
_context.SaveChanges();
}
public void Save()
{
context.SaveChanges();
}
public void AddEntity(OrderDetails entity)
{
_context.Orders.Add(entity);
_context.SaveChanges();
}
public void Execute(Genre genre)
{
_context.Genres.Add(genre);
_context.SaveChanges();
}
public void AddEntity(User entity)
{
_context.Users.Add(entity);
_context.SaveChanges();
}
public void AddEntity(Movie entity)
{
_context.Add(entity);
_context.SaveChanges();
}
/// <summary>
/// The customer has chosen to change only the seats, not the showtime on its booking
/// Sets the old seats BookingId to null
/// Sets the new seats to correct bookingId
/// </summary>
/// <param name="roomId"></param>
/// <param name="oldSeats"></param>
/// <param name="oldShowTimeId"></param>
/// <param name="newSeats"></param>
public void ChangeOnlySeatsOnBooking(int roomId, List <int> oldSeats, int oldShowTimeId, List <int> newSeats)
{
List <int> oldticketsId = new List <int>();
List <int> newticketsId = new List <int>();
List <int> bookingId = new List <int>();
using (var movieContext = new MovieAppContext())
{
foreach (var oldSeatNumber in oldSeats)
{
var oldTicketsList = movieContext.Tickets.Where(ticket => ticket.RoomId == roomId)
.Where(ticket => ticket.ShowTimeId == oldShowTimeId)
.Where(ticket => ticket.SeatNumber == oldSeatNumber).ToList();
foreach (var ticket in oldTicketsList)
{
oldticketsId.Add(ticket.Id);
}
}
foreach (var ticketId in oldticketsId)
{
var listOfTickets = movieContext.Tickets.Where(ticket => ticket.Id == ticketId);
var listbookingId = listOfTickets.Select(ticket => ticket.BookingId).ToList();
foreach (var ticket in listOfTickets)
{
ticket.BookingId = null;
}
foreach (var booking in listbookingId)
{
bookingId.Add((int)booking);
}
}
var takebookingId = bookingId.First();
movieContext.SaveChanges();
foreach (var newSeatNumber in newSeats)
{
var newTicketsList = movieContext.Tickets.Where(ticket => ticket.RoomId == roomId)
.Where(ticket => ticket.ShowTimeId == oldShowTimeId)
.Where(ticket => ticket.SeatNumber == newSeatNumber).ToList();
foreach (var ticket in newTicketsList)
{
newticketsId.Add(ticket.Id);
}
}
foreach (var ticketId in newticketsId)
{
var listOfTickets = movieContext.Tickets.Where(ticket => ticket.Id == ticketId).ToList();
foreach (var ticket in listOfTickets)
{
ticket.BookingId = takebookingId;
}
}
movieContext.SaveChanges();
}
}
public void Execute(Hashtag hashtag)
{
_context.Hashtags.Add(hashtag);
_context.SaveChanges();
}
public int Complete()
{
return(context.SaveChanges());
}