private static PlayerDTO ModelPlayerToDTO(Players player) 
 {
     return new PlayerDTO
     {
         Id = player.P_Id,
         Name = player.Name,
         Number = player.Number,
         Points = player.Points
     };
 }
        private static void AddPlayersToGame(List<PlayerDTO> players, int gameId, out string errorMessage)
        {
            using (var dbContext = new FilmQuizDBEntities())
            {
                try
                {
                    foreach (var p in players)
                    {
                        var newPlayer = new Players
                        {
                            Name = p.Name,
                            Game = gameId,
                            Number = p.Number,
                            Points = 0,
                        };
                        dbContext.Players.Add(newPlayer);
                    }
                    dbContext.SaveChanges();

                    errorMessage = null;
                }

                catch(Exception e)
                {
                    errorMessage = "Something went wrong on the server: " + e.Message;
                }
            }
        }