public ImportStat ImportGameTeams() { string table = "GameTeams"; var iStat = new ImportStat(_logger, table); if (_seed && _context.GameTeams.Count() == 0) { _logger.Write("Importing " + table); dynamic parsedJson = _jsonFileService.ParseObjectFromJsonFile(_folderPath + "Games.json"); int count = parsedJson.Count; _logger.Write("ImportGameTeams: Access records to process:" + count); int countSaveOrUpdated = 0; for (var d = 0; d < parsedJson.Count; d++) { if (d % 100 == 0) { _logger.Write("ImportGameTeams: Access records processed:" + d); } var json = parsedJson[d]; int gameId = json["GAME_ID"]; int seasonId = json["SEASON_ID"]; int homeTeamId, awayTeamId; homeTeamId = json["HOME_TEAM_ID"]; awayTeamId = json["AWAY_TEAM_ID"]; // FK check //_lo30ContextService.FindGame(gameId, errorIfNotFound: true, errorIfMoreThanOneFound: true, populateFully: false); //_lo30ContextService.FindTeam(homeTeamId, errorIfNotFound: true, errorIfMoreThanOneFound: true, populateFully: false); //_lo30ContextService.FindTeam(awayTeamId, errorIfNotFound: true, errorIfMoreThanOneFound: true, populateFully: false); var gameTeam = new GameTeam(sid: seasonId, gid: gameId, ht: true, tid: homeTeamId, otid: awayTeamId); countSaveOrUpdated = countSaveOrUpdated + _lo30ContextService.SaveOrUpdateGameTeam(gameTeam); gameTeam = new GameTeam(sid: seasonId, gid: gameId, ht: false, tid: awayTeamId, otid: homeTeamId); countSaveOrUpdated = countSaveOrUpdated + _lo30ContextService.SaveOrUpdateGameTeam(gameTeam); } iStat.Imported(); ContextSaveChanges(); iStat.Saved(_context.GameTeams.Count()); } else { _logger.Write(table + " records exist in context; not importing"); iStat.Imported(); iStat.Saved(0); } iStat.Log(); return iStat; }
public GameTeam GetGameTeamByGameIdAndHomeTeam(int gameId, bool homeTeam) { var results = new GameTeam(); using (var context = new LO30Context()) { results = context.GameTeams .Where(x => x.GameId == gameId && x.HomeTeam == homeTeam) .IncludeAll() .FirstOrDefault(); } return results; }
public GameTeam GetGameTeamByGameAndTeamId(int gameId, int teamId) { var results = new GameTeam(); using (var context = new LO30Context()) { results = context.GameTeams .Where(x=>x.GameId == gameId && x.TeamId == teamId) .IncludeAll() .FirstOrDefault(); } return results; }