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