public Game GetGamesByGameId(int gameId) { var results = new Game(); using (var context = new LO30Context()) { results = context.Games .Where(x => x.GameId == gameId) .IncludeAll() .FirstOrDefault(); } return results; }
public ImportStat ImportGames() { string table = "Games"; var iStat = new ImportStat(_logger, table); if (_seed && _context.Games.Count() == 0) { _logger.Write("Importing " + table); dynamic parsedJson = _jsonFileService.ParseObjectFromJsonFile(_folderPath + "Games.json"); int count = parsedJson.Count; _logger.Write("SaveOrUpdateGames:Access records to process:" + count); int countSaveOrUpdated = 0; for (var d = 0; d < parsedJson.Count; d++) { if (d % 100 == 0) { _logger.Write("SaveOrUpdateGames:Access records processed:" + d); } var json = parsedJson[d]; int gameId = json["GAME_ID"]; //if (gameId >= startingGameIdToProcess && gameId <= endingGameIdToProcess) //{ int seasonId = json["SEASON_ID"]; DateTime gameDate = json["GAME_DATE"]; DateTime gameTime = json["GAME_TIME"]; bool playoffGame = json["PLAYOFF_GAME_IND"]; var timeSpan = new TimeSpan(gameTime.Hour, gameTime.Minute, gameTime.Second); var gameDateTime = gameDate.Add(timeSpan); var game = new Game( sid: seasonId, gid: gameId, time: gameDateTime, loc: "not set", pfs: playoffGame ); //context.Games.Add(game); // works only if never reprocessing data countSaveOrUpdated = countSaveOrUpdated + _lo30ContextService.SaveOrUpdateGame(game); //} } iStat.Imported(); ContextSaveChanges(); iStat.Saved(_context.Games.Count()); } else { _logger.Write(table + " records exist in context; not importing"); iStat.Imported(); iStat.Saved(0); } iStat.Log(); return iStat; }