public void UpdateShowsMovie(ShowsMovie showsMovie)
{
using (IMDBEntities7 dbContext = new IMDBEntities7())
{
var exists = dbContext.ShowsMovies.Where(s => s.Deleted == false &&
s.Cinema_Id == showsMovie.Cinema_Id &&
s.Movie_Id == showsMovie.Movie_Id).FirstOrDefault();
if (exists != null)
{
exists.Movie_Id = showsMovie.Movie_Id;
exists.Cinema_Id = showsMovie.Cinema_Id;
exists.ToDate = showsMovie.ToDate;
exists.FromDate = showsMovie.FromDate;
dbContext.Entry(exists).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
}
public void AddShowsMovie(ShowsMovie showsMovie)
{
using (IMDBEntities7 dbContext = new IMDBEntities7())
{
var exists = dbContext.ShowsMovies.Where(s => s.Deleted == false &&
s.Cinema_Id == showsMovie.Cinema_Id &&
s.Movie_Id == showsMovie.Movie_Id).FirstOrDefault();
if (exists == null)
{
ShowsMovie newShows = new ShowsMovie
{
FromDate = showsMovie.FromDate,
ToDate = showsMovie.ToDate,
Cinema_Id = showsMovie.Cinema_Id,
Movie_Id = showsMovie.Movie_Id,
Deleted = false
};
dbContext.ShowsMovies.Add(newShows);
dbContext.SaveChanges();
}
}
}
public void AddShowsMovie(ShowsMovie showsMovie)
{
DALCinema dALCinema = new DALCinema();
dALCinema.AddShowsMovie(showsMovie);
}
