public async Task GiveGoldEveryone(List <SocketGuildUser> users, int amount) { foreach (var user in users) { if (!db.TbCurrencies.Any(x => x.UserID == user.Id)) { db.TbCurrencies.Add(new TbCurrency { UserID = user.Id, Username = user.Username, GoldAmount = amount, AmountOfGambles = 0, GuildID = user.Guild.Id }); } else { TbCurrency tbUser = await db.TbCurrencies.AsQueryable().SingleOrDefaultAsync(x => x.UserID == user.Id); var debugGoldAmount = tbUser.GoldAmount; tbUser.GoldAmount += amount; tbUser.Username = user.Username; db.TbCurrencies.Update(tbUser); Console.WriteLine($"Giving {tbUser.Username} {amount} gold, they had {debugGoldAmount} and now have {tbUser.GoldAmount}"); } } await db.SaveChangesAsync(); }
public async Task SaveGoldToBot(int amount) { TbCurrency tbUser = await db.TbCurrencies.AsQueryable().Where(x => x.UserID == 276456075559960576).SingleOrDefaultAsync(); tbUser.GoldAmount += amount; db.TbCurrencies.Update(tbUser); await db.SaveChangesAsync(); }
public async Task UpdateGambleAmount(IUser user) { TbCurrency tbUser = await db.TbCurrencies.AsQueryable().Where(x => x.UserID == user.Id).SingleOrDefaultAsync(); tbUser.AmountOfGambles++; db.TbCurrencies.Update(tbUser); await db.SaveChangesAsync(); }
public async Task SaveGold(IUser user, ulong guildID, int amount) { if (!db.TbCurrencies.Any(x => x.UserID == user.Id)) { db.TbCurrencies.Add(new TbCurrency { UserID = user.Id, Username = user.Username, GoldAmount = amount, GuildID = guildID, }); } else { TbCurrency tbUser = db.TbCurrencies.AsQueryable().Where(x => x.UserID == user.Id).FirstOrDefault(); var debugGoldAmount = tbUser.GoldAmount; tbUser.GoldAmount += amount; tbUser.Username = user.Username; db.TbCurrencies.Update(tbUser); Console.WriteLine($"Giving {tbUser.Username} {amount} gold, they had {debugGoldAmount} and now have {tbUser.GoldAmount}"); } await db.SaveChangesAsync(); }