protected void Page_Load(object sender, EventArgs e) { con.Open(); // SqlConnection strConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); strConn.Open(); if (User.Identity.IsAuthenticated) { Label3.Visible = true; SqlCommand command = new SqlCommand("SELECT SpaceBucks from AspNetUsers WHERE Email= '" + User.Identity.Name + "'", strConn); SqlDataReader read = command.ExecuteReader(); if (read.Read()) { oldbalance = (read["SpaceBucks"].ToString()); Label3.Text = "Your balance: " + oldbalance + " Space Bucks"; read.Close(); } } if (Session["infoObject"] != null) { MainPageFeedResults streamObject = (MainPageFeedResults)Session["infoObject"]; if (streamObject != null) { Debug.WriteLine(streamObject.matchTitle); this.streamTitle.InnerText = streamObject.matchTitle; title = streamObject.matchTitle; string[] words = title.Split(new[] { " vs " }, StringSplitOptions.None); this.team1button.Text = words[0]; this.team2button.Text = words[1]; this.gameInfoLink.HRef = streamObject.matchLink; this.gameInfoLabel.InnerText = streamObject.matchTitle + " Inside Info and Tips provided by HLTV.com, click here"; this.SqlDataSource1.SelectCommand = "SELECT [User], [TeamChosen], [MatchName], [BetAmount] FROM [OpenBets] WHERE MatchName =" + "'" + title + "'"; } } }
protected void rssMatchFeedCall() { string url = "http://www.hltv.org/hltv.rss.php"; XmlDocument MyRssDocument = new XmlDocument(); MyRssDocument.Load(url); XmlNodeList MyRssList = MyRssDocument.SelectNodes("rss/channel/item"); string sTitle = ""; string sLink = ""; string sDescription = ""; string spubDate = ""; string sgametype = ""; for (int i = 0; i < MyRssList.Count; i++) { MainPageFeedResults f = new MainPageFeedResults(); XmlNode MyRssDetail; MyRssDetail = MyRssList.Item(i).SelectSingleNode("title"); if (MyRssDetail != null) { sTitle = MyRssDetail.InnerText; } else { sTitle = ""; } MyRssDetail = MyRssList.Item(i).SelectSingleNode("link"); if (MyRssDetail != null) { sLink = MyRssDetail.InnerText; } else { sLink = ""; } MyRssDetail = MyRssList.Item(i).SelectSingleNode("description"); if (MyRssDetail != null) { sDescription = MyRssDetail.InnerText; } else { sDescription = ""; } MyRssDetail = MyRssList.Item(i).SelectSingleNode("pubDate"); if (MyRssDetail != null) { spubDate = MyRssDetail.InnerText; } else { spubDate = ""; } MyRssDetail = MyRssList.Item(i).SelectSingleNode("gametype"); if (MyRssDetail != null) { sgametype = MyRssDetail.InnerText; } else { sgametype = ""; } f.matchDes = sDescription; f.matchGameType = sgametype; f.matchPubDate = spubDate; f.matchTitle = sTitle; f.matchLink = sLink; MatchfeedResults.Add(f); // Debug.WriteLine(sTitle + " " + sLink + " " + sDescription + " " + sgametype + " " + spubDate); } }
protected void rssNewsFeedCall() { string url = "http://www.hltv.org/news.rss.php"; XmlDocument MyRssDocument = new XmlDocument(); MyRssDocument.Load(url); XmlNodeList MyRssList = MyRssDocument.SelectNodes("rss/channel/item"); string sTitle = ""; string sLink = ""; string spubDate = ""; for (int i = 0; i < MyRssList.Count; i++) { MainPageFeedResults f = new MainPageFeedResults(); XmlNode MyRssDetail; MyRssDetail = MyRssList.Item(i).SelectSingleNode("title"); if (MyRssDetail != null) sTitle = MyRssDetail.InnerText; else sTitle = ""; MyRssDetail = MyRssList.Item(i).SelectSingleNode("link"); if (MyRssDetail != null) sLink = MyRssDetail.InnerText; else sLink = ""; MyRssDetail = MyRssList.Item(i).SelectSingleNode("pubDate"); if (MyRssDetail != null) spubDate = MyRssDetail.InnerText; else { spubDate = ""; } f.matchPubDate = spubDate; f.matchTitle = sTitle; f.matchLink = sLink; NewsfeedResults.Add(f); Debug.WriteLine(sTitle + " " + sLink + " " + " " + spubDate); } }
protected void Button1_Click(object sender, EventArgs e) { string choice = null; if (!User.Identity.IsAuthenticated) { Label2.Visible = true; Label2.Text = "Please log in or register to submit a bet"; } else if (team1button.Checked && team2button.Checked) { Label2.Visible = true; Label2.Text = "You may only select one team to bet on"; } else if (!team1button.Checked && !team2button.Checked) { Label2.Visible = true; Label2.Text = "Please select a team to bet on"; } else { if (Session["infoObject"] != null) { MainPageFeedResults streamObject = (MainPageFeedResults)Session["infoObject"]; string[] words = streamObject.matchTitle.Split(' '); if (team1button.Checked) { choice = words[0]; // choice = "Team 1"; } else if (team2button.Checked) { choice = words[2]; // choice = "Team 2"; } } int number; bool result = Int32.TryParse(amountbox.Text, out number); if (result && number <= (Int32.Parse(oldbalance)) && number > 0) { SqlCommand cmd = new SqlCommand("insert into OpenBets values('" + User.Identity.Name + "', '" + choice + "', '" + title + "', '" + number + "')", con); // SqlCommand cmd = new SqlCommand("insert into TestTable values('" + User.Identity.Name + "', '" + choice + "', '" + number + "')", con); cmd.ExecuteNonQuery(); // SqlCommand cmd2 = new SqlCommand("delete from TestTable", con); // cmd2.ExecuteNonQuery(); // con.Close(); GridView1.DataBind(); Label2.Visible = true; Label2.Text = "Your bet has been made " + User.Identity.Name; SqlCommand updatecmd = new SqlCommand("UPDATE AspNetUsers SET SpaceBucks=@newSpaceBucks WHERE Email = '" + User.Identity.Name + "'", strConn); // SqlCommand updatecmd = new SqlCommand("UPDATE AspNetUsers SET SpaceBucks=SpaceBucks - '"+ Convert.ToInt32(amountbox.Text) +"' WHERE Email = '" + User.Identity.Name + "'", strConn); // updatecmd.Parameters.AddWithValue("@newSpaceBucks", (Convert.ToInt32(balance) - Convert.ToInt32(amountbox.Text)).ToString()); balancenumber = Convert.ToInt32(oldbalance); newbalance = balancenumber - Convert.ToInt32(amountbox.Text); // newbalance = balancenumber - (Convert.ToInt32(amountbox.Text)); updatecmd.Parameters.AddWithValue("@newSpaceBucks", newbalance); updatecmd.ExecuteNonQuery(); Label3.Text = "Your balance: " + newbalance + " Space Bucks"; // balance = newbalance.ToString(); // Label3.Text = "Your balance: " + newbalance.ToString() + " Space Bucks"; con.Close(); } else { if (!result) { Label2.Visible = true; Label2.Text = "Invalid bet entry. Please enter a whole number"; } else if (number > (Int32.Parse(oldbalance))) { Label2.Visible = true; Label2.Text = "Insufficient balance to place your entered bet"; } else if (number <= 0) { Label2.Visible = true; Label2.Text = "Bet placed must be positive"; } } // if(team1button.Checked == false && team2button.Checked = false) } // if(team1button.Checked) // { team1button.Checked = false; // } // else if(team2button.Checked) // { team2button.Checked = false; // } amountbox.Text = ""; /* GridView1.DataSource = null; * GridView1.DataBind(); * // GridView1.Columns.Clear(); */ }