public string ListShowInCinemaByMovieAndDay(int idCinema, int idMovie, DateTime day)
{
List <movieShow> listMovieShow = new List <movieShow>();
var movie_shows = _context.Movie_Shows.Include(m => m.Room).Where(m => m.Room.Cinema_ID.Equals(idCinema)).Where(m => m.Movie_ID.Equals(idMovie)).Where(m => m.Start_Show.Date.Equals(day.Date)).ToList();
foreach (var item in movie_shows)
{
movieShow movieShow = new movieShow();
movieShow.id = item.ID;
movieShow.Room_ID = item.Room_ID;
movieShow.Movie_ID = item.Movie_ID;
movieShow.h_start = item.Start_Show.Hour;
movieShow.m_start = item.Start_Show.Minute;
listMovieShow.Add(movieShow);
}
return(JsonConvert.SerializeObject(listMovieShow));
}
public string ListInRoom(int id, DateTime date)
{
var dPContext = _context.Movie_Shows.Include(m => m.Movie).Where(m => m.Room_ID.Equals(id)).Where(m => m.Start_Show.Date.Equals(date.Date));
List <movieShow> listMovieShow = new List <movieShow>();
foreach (var item in dPContext.ToList())
{
movieShow movieShow = new movieShow();
movieShow.id = item.ID;
movieShow.Room_ID = item.Room_ID;
movieShow.Movie_ID = item.Movie_ID;
movieShow.h_start = item.Start_Show.Hour;
movieShow.m_start = item.Start_Show.Minute;
movieShow.runningTime = item.Movie.Running_Time;
movieShow.movieName = item.Movie.Name;
listMovieShow.Add(movieShow);
}
return(JsonConvert.SerializeObject(listMovieShow));
}
public string Create(DateTime Start_Show, int Room_ID, int Status, int Movie_ID)
{
Movie movie = _context.Movies.Find(Movie_ID);
Movie_Show movie_Show = new Movie_Show();
movie_Show.Start_Show = Start_Show;
movie_Show.Room_ID = Room_ID;
movie_Show.Status = Status;
movie_Show.Movie_ID = Movie_ID;
_context.Add(movie_Show);
_context.SaveChanges();
movieShow movieShow = new movieShow();
movieShow.id = movie_Show.ID;
movieShow.Room_ID = movie_Show.Room_ID;
movieShow.Movie_ID = movie_Show.Movie_ID;
movieShow.h_start = movie_Show.Start_Show.Hour;
movieShow.m_start = movie_Show.Start_Show.Minute;
movieShow.runningTime = movie_Show.Movie.Running_Time;
movieShow.movieName = movie_Show.Movie.Name;
return(JsonConvert.SerializeObject(movieShow));
}