protected void btnCreateTeamBet_Click(object sender, EventArgs e)
{
if (Session["UserId"] != null)
{
if (rdoTypeOfBet.SelectedIndex == 0)
{
this.Page.Validate("TeamBet");
if (this.Page.IsValid)
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
tblTeamBet NewBet = new tblTeamBet
{
fkCreatorUserId = (int)Session["UserId"],
intWeekNumber = ddlWeekNumber.SelectedIndex,
strTeam = ddlTeams.SelectedItem.Text,
fkStatType = ddlTeamArguments.SelectedItem.Text,
strLogicArgument = ddlTeamLogic.SelectedItem.Text,
decArgumentValue = Convert.ToDecimal(txtTeamArgumentValue.Text),
datDateTimeCreated = DateTime.Now,
decMoneyWager = Convert.ToDecimal(txtTeamWagerAmount.Text.Trim()),
blnBetIsOpened = true
};
con.tblTeamBets.InsertOnSubmit(NewBet);
con.SubmitChanges();
}
pnlBetCreationIsSuccessful.Visible = true;
}
}
}
}
public static void UserAgreeToBet(int BetId, int UserIdWhoCreated, int UserIdWhoAccepted, bool IsTeamBet)
{
using (SqlContextDataContext con = new SqlContextDataContext())
{
tblLinkUsersToBet NewBetAcceptor = new tblLinkUsersToBet
{
fkUserWhoCreatedId = UserIdWhoCreated,
fkUserWhoAccepted = UserIdWhoAccepted,
fkBetId = BetId,
datDateTimeAccepted = DateTime.Now,
blnIsTeamBet = IsTeamBet
};
con.tblLinkUsersToBets.InsertOnSubmit(NewBetAcceptor);
con.SubmitChanges();
if (IsTeamBet)
{
tblTeamBet TeamBet = con.tblTeamBets.Single(x => x.pkBetId == BetId);
TeamBet.blnBetIsOpened = false;
con.SubmitChanges();
}
else
{
tblPlayerBet PlayerBet = con.tblPlayerBets.Single(x => x.pkBetId == BetId);
PlayerBet.blnBetIsOpened = false;
con.SubmitChanges();
}
}
}
protected void gvMyCreatedBets_RowCommand(object sender, GridViewCommandEventArgs e)
{
int RowIndex = ((GridViewRow)((ImageButton)e.CommandSource).NamingContainer).RowIndex;
string TeamOrPlayer = e.CommandArgument.ToString();
GridView gv = (GridView)sender;
int BetId = Convert.ToInt32(((Label)gv.Rows[RowIndex].FindControl("lblBetId")).Text);
if (e.CommandName == "CancelBet")
{
using (SqlContextDataContext context = new SqlContextDataContext())
{
if (TeamOrPlayer == "TeamBet")
{
tblTeamBet TeamBet = context.tblTeamBets.SingleOrDefault(x => x.pkBetId == BetId);
context.tblTeamBets.DeleteOnSubmit(TeamBet);
context.SubmitChanges();
int TeamLinkCount = context.tblLinkUsersToBets.Count(x => x.fkBetId == BetId && x.blnIsTeamBet == true);
if (TeamLinkCount != 0)
{
tblLinkUsersToBet DeleteBet = context.tblLinkUsersToBets.SingleOrDefault(x => x.fkBetId == BetId && x.blnIsTeamBet == true);
context.tblLinkUsersToBets.DeleteOnSubmit(DeleteBet);
context.SubmitChanges();
}
}
else
{
tblPlayerBet PlayerBet = context.tblPlayerBets.SingleOrDefault(x => x.pkBetId == BetId);
context.tblPlayerBets.DeleteOnSubmit(PlayerBet);
context.SubmitChanges();
int PlayerLinkCount = context.tblLinkUsersToBets.Count(x => x.fkBetId == BetId && x.blnIsTeamBet == false);
if (PlayerLinkCount != 0)
{
tblLinkUsersToBet DeleteBet = context.tblLinkUsersToBets.SingleOrDefault(x => x.fkBetId == BetId && x.blnIsTeamBet == false);
context.tblLinkUsersToBets.DeleteOnSubmit(DeleteBet);
context.SubmitChanges();
}
}
}
GetMyCreatedBets((int)Session["UserId"], 1);
}
else if (e.CommandName == "SendBetEmail")
{
}
}
private void SendTeamBetEmail(string EmailAddressToSendTo, string EmailTopic, string EmailMessage, tblTeamBet Bet)
{
MailMessage mail = new MailMessage();
StringBuilder message = new StringBuilder();
message.Append(Bet.strLogicArgument);
message.Append("<br />");
message.Append("<br />");
mail.IsBodyHtml = true;
mail.Body = message.ToString();
mail.Subject = "Social Sports PassWord Reset Link";
mail.From = new MailAddress("NoReply@SocialSports", "SocialSports");
mail.To.Add(new MailAddress(EmailAddressToSendTo));
SmtpClient c = new SmtpClient();
c.Port = 587;
c.Host = "smtp.gmail.com";
c.Credentials = new System.Net.NetworkCredential("*****@*****.**", "11111111");
c.DeliveryMethod = SmtpDeliveryMethod.Network;
c.EnableSsl = true;
c.Send(mail);
}
//finish
public static void MakeCopyOBet(int UserId, int BetId, bool IsTeamBet, bool IsOpposite)
{
using (SqlContextDataContext context = new SqlContextDataContext())
{
if (IsTeamBet)
{
var Results = context.tblTeamBets.Where(y => y.pkBetId == BetId)
.Select(g => new { TeamBets = g });
tblTeamBet NewTeamBet = new tblTeamBet();
foreach (var Result in Results)
{
NewTeamBet.strTeam = Result.TeamBets.strTeam;
NewTeamBet.pkBetId = Result.TeamBets.pkBetId;
NewTeamBet.fkStatType = Result.TeamBets.fkStatType;
NewTeamBet.datDateTimeCreated = DateTime.Now;
NewTeamBet.decArgumentValue = Result.TeamBets.decArgumentValue;
NewTeamBet.intWeekNumber = Result.TeamBets.intWeekNumber;
NewTeamBet.fkCreatorUserId = UserId;
if (IsOpposite)
{
if (Result.TeamBets.strLogicArgument.Trim() == "Will Have More Than")
{
NewTeamBet.strLogicArgument = "Will Have Less Than";
}
else
{
NewTeamBet.strLogicArgument = "Will Have More Than";
}
}
else
{
NewTeamBet.strLogicArgument = Result.TeamBets.strLogicArgument;
}
NewTeamBet.decMoneyWager = Result.TeamBets.decMoneyWager;
}
context.tblTeamBets.InsertOnSubmit(NewTeamBet);
context.SubmitChanges();
}
else
{
var Results = context.tblPlayerBets.Where(y => y.pkBetId == BetId)
.Select(g => new { PlayerBets = g });
tblPlayerBet NewPlayerBet = new tblPlayerBet();
foreach (var Result in Results)
{
NewPlayerBet.strPlayerName = Result.PlayerBets.strPlayerName;
NewPlayerBet.pkBetId = Result.PlayerBets.pkBetId;
NewPlayerBet.fkStatType = Result.PlayerBets.fkStatType;
NewPlayerBet.datDateTimeCreated = DateTime.Now;
NewPlayerBet.decArgumentValue = Result.PlayerBets.decArgumentValue;
NewPlayerBet.intWeekNumber = Result.PlayerBets.intWeekNumber;
NewPlayerBet.fkCreatorUserId = UserId;
NewPlayerBet.decMoneyWager = Result.PlayerBets.decMoneyWager;
if (IsOpposite)
{
if (Result.PlayerBets.strLogicArgument.Trim() == "Will Have More Than")
{
NewPlayerBet.strLogicArgument = "Will Have Less Than";
}
else
{
NewPlayerBet.strLogicArgument = "Will Have More Than";
}
}
else
{
NewPlayerBet.strLogicArgument = Result.PlayerBets.strLogicArgument;
}
}
context.tblPlayerBets.InsertOnSubmit(NewPlayerBet);
context.SubmitChanges();
}
}
}