/// <summary> /// Gets all countries that allow shipping /// </summary> /// <returns>Country collection</returns> public override DBCountryCollection GetAllCountriesForShipping(bool showHidden) { var result = new DBCountryCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_CountryLoadAllForShipping"); db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetCountryFromReader(dataReader); result.Add(item); } } return(result); }
/// <summary> /// Gets all countries that allow registration /// </summary> /// <returns>Country collection</returns> public override DBCountryCollection GetAllCountriesForRegistration(bool showHidden) { DBCountryCollection countryCollection = new DBCountryCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_CountryLoadAllForRegistration"); db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBCountry country = GetCountryFromReader(dataReader); countryCollection.Add(country); } } return(countryCollection); }
/// <summary> /// Gets all countries that allow shipping /// </summary> /// <returns>Country collection</returns> public override DBCountryCollection GetAllCountriesForShipping(bool showHidden) { DBCountryCollection countryCollection = new DBCountryCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_CountryLoadAllForShipping"); db.AddInParameter(dbCommand, "ShowHidden", DbType.Boolean, showHidden); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBCountry country = GetCountryFromReader(dataReader); countryCollection.Add(country); } } return countryCollection; }