public override void MigrateLeagueDetails(int countryId) { var countryRepository = new CountryRepository(Session); var country = countryRepository.GetCountryByHtId(countryId); foreach (var series in country.SupportedSeriesId) { if (country.Series.FirstOrDefault(s => s.HtSeriesId == series.HtSeriesId) == null) { var htseries = ReadSeriesDetails(series.HtSeriesId); country.AddSeries(new Series { HtSeriesId = htseries.LeagueLevelUnitID, LeagueLevel = (short)htseries.LeagueLevel, LeagueLevelUnitName = htseries.LeagueLevelUnitName }); } } countryRepository.SaveUpdate(country); Session.Flush(); }
public void CountriesCRUDTest() { var sessionFactory = SessionFactory.CreateSessionFactory(true); const string country1 = "CountryName1"; const string country2 = "CountryName2"; var countries = new List<Country> { TestEntities.CreateCountry(10000, "EnglishName1", country1), TestEntities.CreateCountry(10001, "EnglishName2", country2) }; var session = SessionManager.CurrentSession; var repository = new CountryRepository(session); repository.SaveUpdateCountries(countries); var fromDb = repository.GetAll(); Assert.True(fromDb.ToList().Count(c => c.CountryName == country1 || c.CountryName == country2) == 2 ); var updateCountry = countries.First(); const string country3 = "CountryName3"; const string englishName3 = "EnglishName3"; updateCountry.EnglishName = englishName3; updateCountry.CountryName = country3; repository.SaveUpdate(updateCountry); var updatedCountry = repository.GetById(updateCountry.CountryId); Assert.True(updatedCountry.CountryName == updateCountry.CountryName); Assert.True(updatedCountry.EnglishName == updateCountry.EnglishName); foreach (var country in countries) { repository.Delete(country); } session.Flush(); fromDb = repository.GetAll(); Assert.True(fromDb.ToList().Count(c => c.CountryName == country1 || c.CountryName == country2) == 0); }