//read csv files
//split lines with ',' , put attributes in array
public static List <GameResult> ReadSoccerResults(string fileName)
{
List <GameResult> soccerResults = new List <GameResult>();
string line = "";
using (var reader = new StreamReader(fileName))
{
reader.ReadLine();
while ((line = reader.ReadLine()) != null)
{
var gameResult = new GameResult();
string[] values = line.Split(',');
//parse game date, team name,HomeOrAway, Goals, GoalAttempts, ShotsOnGoal, ShotsOffGoal, PosessionPercent
DateTime gameDate;
if (DateTime.TryParse(values[0], out gameDate))
{
gameResult.GameDate = gameDate;
}
gameResult.TeamName = values[1];
HomeOrAway homeOrAway;
if (Enum.TryParse(values[2], out homeOrAway))
{
gameResult.HomeOrAway = homeOrAway;
}
int parseInt;
if (int.TryParse(values[3], out parseInt))
{
gameResult.Goals = parseInt;
}
if (int.TryParse(values[4], out parseInt))
{
gameResult.GoalAttempts = parseInt;
}
if (int.TryParse(values[5], out parseInt))
{
gameResult.ShotOnGoal = parseInt;
}
if (int.TryParse(values[6], out parseInt))
{
gameResult.ShotOffGoal = parseInt;
}
double possessionPercent;
if (double.TryParse(values[7], out possessionPercent))
{
gameResult.PosessionPercent = possessionPercent;
}
soccerResults.Add(gameResult);
}
}
return(soccerResults);
}
public static List <GameResult> ReadSoccerResults(string fileName)
{
var soccerResults = new List <GameResult>();
using (var reader = new StreamReader(fileName))
{
string line = "";
reader.ReadLine();
while ((line = reader.ReadLine()) != null)
{
//read the .csv line by line until end
var gameResult = new GameResult();
string[] values = line.Split(',');
//get the date and time of the game
DateTime gameDate;
if (DateTime.TryParse(values[0], out gameDate))
{
gameResult.GameDate = gameDate;
}
//get the team name as a string
gameResult.TeamName = values[1];
//get enum value for home or away game
HomeOrAway homeOrAway;
if (Enum.TryParse(values[2], out homeOrAway))
{
gameResult.HomeOrAway = homeOrAway;
}
//get ints from .csv
int ParseInt;
if (int.TryParse(values[3], out ParseInt))
{
gameResult.Goals = ParseInt;
}
if (int.TryParse(values[4], out ParseInt))
{
gameResult.GoalAttempts = ParseInt;
}
if (int.TryParse(values[5], out ParseInt))
{
gameResult.ShotsOnGoal = ParseInt;
}
if (int.TryParse(values[6], out ParseInt))
{
gameResult.ShotsOffGoals = ParseInt;
}
//get percentage as a double
double possessionPercent;
if (double.TryParse(values[7], out possessionPercent))
{
gameResult.PossessionPercent = possessionPercent;
}
soccerResults.Add(gameResult);
}
}
return(soccerResults);
}