private static DiscountRequirementCollection DBMapping(DBDiscountRequirementCollection dbCollection) { if (dbCollection == null) return null; DiscountRequirementCollection collection = new DiscountRequirementCollection(); foreach (DBDiscountRequirement dbItem in dbCollection) { DiscountRequirement item = DBMapping(dbItem); collection.Add(item); } return collection; }
private static DiscountRequirementCollection DBMapping(DBDiscountRequirementCollection dbCollection) { if (dbCollection == null) { return(null); } DiscountRequirementCollection collection = new DiscountRequirementCollection(); foreach (DBDiscountRequirement dbItem in dbCollection) { DiscountRequirement item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets all discount requirements /// </summary> /// <returns>Discount requirement collection</returns> public override DBDiscountRequirementCollection GetAllDiscountRequirements() { var result = new DBDiscountRequirementCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_DiscountRequirementLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetDiscountRequirementFromReader(dataReader); result.Add(item); } } return(result); }
/// <summary> /// Gets all discount requirements /// </summary> /// <returns>Discount requirement collection</returns> public static DiscountRequirementCollection GetAllDiscountRequirements() { string key = string.Format(DISCOUNTREQUIREMENT_ALL_KEY); object obj2 = NopCache.Get(key); if (DiscountManager.CacheEnabled && (obj2 != null)) { return((DiscountRequirementCollection)obj2); } DBDiscountRequirementCollection dbCollection = DBProviderManager <DBDiscountProvider> .Provider.GetAllDiscountRequirements(); DiscountRequirementCollection discountRequirements = DBMapping(dbCollection); if (DiscountManager.CacheEnabled) { NopCache.Max(key, discountRequirements); } return(discountRequirements); }
/// <summary> /// Gets all discount requirements /// </summary> /// <returns>Discount requirement collection</returns> public override DBDiscountRequirementCollection GetAllDiscountRequirements() { DBDiscountRequirementCollection discountRequirementCollection = new DBDiscountRequirementCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_DiscountRequirementLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBDiscountRequirement discountRequirement = GetDiscountRequirementFromReader(dataReader); discountRequirementCollection.Add(discountRequirement); } } return discountRequirementCollection; }