public PlayerModel GetPlayerByName(string playerName)
        {
            var playerModel =
                PlayerModel.FromDbObject(_entities.players.FirstOrDefault(x => x.name.Equals(playerName)));

            if (playerModel == null)
            {
                throw PlayerNotFoundException.FromName(playerName);
            }

            return(playerModel);
        }
        public void AddGuildMember(string playerName, string guildName)
        {
            var getPlayerModel = PlayerModel.FromDbObject(_entities.players.FirstOrDefault(x => x.name.Equals(playerName)));

            if (getPlayerModel == null)
            {
                throw PlayerNotFoundException.FromName(playerName);
            }

            var guildModel = GuildModel.FromDbObject(_entities.guilds.FirstOrDefault(x => x.name.Equals(guildName)));

            if (guildModel == null)
            {
                throw GuildNotFoundException.FromName(guildName);
            }

            _entities.guild_members.Add(new guild_members
            {
                fk_guild  = guildModel.Id,
                fk_player = getPlayerModel.Id
            });
            _entities.SaveChanges();
        }