private static ProductTypeCollection DBMapping(DBProductTypeCollection dbCollection)
{
if (dbCollection == null)
return null;
ProductTypeCollection collection = new ProductTypeCollection();
foreach (DBProductType dbItem in dbCollection)
{
ProductType item = DBMapping(dbItem);
collection.Add(item);
}
return collection;
}
/// <summary>
/// Gets all product types
/// </summary>
/// <returns>Product type collection</returns>
public override DBProductTypeCollection GetAllProductTypes()
{
DBProductTypeCollection productTypeCollection = new DBProductTypeCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductTypeLoadAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBProductType productType = GetProductTypeFromReader(dataReader);
productTypeCollection.Add(productType);
}
}
return productTypeCollection;
}