コード例 #1
0
 public override void MigrateFixtures(int seriesId, int season)
 {
     var seriesFixturesResult = new List<SeriesFixturesSummaryEntity>();
     seriesFixturesResult = GetSeriesFixtures(season, seriesId);
     var dbService = new WhoScoredRepository();
     dbService.SaveSeriesFixtures(seriesFixturesResult);
 }
コード例 #2
0
        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);
        }
コード例 #3
0
        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);
        }
コード例 #4
0
        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);
        }
コード例 #5
0
        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);
        }
コード例 #6
0
        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);
        }
コード例 #7
0
        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();
        }
コード例 #8
0
        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);
        }
コード例 #9
0
        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);
        }
コード例 #10
0
        public override void MigrateWorldDetails()
        {
            var worldDetailsList = this.ReadWorldDetails();

            var dbService = new WhoScoredRepository();
            dbService.SaveWorldDetails(worldDetailsList);
        }