Example #1
0
        public IList <PerformanceModelDTO> GetPerformances(Guid theaterId)
        {
            IList <PerformanceModelDTO> performancesList = new List <PerformanceModelDTO>();

            using (var context = new CinemaEntities())
            {
                var performances = (from performance in context.Perfomances.Include("Room")
                                    where performance.TheaterID == theaterId
                                    select performance).ToList();


                foreach (var perform in performances)
                {
                    var performanceRow = new PerformanceModelDTO();
                    performanceRow.PerformanceID = perform.PerfomanceID;
                    string date = perform.Date.ToString("yyyy'/'MM'/'dd");
                    performanceRow.Date = date;                                                    //(DateTime)perform.Date;
                    TimeSpan time = (TimeSpan)perform.StartingTime;
                    performanceRow.StartingTime = string.Format("{0:hh\\:mm}", time);              // (TimeSpan)perform.StartingTime;
                    performanceRow.Title        = perform.Movie.Title;
                    performanceRow.Price        = perform.Price;
                    performanceRow.RoomNumber   = perform.Room.RoomNumber;
                    performanceRow.Duration     = perform.Duration;;
                    performancesList.Add(performanceRow);
                }
            }
            return(performancesList);
        }
        public IList<PerformanceModelDTO> GetPerformances(Guid theaterId)
        {
            IList<PerformanceModelDTO> performancesList = new List<PerformanceModelDTO>();

                            using (var context = new CinemaEntities())
                            {
                                var performances = (from performance in context.Perfomances.Include("Room")
                                                                        where performance.TheaterID == theaterId
                                                                        select performance).ToList();

                                foreach (var perform in performances)
                                {
                                    var performanceRow = new PerformanceModelDTO();
                                    performanceRow.PerformanceID = perform.PerfomanceID;
                                    string date = perform.Date.ToString("yyyy'/'MM'/'dd");
                                    performanceRow.Date = date;//(DateTime)perform.Date;
                                    TimeSpan time = (TimeSpan)perform.StartingTime;
                                    performanceRow.StartingTime = string.Format("{0:hh\\:mm}", time);// (TimeSpan)perform.StartingTime;
                                    performanceRow.Title = perform.Movie.Title;
                                    performanceRow.Price = perform.Price;
                                    performanceRow.RoomNumber = perform.Room.RoomNumber;
                                    performanceRow.Duration = perform.Duration; ;
                                    performancesList.Add(performanceRow);

                                }
                            }
                                return performancesList;
        }
        public IList<PerformanceModelDTO> GetPerformances(Guid theaterId)
        {
            IList<PerformanceModelDTO> performancesList = new List<PerformanceModelDTO>();
            IList<RoomModelDTO>roomsList=new List<RoomModelDTO>();

            using (var context1 = new CinemaEntities())
            {
                var rooms = (from room in context1.Rooms
                                         where room.TheaterID == theaterId
                                         select room).ToList();

                if (rooms.Count > 0)
                {
                    foreach (var room in rooms)
                    {
                        var roomRow = new RoomModelDTO();
                        roomRow.RoomNumber = room.RoomID;
                        roomRow.RoomNumber = room.RoomNumber;
                        roomsList.Add(roomRow);

                        if (roomsList != null)
                        {
                            using (var context = new CinemaEntities())
                            {
                                var performances = (from performance in context.Perfomances
                                                                        where performance.TheaterID == theaterId
                                                                        select performance).ToList();

                                foreach (var perform in performances)
                                {
                                    var performanceRow = new PerformanceModelDTO();
                                    performanceRow.PerformanceID = perform.PerfomanceID;
                                    performanceRow.Tilte = perform.Movie.Title;
                                    performanceRow.Price = perform.Price;
                                    //performanceRow.Room.RoomNumber = perform.Room.RoomNumber;
                                    performanceRow.Duration = perform.Duration; ;
                                    performancesList.Add(performanceRow);

                                }
                            }
                        }

                    }

                }
            } return performancesList;
        }
Example #4
0
        public IList <PerformanceModelDTO> GetPerformances(Guid theaterId)
        {
            IList <PerformanceModelDTO> performancesList = new List <PerformanceModelDTO>();
            IList <RoomModelDTO>        roomsList        = new List <RoomModelDTO>();


            using (var context1 = new CinemaEntities())
            {
                var rooms = (from room in context1.Rooms
                             where room.TheaterID == theaterId
                             select room).ToList();

                if (rooms.Count > 0)
                {
                    foreach (var room in rooms)
                    {
                        var roomRow = new RoomModelDTO();
                        roomRow.RoomNumber = room.RoomID;
                        roomRow.RoomNumber = room.RoomNumber;
                        roomsList.Add(roomRow);


                        if (roomsList != null)
                        {
                            using (var context = new CinemaEntities())
                            {
                                var performances = (from performance in context.Perfomances
                                                    where performance.TheaterID == theaterId
                                                    select performance).ToList();


                                foreach (var perform in performances)
                                {
                                    var performanceRow = new PerformanceModelDTO();
                                    performanceRow.PerformanceID = perform.PerfomanceID;
                                    performanceRow.Tilte         = perform.Movie.Title;
                                    performanceRow.Price         = perform.Price;
                                    //performanceRow.Room.RoomNumber = perform.Room.RoomNumber;
                                    performanceRow.Duration = perform.Duration;;
                                    performancesList.Add(performanceRow);
                                }
                            }
                        }
                    }
                }
            } return(performancesList);
        }