Exemple #1
0
        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;
        }