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