private static CountryCollection DBMapping(DBCountryCollection dbCollection)
{
if (dbCollection == null)
return null;
CountryCollection collection = new CountryCollection();
foreach (DBCountry dbItem in dbCollection)
{
Country item = DBMapping(dbItem);
collection.Add(item);
}
return collection;
}
private static CountryCollection DBMapping(DBCountryCollection dbCollection)
{
if (dbCollection == null)
{
return(null);
}
CountryCollection collection = new CountryCollection();
foreach (DBCountry dbItem in dbCollection)
{
Country item = DBMapping(dbItem);
collection.Add(item);
}
return(collection);
}
/// <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
/// </summary>
/// <returns>Country collection</returns>
public static CountryCollection GetAllCountries()
{
bool showHidden = NopContext.Current.IsAdmin;
string key = string.Format(COUNTRIES_ALL_KEY, showHidden);
object obj2 = NopCache.Get(key);
if (CountryManager.CacheEnabled && (obj2 != null))
{
return((CountryCollection)obj2);
}
DBCountryCollection dbCollection = DBProviderManager <DBCountryProvider> .Provider.GetAllCountries(showHidden);
CountryCollection countryCollection = DBMapping(dbCollection);
if (CountryManager.CacheEnabled)
{
NopCache.Max(key, countryCollection);
}
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;
}
