/// <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;
}
