public async Task Wallet()
{
var user_id = this.Context.Message.Author.AvatarId;
long guild_id = (long)this.Context.Guild.Id;
using (var db = new DatabaseContext())
{
db.Database.Initialize(true);
}
if (this.ValidateUser(user_id, guild_id))
{
using (var db = new WalletDbContext())
{
var row = db.Wallets.SingleOrDefault(u => u.User_id == user_id && u.Guild_id == guild_id);
using (var wdb = new WalletInfoDbContext())
{
var info = wdb.WalletInfos.SingleOrDefaultAsync(w => w.Guid == row.Guid);
var user = Context.User.Mention;
this.Context.Channel.SendMessageAsync(user + "Your wallet balance is : " + info.Result.Points);
}
}
}
else
{
this.Context.Channel.SendMessageAsync("You must !register first to obtain a wallet.");
}
}
public async Task Topup()
{
var amount = 20;
var time = 1;
var user_id = this.Context.Message.Author.AvatarId;
long guild_id = (long)this.Context.Guild.Id;
DateTime current = DateTime.Now;
using (var db = new DatabaseContext())
{
db.Database.Initialize(true);
}
using (var db = new WalletDbContext())
{
var row = db.Wallets.SingleOrDefault(u => u.User_id == user_id && u.Guild_id == guild_id);
using (var wdb = new WalletInfoDbContext())
{
var info = wdb.WalletInfos.SingleOrDefaultAsync(w => w.Guid == row.Guid);
var user = Context.User.Mention;
WalletInfo walletinfo = (from x in wdb.WalletInfos where x.Guid == row.Guid select x).First();
if (info.Result.Modified_on <= current.AddHours(-time))
{
walletinfo.Points = walletinfo.Points + amount;
walletinfo.TopupAmount = walletinfo.TopupAmount + amount;
walletinfo.TopupCount = walletinfo.TopupCount + 1;
walletinfo.Modified_on = current;
this.Context.Channel.SendMessageAsync(user + " Topup successfull. Your new wallet balance is : " + walletinfo.Points);
}
else
{
walletinfo.TopupFail = walletinfo.TopupFail + 1;
TimeSpan span = current.Subtract(info.Result.Modified_on);
if (time == 1)
{
this.Context.Channel.SendMessageAsync(user + "You may top up every hour. It has been " + (int)span.TotalMinutes + " minutes since your last topup.");
}
else
{
this.Context.Channel.SendMessageAsync(user + "You may top up every " + time + " hours. It has been " + (int)span.TotalMinutes + " minutes since your last topup.");
}
}
wdb.SaveChanges();
}
}
}
public async Task Flip()
{
int amount = 2;
Random rand = new Random();
bool modified = false;
bool win = false;
var user_id = this.Context.Message.Author.AvatarId;
long guild_id = (long)this.Context.Guild.Id;
using (var db = new DatabaseContext())
{
db.Database.Initialize(true);
}
if (this.ValidateUser(user_id, guild_id))
{
using (var db = new WalletDbContext())
{
var row = db.Wallets.SingleOrDefault(u => u.User_id == user_id && u.Guild_id == guild_id);
using (var wdb = new WalletInfoDbContext())
{
var info = wdb.WalletInfos.SingleOrDefault(w => w.Guid == row.Guid);
var user = Context.User.Mention;
WalletInfo walletinfo = (from x in wdb.WalletInfos where x.Guid == row.Guid select x).First();
if (rand.Next(0, 2) == 0)
{
await this.Context.Channel.SendMessageAsync("Heads!");
walletinfo.Points = walletinfo.Points + amount;
walletinfo.Won = walletinfo.Won + amount;
modified = true;
win = true;
}
else
{
if (walletinfo.Points - amount > 0)
{
await this.Context.Channel.SendMessageAsync("Tails!");
walletinfo.Points = walletinfo.Points - amount;
walletinfo.Lost = walletinfo.Lost + amount;
modified = true;
win = false;
}
else
{
this.Context.Channel.SendMessageAsync(user + "You may not bet more than is avaiable in your wallet. Amount to bet: " + amount + " Amount in Wallet: " + walletinfo.Points);
}
}
if (modified)
{
wdb.SaveChanges();
if (win)
{
this.Context.Channel.SendMessageAsync(user + "You Win! Your new wallet balance is : " + walletinfo.Points);
}
else
{
this.Context.Channel.SendMessageAsync(user + "You Lose. Your new wallet balance is : " + walletinfo.Points);
}
}
}
}
}
else
{
this.Context.Channel.SendMessageAsync("You must !register for an account before using this command. (Type !help for help)");
}
}
public async Task Register()
{
var user_id = this.Context.Message.Author.AvatarId;
long guild_id = (long)this.Context.Guild.Id;
using (var db = new DatabaseContext())
{
db.Database.Initialize(true);
}
using (var db = new UserDbContext())
{
var user = new User
{
User_id = user_id,
Guild_id = guild_id,
Status = 1,
Created_on = DateTime.Now
};
db.Database.CreateIfNotExists();
var row = db.Users.Count(u => u.User_id == user_id && u.Guild_id == guild_id);
if (row > 0)
{
this.Context.Channel.SendMessageAsync("User Already Exists On This Server");
}
else
{
db.Users.Add(user);
db.SaveChanges();
this.Context.Channel.SendMessageAsync("User successfully saved");
}
}
using (var db = new WalletDbContext())
{
var wallet = new Wallet
{
Guid = Guid.NewGuid(),
User_id = user_id,
Guild_id = guild_id
};
var row = db.Wallets.Count(w => w.User_id == user_id && w.Guild_id == guild_id);
if (row > 0)
{
this.Context.Channel.SendMessageAsync("Wallet Already Exists For This User On This Server");
}
else
{
db.Wallets.Add(wallet);
db.SaveChanges();
this.Context.Channel.SendMessageAsync("User Wallet successfully saved");
using (var wdb = new WalletInfoDbContext())
{
var walletInfo = new WalletInfo()
{
Guid = wallet.Guid,
Created_on = DateTime.Now,
Modified_on = DateTime.Now
};
wdb.Database.CreateIfNotExists();
wdb.WalletInfos.Add(walletInfo);
wdb.SaveChanges();
this.Context.Channel.SendMessageAsync("User Wallet Info successfully saved");
}
}
}
}
