private static TaxCategoryCollection DBMapping(DBTaxCategoryCollection dbCollection) { if (dbCollection == null) return null; TaxCategoryCollection collection = new TaxCategoryCollection(); foreach (DBTaxCategory dbItem in dbCollection) { TaxCategory item = DBMapping(dbItem); collection.Add(item); } return collection; }
/// <summary> /// Gets all tax categories /// </summary> /// <returns>Tax category collection</returns> public override DBTaxCategoryCollection GetAllTaxCategories() { DBTaxCategoryCollection taxCategoryCollection = new DBTaxCategoryCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxCategoryLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBTaxCategory taxCategory = GetTaxCategoryFromReader(dataReader); taxCategoryCollection.Add(taxCategory); } } return(taxCategoryCollection); }
private static TaxCategoryCollection DBMapping(DBTaxCategoryCollection dbCollection) { if (dbCollection == null) { return(null); } TaxCategoryCollection collection = new TaxCategoryCollection(); foreach (DBTaxCategory dbItem in dbCollection) { TaxCategory item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets all tax categories /// </summary> /// <returns>Tax category collection</returns> public static TaxCategoryCollection GetAllTaxCategories() { string key = string.Format(TAXCATEGORIES_ALL_KEY); object obj2 = NopCache.Get(key); if (TaxCategoryManager.CacheEnabled && (obj2 != null)) { return((TaxCategoryCollection)obj2); } DBTaxCategoryCollection dbCollection = DBProviderManager <DBTaxCategoryProvider> .Provider.GetAllTaxCategories(); TaxCategoryCollection taxCategoryCollection = DBMapping(dbCollection); if (TaxCategoryManager.CacheEnabled) { NopCache.Max(key, taxCategoryCollection); } return(taxCategoryCollection); }
/// <summary> /// Gets all tax categories /// </summary> /// <returns>Tax category collection</returns> public override DBTaxCategoryCollection GetAllTaxCategories() { DBTaxCategoryCollection taxCategoryCollection = new DBTaxCategoryCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxCategoryLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBTaxCategory taxCategory = GetTaxCategoryFromReader(dataReader); taxCategoryCollection.Add(taxCategory); } } return taxCategoryCollection; }