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")
{
}
}
