private static TaxRateCollection DBMapping(DBTaxRateCollection dbCollection) { if (dbCollection == null) return null; TaxRateCollection collection = new TaxRateCollection(); foreach (DBTaxRate dbItem in dbCollection) { TaxRate item = DBMapping(dbItem); collection.Add(item); } return collection; }
/// <summary> /// Gets all tax rates /// </summary> /// <returns>Tax rate collection</returns> public override DBTaxRateCollection GetAllTaxRates() { var result = new DBTaxRateCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_TaxRateLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetTaxRateFromReader(dataReader); result.Add(item); } } return(result); }
private static TaxRateCollection DBMapping(DBTaxRateCollection dbCollection) { if (dbCollection == null) { return(null); } var collection = new TaxRateCollection(); foreach (var dbItem in dbCollection) { var item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets all tax rates /// </summary> /// <returns>Tax rate collection</returns> public static TaxRateCollection GetAllTaxRates() { string key = TAXRATE_ALL_KEY; object obj2 = NopCache.Get(key); if (TaxRateManager.CacheEnabled && (obj2 != null)) { return((TaxRateCollection)obj2); } DBTaxRateCollection dbCollection = DBProviderManager <DBTaxRateProvider> .Provider.GetAllTaxRates(); TaxRateCollection collection = DBMapping(dbCollection); if (TaxRateManager.CacheEnabled) { NopCache.Max(key, collection); } return(collection); }