Пример #1
0
        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 GetLanguagesTest()
        {
            //Arrange
            LanguageSqlDAL languageDal = new LanguageSqlDAL(connectionString);

            //Act
            List <Language> languages = languageDal.GetLanguages("ABC", true);

            //Assert
            Assert.AreEqual(1, languages.Count);
            Assert.AreEqual("OfficialLanguage", languages[0].Name);
        }
Пример #3
0
        private void GetLanguagesForCountry()
        {
            string countryCode  = CLIHelper.GetString("Enter the country code you want to retrieve:");
            bool   officialOnly = CLIHelper.GetBool("Retrieve official languages only? True/False ");

            LanguageSqlDAL  languageDal = new LanguageSqlDAL(DatabaseConnectionString);
            List <Language> languages   = languageDal.GetLanguages(countryCode, officialOnly);

            Console.WriteLine();
            Console.WriteLine($"Printing {languages.Count} languages for {countryCode}");

            foreach (var language in languages)
            {
                Console.WriteLine(language);
            }
        }
        public void RemoveLanguageTest_ReturnsFalseIfNotExists()
        {
            //Arrange
            LanguageSqlDAL dal          = new LanguageSqlDAL(connectionString);
            Language       deadLanguage = new Language()
            {
                CountryCode = "ABC",
                Name        = "Nonexistent-Language"
            };

            //Act
            bool didRemove = dal.RemoveLanguage(deadLanguage);

            //Assert
            Assert.IsFalse(didRemove);
        }
        public void RemoveLanguageTest_ReturnsTrueIfExists()
        {
            //Arrange
            LanguageSqlDAL dal          = new LanguageSqlDAL(connectionString);
            Language       deadLanguage = new Language()
            {
                CountryCode = "ABC",
                Name        = "OfficialLanguage"
            };

            //Act
            bool didRemove = dal.RemoveLanguage(deadLanguage);

            //Assert
            Assert.IsTrue(didRemove);
        }
Пример #6
0
        private void GetLanguagesForCountry()
        {
            string countryCode = CLIHelper.GetString("Enter the country code you want to retrieve:");


            LanguageSqlDAL  languageDal = new LanguageSqlDAL(DatabaseConnectionString);
            List <Language> languages   = languageDal.GetLanguages(countryCode);

            Console.WriteLine();
            Console.WriteLine($"Printing {languages.Count} languages for {countryCode}");

            foreach (Language l in languages)
            {
                Console.WriteLine(l.Name.PadRight(30) + l.CountryCode.PadRight(5) + (l.IsOfficial ? "Official" : "Unofficial").PadRight(15) + (l.Percentage / 100.00).ToString("P").PadRight(5));
            }
        }
        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);
        }
Пример #8
0
        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);
            }
        }
Пример #9
0
        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);
            }
        }