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();
}
