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 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);
}
}