Example #1
0
        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));
        }
Example #2
0
        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));
        }
Example #3
0
        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));
        }