private void LoadTreeView(int sportid) { CrawlAllMarkets crawl = new CrawlAllMarkets(); DataSet ds = crawl.GetMatchByDate(sportid); ds.Relations.Add("Date_Section1", ds.Tables[0].Columns["matchdate"], ds.Tables[1].Columns["matchdate"]); TreeNode tn_group = new TreeNode(lblSportName.Text); foreach (DataRow dr in ds.Tables[0].Rows) { TreeNode tn_date = new TreeNode(dr["MatchDate"].ToString()); string matchdate = Convert.ToString(dr["matchdate"]); string sql1 = "(matchdate='" + matchdate + "')"; foreach (DataRow dr1 in ds.Tables[1].Select(sql1)) { TreeNode tn_match = new TreeNode(dr1["Home"].ToString() + " V " + dr1["Away"].ToString() + ":" + dr1["id"].ToString()); tn_date.Nodes.Add(tn_match); } tn_group.Nodes.Add(tn_date); } if (InvokeRequired) { Action a = () => { treeView1.Nodes.Add(tn_group); }; BeginInvoke(a); } }
private void LoadChampionsLeague() { DataTable dt = new DataTable(); CrawlAllMarkets crawl = new CrawlAllMarkets(); // 358==Leagueid of Champions League dt = crawl.GetMatchesByCoupon(); TreeNode tn_group = new TreeNode("Match Result"); string matchdate = ""; foreach (DataRow row in dt.Rows) { if (matchdate != row["MatchDate"].ToString()) { matchdate = row["MatchDate"].ToString(); TreeNode tn_date = new TreeNode(matchdate); string sql1 = "(matchdate='" + matchdate + "')"; tn_group.Nodes.Add(tn_date); foreach (DataRow dr1 in dt.Select(sql1)) { TreeNode tn_match = new TreeNode(dr1["Home"].ToString() + " V " + dr1["Away"].ToString() + ":" + dr1["id"].ToString()); tn_date.Nodes.Add(tn_match); } } } if (InvokeRequired) { Action a = () => { treeView1.Nodes.Add(tn_group); }; BeginInvoke(a); } }
private void BindMasterMarket(int sportid) { CrawlAllMarkets crawl = new CrawlAllMarkets(); cmbMasterMarketName.DataSource = crawl.GetMasterMarketName(sportid); cmbMasterMarketName.DisplayMember = "ResultName"; cmbMasterMarketName.ValueMember = "ResultLink"; }
private void GetMatchResult(int matchid, int spportid) { CrawlAllMarkets crawl = new CrawlAllMarkets(); DataTable dt = new DataTable(); dt = crawl.GetMatchResult(matchid, spportid); dataGridView1.DataSource = dt; }
private void treeView1_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e) { try { TreeNode parentnode = e.Node; while (parentnode.Parent != null) { parentnode = parentnode.Parent; } if (parentnode.Text.Equals("Match Result")) //if (e.Node.Level == 3 || e.Node.Level == 5) { OddsCheckerCrawler parent = this.MdiParent as OddsCheckerCrawler; if (!parent.IsProcessRunning) { //if (!string.IsNullOrEmpty(parent.SelectedBookies())) //{ //parent.SetProgress(true); //parent.IsProcessRunning = true; string info = e.Node.Text; string[] info1 = info.Split(':'); CrawlAllMarkets crawl = new CrawlAllMarkets(); string[] match = crawl.GetChampionMatchInfo(Convert.ToInt32(info1[1].ToString())); //match[0]=link;match[1]=time; if (match[0] != null) { parent.IsProcessRunning = true; parent.SetProgress(true); flowLayoutPanel1.Controls.Clear(); // lblsportid.Text = info1[3]; countthread = 0; Task taskA = Task.Factory.StartNew(() => { FillMatchInfo(info1[1], match[0], match[1], 1); }, TaskCreationOptions.LongRunning); } //} //else //{ // MessageBox.Show("Please select atleast one bookie from Select Bookies menu"); //} } else { MessageBox.Show("A process is already running"); } } } catch (Exception ex) { MessageBox.Show("An internal error occured while processing the request"); } }
private void btnsave_Click(object sender, EventArgs e) { CrawlAllMarkets c = new CrawlAllMarkets(); // c.CrawlBettingMarkets("http://www.oddschecker.com//football/world/morocco/gnf-1/ocs-olympique-de-safi-v-fus-rabat/betting-markets", 7624); CrawlFirstPage crawl = new CrawlFirstPage(); Console.WriteLine("Crawling Started EachSport"); crawl.GetMatchListByTime(); // crawl.CrawlChampionLeauge("3866", "file:///E:/OddsCompiler/z-rowdata/Results/Barcelona%20v%20Atletico%20Madrid/Barcelona%20v%20Atletico%20Madrid%20Winner%20Betting%20Odds%20%20%20Football%20Betting%20%20%20Oddschecker.htm", "34pm"); }
private void callback() { TraceService("Timer Started"); CrawlAllMarkets crawl = new CrawlAllMarkets(); CrawlFirstPage crawlpage = new CrawlFirstPage(); ////CrawlEachMarket crawlmarket = new CrawlEachMarket(); //string msg = crawlpage.DeleteFirstPageRecords(); string msg1 = "", msg2 = "", msg3 = ""; try { msg1 = DateTime.Now + ":" + crawlpage.CrawlEachSport(); } catch (Exception ex) { } finally { TraceService("Reply from CrawlEachSport at " + msg1 + "\n"); } try { msg2 = DateTime.Now + ":" + crawl.CrawlBettingLinks(); } catch (Exception ex) { } finally { TraceService("Reply from CrawlEachSport at " + msg2 + "\n"); } try { msg3 = DateTime.Now + ":" + crawlpage.CrawlAllGolf(); } catch (Exception ex) { } finally { TraceService(" Reply from CrawlEachMatchResult at " + msg3 + "\n"); } try { msg3 = DateTime.Now + ":" + crawlpage.CrawlEachMatchResult(); } catch (Exception ex) { } finally { TraceService(" Reply from CrawlEachMatchResult at " + msg3 + "\n"); } }
private void loadData() { string url = "http://www.oddschecker.com/football-betting"; //string html = Helper.GetWebSiteContent("http://www.oddschecker.com/gaelic-games/gaelic-football/"); //(ConfigurationSettings.AppSettings["URL"]); CrawlAllMarkets crawl = new CrawlAllMarkets(); CrawlFirstPage crawlpage = new CrawlFirstPage(); CrawlEachMarket crawlmarket = new CrawlEachMarket(); //string msg = crawlpage.DeleteFirstPageRecords(); //Task taskA = Task.Factory.StartNew(() => //{ // string msg1 = crawlpage.CrawlEachSport(); //}, TaskCreationOptions.LongRunning | TaskCreationOptions.PreferFairness); string msg2 = crawl.CrawlBettingLinks(); //crawlpage.CrawlWorldMarkets(); //crawlpage.CrawlLeagues(url); }
private void LoadTreeViewForGaelic(string sport) { int id = Convert.ToInt32(sport); CrawlAllMarkets crawl = new CrawlAllMarkets(); DataSet ds = crawl.GetMatchesAndMarkets(id); ds.Relations.Add("Sport_Match", ds.Tables[0].Columns["sportid"], ds.Tables[1].Columns["sportid"]); ds.Relations.Add("Match_Mkt", ds.Tables[2].Columns["id"], ds.Tables[3].Columns["matchid"]); //ds.Relations.Add("Match_Date", ds.Tables[1].Columns["MatchDate"], ds.Tables[2].Columns["MatchDate"]); //TreeNode tn_group = new TreeNode("GAA Football"); foreach (DataRow drSport in ds.Tables[0].Rows) { TreeNode tn_group = new TreeNode(drSport["SportName"].ToString()); foreach (DataRow dr in drSport.GetChildRows("Sport_Match")) { string matchdate = dr["MatchDate"].ToString(); string sportid = dr["sportid"].ToString(); TreeNode tn_date = new TreeNode(matchdate); tn_group.Nodes.Add(tn_date); string sql1 = "(matchdate='" + matchdate + "') AND (sportid='" + sportid + "')"; foreach (DataRow dr1 in ds.Tables[2].Select(sql1)) //foreach (DataRow dr1 in dr.GetChildRows("Match_Date")) { TreeNode tn_match = new TreeNode(dr1["Home"].ToString() + " V " + dr1["Away"].ToString()); tn_date.Nodes.Add(tn_match); //foreach (DataRow drChild in dr1.GetChildRows("Match_Mkt")) //{ // TreeNode tn_market = new TreeNode(drChild["bettingmarket"].ToString()); // tn_market.Name = drChild["id"].ToString() + "," + drChild["matchid"].ToString() + "," + drChild["bettinglink"].ToString() + "," + Convert.ToString(drSport["sportid"]); // tn_match.Nodes.Add(tn_market); //} } } if (InvokeRequired) { Action a = () => { treeView1.Nodes.Add(tn_group); }; BeginInvoke(a); } } //treeView1.Nodes.Add(tn_group); }
private void OnElapsedTime(object source, ElapsedEventArgs e) { string html = Helper.GetWebSiteContent("http://www.oddschecker.com/gaelic-games/gaelic-football/"); //(ConfigurationSettings.AppSettings["URL"]); CrawlAllMarkets crawl = new CrawlAllMarkets(); CrawlFirstPage crawlpage = new CrawlFirstPage(); ////CrawlEachMarket crawlmarket = new CrawlEachMarket(); string msg = crawlpage.DeleteFirstPageRecords(); string msg1 = crawlpage.CrawlMyPage(html); string msg2 = crawl.CrawlBettingLinks(); //TraceService("Reply from DeleteFirstPageRecords at " + DateTime.Now + ":" + msg + "\n Reply from CrawlMyPage at " + DateTime.Now + ":" + msg1 + "\n Reply from CrawlBettingLinks at " + DateTime.Now + ":" + msg2 + "\n"); //string html = Helper.GetWebSiteContent(ConfigurationSettings.AppSettings["URL"]); //CrawlAllMarkets crawl = new CrawlAllMarkets(); //CrawlFirstPage crawlpage = new CrawlFirstPage(); //CrawlEachMarket crawlmarket = new CrawlEachMarket(); //crawlpage.CrawlMyPage(html); //crawl.CrawlBettingLinks(); //crawlmarket.CrawlMarketLinks(); }
protected void BindGrid(long matchid) { BindingSource bindingSource1 = new BindingSource(); dataGridMarkets.AutoGenerateColumns = false; dataGridMarkets.ColumnCount = 4; dataGridMarkets.Columns[0].Name = "ID"; dataGridMarkets.Columns[0].DataPropertyName = "id"; dataGridMarkets.Columns[0].Visible = false; dataGridMarkets.Columns[1].Name = "MatchID"; dataGridMarkets.Columns[1].DataPropertyName = "matchid"; dataGridMarkets.Columns[1].Visible = false; dataGridMarkets.Columns[2].Name = "Markets"; dataGridMarkets.Columns[2].DataPropertyName = "bettingmarket"; dataGridMarkets.Columns[3].Name = "BettingLink"; dataGridMarkets.Columns[3].DataPropertyName = "bettinglink"; dataGridMarkets.Columns[3].Visible = false; var buttonCol = new DataGridViewButtonColumn(); buttonCol.UseColumnTextForButtonValue = true; buttonCol.Name = "Odds"; buttonCol.Text = "View Odds"; dataGridMarkets.Columns.Add(buttonCol); CrawlAllMarkets crawl = new CrawlAllMarkets(); dataGridMarkets.DataSource = crawl.GetBettingMarkets(matchid); //foreach (DataGridViewColumn column in dataGridMarkets.Columns) // column.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; //this.Width = dataGridMarkets.Width + 100; //int totalRowHeight = dataGridMarkets.ColumnHeadersHeight; //foreach (DataGridViewRow row in dataGridMarkets.Rows) // totalRowHeight += row.Height; //dataGridMarkets.Height = totalRowHeight+10; //this.Height = dataGridMarkets.Height + 100; }
private void LoadTreeViewForSoccer() { CrawlAllMarkets crawl = new CrawlAllMarkets(); DataSet ds = crawl.GetMatchesAndMarketsFoSoccer(); ds.Relations.Add("Sport_Match", ds.Tables[0].Columns["sportid"], ds.Tables[1].Columns["sportid"]); ds.Relations.Add("Date_Section", ds.Tables[1].Columns["matchdate"], ds.Tables[2].Columns["matchdate"]); // ds.Relations.Add("League_Match", ds.Tables[3].Columns["leagueid"], ds.Tables[4].Columns["leagueid"]); ds.Relations.Add("Match_Mkt", ds.Tables[4].Columns["id"], ds.Tables[5].Columns["matchid"]); //TreeNode tn_group = new TreeNode("GAA Football"); foreach (DataRow drSport in ds.Tables[0].Rows) { TreeNode tn_group = new TreeNode(drSport["SportName"].ToString()); //treeView1.Nodes.Add(tn_group); foreach (DataRow dr in drSport.GetChildRows("Sport_Match")) { TreeNode tn_date = new TreeNode(dr["MatchDate"].ToString()); tn_group.Nodes.Add(tn_date); TreeNode worldsec = new TreeNode("World"); tn_date.Nodes.Add(worldsec); foreach (DataRow dr1 in dr.GetChildRows("Date_Section")) { string matchdate = Convert.ToString(dr1["matchdate"]); string section = Convert.ToString(dr1["section"]); TreeNode tn_section = new TreeNode(section); if (section.Equals("English") || section.Equals("Scottish") || section.Equals("European") || section.Equals("Champions League") || section.Equals("Europa League")) { tn_date.Nodes.Add(tn_section); } else { worldsec.Nodes.Add(tn_section); } string sql = "(matchdate='" + matchdate + "') AND (section='" + section + "')"; foreach (DataRow drChild in ds.Tables[3].Select(sql)) { string leagueid = drChild["leagueid"].ToString(); TreeNode tn_league = new TreeNode(drChild["league"].ToString()); tn_section.Nodes.Add(tn_league); string sql1 = "(matchdate='" + matchdate + "') AND (leagueid='" + leagueid + "')"; foreach (DataRow drchildrow in ds.Tables[4].Select(sql1)) { TreeNode tn_match = new TreeNode(drchildrow["Home"].ToString() + " V " + drchildrow["Away"].ToString()); tn_league.Nodes.Add(tn_match); //foreach (DataRow drmarket in drchildrow.GetChildRows("Match_Mkt")) //{ // TreeNode tn_market = new TreeNode(drmarket["bettingmarket"].ToString()); // tn_market.Name = drmarket["id"].ToString() + "," + drmarket["matchid"].ToString() + "," + drmarket["bettinglink"].ToString() + "," + Convert.ToString(drSport["sportid"]); // tn_match.Nodes.Add(tn_market); //} } } } } if (InvokeRequired) { Action a = () => { treeView1.Nodes.Add(tn_group); }; BeginInvoke(a); } } //treeView1.Nodes.Add(tn_group); }
private void notarchivedToolStripMenuItem_Click(object sender, EventArgs e) { CrawlAllMarkets crawl = new CrawlAllMarkets(); crawl.CrawlBettingLinksByCoupon(false); }
private void crawlerToolStripMenuItem_Click(object sender, EventArgs e) { // Start Crawling. // time = new System.Threading.Timer(startcrawling()); //BackCrawler.GetCrawler d = new GetCrawler(); //d.startCrawling(); // foreach (ToolStripMenuItem item in startCrawlingToolStripMenuItem.DropDown.Items) // { // item.Text = (sender as ToolStripMenuItem).Text; if (IsCrawlProcessRunning == true) { SetProgress(false); IsCrawlProcessRunning = false; } SetProgress(true); IsCrawlProcessRunning = true; CrawlFirstPage crawldata = new CrawlFirstPage(); if ((sender as ToolStripMenuItem).Text == "League") { DataTable dt = crawldata.GetSports("2"); string link = dt.Rows[0]["link"].ToString(); int sportid = Convert.ToInt32(dt.Rows[0]["sportid"].ToString()); if (sportid == 2) { crawldata.CrawlLeagues(link); } } else if ((sender as ToolStripMenuItem).Text == "WorldMarket") { DataTable dt = crawldata.GetSports("2"); string link = dt.Rows[0]["link"].ToString(); int sportid = Convert.ToInt32(dt.Rows[0]["sportid"].ToString()); if (sportid == 2) { crawldata.CrawlWorldMarkets(); } } else if ((sender as ToolStripMenuItem).Text == "Soccer") { DataTable dt = crawldata.GetSports((sender as ToolStripMenuItem).Name.ToString()); string link = dt.Rows[0]["link"].ToString(); int sportid = Convert.ToInt32(dt.Rows[0]["sportid"].ToString()); // soocer // crawldata.CrawlLeagues(link); // crawldata.CrawlWorldMarkets(); DataSet ds = crawldata.GetLeague(); for (int j = 0; j < ds.Tables[0].Rows.Count; j++) { string matchlink = Convert.ToString(ds.Tables[0].Rows[j]["link"]); int sport_id = Convert.ToInt32(ds.Tables[0].Rows[j]["sportid"]); long leagueid = Convert.ToInt32(ds.Tables[0].Rows[j]["leagueid"]); ThreadParameters t = new ThreadParameters(); t.URL = matchlink; t.SportID = sport_id; t.LeagueID = leagueid; crawldata.CrawlMyPage(t); } } else if ((sender as ToolStripMenuItem).Text == "GaaFootball") { DataTable dt = crawldata.GetSports((sender as ToolStripMenuItem).Name.ToString()); string link = dt.Rows[0]["link"].ToString(); int sportid = Convert.ToInt32(dt.Rows[0]["sportid"].ToString()); // GAA Football ThreadParameters tp = new ThreadParameters(); tp.URL = link; tp.SportID = sportid; if (sportid == 12) { crawldata.CrawlMyPage(tp); } } else if ((sender as ToolStripMenuItem).Text == "GaaHurling") { DataTable dt = crawldata.GetSports((sender as ToolStripMenuItem).Name.ToString()); string link = dt.Rows[0]["link"].ToString(); int sportid = Convert.ToInt32(dt.Rows[0]["sportid"].ToString()); ThreadParameters tp = new ThreadParameters(); tp.URL = link; tp.SportID = sportid; // GAA Hurling. if (sportid == 28) { crawldata.CrawlMyPage(tp); } } else if ((sender as ToolStripMenuItem).Text == "Golf") { DataTable dt = crawldata.GetSports((sender as ToolStripMenuItem).Name.ToString()); string link = dt.Rows[0]["link"].ToString(); int sportid = Convert.ToInt32(dt.Rows[0]["sportid"].ToString()); // Golf if (sportid == 29) { crawldata.CrawlGolfTurnament(link, sportid.ToString()); } } else if ((sender as ToolStripMenuItem).Text == "GolfMarketName") { crawldata.CrawlGolfBettingMarketName(); } else if ((sender as ToolStripMenuItem).Text == "GolfMarkets") { crawldata.CrawlGolfBettingMarket(); } else if ((sender as ToolStripMenuItem).Text == "BettingMarket") { CrawlAllMarkets crawl = new CrawlAllMarkets(); crawl.CrawlBettingLinks(); } else if ((sender as ToolStripMenuItem).Text == "MarketResult") { crawldata.CrawlEachMatchResult(); } // Thread d = new Thread(); SetProgress(false); IsCrawlProcessRunning = false; // } }