public IActionResult Create(CountryCreateViewModel c)
        {
            if (c is null)
            {
                throw new System.ArgumentNullException(nameof(c));
            }

            if (ModelState.IsValid)
            {
                var langids = _langrepo.GetAll().Where(l => l.Name == "English").ToList();

                int englishid = langids[0].LanguageId;
                if (c.LanguageId == englishid)
                {
                    Countries cou = new Countries()
                    {
                        Name = c.Name, IsActive = c.IsActive
                    };
                    int r = _countryrepo.Create(cou);
                    return(RedirectToAction("Index"));
                }
                else

                {
                    CountryLanguages clangs = new CountryLanguages()
                    {
                        Name = c.Name, LanguageId = c.LanguageId, CountryId = c.EnglishCountryID
                    };
                    int i = _countrylang.Create(clangs);
                    return(RedirectToAction("Index"));
                }
            }
            return(View());
        }
        public IActionResult Edit(CountryEditViewModel cem)
        {
            if (cem is null)
            {
                throw new System.ArgumentNullException(nameof(cem));
            }

            int i;

            if (ModelState.IsValid)
            {
                if (cem.Language == "English")
                {
                    Countries co = new Countries();
                    co.Name      = cem.Country;
                    co.CountryId = cem.CountryID;
                    i            = _countryrepo.Update(co);
                }
                else

                {
                    CountryLanguages cl = new CountryLanguages()
                    {
                        CountryLanguageId = cem.CountryLanguageID, Name = cem.Country, CountryId = cem.CountryID, LanguageId = cem.LanguageId
                    };
                    i = _countrylang.Update(cl);
                }
                if (i > 0)
                {
                    return(RedirectToAction("Index"));
                }
            }
            return(View());
        }
        static void Main(string[] args)
        {
            Country          countryOneInstance = new Country();
            Country          countryTwoInstance = new Country();
            CountryLanguages countryLanguages   = new CountryLanguages();

            countryLanguages.FirstLanguage  = Language.Bosnian.ToString();
            countryLanguages.SecondLanguage = Language.Urdu.ToString();

            countryOneInstance.CountryLanguages = countryLanguages;
            countryOneInstance.PlanetName       = "Earth";
            countryOneInstance.CountryName      = "Germany";
            countryOneInstance.Currency         = Currencies.BAM;
            countryOneInstance.Continents       = Continents.Americas;

            countryOneInstance.SayHi();
            countryOneInstance.SayHi(countryOneInstance.CountryName);
            Console.WriteLine($"Planet {countryOneInstance.PlanetName} and country {countryOneInstance.CountryName} and currency {countryOneInstance.Currency}");
        }
Ejemplo n.º 4
0
        private static void Main(string[] args)
        {
            Country          countryOneInstance = new Country();
            Country          countryTwoInstance = new Country();
            CountryLanguages countryLanguages   = new CountryLanguages();

            countryLanguages.FirstLanguage  = Languages.English.ToString();
            countryLanguages.SecondLanguage = Languages.French.ToString();

            countryOneInstance.CountryLanguages = countryLanguages;
            countryOneInstance.PlanetName       = "Earth";
            countryOneInstance.CountryName      = "Canada";
            countryOneInstance.Currency         = Currencies.CAD;
            countryOneInstance.Continents       = Continents.NorthAmerica;

            countryOneInstance.SayHi();
            countryOneInstance.SayHi(countryOneInstance.CountryName);

            Console.WriteLine($"Planet {countryOneInstance.PlanetName} and country is {countryOneInstance.CountryName} and currency is {countryOneInstance.Currency}");
        }
 public IActionResult Delete(
     string languagename,
     int countryid,
     int clang)
 {
     if (languagename == "English")
     {
         Countries c = new Countries();
         c.CountryId = countryid;
         int i = _countryrepo.Delete(c);
         return(RedirectToAction("Index"));
     }
     else
     {
         CountryLanguages cl = new CountryLanguages();
         cl.CountryLanguageId = clang;
         int i = _countrylang.Delete(cl);
         return(RedirectToAction("Index"));
     }
 }
Ejemplo n.º 6
0
        static void Main(string[] args)
        {
            Country          countryOne       = new Country();
            Country          countryTwo       = new Country();
            CountryLanguages countryLanguages = new CountryLanguages();

            countryLanguages.FirstLanguage  = Languages.Italian.ToString();
            countryLanguages.SecondLanguage = Languages.English.ToString();

            countryOne.CountryLanguage = countryLanguages;
            countryOne.PlanetName      = "Earth";
            countryOne.CountryName     = "Italy";
            countryOne.Currency        = Currencies.EUR;
            countryOne.Continents      = Continents.Europe;

            countryOne.SayHi();
            countryOne.SayHi(countryOne.CountryName);

            Console.WriteLine($"Planet {countryOne.PlanetName} \nCountry is {countryOne.CountryName}");
            Console.WriteLine($"The languages spoken are {countryOne.CountryLanguage.FirstLanguage} and {countryOne.CountryLanguage.SecondLanguage}, \nand the currency is {countryOne.Currency}");
        }
