ATMLDataAccessLibrary.db.daos.LookupTablesDAO.getActiveCountries C# (CSharp) Method

        public List<dbCountry> getActiveCountries()
        {
            var parameters = new[] { new OleDbParameter(dbCountry._ACTIVE_FLAG, TRUE) };
            List<dbCountry> list =
                CreateList<dbCountry>(
                    BuildSqlSelect(dbCountry._TABLE_NAME, new String[] { ALL }, new String[] { dbCountry._ACTIVE_FLAG }),
                    parameters);
            foreach (dbCountry country in list)
            {
                country.States = getCountryStates(country.countryCode);
            }
            return list;
        }