public List <UserBookings> GetUserBookings() { using (var db = new CinemaDB()) { return(db.UserBookings.OrderBy(b => b.Name).ToList()); } }
//Getting a screening by the Id value public List <DateTime> GetScreeningTimesById(int screeningId) { using (var db = new CinemaDB()) { var screening = db.Screening.FirstOrDefault(s => s.Id == screeningId); List <DateTime> screeningTimes = new List <DateTime>(); if (screening != null) { DateTime screening1 = screening.StartTime1; screeningTimes.Add(screening1); DateTime screening2 = screening.StartTime2 ?? default; DateTime screening3 = screening.StartTime3 ?? default; if (screening2 != default) { screeningTimes.Add(screening2); } if (screening3 != default) { screeningTimes.Add(screening3); } return(screeningTimes); } return(null); } }
private static async Task GerarRelatorio(CinemaDB cinemaDB) { Stopwatch stopwatch = new Stopwatch(); stopwatch.Start(); IList <Filme> filmes = await cinemaDB.GetFilmes(); Console.WriteLine("RELATÓRIO DE FILMES"); Console.WriteLine(new string('=', 50)); foreach (var filme in filmes) { Console.WriteLine("Diretor: {0}\n Titulo: {1}", filme.Diretor, filme.Titulo); Console.WriteLine(new string('-', 50)); } stopwatch.Stop(); var tempoDecorrido = stopwatch.ElapsedMilliseconds; Console.WriteLine($"Tempo decorrido: {tempoDecorrido} milissegundos."); CinemaPerformance.ContadorAverageTimer32.IncrementBy(stopwatch.ElapsedTicks); CinemaPerformance.ContadorAverageTimer32Base.Increment(); }
public List <Movies> GetAllMovies() { using (var db = new CinemaDB()) { return(db.Movies.OrderBy(m => m.Category).ToList()); } }
public Movies GetMovies(int id) { using (var db = new CinemaDB()) { return(db.Movies.FirstOrDefault(m => m.Id == id)); } }
public List <Timetable> GetTimetable() { using (var db = new CinemaDB()) { return(db.Timetable.ToList()); } }
//getting all of the films in the cinema database public List <Films> GetAllFilms() { using (var db = new CinemaDB()) { return(db.Films.ToList()); } }
public List <MovieInfo> GetMoviesByCategories(int categorieid) { using (var db = new CinemaDB()) { return(db.MovieInfo.OrderByDescending(a => a.CategorieId).Take(categorieid).ToList()); } }
//getting the film user has chosen public List <UserFilms> GetUserFilm() { using (var db = new CinemaDB()) { return(db.UserFilms.ToList()); } }
// POST api/<controller> public void Post() { Movies movie = new Movies(); movie.name = HttpContext.Current.Request.Params["name"]; movie.date = Convert.ToDateTime(HttpContext.Current.Request.Params["date"]); movie.year = HttpContext.Current.Request.Params["year"]; movie.genre = HttpContext.Current.Request.Params["genre"]; movie.length = Convert.ToInt32(HttpContext.Current.Request.Params["length"]); movie.seats = Convert.ToInt32(HttpContext.Current.Request.Params["seats"]); HttpPostedFile file = HttpContext.Current.Request.Files["img"]; //string ext = Path.GetExtension(file.FileName); file.SaveAs(HttpContext.Current.Server.MapPath("~") + "/images/" + file.FileName); movie.movie_img_url = "/images/" + file.FileName; Theaters theater = new Theaters(); theater.hall_num = Convert.ToInt32(HttpContext.Current.Request.Params["hall_num"]); theater.avail_seats_arr = "0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"; movie.Theaters.Add(theater); CinemaDB db = new CinemaDB(); db.Movies.Add(movie); db.SaveChanges(); }
public int getMovieByName(string name, string s) { CinemaDB db = new CinemaDB(); Movies m = db.Movies.SingleOrDefault(x => x.name.Equals(name)); return(m.number); }
//gets the newest releases of 9 films public List <Films> GetNewestFilms() { using (var db = new CinemaDB()) { return(db.Films.OrderByDescending(f => f.ReleaseDate).Take(9).ToList()); } }
public Categories GetCategory(int id) { using (var db = new CinemaDB()) { return(db.Categories.FirstOrDefault(c => c.Id == id)); } }
private static async Task <CinemaDB> CriarBanco() { var cinemaDB = new CinemaDB(DatabaseServer, MasterDatabase, DatabaseName); await cinemaDB.CriarBancoDeDadosAsync(); return(cinemaDB); }
public List <MovieInfo> GetAllMovies() { //throw new NotImplementedException(); using (var db = new CinemaDB()) { return(db.MovieInfo.OrderByDescending(a => a.Title).ToList()); } }
public List <Categories> GetAllCategories() { //returns Categories, ordered by Title using (var db = new CinemaDB()) { return(db.Categories.OrderBy(n => n.Name).ToList()); } }
static async Task Main(string[] args) { if (CinemaPerformance.ConfigurarCategoria()) { return; } CinemaPerformance.CriarContadores(); TraceListener traceListener = new EventLogTraceListener("Cinema"); Trace.Listeners.Add(traceListener); Trace.AutoFlush = true; TraceSource traceSource = new TraceSource("Cinema", SourceLevels.All); traceSource.Listeners.Add(traceListener); traceSource.TraceEvent(TraceEventType.Information, 1001, "A aplicação iniciou."); CinemaDB cinemaDB = await CriarBanco(); while (true) { await GerarRelatorio(cinemaDB); } //traceListener.Flush(); Console.CancelKeyPress += (source, e) => { traceSource.TraceEvent(TraceEventType.Warning, 1003, "Control + C foi acionado"); e.Cancel = true; }; Console.ReadLine(); traceSource.TraceEvent(TraceEventType.Information, 1002, "A aplicação terminou."); if (!EventLog.SourceExists("MinhaFonte")) { EventLog.CreateEventSource("MinhaFonte", "Application"); } EventLog eventLog = new EventLog(); eventLog.Source = "MinhaFonte"; eventLog.WriteEntry("A aplicação terminou.", EventLogEntryType.Information, 1002); foreach (EventLogEntry entrada in eventLog.Entries) { Console.WriteLine($"Fonte: {entrada.Source}\nTipo: {entrada.EntryType}\nHora: {entrada.TimeWritten}\nMensagem: {entrada.Message}\n"); } eventLog.Close(); Console.ReadLine(); }
public TheaterDto Get(string s, int number) { CinemaDB db = new CinemaDB(); return(db.Theaters.Where(y => y.movie_number == number).Select(x => new TheaterDto() { avail_seats_arr = x.avail_seats_arr, hall_num = x.hall_num }).First()); }
//method to get all of the the films in a category public List <Films> GetByCategory(int categoryId) { using (var db = new CinemaDB()) { return(db.Films .Where(f => f.CategoryId == categoryId) .OrderByDescending(f => f.ReleaseDate) .ToList()); } }
public void Put(int movieNumber, string newSeatsArr) { CinemaDB db = new CinemaDB(); Theaters theater = db.Theaters.SingleOrDefault(x => x.movie_number == movieNumber); if (theater != null) { theater.avail_seats_arr = newSeatsArr; db.SaveChanges(); } }
//Getting a genre by the Id value public Categories GetGenreById(int categoryId) { using (var db = new CinemaDB()) { var genre = db.Categories.FirstOrDefault(c => c.Id == categoryId); if (genre != null) { return(genre); } } return(null); }
//Choosing a film user has clicked on public Films ChooseAFilm(int filmId) { using (var db = new CinemaDB()) { var film = db.Films.FirstOrDefault(f => f.Id == filmId); if (film != null) { return(film); } } return(null); }
public MovieInfo SelectMovieWithTitle(string title) { using (var db = new CinemaDB()) { var movie = db.MovieInfo.FirstOrDefault(m => m.Title.ToLower() == title.ToLower()); if (movie != null) { return(movie); } } return(null); }
public void Post(int movieNum, [FromBody] int hallNum) { Theaters theater = new Theaters(); theater.movie_number = movieNum; theater.hall_num = hallNum; theater.avail_seats_arr = "0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"; CinemaDB db = new CinemaDB(); db.Theaters.Add(theater); db.SaveChanges(); }
public void Put(int movieNumber, string userAmountSeats) { CinemaDB db = new CinemaDB(); Movies movie = db.Movies.SingleOrDefault(x => x.number == movieNumber); if (movie != null) { int?oldAmount = movie.seats; movie.seats = oldAmount - Convert.ToInt32(userAmountSeats); db.SaveChanges(); } }
public void Post(int num, int seatsAmount, [FromBody] string seatsPositions) { Orders order = new Orders(); order.movie_number = num; order.user_seats_amount = seatsAmount; order.order_date = DateTime.Now; order.user_seats_positions = seatsPositions; CinemaDB db = new CinemaDB(); db.Orders.Add(order); db.SaveChanges(); }
//cancelling a booking public UserFilms CancelBooking(int filmId) { using (var db = new CinemaDB()) { var userFilm = db.UserFilms.FirstOrDefault(u => u.FilmId == filmId); if (userFilm != null) { db.UserFilms.Remove(userFilm); db.SaveChanges(); return(userFilm); } } return(null); }
static async Task Main(string[] args) { var cinemaDB = new CinemaDB(DatabaseServer, MasterDatabase, DatabaseName); await cinemaDB.CriarBancoDeDadosAsync(); IList <Filme> filmes = await cinemaDB.GetFilmes(); foreach (var filme in filmes) { Console.WriteLine("Diretor: {0} Titulo: {1}", filme.Diretor, filme.Titulo); } Console.ReadKey(); }
// GET api/<controller>/5 public List <MovieDto> Get(string id) { CinemaDB db = new CinemaDB(); return(db.Movies.Where(s => s.name.StartsWith(id)).Select(x => new MovieDto() { number = x.number, name = x.name, date = x.date, year = x.year, genre = x.genre, length = x.length, movie_img_url = x.movie_img_url, seats = x.seats }).OrderBy(y => y.date).ToList()); }
public List <Reservation> AddToBasket(string title) { using (var db = new CinemaDB()) { var movie = db.MovieInfo.FirstOrDefault(m => m.Title.ToLower() == title.ToLower()); if (movie != null) { db.Reservation.Add(new Reservation() { MovieId = movie.Id, }); db.SaveChanges(); } } return(null); }