public DbContext CreateContext() { var context = new TheaterContext(); context.Configuration.ProxyCreationEnabled = false; context.Configuration.LazyLoadingEnabled = false; return context; }
public bool ChangeTicketItem(AppTicketItem TicketItem) { TicketItem t = new TicketItem(TicketItem); using (var dbContext = new TheaterContext()) { int ticketPrice = -1; foreach (Ticket item in dbContext.Tickets) { if (TicketItem.Ticket == item.Tag) { ticketPrice = item.Price; break; } } foreach (TicketItem item in dbContext.TicketItems) { if (item.Id != t.Id && item.TheaterId == t.TheaterId && item.AuditoriumId == t.AuditoriumId && item.Row == t.Row && ((int.Parse(item.Seats.Split('-')[0]) <= int.Parse(t.Seats) && int.Parse(item.Seats.Split('-')[1]) >= int.Parse(t.Seats)) || ((int.Parse(item.Seats.Split('-')[0]) <= int.Parse(t.Seats) + t.Quantity && int.Parse(item.Seats.Split('-')[1]) >= int.Parse(t.Seats) + t.Quantity)))) { return(false); } else if (item.Id == t.Id) { item.Quantity = t.Quantity; int seat = int.Parse(t.Seats); item.Seats = t.Seats; seat += t.Quantity; item.Seats += "-" + seat; item.Row = t.Row; item.TicketId = t.TicketId; item.AuditoriumId = t.AuditoriumId; item.TotalPrice = item.Quantity * ticketPrice; item.TheaterId = t.TheaterId; break; } } dbContext.SaveChanges(); return(true); } }
public IList <ShowTime> GetShowTimes(int movieId) { using (var context = new TheaterContext()) { var results = from data in context.Showings where data.MovieId == movieId from room in data.Theaters select new ShowTime { TheaterNumber = room.Number, ShowingId = data.ShowingId, TheaterId = room.TheaterId, StartTime = data.StartTime, EndTime = data.EndTime }; return(results.ToList()); } }
public static void AddPlaatsen(string letter, TheaterContext context) { var check = context.Reserveringen.FirstOrDefault(reservering => reservering.Naam.Contains(letter)); if (check == null) { for (int i = 1; i < 7; i++) { string plek = letter + i.ToString(); context.Reserveringen.Add(new Reservering() { Naam = plek, Bezet = false }); context.SaveChanges(); } } }
public bool AddUser(AppUser user) { user.Username = user.Username.ToLower(); using (var dbContext = new TheaterContext()) { foreach (User u in dbContext.Users) { if (u.Username.ToLower() == user.Username.ToLower()) { return(false); } } dbContext.Users.Add(new User(user)); dbContext.SaveChanges(); return(true); } }
public int AddTicketItem(AppTicketItem ticketItem) { TicketItem t = new TicketItem(ticketItem); using (var dbContext = new TheaterContext()) { int ticketPrice = -1; foreach (Ticket item in dbContext.Tickets) { if (ticketItem.Ticket == item.Tag) { ticketPrice = item.Price; break; } } foreach (TicketItem item in dbContext.TicketItems) { if (item.Id == t.Id) { return(-1); } if (item.TheaterId == t.TheaterId && item.AuditoriumId == t.AuditoriumId && item.Row == t.Row && ((int.Parse(item.Seats.Split('-')[0]) <= int.Parse(t.Seats) && int.Parse(item.Seats.Split('-')[1]) >= int.Parse(t.Seats)) || ((int.Parse(item.Seats.Split('-')[0]) <= int.Parse(t.Seats) + t.Quantity && int.Parse(item.Seats.Split('-')[1]) >= int.Parse(t.Seats) + t.Quantity)))) { return(-2); } } int seat = int.Parse(t.Seats); seat += t.Quantity; t.Seats += "-" + seat; t.TotalPrice = t.Quantity * ticketPrice; dbContext.TicketItems.Add(t); dbContext.SaveChanges(); return(dbContext.TicketItems.ToList().Last().Id); } }
public IQueryable <object> getMostWatchedMovies() { TheaterContext context = new TheaterContext(); var answer = from userMovies in context.UserMovies join movies in context.Movies on userMovies.MovieID equals movies.IMDBID group new { userMovies, movies } by userMovies.MovieID into newGroup select new { IMDBID = newGroup.Key, Level = (from moviesOwned in newGroup select moviesOwned.userMovies.MovieID).Count(), Name = (from moviesOwned in newGroup select moviesOwned.movies.Name).FirstOrDefault(), Year = (from moviesOwned in newGroup select moviesOwned.movies.Year).FirstOrDefault(), Director = (from moviesOwned in newGroup select moviesOwned.movies.Director).FirstOrDefault(), Stars = (from moviesOwned in newGroup select moviesOwned.movies.Stars).FirstOrDefault() }; return(answer); }
public bool DeleteTicket2(AppTicket ticket) { Ticket t = new Ticket(ticket); using (var dbContext = new TheaterContext()) { foreach (Ticket item in dbContext.Tickets) { if (item.Id == t.Id) { t = item; } } dbContext.Tickets.Remove(t); dbContext.SaveChanges(); return(true); } }
public BindingList <AppTicket> GetAllTickets() { BindingList <AppTicket> retVal = new BindingList <AppTicket>(); using (var dbContext = new TheaterContext()) { List <int> bilateralNums = new List <int>(); foreach (Ticket t in dbContext.Tickets) { AppTicket ticket = new AppTicket(t); retVal.Add(ticket); } } return(retVal); }
public List <MovieShowTime> GetShowTimes(int movieId) { using (var context = new TheaterContext()) { var result = from movie in context.Movies where movie.MovieId == movieId from show in movie.ShowTimes from room in show.Theaters orderby show.StartTime select new MovieShowTime { ShowTimeId = show.ShowingId, TheaterId = room.TheaterId, StartTime = show.StartTime, TheaterNumber = room.Number }; return(result.ToList()); } }
public bool ChangeInfo(AppUser user) { user.Username = user.Username.ToLower(); using (var dbContext = new TheaterContext()) { foreach (User u in dbContext.Users) { if (u.Username.ToLower() == user.Username.ToLower()) { u.FirstName = user.FirstName; u.LastName = user.LastName; u.Password = user.Password; break; } } dbContext.SaveChanges(); return(true); } }
public bool ChangeTicket(AppTicket ticket, AppTicket oldTicket) { Ticket t = new Ticket(ticket); Ticket t2 = new Ticket(oldTicket); bool found = false; using (var dbContext = new TheaterContext()) { foreach (Ticket item in dbContext.Tickets) { if (item.Id == t2.Id && item.Price == t2.Price && item.Tag == t2.Tag) { item.Tag = t.Tag; item.Price = t.Price; found = true; break; } } if (found) { foreach (TicketItem item in dbContext.TicketItems) { if (item.TicketId == t.Id) { item.TotalPrice = t.Price * item.Quantity; } } dbContext.SaveChanges(); return(true); } else { return(false); } } }
public static bool deleteMovieFromUserList(String movieToRemove, String strUserName) { bool answer = false; if (isTheMovieOnMyList(movieToRemove, strUserName)) { try { TheaterContext context = new TheaterContext(); context.UserMovies.Remove(new UserMovie { MovieID = movieToRemove, UserID = strUserName }); context.SaveChanges(); answer = true; } catch (Exception e) { answer = false; } } return(answer); }
public BindingList <AppTicketItem> GetAllTicketItems() { BindingList <AppTicketItem> retVal = new BindingList <AppTicketItem>(); using (var dbContext = new TheaterContext()) { List <int> bilateralNums = new List <int>(); List <int> ids = new List <int>(); dbContext.Tickets.ToList().ForEach(x => ids.Add(x.Id)); foreach (TicketItem t in dbContext.TicketItems) { AppTicketItem TicketItem = new AppTicketItem(t); if (!ids.Contains(t.TicketId)) { TicketItem.Ticket = "Ticket is deleted."; } retVal.Add(TicketItem); } } return(retVal); }
public ReserveringenController(TheaterContext context) { _context = context; }
public SeasonsRepository(TheaterContext context) { _context = context; }
public KlantenController(TheaterContext context) { _context = context; client.BaseAddress = new Uri("https://localhost:5001"); }
public PlayRepository(TheaterContext context) { this.context = context; }
/// <summary> /// /// </summary> /// <returns></returns> public IEnumerable <Movie> getAllMovies() { TheaterContext context = new TheaterContext(); return(context.Movies.ToList <Movie>()); }
public MoviesRepository(TheaterContext context) { _context = context; }
public SubtitlesRepository(TheaterContext context) { _context = context; }
public DirectorServices(TheaterContext context) { _context = context; }
// List<Movie> Values = new List<Movie>() { // new Movie("ET", "An alien and a Boy"), // new Movie("IT", "A clown and several boys"), // new Movie("Lassie", "A dog and a boy") // }; public MoviesController(TheaterContext db) { _db = db; // Values.Add(new Movie("Blade", "Some Vampires and a boy")); }
public ContentPathsRepository(TheaterContext context) { _context = context; }
public MovieServices(TheaterContext context) { _context = context; }
public ActorRepository(TheaterContext context) { this.context = context; }
public WritersRepository(TheaterContext context) { _context = context; }
public GenreServices(TheaterContext context) { _context = context; }
public ActorsRepository(TheaterContext context) { _context = context; }
public EpisodesRepository(TheaterContext context) { _context = context; }
public GenresRepository(TheaterContext context) { _context = context; }