public List <TestSprocGenerator.Business.SingleTable.Bo.Country> GetCountries()
        {
            CountryCityProvinceDataLayer.CityCountryProvinceStateDataAccess dataLayer =
                new CountryCityProvinceDataLayer.CityCountryProvinceStateDataAccess();

            Country bo = new Country(_smoSettings[CONNECTION_STRING_NAME]);

            TestSprocGenerator.Business.SingleTable.Bo.List.Country countryBoList =
                new TestSprocGenerator.Business.SingleTable.Bo.List.Country(_smoSettings[CONNECTION_STRING_NAME]);

            countryBoList.FillByGetAll(bo);
            return(countryBoList.ConvertAll(new Converter <TestSprocGenerator.Data.SingleTable.Dto.Country,
                                                           TestSprocGenerator.Business.SingleTable.Bo.Country>(CountryFromDtoToBo)));
        }
        public List <TestSprocGenerator.Business.SingleTable.Bo.City> GetCities(System.Nullable <int> countryID)
        {
            CountryCityProvinceDataLayer.CityCountryProvinceStateDataAccess dataLayer =
                new CountryCityProvinceDataLayer.CityCountryProvinceStateDataAccess();

            City bo = new City(_smoSettings[CONNECTION_STRING_NAME]);

            bo.CountryID = countryID;

            TestSprocGenerator.Business.SingleTable.Bo.List.City cityBoList =
                new TestSprocGenerator.Business.SingleTable.Bo.List.City(_smoSettings[CONNECTION_STRING_NAME]);


            cityBoList.FillByCriteriaExact(bo);
            return(cityBoList.ConvertAll(new Converter <TestSprocGenerator.Data.SingleTable.Dto.City,
                                                        TestSprocGenerator.Business.SingleTable.Bo.City>(CityFromDtoToBo)));
        }