public override void MigrateFixtures(int seriesId, int season) { var seriesFixturesResult = new List<SeriesFixturesSummaryEntity>(); seriesFixturesResult = GetSeriesFixtures(season, seriesId); var dbService = new WhoScoredRepository(); dbService.SaveSeriesFixtures(seriesFixturesResult); }
public void MigrateLeagueDetailsTest_FromXmlToDb() { string strFile = "leaguedetails.xml"; string response = GetXmlString(strFile); var leagueDetailsInput = CHPP.LeagueDetails.Serializer.HattrickData.Deserialize(response); IWhoScoredRepository repository = new WhoScoredRepository(); repository.SaveSeriesDetails(leagueDetailsInput); Thread.Sleep(1000); var worldDetailsCount = repository.GetSeriesDetails<CHPP.LeagueDetails.Serializer.HattrickData>().Count; repository.DropSeriesDetails(); Assert.AreEqual(1, worldDetailsCount); }
public void GetWorldDetailTest_LoadOneWordlDetailFromDB() { string strFile = "worlddetails.xml"; string response = GetXmlString(strFile); var worldDetailsInput = HattrickData.Deserialize(response); IWhoScoredRepository repository = new WhoScoredRepository(); repository.SaveWorldDetails(worldDetailsInput.LeagueList.First().League.ToList()); Thread.Sleep(1000); var countryDetails = repository.GetWorldDetails<HattrickDataLeagueListLeague>(66); repository.DropWorldDetails(); Assert.AreEqual(worldDetailsInput.LeagueList.First().League.Where(l => l.LeagueID == 66).First().LeagueName, countryDetails.LeagueName); }
public void MigrateLeagueDetails(List<int> seriesIdList) { var seriesDetails = new List<LeagueDetails>(); foreach (int seriesId in seriesIdList) { var leagueDetailsRaw = new CHPP.Files.HattrickFileAccessors. LeagueDetails(ProtectedResourceUrl) { LeagueLevelUnitID = seriesId }; var request = new WhoScoredRequest(); string response = request.MakeRequest(leagueDetailsRaw.GetHattrickFileAccessorAbsoluteUri()); seriesDetails.Add(LeagueDetails.Deserialize(response)); } var dbService = new WhoScoredRepository(); dbService.SaveSeriesDetails(seriesDetails); }
public override void MigrateMatchDetails(int matchId, int matchRound, int season, int leagueId) { var matchDetailsRaw = new MatchDetails(ProtectedResourceUrl) { MatchID = matchId, MatchEvents = true }; var request = new WhoScoredRequest(); string response = request.MakeRequest(matchDetailsRaw.GetHattrickFileAccessorAbsoluteUri()); var matchDetails = CHPP.MatchDetails.Serializer.HattrickData.Deserialize(response); matchDetails.Match.First().MatchSeason = season.ToString(); matchDetails.Match.First().LeagueLevelUnitID = leagueId.ToString(); matchDetails.Match.First().MatchRound = matchRound; var dbSevice = new WhoScoredRepository(); dbSevice.SaveMatchDetails(matchDetails.Match); }
public void MigrateMatchDetailsTest_FromXmlToDb() { string strFile = "matchdetails.xml"; string response = GetXmlString(strFile); var matchDetailsInput = CHPP.MatchDetails.Serializer.HattrickData.Deserialize(response).Match.First(); IWhoScoredRepository repository = new WhoScoredRepository(); repository.SaveMatchDetails(matchDetailsInput); Thread.Sleep(1000); var matchDetails = repository.GetMatchDetails<MatchDetails>(); repository.DropSeriesFixtures(); Assert.AreEqual(1, matchDetails.Count); }
public void UpdateWorldDetailsTest_FromXmlToDb() { string strFile = "worlddetails.xml"; string response = GetXmlString(strFile); var worldDetailsInput = HattrickData.Deserialize(response); IWhoScoredRepository repository = new WhoScoredRepository(); repository.SaveWorldDetails(worldDetailsInput.LeagueList.First().League.ToList()); Thread.Sleep(1000); var worldDetails = repository.GetWorldDetails<CountryDetails>(); int newNumberOfLevels = 100; string newEnglishName = "newEnglishName"; string newLeagueName = "newLeagueName"; var lithData = worldDetails.Where(w => w.EnglishName == "Lithuania").First(); lithData.NumberOfLevels = newNumberOfLevels; lithData.LeagueName = newLeagueName; lithData.EnglishName = newEnglishName; repository.SaveWorldDetails(lithData); worldDetails = repository.GetWorldDetails<CountryDetails>(); lithData = worldDetails.Where(w => w.EnglishName == newEnglishName).First(); Assert.AreEqual(lithData.EnglishName, newEnglishName); Assert.AreEqual(lithData.LeagueName, newLeagueName); Assert.AreEqual(lithData.NumberOfLevels, newNumberOfLevels); repository.DropWorldDetails(); }
public void MigrateWorldDetailsTest_FromXmlToDb() { string strFile = "worlddetails.xml"; string response = GetXmlString(strFile); var worldDetailsInput = HattrickData.Deserialize(response); IWhoScoredRepository repository = new WhoScoredRepository(); repository.SaveWorldDetails(worldDetailsInput.LeagueList.First().League.ToList()); Thread.Sleep(1000); var worldDetailsCount = repository.GetWorldDetails<HattrickDataLeagueListLeague>().Count; repository.DropWorldDetails(); Assert.AreEqual(worldDetailsInput.LeagueList.First().League.Count, worldDetailsCount); }
public void MigrateSeriesFixturesTest_FromXmlToDb() { string strFile = "seriesfixtures.xml"; string response = GetXmlString(strFile); var seriesFixturesInput = CHPP.SeriesFixtures.Serializer.HattrickData.Deserialize(response); IWhoScoredRepository repository = new WhoScoredRepository(); var entity = MigrationDomainService.GetSeriesFixtureEntity(seriesFixturesInput); repository.SaveSeriesFixtures(entity); Thread.Sleep(1000); var fixturesCount = repository.GetSeriesFixturesSummary<SeriesFixturesSummaryEntity>().Count; repository.DropSeriesFixtures(); Assert.AreEqual(1, fixturesCount); }
public override void MigrateWorldDetails() { var worldDetailsList = this.ReadWorldDetails(); var dbService = new WhoScoredRepository(); dbService.SaveWorldDetails(worldDetailsList); }