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(); }
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(); }
public async Task <CreatePlaylistResult> CreatePlaylistAsync(long discordUserId, string playlistName) { AsyncDataReader dr = new AsyncDataReader("PLAYLIST_CreatePlaylist", _credentials.DbConnectionString); dr.AddParameter("@DiscordUserId", discordUserId); dr.AddParameter("@PlaylistName", playlistName); CreatePlaylistResult result = (CreatePlaylistResult)await dr.ExecuteScalarAsync(); return(result); }
public async Task <RemoveSongResult> RemoveSongFromPlaylistByIndexAsync(long discordUserId, string playlistName, int index) { AsyncDataReader dr = new AsyncDataReader("PLAYLIST_RemoveSongByIndex", _credentials.DbConnectionString); dr.AddParameter("@DiscordUserId", discordUserId); dr.AddParameter("@PlaylistName", playlistName); dr.AddParameter("@Index", index); RemoveSongResult result = (RemoveSongResult)await dr.ExecuteScalarAsync(); return(result); }
public async Task <AddSongResult> AddSongToPlaylistAsync(long discordUserId, string playlistName, PlaylistSong song) { AsyncDataReader dr = new AsyncDataReader("PLAYLIST_AddSong", _credentials.DbConnectionString); dr.AddParameter("@DiscordUserId", discordUserId); dr.AddParameter("@PlaylistName", playlistName); dr.AddParameter("@SongName", song.Name); dr.AddParameter("@SongUrl", song.Url); AddSongResult result = (AddSongResult)await dr.ExecuteScalarAsync(); return(result); }
public async Task <DonateMoneyResult> DonateMoneyAsync(long donorDiscordUserId, long doneeDiscordUserId, long guildId, int amount) { AsyncDataReader dr = new AsyncDataReader("MONEY_DonateMoney", _credentials.DbConnectionString); dr.AddParameter("@DonorDiscordUserId", donorDiscordUserId); dr.AddParameter("@DoneeDiscordUserId", doneeDiscordUserId); dr.AddParameter("@DiscordGuildId", guildId); dr.AddParameter("@Amount", amount); try { return((DonateMoneyResult)await dr.ExecuteScalarAsync()); } catch { return(DonateMoneyResult.TransactionFailed); } }
public async Task <int> GetMoneyAsync(long discordUserId, long guildId) { AsyncDataReader dr = new AsyncDataReader("MONEY_GetMoney", _credentials.DbConnectionString); dr.AddParameter("@DiscordUserId", discordUserId); dr.AddParameter("@DiscordGuildId", guildId); int money = 0; await dr.ExecuteReaderAsync(reader => { money = reader.GetInt32(reader.GetOrdinal("MONEY")); return(Task.CompletedTask); }); return(money); }
public async Task <Models.Playlist> GetPlaylistAsync(long discordUserId, string playlistName) { AsyncDataReader dr = new AsyncDataReader("PLAYLIST_GetPlaylist", _credentials.DbConnectionString); dr.AddParameter("@DiscordUserId", discordUserId); dr.AddParameter("@PlaylistName", playlistName); Models.Playlist playlist = null; await dr.ExecuteReaderAsync(reader => { GetPlaylistWithSongsFromReader(reader, ref playlist); return(Task.CompletedTask); }); return(playlist); }
public async Task <Dictionary <PokemonSummary, int> > GetPokemonAsync(long discordUserId, long guildId) { AsyncDataReader dr = new AsyncDataReader("POKEMON_GetPokemonInventory", _connectionString); dr.AddParameter("@DiscordGuildId", guildId); dr.AddParameter("@DiscordUserId", discordUserId); Dictionary <PokemonSummary, int> pokemon = new Dictionary <PokemonSummary, int>(); await dr.ExecuteReaderAsync(reader => { int amount = reader.GetInt32(reader.GetOrdinal("AMOUNT")); pokemon.TryAdd(GetPokemonSummaryFromReader(reader), amount); return(Task.CompletedTask); }); return(pokemon); }
public async Task <List <Models.Playlist> > GetPlaylistsAsync(long discordUserId) { AsyncDataReader dr = new AsyncDataReader("PLAYLIST_GetPlaylists", _credentials.DbConnectionString); dr.AddParameter("@DiscordUserId", discordUserId); List <Models.Playlist> playlists = new List <Models.Playlist>(); await dr.ExecuteReaderAsync(reader => { playlists.Add(GetPlaylistFromReader(reader)); return(Task.CompletedTask); }); return(playlists); }