public OddResult PickOdd(SportMatch sportMatch)
{
OddResult oddResult = new OddResult()
{
OddValue = -1, ExpectedResult = "I"
};
List <OddResult> values = new List <OddResult>()
{
new OddResult {
OddValue = sportMatch.HtOdd, ExpectedResult = "H"
},
new OddResult {
OddValue = sportMatch.DrawOdd, ExpectedResult = "D"
},
new OddResult {
OddValue = sportMatch.AtOdd, ExpectedResult = "A"
}
}.OrderBy(o => o.OddValue).ToList();
int middleIndex = (values.Count() - 1) / 2;
oddResult = values.ToArray()[middleIndex];
return(oddResult);
}
static bool IsSameMatch(SportMatch mat, Fixture fix, string league)
{
mappings.TryGetValue(league, out string dbCompetitionName);
if (mat.Competition != dbCompetitionName || mat.Date.Date != fix.date.Date)
{
return(false);
}
if (NameComparator(mat.HomeTeam, fix.homeTeamName) && NameComparator(mat.AwayTeam, fix.awayTeamName))
{
Console.WriteLine("Games are equal:{0}vs{1} || {2}vs{3}", mat.HomeTeam, mat.AwayTeam, fix.homeTeamName, fix.awayTeamName);
return(true);
}
return(false);
}
public OddResult PickOdd(SportMatch sportMatch)
{
OddResult oddResult = new OddResult()
{
OddValue = -1, ExpectedResult = "I"
};
List <OddResult> values = new List <OddResult>()
{
new OddResult {
OddValue = sportMatch.HtOdd, ExpectedResult = "H"
},
new OddResult {
OddValue = sportMatch.DrawOdd, ExpectedResult = "D"
},
new OddResult {
OddValue = sportMatch.AtOdd, ExpectedResult = "A"
}
}.OrderByDescending(o => o.OddValue).ToList();
oddResult = values.ToArray()[0];
return(oddResult);
}
private void btnOpenFile_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Csv files (*.csv)|*.csv|Text files (*.txt)|*.txt|All files (*.*)|*.*";
if (openFileDialog.ShowDialog() == true)
{
this.openFilePath.Content = openFileDialog.FileName;
this.dataGrid.ItemsSource = new List <SportMatch>();
matches = new List <SportMatch>();
using (TextReader reader = File.OpenText(openFileDialog.FileName))
{
try
{
int ID = 0;
var ci = new CultureInfo("en-GB");
var formats = new[] { "dd/MM/yy", "dd/MM/yyyy", "d/MM/yy", "d/M/yy", "dd/M/yy", }
.Union(ci.DateTimeFormat.GetAllDateTimePatterns()).ToArray();
var csv = new CsvReader(reader);
while (csv.Read())
{
try
{
ID++;
var match = new SportMatch();
string compValue;
Mappings.Competitions.TryGetValue(csv.GetField <string>("Div"), out compValue);
match.Competition = compValue ?? csv.GetField <string>("Div");
// CultureInfo.GetCultureInfo("en-GB")
match.Date = DateTime.ParseExact(csv.GetField <string>("Date"), formats, ci, DateTimeStyles.AssumeLocal);
match.Epoca = GetEpocaByDate(match.Date);
match.HomeTeam = csv.GetField <string>("HomeTeam");
match.AwayTeam = csv.GetField <string>("AwayTeam");
match.HomeTeamGoals = csv.GetField <int>("FTHG");
match.AwayTeamGoals = csv.GetField <int>("FTAG");
match.Result = csv.GetField <string>("FTR");
match.HalfHGoals = csv.GetField <int>("HTHG");
match.HalfAGoals = csv.GetField <int>("HTAG");
match.HalfTimeResult = csv.GetField <string>("HTR");
// 23, 26, 29, 32, 35, 38, 41, 44, 47,
match.HtOdd = GetHomeTeamOdd(csv);
match.DrawOdd = GetDrawOdd(csv);
match.AtOdd = GetAwayTeamOdd(csv);
match.ID = ID;
matches.Add(match);
}
catch (Exception) {}
}
this.dataGrid.ItemsSource = matches;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