Ejemplo n.º 7
0
        static void Main(string[] args)
        {
            Country          countryOne       = new Country();
            Country          countryTwo       = new Country();
            CountryLanguages countryLanguages = new CountryLanguages();

            countryLanguages.FirstLanguage  = languages.English.ToString();
            countryLanguages.SecondLanguage = languages.French.ToString();

            countryOne.CountryLanguages = countryLanguages;
            countryOne.PlanetName       = "earth";
            countryOne.CountryNames     = "Canada";
            countryOne.Currency         = Currencies.CAD.ToString();
            countryOne.ContinentsName   = Continents.NORTH_AMERICA;

            countryOne.sayHi(countryOne.PlanetName);
            countryOne.sayHi(
                countryOne.CountryNames,
                countryOne.Currency,
                countryLanguages.FirstLanguage,
                countryLanguages.SecondLanguage);
        }
Ejemplo n.º 8
0
        public static void WriteQueriesToFiles()
        {
            Directory.CreateDirectory(SeedFolderPath);
            using (var currencyFile = new StreamWriter(CurrencyFilePath))
            {
                currencyFile.WriteLine(SetIdentityInsert(nameof(Currency), true));
                currencyFile.WriteLine(CurrencyInsertClause);
                Currencies.ForEach(currency => currencyFile.WriteLine(currency.Id == 1 ? FormatCurrencyValues(currency) : $"union all {FormatCurrencyValues(currency)}"));
                currencyFile.WriteLine(SetIdentityInsert(nameof(Currency), false));
            }

            using (var languageFile = new StreamWriter(LanguageFilePath))
            {
                languageFile.WriteLine(SetIdentityInsert(nameof(Language), true));
                languageFile.WriteLine(LanguageInsertClause);
                Languages.ForEach(language => languageFile.WriteLine(language.Id == 1 ? FormatLanguageValues(language) : $"union all {FormatLanguageValues(language)}"));
                languageFile.WriteLine(SetIdentityInsert(nameof(Language), false));
            }

            using (var countryFile = new StreamWriter(CountryFilePath))
            {
                countryFile.WriteLine(SetIdentityInsert(nameof(Country), true));
                countryFile.WriteLine(CountryInsertClause);
                Countries.ForEach(country => countryFile.WriteLine(country.Id == 1 ? FormatCountryValues(country) : $"union all {FormatCountryValues(country)}"));
                countryFile.WriteLine(SetIdentityInsert(nameof(Country), false));
            }

            using (var countryLanguageFile = new StreamWriter(CountryLanguageFilePath))
            {
                countryLanguageFile.WriteLine(CountryLanguageInsertClause);
                CountryLanguages.Select((countrylanguage, index) => new { countrylanguage, index }).ToList().ForEach(x => countryLanguageFile.WriteLine(
                                                                                                                         x.index == 0 ? FormatCountryLanguageValues(x.countrylanguage) : $"union all {FormatCountryLanguageValues(x.countrylanguage)}"));
            }

            using (var stateFile = new StreamWriter(StateFilePath))
            {
                stateFile.WriteLine(SetIdentityInsert(nameof(State), true));
                stateFile.WriteLine(StateInsertClause);
                States.ForEach(state => stateFile.WriteLine(state.Id == 1 ? FormatStateValues(state) : $"union all {FormatStateValues(state)}"));
                stateFile.WriteLine(SetIdentityInsert(nameof(State), false));
            }

            using (var provinceFile = new StreamWriter(ProvinceFilePath))
            {
                provinceFile.WriteLine(SetIdentityInsert(nameof(Province), true));
                provinceFile.WriteLine(ProvinceInsertClause);
                Provinces.ForEach(province => provinceFile.WriteLine(province.Id == 1 ? FormatProvinceValues(province) : $"union all {FormatProvinceValues(province)}"));
                provinceFile.WriteLine(SetIdentityInsert(nameof(Province), false));
            }

            using (var communityFile = new StreamWriter(CommunityFilePath))
            {
                communityFile.WriteLine(SetIdentityInsert(nameof(Community), true));
                communityFile.WriteLine(CommunityInsertClause);
                Communities.ForEach(community => communityFile.WriteLine(community.Id == 1 ? FormatCommunityValues(community) : $"union all {FormatCommunityValues(community)}"));
                communityFile.WriteLine(SetIdentityInsert(nameof(Community), false));
            }

            using (var placeFile = new StreamWriter(PlaceFilePath))
            {
                placeFile.WriteLine(SetIdentityInsert(nameof(Place), true));
                placeFile.WriteLine(PlaceInsertClause);
                Places.ForEach(place => placeFile.WriteLine(place.Id == 1 ? FormatPlaceValues(place) : $"union all {FormatPlaceValues(place)}"));
                placeFile.WriteLine(SetIdentityInsert(nameof(Place), false));
            }
        }