private void AddNewLanguage()
{
string countryCode = CLIHelper.GetString("Enter the country code the language is for:");
bool officialOnly = CLIHelper.GetBool("Is it official only? True/False ");
int percentage = CLIHelper.GetInteger("What percentage is it spoken by?");
string name = CLIHelper.GetString("What is the name of the lanaguage?");
Language lang = new Language
{
CountryCode = countryCode,
IsOfficial = officialOnly,
Percentage = percentage,
Name = name
};
LanguageSqlDAL languageDal = new LanguageSqlDAL(DatabaseConnectionString);
bool result = languageDal.AddNewLanguage(lang);
if (result)
{
Console.WriteLine("Success!");
}
else
{
Console.WriteLine("The new language was not inserted");
}
}
public void AddNewLanguageTest()
{
//Arrange
LanguageSqlDAL languageDal = new LanguageSqlDAL(connectionString);
Language language = new Language
{
CountryCode = "ABC",
IsOfficial = true,
Name = "Test Language",
Percentage = 100
};
//Act
bool didWork = languageDal.AddNewLanguage(language);
//Assert
Assert.AreEqual(true, didWork);
}
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);
}
}
