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);
}
