public async Task SetMoneyAsync(long discordUserId, long guildId, int money)
        {
            AsyncDataReader dr = new AsyncDataReader("MONEY_SetMoney", _credentials.DbConnectionString);

            dr.AddParameter("@DiscordUserId", discordUserId);
            dr.AddParameter("@DiscordGuildId", guildId);
            dr.AddParameter("@Money", money);

            await dr.ExecuteNonQueryAsync();
        }
Example #2
0
        public async Task AddPokemonAsync(long discordUserId, long guildId, PokemonSummary pokemon)
        {
            AsyncDataReader dr = new AsyncDataReader("POKEMON_AddPokemonToInventory", _connectionString);

            dr.AddParameter("@DiscordGuildId", guildId);
            dr.AddParameter("@DiscordUserId", discordUserId);
            dr.AddParameter("@PokemonNumber", pokemon.Id);
            dr.AddParameter("@PokemonName", pokemon.Name);

            await dr.ExecuteNonQueryAsync();
        }