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);
}
