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 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 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 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 LoadTreeViewForGaelic(string sport) { int id = Convert.ToInt32(sport.Substring(1)); 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 BindMasterMarket(int sportid) { CrawlAllMarkets crawl = new CrawlAllMarkets(); cmbMasterMarketName.DataSource = crawl.GetMasterMarketName(sportid); cmbMasterMarketName.DisplayMember = "ResultName"; cmbMasterMarketName.ValueMember = "ResultLink"; }
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; // } }
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 MatchResult(string[] result, string matchid) { CrawlEachMarketData crawl = new CrawlEachMarketData(); int sportid = crawl.GetSportID(Convert.ToInt32(matchid)); CrawlAllMarkets crawls=new CrawlAllMarkets(); DataTable dt = new DataTable(); dt = crawls.GetMatchResult(Convert.ToInt32(matchid),sportid); Dictionary<string, string> data = new Dictionary<string, string>(); if (dt.Rows.Count > 0) { for(int i=0;i<dt.Rows.Count;i++) { DataRow row=dt.Rows[i]; if (row[0].ToString() == "Winner") { string[] score = result[1].Split('-'); if (Convert.ToInt32(score[0]) > Convert.ToInt32(score[1])) dt.Rows[i][1] = "Home"; else if (Convert.ToInt32(score[0]) < Convert.ToInt32(score[1])) dt.Rows[i][1] = "Away"; else dt.Rows[i][1] = "Draw"; } else if (row[0].ToString() == "HalfTime") dt.Rows[i][1] =((result[2].Substring(result[2].IndexOf('-') - 1, 1)) + "-" + (result[2].Substring(result[2].IndexOf('-') + 1, 1))); else if (row[0].ToString() == "BothTeamToScore") { string[] scorefull = result[1].Split('-'); string full; if (Convert.ToInt32(scorefull[0]) > 0 & Convert.ToInt32(scorefull[1]) > 0) dt.Rows[i][1] = "YES"; else dt.Rows[i][1] = "NO"; } else if (row[0].ToString() == "HalfTimeFullTimeWinner") { string[] scorefull = result[1].Split('-'); string full; string[] scorehalf = ((result[2].Substring(result[2].IndexOf('-') - 1, 1)) + "-" + (result[2].Substring(result[2].IndexOf('-') + 1, 1))).Split('-'); string half = ""; if (Convert.ToInt32(scorehalf[0]) > Convert.ToInt32(scorehalf[1])) half = "Home"; else if (Convert.ToInt32(scorehalf[0]) < Convert.ToInt32(scorehalf[1])) half = "Away"; else half = "Draw"; if (Convert.ToInt32(scorefull[0]) > Convert.ToInt32(scorefull[1])) full = "Home"; else if (Convert.ToInt32(scorefull[0]) < Convert.ToInt32(scorefull[1])) full = "Away"; else full = "Draw"; dt.Rows[i][1]= half + "/" + full; } else if (row[0].ToString() == "CorrectScore") { dt.Rows[i][1]= result[2].Substring(0, result[2].IndexOf('-') - 1) + " " + result[1] + " " + result[2].Substring(result[2].IndexOf('-') + 2, result[2].Length - result[2].Substring(0, result[2].IndexOf('-') + 1).Length); } else if (row[0].ToString() == "HalfTimeScore") { dt.Rows[i][1] =((result[2].Substring(result[2].IndexOf('-') - 1, 1)) + "-" + (result[2].Substring(result[2].IndexOf('-') + 1, 1))); } else if (row[0].ToString() == "Handicaps") { dt.Rows[i][1] = ""; } else if (row[0].ToString() == "AlternativeHandicaps") { dt.Rows[i][1] = ""; } else if (row[0].ToString() == "MatchResultAndBoth") { string[] scorefull = result[1].Split('-'); string full; if (Convert.ToInt32(scorefull[0]) > 0 & Convert.ToInt32(scorefull[1]) > 0) dt.Rows[i][1] = "YES" +" "+result[1]; else dt.Rows[i][1] = "NO" + " " + result[1]; } else if (row[0].ToString() == "DoubleChanceWinner") { string[] scorefull = result[1].Split('-'); string full; if (Convert.ToInt32(scorefull[0]) ==Convert.ToInt32(scorefull[1])) dt.Rows[i][1] = "Home or Draw, Away or Draw"; else if(Convert.ToInt32(scorefull[0]) >Convert.ToInt32(scorefull[1])) dt.Rows[i][1] = "Home or Away, Home or Draw"; else if (Convert.ToInt32(scorefull[0]) < Convert.ToInt32(scorefull[1])) dt.Rows[i][1] = "Home or Away , Away or Draw"; } else if (row[0].ToString() == "DoubleChanceBeaten") { string[] scorefull = result[1].Split('-'); string full; if (Convert.ToInt32(scorefull[0]) == Convert.ToInt32(scorefull[1])) dt.Rows[i][1] = "Home or Away"; else if (Convert.ToInt32(scorefull[0]) > Convert.ToInt32(scorefull[1])) dt.Rows[i][1] = "Away or Draw"; else if (Convert.ToInt32(scorefull[0]) < Convert.ToInt32(scorefull[1])) dt.Rows[i][1] = "Home or Draw"; } else if (row[0].ToString() == "TeamToScoreFirst") { string hgt = result[8].Substring(result[8].IndexOf("mins") - 3, 2) + ""; string agt = result[10].Substring(result[10].IndexOf("mins") - 3, 2) + ""; if (Convert.ToInt32(hgt) < Convert.ToInt32(agt)) dt.Rows[i][1] = "Home"; else if (Convert.ToInt32(hgt) < Convert.ToInt32(agt)) dt.Rows[i][1] = "Away"; else dt.Rows[i][1] = "Both"; } else if (row[0].ToString() == "ToWinBothHalves") { string[] hscore =((result[2].Substring(result[2].IndexOf('-') - 1, 1)) + "-" + (result[2].Substring(result[2].IndexOf('-') + 1, 1))).Split('-'); string[] score = result[1].Split('-'); if (Convert.ToInt32(score[0]) > Convert.ToInt32(score[1]) && Convert.ToInt32(hscore[0]) > Convert.ToInt32(hscore[1])) dt.Rows[i][1] = "Home"; else if (Convert.ToInt32(score[0]) < Convert.ToInt32(score[1]) && Convert.ToInt32(hscore[0]) < Convert.ToInt32(hscore[1])) dt.Rows[i][1] = "Away"; else dt.Rows[i][1] = "Nither"; } else if (row[0].ToString() == "ToWinEitherHalf") { string[] hscore =((result[2].Substring(result[2].IndexOf('-') - 1, 1)) + "-" + (result[2].Substring(result[2].IndexOf('-') + 1, 1))).Split('-'); string[] score = result[1].Split('-'); if (Convert.ToInt32(hscore[0]) > Convert.ToInt32(hscore[1])) dt.Rows[i][1] = "Home"; else if (Convert.ToInt32(hscore[0]) > Convert.ToInt32(hscore[1])) dt.Rows[i][1] = "Away"; else dt.Rows[i][1] = "Draw"; if (Convert.ToInt32(score[0]) > Convert.ToInt32(score[1])) dt.Rows[i][1] += "Home"; else if (Convert.ToInt32(score[0]) < Convert.ToInt32(score[1])) dt.Rows[i][1] += "Away"; else dt.Rows[i][1] += "Draw"; } else if (row[0].ToString() == "ToWinFormBehind") { string[] hscore =((result[2].Substring(result[2].IndexOf('-') - 1, 1)) + "-" + (result[2].Substring(result[2].IndexOf('-') + 1, 1))).Split('-'); string[] score = result[1].Split('-'); if (Convert.ToInt32(hscore[0]) < Convert.ToInt32(hscore[1]) && Convert.ToInt32(score[0]) > Convert.ToInt32(score[1])) dt.Rows[i][1] = "Home"; else if(Convert.ToInt32(hscore[0]) > Convert.ToInt32(hscore[1]) && Convert.ToInt32(score[0]) < Convert.ToInt32(score[1])) dt.Rows[i][1] = "Away"; else dt.Rows[i][1] = "Nither"; } else if (row[0].ToString() == "TimeOfFirstGoal") { dt.Rows[i][1] = result[6]; } else if (row[0].ToString() == "TimeofLastGoal") { dt.Rows[i][1] = result[7]; } else if (row[0].ToString() == "ExactTotalGoal") { dt.Rows[i][1] = ""; } else if (row[0].ToString() == "ToScoreFirstAndNotWin") { string[] score = result[1].Split('-'); string hgt = result[8].Substring(result[8].IndexOf("mins") - 3, 2) + ""; string agt = result[10].Substring(result[10].IndexOf("mins") - 3, 2) + ""; if (Convert.ToInt32(hgt) < Convert.ToInt32(agt)) { if(Convert.ToInt32(score[0])<Convert.ToInt32(score[1])) dt.Rows[i][1] = "Home"; } else if (Convert.ToInt32(hgt) < Convert.ToInt32(agt)) { if (Convert.ToInt32(score[0]) > Convert.ToInt32(score[1])) dt.Rows[i][1] = "Away"; } if (dt.Rows[i][1].ToString() == "") dt.Rows[i][1] = "No One"; } else if (row[0].ToString() == "FirstGoalScorer") { dt.Rows[i][1] = result[3]; } else if (row[0].ToString() == "LastGoalScorer") { dt.Rows[i][1] = result[4]; } else if (row[0].ToString() == "AnyTimeGoalScorer") { dt.Rows[i][1] = ""; } else if (row[0].ToString() == "ToScoreToOrMoreGoales") { dt.Rows[i][1] = ""; } else if (row[0].ToString() == "ToScoreHatTrick") { dt.Rows[i][1] = ""; } else if (row[0].ToString() == "TotalScore") { dt.Rows[i][1] = result[1]; } else if (row[0].ToString() == "OverUnder0.5") { string[] score = result[1].ToString().Trim(' ').Split('-'); int total = Convert.ToInt32(score[0]) + Convert.ToInt32(score[1]); if (total >= 1) dt.Rows[i][1] = "Winner"; else dt.Rows[i][1] = "Beaten"; } else if (row[0].ToString() == "OverUnder1.5") { string[] score = result[1].Trim(' ').Split('-'); int total = Convert.ToInt32(score[0]) + Convert.ToInt32(score[1]); if (total >= 2) dt.Rows[i][1] = "Winner"; else dt.Rows[i][1] = "Beaten"; } else if (row[0].ToString() == "OverUnder2.5") { string[] score = result[1].Trim(' ').Split('-'); int total = Convert.ToInt32(score[0]) + Convert.ToInt32(score[1]); if (total >= 3) dt.Rows[i][1] = "Winner"; else dt.Rows[i][1] = "Beaten"; } else if (row[0].ToString() == "OverUnder3.5") { string[] score = result[1].Trim(' ').Split('-'); int total = Convert.ToInt32(score[0]) + Convert.ToInt32(score[1]); if (total >= 4) dt.Rows[i][1] = "Winner"; else dt.Rows[i][1] = "Beaten"; } else if (row[0].ToString() == "OverUnder4.5") { string[] score = result[1].Trim(' ').Split('-'); int total = Convert.ToInt32(score[0]) + Convert.ToInt32(score[1]); if (total >= 5) dt.Rows[i][1] = "Winner"; else dt.Rows[i][1] = "Beaten"; } else if (row[0].ToString() == "") { } } // Update to database CrawlAllMarketsData marketdata = new CrawlAllMarketsData(); marketdata.UpdateMarketResults(dt,Convert.ToInt32(matchid), sportid); } }
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); } }