private static ProductTemplateCollection DBMapping(DBProductTemplateCollection dbCollection) { if (dbCollection == null) { return(null); } var collection = new ProductTemplateCollection(); foreach (var dbItem in dbCollection) { var item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets all product templates /// </summary> /// <returns>Product template collection</returns> public override DBProductTemplateCollection GetAllProductTemplates() { var result = new DBProductTemplateCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductTemplateLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetProductTemplateFromReader(dataReader); result.Add(item); } } return(result); }
/// <summary> /// Gets all product templates /// </summary> /// <returns>Product template collection</returns> public static ProductTemplateCollection GetAllProductTemplates() { string key = string.Format(PRODUCTTEMPLATES_ALL_KEY); object obj2 = NopCache.Get(key); if (TemplateManager.CacheEnabled && (obj2 != null)) { return((ProductTemplateCollection)obj2); } DBProductTemplateCollection dbCollection = DBProviderManager <DBTemplateProvider> .Provider.GetAllProductTemplates(); ProductTemplateCollection productTemplates = DBMapping(dbCollection); if (TemplateManager.CacheEnabled) { NopCache.Max(key, productTemplates); } return(productTemplates); }
/// <summary> /// Gets all product templates /// </summary> /// <returns>Product template collection</returns> public override DBProductTemplateCollection GetAllProductTemplates() { DBProductTemplateCollection productTemplateCollection = new DBProductTemplateCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductTemplateLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBProductTemplate productTemplate = GetProductTemplateFromReader(dataReader); productTemplateCollection.Add(productTemplate); } } return productTemplateCollection; }