public void AddLanguage_ThrowsExceptionIfRowExists() { using (TransactionScope transaction = new TransactionScope()) { //Arrange CountrySqlDALTests.InsertFakeCountry("JRT", "Fake Country", "North America"); LanguageSqlDALTests.InsertFakeLanguage("JRT", "TEST LANGUAGE", true); LanguageSqlDAL testClass = new LanguageSqlDAL(connectionString); Language newLanguage = new Language(); newLanguage.CountryCode = "JRT"; newLanguage.Name = "TEST LANGUAGE"; newLanguage.IsOfficial = true; newLanguage.Percentage = 100; //Act bool output = testClass.AddNewLanguage(newLanguage); } }
public void LanguagesByCountry_OfficialLanguages() { using (TransactionScope transaction = new TransactionScope()) { // Arrange CountrySqlDALTests.InsertFakeCountry("JRT", "Joshtopia", "North America"); LanguageSqlDALTests.InsertFakeLanguage("JRT", "Official Language", true); LanguageSqlDALTests.InsertFakeLanguage("JRT", "Unofficial Languauge", false); LanguageSqlDAL testClass = new LanguageSqlDAL(connectionString); // Act List <Language> languages = testClass.GetLanguages("JRT", true); // Assert Assert.AreEqual(1, languages.Count); Assert.AreEqual("Official Language", languages[0].Name); } }
public void CitiesByCountryCode_Country_With_Cities() { // Rolls back the data when done with the test. using (TransactionScope transaction = new TransactionScope()) { //Arrange CountrySqlDALTests.InsertFakeCountry("JRT", "Joshtopia", "North America"); int cityId = CitySqlDALTests.InsertFakeCity("Joshville", "JRT"); CitySqlDAL testClass = new CitySqlDAL(connectionString); //Act List <City> cities = testClass.GetCitiesByCountryCode("JRT"); //Assert Assert.AreEqual(1, cities.Count); Assert.AreEqual("Joshville", cities[0].Name); Assert.AreEqual(cityId, cities[0].CityId); } }