private static PricelistCollection DBMapping(DBPricelistCollection dbCollection)
{
if (dbCollection == null)
return null;
PricelistCollection collection = new PricelistCollection();
foreach (DBPricelist dbItem in dbCollection)
{
Pricelist item = DBMapping(dbItem);
collection.Add(item);
}
return collection;
}
/// <summary>
/// Gets a collection of all available pricelists
/// </summary>
/// <returns>Collection of pricelists</returns>
public override DBPricelistCollection GetAllPricelists()
{
DBPricelistCollection pricelistCollection = new DBPricelistCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_PricelistLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBPricelist newPricelist = GetPricelistFromReader(dataReader);
pricelistCollection.Add(newPricelist);
}
}
return pricelistCollection;
}
