public static bool AddScreenLayout(int showId)
        {
            bool layoutAdded = false;

            try
            {
                CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL();
                var objSeatLayout = new ShowSeatLayout();
                objSeatLayout.ShowId   = showId;
                objSeatLayout.LayoutId = showId;

                objSeatLayout.UnavailableSeats = string.Empty;

                ObjContext.ShowSeatLayouts.Add(objSeatLayout);
                int NoOfRowsAffected = ObjContext.SaveChanges();
                if (NoOfRowsAffected > 0)
                {
                    layoutAdded = true;
                }
            }
            catch (Exception ex)
            {
                throw new MovieExceptions("Error : Reading data", ex);
            }
            return(layoutAdded);
        }
        public static ShowSeatLayoutEntity ReturnSeatLayoutDAL(int showId)
        {
            CinestarEntitiesDAL cinestar = new CinestarEntitiesDAL();
            var query = from item in cinestar.ShowSeatLayouts
                        where item.ShowId == showId
                        select item;

            ShowSeatLayout       layout = query.FirstOrDefault();
            ShowSeatLayoutEntity entity = new ShowSeatLayoutEntity();

            entity.LayoutId         = layout.LayoutId;
            entity.ShowId           = layout.ShowId;
            entity.UnavailableSeats = layout.UnavailableSeats;
            return(entity);
        }
        public static bool UpdateLayoutDAL(ShowSeatLayoutEntity layout)
        {
            CinestarEntitiesDAL cinestar   = new CinestarEntitiesDAL();
            ShowSeatLayout      seatLayout = new ShowSeatLayout();

            seatLayout.LayoutId              = layout.LayoutId;
            seatLayout.ShowId                = layout.ShowId;
            seatLayout.UnavailableSeats      = layout.UnavailableSeats;
            cinestar.Entry(seatLayout).State = EntityState.Modified;
            int rowsaffected = cinestar.SaveChanges();

            if (rowsaffected > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }