public void LoadFolder() { DirectoryInfo directory = new DirectoryInfo(LeagueDir); FileInfo[] fileInfos = directory.GetFiles(); DAL dal = new DAL(); List<int> originalMatchIDs = dal.GetOriginalMatchIDs(); if (fileInfos.Length > 0) { Console.WriteLine(LeagueName + ": Start..."); foreach (FileInfo file in fileInfos) { if (file.Length < Globe.IncorrectFileSize) continue; string fileName = Path.GetFileNameWithoutExtension(file.FullName); if (fileName.Equals("LiveScores") || originalMatchIDs.Contains(int.Parse(fileName))) continue; string htmlContent = Globe.LoadFile(file.FullName); ContentFilter filter = new ContentFilter(); MatchInfo matchInfo = filter.GetMatchInfo(int.Parse(fileName), LeagueName, htmlContent); InsertData(matchInfo); } } }
private void InsertData(MatchInfo matchInfo) { DAL dal = new DAL(); dal.InsertMatchInformation(matchInfo); dal.InsertTeamStatistics(matchInfo.HomeTeamStatistics, matchInfo.League, matchInfo.id, true); dal.InsertTeamStatistics(matchInfo.AwayTeamStatistics, matchInfo.League, matchInfo.id, false); foreach (PlayerStatistics player in matchInfo.HomeTeamPlayerStatistics) { dal.InsertPlayerStatistics(player, matchInfo.HomeTeamStatistics.id, matchInfo.HomeTeamStatistics.name, matchInfo.League, matchInfo.id, true); } foreach (PlayerStatistics player in matchInfo.AwayTeamPlayerStatistics) { dal.InsertPlayerStatistics(player, matchInfo.AwayTeamStatistics.id, matchInfo.AwayTeamStatistics.name, matchInfo.League, matchInfo.id, false); } }