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") { } }
protected void btnReply_Click(object sender, EventArgs e) { using (SqlContextDataContext con = new SqlContextDataContext()) { tblChildBulletinBoard Child = new tblChildBulletinBoard() { intBoardCreatorUserId = (int)Session["UserId"], datDateTimeCreated = DateTime.Now, intNumOfLikes = 0, intParentBoardId = Convert.ToInt32(Request.QueryString["BulletinId"]), strBoardMessage = txtReplyBulletin.Text.Trim() }; con.tblChildBulletinBoards.InsertOnSubmit(Child); con.SubmitChanges(); } ViewState["BulletinWasPosted"] = true; int BetId = Convert.ToInt32(Request.QueryString["BetId"]); bool IsTeamBet = Request.QueryString["Type"] == null ? true : false; if (IsTeamBet) { Response.Redirect("ViewBet.aspx?BetId=" + BetId.ToString()); } else { Response.Redirect("ViewBet.aspx?Type=PlayerBet&BetId=" + BetId.ToString()); } }
protected void btnUploadAvatar_Click(object sender, EventArgs e) { HttpPostedFile Avatar = filUploadAvatar.PostedFile; string FileName = Path.GetFileName(filUploadAvatar.PostedFile.FileName); string FileExtension = Path.GetExtension(FileName); int FileSize = Avatar.ContentLength; if (FileExtension == ".jpg" || FileExtension == ".gif" || FileExtension == ".png" || FileExtension == ".bmp") { Stream s = Avatar.InputStream; BinaryReader rdr = new BinaryReader(s); byte[] ImageBytes = rdr.ReadBytes((int)s.Length); using (SqlContextDataContext con = new SqlContextDataContext()) { tblUser User = con.tblUsers.Single(x => x.pkUserId == (int)Session["UserId"]); User.bytUserImage = ImageBytes; con.SubmitChanges(); } GetUserAvatar((int)Session["UserId"]); } }
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 bool UserBetApprovals(int BetId, int UserId) { bool IsAlreadyApproved = false; using (SqlContextDataContext con = new SqlContextDataContext()) { int ApprovalCount = con.tblBetApprovals.Where(x => x.fkUserIdWhoApproved == UserId).Count(); if (ApprovalCount == 0) { tblBetApproval NewBetApproval = new tblBetApproval() { fkBetId = BetId, fkUserIdWhoApproved = UserId }; con.tblBetApprovals.InsertOnSubmit(NewBetApproval); con.SubmitChanges(); } else { IsAlreadyApproved = true; } } return(IsAlreadyApproved); }
public static void InsertDefaultAvatar(int UserId) { FileStream fs = new FileStream(System.Web.HttpContext.Current.Server.MapPath("Icons\\default-avatar.jpg"), FileMode.Open); using (fs) { using (BinaryReader binaryReader = new BinaryReader(fs)) { Byte[] bytes = binaryReader.ReadBytes((int)fs.Length); try { using (SqlContextDataContext con = new SqlContextDataContext()) { tblUser user = con.tblUsers.First(x => x.pkUserId == UserId); user.bytUserImage = bytes; con.SubmitChanges(); } } catch (Exception err) { throw new ApplicationException(err.Message); } } } }
protected void btnRegister_Click(object sender, EventArgs e) { Page.Validate(); if (this.Page.IsValid) { using (SqlContextDataContext context = new SqlContextDataContext()) { string UserName = txtUserName.Text.Trim(); string UserEmail = txtUserEmail.Text.Trim(); int UserNameCount = context.tblUsers.Where(x => x.strUserName == UserName).Count(); int UserEmailCount = context.tblUsers.Where(x => x.strEmail == UserEmail).Count(); if (UserNameCount == 0 && UserEmailCount == 0) { int UserId = 0; tblUser NewUser = new tblUser { datDateRegistered = DateTime.Now, strEmail = txtUserEmail.Text.Trim(), strPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassWord.Text.Trim(), "SHA1"), strUserName = txtUserName.Text.Trim(), }; context.tblUsers.InsertOnSubmit(NewUser); context.SubmitChanges(); UserId += NewUser.pkUserId; lblRegisterSuccessful.Text = "Registered Successfully!"; lblRegisterSuccessful.ForeColor = System.Drawing.Color.Green; pnlRegisterIsSuccessful.Visible = true; pnlRegisterIsNotSuccessful.Visible = false; UserInfo.InsertDefaultAvatar(UserId); } else if (UserNameCount == 1) { lblStatus.Text = "User Name Already In User"; lblStatus.ForeColor = System.Drawing.Color.Red; pnlRegisterIsNotSuccessful.Visible = true; } else { lblStatus.Text = "User Email Already In User"; lblStatus.ForeColor = System.Drawing.Color.Red; pnlRegisterIsNotSuccessful.Visible = true; } } } }
private void InsertUserFavoriteNflTeam(int UserId, int FavoriteTeamId) { using (SqlContextDataContext context = new SqlContextDataContext()) { tblUsersFavoriteNflTeam NewUsersFavoriteTeam = new tblUsersFavoriteNflTeam { fkSportsTeam = FavoriteTeamId, fkUserId = UserId }; context.tblUsersFavoriteNflTeams.InsertOnSubmit(NewUsersFavoriteTeam); context.SubmitChanges(); } }
public void InsertPageView(int UserId, string BaseUrl, int QueryStringValue, bool IsTeamBet) { using (SqlContextDataContext c = new SqlContextDataContext()) { tblStatsPageVisit NewPageVisit = new tblStatsPageVisit { fkUserId = UserId, strBaseUrlVisited = BaseUrl, strQueryStringValue = QueryStringValue, datDateTimeVisited = DateTime.Now, blnIsTeamBet = IsTeamBet }; c.tblStatsPageVisits.InsertOnSubmit(NewPageVisit); c.SubmitChanges(); } }
protected void fvPaymentInformation_ItemUpdating(object sender, FormViewUpdateEventArgs e) { FormView fv = (FormView)sender; DataKey key = fv.DataKey; string txtAccountNumber = ((TextBox)fv.FindControl("txtAccountNumber")).Text; string txtFirstName = ((TextBox)fv.FindControl("txtFirstName")).Text; string txtLastName = ((TextBox)fv.FindControl("txtLastName")).Text; using (SqlContextDataContext con = new SqlContextDataContext()) { tblUsersPaymentInformation pay = con.tblUsersPaymentInformations.SingleOrDefault(x => x.fkUserId == (int)Session["UserId"]); pay.strAccountNumber = txtAccountNumber.Trim(); pay.strFirstName = txtFirstName.Trim(); pay.strLastName = txtLastName.Trim(); con.SubmitChanges(); } }
protected void btnRecoverPassWord_Click(object sender, EventArgs e) { this.Page.Validate(); if (this.Page.IsValid) { using (SqlContextDataContext context = new SqlContextDataContext()) { var results = from t in context.tblUsers where t.strEmail == txtEmail.Text select t; if (results.Count() > 0) { foreach (var result in results) { Guid guid = Guid.NewGuid(); string TempPassWord = RandomPassWordGenerator(16); tblCredentialsRecovery rec = new tblCredentialsRecovery { guiRecoveryGuid = guid, fkUserId = result.pkUserId, datResetRequestDateTime = DateTime.Now, strTemporaryPassWord = TempPassWord, blnIsPassWordRecovery = Convert.ToBoolean(rdoForgot.SelectedIndex) }; context.tblCredentialsRecoveries.InsertOnSubmit(rec); context.SubmitChanges(); SendPassWordResetLink(result.strEmail, result.strUserName, guid.ToString(), TempPassWord); pnlEmailSent.Visible = true; } } else { lblStatus.Text = "Email Was Not Found"; lblStatus.ForeColor = System.Drawing.Color.Red; } } } }
protected void btnPostToBulletin_Click(object sender, EventArgs e) { bool IsTeamBet = false; if (Request.QueryString["Type"] != null) { IsTeamBet = true; } int BetId; if (Request.QueryString["BetId"] != null && int.TryParse(Request.QueryString["BetId"], out BetId)) { if (Session["UserId"] != null) { tblParentBulletinBoard Board = new tblParentBulletinBoard { blnIsTeamBet = IsTeamBet, intBetId = Convert.ToInt32(Request.QueryString["BetId"]), datDateTimeCreated = DateTime.Now, intNumOfLikes = 0, strBoardMessage = txtBulletinBoardMessage.Text.Trim(), intUserIdWhoPostedBoard = (int)Session["UserId"], intBoardAttachmentId = 0 }; using (SqlContextDataContext c = new SqlContextDataContext()) { c.tblParentBulletinBoards.InsertOnSubmit(Board); c.SubmitChanges(); } litBulletinBoard.Text = GetBulletinBoard(BetId, IsTeamBet).ToString(); ViewState["BulletinWasPosted"] = true; pnlBulletinPosted.Visible = true; } else { pnlMustBeLoggedId.Visible = true; ViewState["MustBeLoggedIn"] = true; } } }
public void InsertSearchQuery(int UserId, bool IsPlayerBet, Guid guid, string EntityName, string StatArgument, string LogicArgument, decimal?ValueArgument) { using (SqlContextDataContext con = new SqlContextDataContext()) { tblStatsBetSearchQuery NewBetSearch = new tblStatsBetSearchQuery { fkUserId = UserId, IsPlayerBetSearch = IsPlayerBet, strEntityName = EntityName, strStatArgument = StatArgument, strLogicArgument = LogicArgument, strValueArgument = ValueArgument, datDateTimeCreated = DateTime.Now, guidQuery = guid }; con.tblStatsBetSearchQueries.InsertOnSubmit(NewBetSearch); con.SubmitChanges(); } }
protected void btnResetPassWord_Click(object sender, EventArgs e) { Guid g; if (Guid.TryParse(Request.QueryString["guid"], out g)) { using (SqlContextDataContext context = new SqlContextDataContext()) { var q = from t in context.tblCredentialsRecoveries where t.guiRecoveryGuid.ToString() == g.ToString() select t; foreach (var r in q) { Page.Validate(); if (this.Page.IsValid) { if (txtTemporaryPassWord.Text.Trim() == r.strTemporaryPassWord) { tblUser user = context.tblUsers.SingleOrDefault(x => x.pkUserId == r.fkUserId); user.strPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassWord.Text.Trim(), "SHA1"); context.SubmitChanges(); pnlPassWordReset.Visible = true; } else { lblStatus.Text = "Invalid Temporary PassWord"; lblStatus.ForeColor = System.Drawing.Color.Red; } } } } } }
//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(); } } }