public List <FootballDataModel> ParseCsv(string fileName, string season) { var results = new List <FootballDataModel>(); using (CsvReader csv = new CsvReader(new StreamReader(fileName), true)) { int fieldCount = csv.FieldCount; string[] headers = csv.GetFieldHeaders(); while (csv.ReadNextRecord()) { try { var match = new FootballDataModel(); for (int i = 0; i < fieldCount; i++) { string csvValue = string.Empty; try { csvValue = csv[i]; } catch (Exception ex) { //file doesn't contain information of other fields break; } if (!match.SetProperty(headers[i], csvValue)) { if (!string.IsNullOrEmpty(csvValue)) { string obj = string.Format("[header '{0}'] = [value '{1}'];", headers[i], csvValue); Console.Write(string.Format("Couldn't set property (possible error). {0}", obj)); logRepo.WriteLog(Database.SystemData.Severity.Warning, "Couldn't parse csv " + obj, nameof(FootballDataCSVParser), "localhost", "", ""); } } } results.Add(match); } catch (Exception ex) { logRepo.WriteExceptionLog(ex, nameof(FootballDataCSVParser)); } } } return(results); }
private void SaveFootballDataModelToDb(FootballDataModel match, ref int processedGames) { bool onlyCreated; var leagueSeason = leagueDataRepo.CreateAndSaveLeagueSeason(_startYear, leagueDataRepo.GetLaLiga()); var homeTeam = leagueDataRepo.GetFootballTeam(match.HomeTeam, leagueSeason, "FootballData"); var awayTeam = leagueDataRepo.GetFootballTeam(match.AwayTeam, leagueSeason, "FootballData"); Game matchDb = null; try { matchDb = leagueDataRepo.GetGame(homeTeam, awayTeam, match.MatchDate, leagueSeason, out onlyCreated); } catch (Exception ex) { return; } if (onlyCreated || matchDb.Result == 0) //update game record { //Console.WriteLine("Game record only created - will be processed"); matchDb.AwayTeamGoals = match.FullTimeAwayTeamGoals; matchDb.HomeTeamGoals = match.FullTimeHomeTeamGoals; if (matchDb.HomeTeamGoals > matchDb.AwayTeamGoals) { matchDb.Result = GameResult.HomeWin; } else if (matchDb.HomeTeamGoals < matchDb.AwayTeamGoals) { matchDb.Result = GameResult.AwayWin; } else { matchDb.Result = GameResult.Draw; } leagueDataRepo.UpdateGameRecord(matchDb); processedGames++; } var matchStats = leagueDataRepo.GetGameStats(matchDb.GameId, out onlyCreated); if (onlyCreated) //update game stats { matchStats.Game = matchDb; matchStats.HalfTimeHomeGoals = match.HalfTimeHomeTeamGoals; matchStats.HalfTimeAwayGoals = match.HalfTimeAwayTeamGoals; if (matchStats.HalfTimeHomeGoals > matchStats.HalfTimeAwayGoals) { matchStats.HalfTimeResult = GameResult.HomeWin; } else if (matchStats.HalfTimeHomeGoals < matchStats.HalfTimeAwayGoals) { matchStats.HalfTimeResult = GameResult.AwayWin; } else { matchStats.HalfTimeResult = GameResult.Draw; } matchStats.HomeTeamShots = match.HomeTeamShots; matchStats.AwayTeamShots = match.AwayTeamShots; matchStats.HomeTeamTargetShots = match.HomeTeamShotsOnTarget; matchStats.AwayTeamTargetShots = match.AwayTeamShotsOnTarget; matchStats.HomeTeamFouls = match.HomeTeamFouls; matchStats.AwayTeamFouls = match.AwayTeamFouls; matchStats.HomeTeamCorners = match.HomeTeamCorners; matchStats.AwayTeamCorners = match.AwayTeamCorners; matchStats.HomeTeamYCards = match.HomeTeamYellowCards; matchStats.AwayTeamYCards = match.AwayTeamYellowCards; matchStats.HomeTeamRedCards = match.HomeTeamRedCards; matchStats.AwayTeamRedCards = match.AwayTeamRedCards; matchStats.HomeTeamOffsides = match.HomeTeamOffsides; matchStats.AwayTeamOffsides = match.AwayTeamOffsides; leagueDataRepo.UpdateGameStats(matchStats); } var bookmaker = bookmakerRepo.GetBookmaker("Bet365"); var bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.B365_HomeWin; bookmakerOdd.DrawCoef = match.B365_Draw; bookmakerOdd.AwayWinCoef = match.B365_AwayWin; bookmakerOdd.Total2_5Over = match.B365_TotalMore2_5; bookmakerOdd.Total2_5Under = match.B365_TotalLess2_5; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("Blue Square"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.BS_HomeWin; bookmakerOdd.DrawCoef = match.BS_Draw; bookmakerOdd.AwayWinCoef = match.BS_AwayWin; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("Bet&Win"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.BW_HomeWin; bookmakerOdd.DrawCoef = match.BW_Draw; bookmakerOdd.AwayWinCoef = match.BW_AwayWin; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("Gamebookers"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.GB_HomeWin; bookmakerOdd.DrawCoef = match.GB_Draw; bookmakerOdd.AwayWinCoef = match.GB_AwayWin; bookmakerOdd.Total2_5Over = match.GB_TotalMore2_5; bookmakerOdd.Total2_5Under = match.GB_TotalLess2_5; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("Interwetten"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.IW_HomeWin; bookmakerOdd.DrawCoef = match.IW_Draw; bookmakerOdd.AwayWinCoef = match.IW_AwayWin; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("Pinnacle"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.Pinnacle_HomeWin; bookmakerOdd.DrawCoef = match.Pinnacle_Draw; bookmakerOdd.AwayWinCoef = match.Pinnacle_AwayWin; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("Sporting Odds"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.SO_HomeWin; bookmakerOdd.DrawCoef = match.SO_Draw; bookmakerOdd.AwayWinCoef = match.SO_AwayWin; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("Sportingbet"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.SB_HomeWin; bookmakerOdd.DrawCoef = match.SB_Draw; bookmakerOdd.AwayWinCoef = match.SB_AwayWin; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("Stan James"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.SJ_HomeWin; bookmakerOdd.DrawCoef = match.SJ_Draw; bookmakerOdd.AwayWinCoef = match.SJ_AwayWin; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("Stanleybet"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.Stanleybet_HomeWin; bookmakerOdd.DrawCoef = match.Stanleybet_Draw; bookmakerOdd.AwayWinCoef = match.Stanleybet_AwayWin; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("VC"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.VC_HomeWin; bookmakerOdd.DrawCoef = match.VC_Draw; bookmakerOdd.AwayWinCoef = match.VC_AwayWin; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("William Hill"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.HomeWinCoef = match.WH_HomeWin; bookmakerOdd.DrawCoef = match.WH_Draw; bookmakerOdd.AwayWinCoef = match.WH_AwayWin; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("Total average odds"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.Total2_5Over = match.Average_TotalMore2_5; bookmakerOdd.Total2_5Under = match.Average_TotalLess2_5; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } bookmaker = bookmakerRepo.GetBookmaker("Total maximal odds"); bookmakerOdd = bookmakerRepo.GetBookmakerOdds(matchDb.GameId, bookmaker.BookmakerId, out onlyCreated); if (onlyCreated) //update game record { bookmakerOdd.Total2_5Over = match.Max_TotalMore2_5; bookmakerOdd.Total2_5Under = match.Max_TotalLess2_5; bookmakerRepo.UpdateBookmakerOdds(bookmakerOdd); } }