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