public static void removeConcert()
        {
            showConcertsList();
            ConcertDTO concertToRemove = getConcertById(GeneralUtilities.askForInt("Select an id:") ?? 0);

            if (concertToRemove.Id == 0 || concertToRemove == null)
            {
                Console.WriteLine("The id introduced does not match with any concert");
            }
            else
            {
                Console.WriteLine($"The concert in {concertToRemove.Venue}, {concertToRemove.City}, has been removed");
                JobServiceDTO.RemoveConcert(concertToRemove);
            }
        }
        public static void removeMovie()
        {
            showMoviesList();
            MovieDTO movieToRemove = getMovieById(GeneralUtilities.askForInt("Select an id:") ?? 0);

            if (movieToRemove.Id == 0)
            {
                Console.WriteLine("The id introduced does not match with any movie");
            }
            else
            {
                Console.WriteLine($"The movie {movieToRemove.Title} has been removed");
                JobServiceDTO.RemoveMovie(movieToRemove);
            }
        }
        public static void addMovie()
        {
            string  title  = GeneralUtilities.askForString("Title:");
            string  genre  = GeneralUtilities.askForString("Genre:");
            decimal salary = GeneralUtilities.askForDecimal("Salary:") ?? 0;

            MovieDTO movie = new MovieDTO()
            {
                Completed = false,
                Assigned  = false,
                Removed   = false,
                Salary    = salary,
                Title     = title,
                Genre     = genre
            };

            JobServiceDTO.AddMovie(movie);
        }
        public static void assignMovie()
        {
            showAvailableMoviesList();
            MovieDTO movie = getMovieById(GeneralUtilities.askForInt("Choose an id from the list: ") ?? 0);

            ActorUtilities.showActorList();
            ActorDTO actor = ActorUtilities.getActorById(GeneralUtilities.askForInt("Choose an id from the list: ") ?? 0);

            if (actor == null || movie == null || movie.Assigned == true)
            {
                Console.WriteLine("The id introduced is not correct");
            }
            else
            {
                JobServiceDTO.AssignMovie(movie, actor);
                Console.WriteLine($"The movie {movie.Title} has been asigned to {actor.FirstName} {actor.LastName}");
            }
        }
        public static void addConcert()
        {
            string  city   = GeneralUtilities.askForString("City:");
            string  venue  = GeneralUtilities.askForString("Venue:");
            decimal salary = GeneralUtilities.askForDecimal("Salary:") ?? 0;

            ConcertDTO concert = new ConcertDTO
            {
                Completed = false,
                Assigned  = false,
                Removed   = false,
                City      = city,
                Venue     = venue,
                Salary    = salary
            };

            JobServiceDTO.AddConcert(concert);
        }
        public static void assignConcert()
        {
            showAvailableConcertsList();
            ConcertDTO concert = getConcertById(GeneralUtilities.askForInt("Choose an id from the list: ") ?? 0);

            MusicianUtilities.showMusicianList();
            MusicianDTO musician = MusicianUtilities.getMusicianById(GeneralUtilities.askForInt("Choose an id from the list: ") ?? 0);

            if (musician == null || concert == null || concert.Assigned == true)
            {
                Console.WriteLine("The id introduced is not correct");
            }
            else
            {
                JobServiceDTO.AssignConcert(concert, musician);
                Console.WriteLine($"The concert in {concert.Venue}, {concert.City}, has been asigned to {musician.FirstName} {musician.LastName}");
            }
        }
        public static void editMovie()
        {
            showMoviesList();
            MovieDTO movieToUpdate = getMovieById(GeneralUtilities.askForInt("Select an id:") ?? 0);
            bool     finished      = false;

            if (movieToUpdate != null)
            {
                do
                {
                    Console.Clear();
                    showMovieInfo(movieToUpdate);
                    showEditMovieOptions();
                    finished = SelectEditMovieOption(movieToUpdate, finished);
                }while (finished == false);
                JobServiceDTO.EditMovie(movieToUpdate);
            }
            else
            {
                Console.WriteLine("The id introduced is not correct");
            }
        }
        public static void editConcert()
        {
            showConcertsList();
            ConcertDTO concertToUpdate = getConcertById(GeneralUtilities.askForInt("Select an id:") ?? 0);
            bool       finished        = false;

            if (concertToUpdate != null)
            {
                do
                {
                    Console.Clear();
                    showConcertInfo(concertToUpdate);
                    showEditConcertOptions();
                    finished = SelectEditConcertOption(concertToUpdate, finished);
                }while (finished == false);
                JobServiceDTO.EditConcert(concertToUpdate);
            }
            else
            {
                Console.WriteLine("The id introduced is not correct");
            }
        }
        public static List <JobDTO> loadJobListfromDB(agencydbEntities1 DBAccess)
        {
            List <JobDTO> result = new List <JobDTO>();

            foreach (Movie m in DBAccess.Movie)
            {
                if (m.Job.removed == false)
                {
                    MovieDTO mDto = mapMovieDTOfromDB(m);
                    JobServiceDTO.AddJob(mDto);
                }
            }

            foreach (Concert c in DBAccess.Concert)
            {
                if (c.Job.removed == false)
                {
                    ConcertDTO cDto = mapConcertDTOfromDB(c);
                    JobServiceDTO.AddJob(cDto);
                }
            }

            return(result);
        }