//TODO pass bet object
public void MakeBet(bet bet)
{
SqlConnection sql = new SqlConnection(ConnectionString);
if (bet.Score != null)
{
using (sql)
{
SqlCommand Command = new SqlCommand("INSERT INTO Bets (UserID, MatchID, BetMoney, Outcome, Score) VALUES (@UserID, @MatchID, @BetMoney, @Outcome, @Score)", sql);
Command.Parameters.AddWithValue("@UserID", bet.UserID);
Command.Parameters.AddWithValue("@MatchID", bet.MatchID);
Command.Parameters.AddWithValue("@BetMoney", bet.Money);
Command.Parameters.AddWithValue("@Score", bet.Score);
Command.Parameters.AddWithValue("@Outcome", bet.Outcome);
sql.Open();
Command.ExecuteNonQuery();
}
}
else
{
using (sql)
{
SqlCommand Command = new SqlCommand("INSERT INTO Bets (UserID, MatchID, BetMoney, Outcome) VALUES (@UserID, @MatchID, @BetMoney, @Outcome)", sql);
Command.Parameters.AddWithValue("@UserID", bet.UserID);
Command.Parameters.AddWithValue("@MatchID", bet.MatchID);
Command.Parameters.AddWithValue("@BetMoney", bet.Money);
Command.Parameters.AddWithValue("@Outcome", bet.Outcome);
sql.Open();
Command.ExecuteNonQuery();
}
}
}
public async Task Bet(long MatchID, string Score, decimal Money)
{
//await Context.Message.DeleteAsync(); // SECRET
long ID = (long)Context.User.Id;
if (!sql.UserExists(ID))
{
await ReplyAsync(MentionUtils.MentionUser(Context.User.Id) + " you have to register before betting");
}
else
{
if (!(Score.Length == 3 && char.IsDigit(Score[0]) && char.IsDigit(Score[2]) && Score[1] == '-'))
{
await ReplyAsync(MentionUtils.MentionUser(Context.User.Id) + " invalid score format");
}
else
{
// make bet object
bet bet = new bet(ID, MatchID, Score, Money);
if (!sql.HasEnoughMoney(ID, Money))
{
await ReplyAsync(MentionUtils.MentionUser(Context.User.Id) + " you don't have enough money to make that bet");
}
else
{
if (Money <= 0)
{
await ReplyAsync(MentionUtils.MentionUser(Context.User.Id) + " invalid number");
}
else
{
if (!sql.MatchExists(MatchID))
{
await ReplyAsync(MentionUtils.MentionUser(Context.User.Id) + " invalid match");
}
else
{
if (sql.IsMatchLive(MatchID))
{
await ReplyAsync(MentionUtils.MentionUser(Context.User.Id) + " you can't bet during a live match baka desu senpai");
}
else
{
if (sql.BetExists(ID, MatchID))
{
await ReplyAsync(MentionUtils.MentionUser(Context.User.Id) + " you already bet on that match");
}
else
{
// FINALS
if (MatchID == 28)
{
bet.Money += 125;
sql.MakeBet(bet);
sql.SubstractMoney(ID, Money);
sql.AddMoneyBet(ID, Money);
await ReplyAsync(MentionUtils.MentionUser(Context.User.Id) + " FINALS MADNESS! You succesfully placed your bet and we added 125★ to it for free!");
}
else
{
sql.MakeBet(bet);
sql.SubstractMoney(ID, Money);
sql.AddMoneyBet(ID, Money);
ScheduledMatch sm = sql.GetScheduledMatch(MatchID);
//await ReplyAsync(string.Format("{0} bet placed on **{1}** vs **{2}**", MentionUtils.MentionUser(Context.User.Id), sm.TeamA, sm.TeamB)); // Secret
await ReplyAsync(string.Format("{0} bet {3}★ on **{1}** vs **{2}**", MentionUtils.MentionUser(Context.User.Id), sm.TeamA, sm.TeamB, Money));// Public
}
}
}
}
}
}
}
}
}