/// <summary>
/// Get low stock product variants
/// </summary>
/// <returns>Result</returns>
public override DBProductVariantCollection GetLowStockProductVariants()
{
DBProductVariantCollection productVariantCollection = new DBProductVariantCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantLoadLowStock");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBProductVariant productVariant = GetProductVariantFromReader(dataReader);
productVariantCollection.Add(productVariant);
}
}
return productVariantCollection;
}
/// <summary>
/// Gets all product variants directly assigned to a pricelist
/// </summary>
/// <param name="PricelistID"></param>
/// <returns></returns>
public override DBProductVariantCollection GetProductVariantsByPricelistID(int PricelistID)
{
DBProductVariantCollection productVariantCollection = new DBProductVariantCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantLoadByPricelistID");
db.AddInParameter(dbCommand, "PricelistID", DbType.Int32, PricelistID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBProductVariant productVariant = GetProductVariantFromReader(dataReader);
productVariantCollection.Add(productVariant);
}
}
return productVariantCollection;
}
