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 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 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 override void MigrateWorldDetails()
{
var worldDetailsList = this.ReadWorldDetails();
var dbService = new WhoScoredRepository();
dbService.SaveWorldDetails(worldDetailsList);
}
