private static CategoryTemplateCollection DBMapping(DBCategoryTemplateCollection dbCollection) { if (dbCollection == null) { return(null); } var collection = new CategoryTemplateCollection(); foreach (var dbItem in dbCollection) { var item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets all category templates /// </summary> /// <returns>Category template collection</returns> public override DBCategoryTemplateCollection GetAllCategoryTemplates() { var result = new DBCategoryTemplateCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_CategoryTemplateLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetCategoryTemplateFromReader(dataReader); result.Add(item); } } return(result); }
/// <summary> /// Gets all category templates /// </summary> /// <returns>Category template collection</returns> public static CategoryTemplateCollection GetAllCategoryTemplates() { string key = string.Format(CATEGORYTEMPLATES_ALL_KEY); object obj2 = NopCache.Get(key); if (TemplateManager.CacheEnabled && (obj2 != null)) { return((CategoryTemplateCollection)obj2); } DBCategoryTemplateCollection dbCollection = DBProviderManager <DBTemplateProvider> .Provider.GetAllCategoryTemplates(); CategoryTemplateCollection categoryTemplates = DBMapping(dbCollection); if (TemplateManager.CacheEnabled) { NopCache.Max(key, categoryTemplates); } return(categoryTemplates); }
/// <summary> /// Gets all category templates /// </summary> /// <returns>Category template collection</returns> public override DBCategoryTemplateCollection GetAllCategoryTemplates() { DBCategoryTemplateCollection categoryTemplateCollection = new DBCategoryTemplateCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_CategoryTemplateLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBCategoryTemplate categoryTemplate = GetCategoryTemplateFromReader(dataReader); categoryTemplateCollection.Add(categoryTemplate); } } return categoryTemplateCollection; }