private void RefreshFilmScreeningsListBox()
{
List <Movie> movies = new List <Movie>();
movies = new MoviesDb("Movies.txt").Movies;
filmScreeningsDb = new FilmScreeningsDb("FilmShows.txt", movies);
List <object> newestScreenings = new List <object>();
foreach (FilmShow fs in filmScreeningsDb.FilmShows)
{
EditScreening es = new EditScreening
{
FilmName = movies.ElementAt(fs.MovieId - 1).Name,
FilmDate = fs.Date,
FilmScreeningId = fs.Id,
};
newestScreenings.Add(es);
}
ListFilmShowsLb.DataSource = newestScreenings;
if (newestScreenings.Count == 0)
{
EditBtn.Enabled = false;
}
else
{
EditBtn.Enabled = true;
}
}
public IActionResult AddMovie(MoviesDb newMovie)
{
if (ModelState.IsValid)
{
_context.MoviesDb.Add(newMovie);
_context.SaveChanges();
}
return(RedirectToAction("ListMovies"));
}
public static List <Categorias> GetLista()
{
List <Categorias> lista = new List <Categorias>();
var db = new MoviesDb();
lista = db.Categorias.ToList();
return(lista);
}
public static List <Peliculas> GetLista()
{
List <Peliculas> lista = new List <Peliculas>();
var db = new MoviesDb();
lista = db.Peliculas.Where(p => p.CategoriaId == 1).ToList();
return(lista);
}
public static List <Autores> GetLista()
{
List <Autores> lista = new List <Autores>();
var db = new MoviesDb();
lista = db.Autores.ToList();
return(lista);
}
// GET: Movies/Delete/5
public ActionResult Delete(int id)
{
Movie movie = MoviesDb.GetById(id);
if (movie == null)
{
return(HttpNotFound());
}
return(View(movie));
}
public ActionResult Edit(Movie movie)
{
if (ModelState.IsValid)
{
MoviesDb.Update(movie);
return(RedirectToAction("Index"));
}
ViewBag.GenreId = new SelectList(GenresDb.GetAll(), "Id", "Name", movie.GenreId);
return(View(movie));
}
// GET: Movies/Edit/5
public ActionResult Edit(int id)
{
Movie movie = MoviesDb.GetById(id);
if (movie == null)
{
return(HttpNotFound());
}
ViewBag.GenreId = new SelectList(GenresDb.GetAll(), "Id", "Name", movie.GenreId);
return(View(movie));
}
public IActionResult DeleteMovie(int id)
{
MoviesDb movie = _context.MoviesDb.Find(id);
if (movie != null)
{
_context.MoviesDb.Remove(movie);
_context.SaveChanges();
}
return(RedirectToAction("ListMovies"));
}
public ActionResult Create(Movie movie)
{
if (ModelState.IsValid)
{
movie.DateAdded = DateTime.UtcNow;
MoviesDb.Add(movie);
return(RedirectToAction("Index"));
}
ViewBag.GenreId = new SelectList(GenresDb.GetAll(), "Id", "Name", movie.GenreId);
return(View(movie));
}
public ManageFilmShowForm(ListBox newestFilmScreeningsLB)
{
InitializeComponent();
this.newestFilmScreeningsLB = newestFilmScreeningsLB;
MoviesDb moviesDb = new MoviesDb("Movies.txt");
//foreach(Movie movie in moviesDb.Movies)
//{
// movies.Add(movie);
//}
movies = moviesDb.Movies;
LoadMoviesList();
filmScreeningsDb = new FilmScreeningsDb("FilmShows.txt", movies);
}
private void LoadNewestScreenings()
{
MoviesDb moviesDb = new MoviesDb("Movies.txt");
List <Movie> movies = moviesDb.Movies;
FilmScreeningsDb filmScreeningsDb = new FilmScreeningsDb("FilmShows.txt", movies);
List <NewestScreening> newestScreenings = new List <NewestScreening>();
foreach (FilmShow objShow in filmScreeningsDb.FilmShows)
{
NewestScreening NS = new NewestScreening
{
FilmName = movies.ElementAt(objShow.MovieId - 1).Name,
FilmDate = objShow.Date
};
newestScreenings.Add(NS);
}
newestScreenings.OrderBy(p => p.FilmDate);
NewestFilmShowsLb.DataSource = newestScreenings;
}
public IActionResult UpdateMovie(MoviesDb newMovie)
{
MoviesDb oldMovie = _context.MoviesDb.Find(newMovie.Id);
if (ModelState.IsValid)
{
oldMovie.Title = newMovie.Title;
oldMovie.Genre = newMovie.Genre;
oldMovie.ReleaseYear = newMovie.ReleaseYear;
oldMovie.RunTime = newMovie.RunTime;
oldMovie.RentPrice = newMovie.RentPrice;
_context.Entry(oldMovie).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.Update(oldMovie);
_context.SaveChanges();
}
return(RedirectToAction("ListMovies"));
}
public ActionResult Save(Movie movie)
{
if (!ModelState.IsValid)
{
return(RedirectToAction("Index", "Movies"));
}
if (movie.Id == 0)
{
MoviesDb.Add(movie);
}
else
{
var movieInDb = MoviesDb.GetById(movie.Id);
// update properties
movieInDb.Name = movie.Name;
MoviesDb.Update(movieInDb);
}
return(RedirectToAction("Index", "Movies"));
}
public static bool Insertar(Peliculas pelicula)
{
bool retorno = false;
try
{
using (var db = new MoviesDb())
{
db.Peliculas.Add(pelicula);
db.SaveChanges();
retorno = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(retorno);
}
private void RefreshTicketsListBox()
{
moviesDb = new MoviesDb("Movies.txt");
filmScreeningsDb = new FilmScreeningsDb("FilmShows.txt", moviesDb.Movies);
ticketsDb = new TicketsDb("Tickets.txt", filmScreeningsDb.FilmShows);
List <TicketToShow> ticketsToShow = new List <TicketToShow>();
foreach (Ticket ticket in ticketsDb.Tickets)
{
TicketToShow tts = new TicketToShow
{
MovieName = moviesDb.Movies.ElementAt(filmScreeningsDb.FilmShows.ElementAt(ticket.FilmShowId - 1).MovieId - 1).Name,
Price = ticket.Price,
RoomPlace = ticket.RoomPlace,
TicketId = ticket.Id
};
ticketsToShow.Add(tts);
}
TicketsLB.DataSource = ticketsToShow;
}
public ActionResult DeleteConfirmed(int id)
{
MoviesDb.Delete(id);
return(RedirectToAction("Index"));
}
public IActionResult UpdateMovie(int id)
{
MoviesDb movie = _context.MoviesDb.Find(id);
return(View(movie));
}
public MovieManager()
{
_moviesDb = new MoviesDb(ConstValue.MoviesTable + ConstValue.CurrentExtensionDatabase);
}
public static Peliculas Buscar(int idPelicula)
{
var db = new MoviesDb();
return(db.Peliculas.Find(idPelicula));
}
// Movies/Edit/1
// Movies/Edit?id=1
//public ActionResult Edit(int id)
//{
// return Content($"id={id}");
//}
// movies
//public ActionResult Index(int? pageIndex, string sortBy)
//{
// if(!pageIndex.HasValue)
// {
// pageIndex = 1;
// }
// if(String.IsNullOrWhiteSpace(sortBy))
// {
// sortBy = "Name";
// }
// return Content($"pageIndex={pageIndex}&sortBy={sortBy}");
//}
public ActionResult Index()
{
var movies = MoviesDb.GetAll();
return(View(movies));
}
public static Categorias Buscar(int IdCategoria)
{
var db = new MoviesDb();
return(db.Categorias.Find(IdCategoria));
}
public ActionResult Edit(int Id)
{
var movieInDb = MoviesDb.GetById(Id);
return(View(movieInDb));
}
