private DBDiscountRequirement GetDiscountRequirementFromReader(IDataReader dataReader) { DBDiscountRequirement discountRequirement = new DBDiscountRequirement(); discountRequirement.DiscountRequirementID = NopSqlDataHelper.GetInt(dataReader, "DiscountRequirementID"); discountRequirement.Name = NopSqlDataHelper.GetString(dataReader, "Name"); return(discountRequirement); }
private DBDiscountRequirement GetDiscountRequirementFromReader(IDataReader dataReader) { var item = new DBDiscountRequirement(); item.DiscountRequirementId = NopSqlDataHelper.GetInt(dataReader, "DiscountRequirementID"); item.Name = NopSqlDataHelper.GetString(dataReader, "Name"); return(item); }
/// <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); }