Esempio n. 1
0
        //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);
        }
Esempio n. 2
0
        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);
        }