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;
}
