private DBProductVariantAttributeCombination GetProductVariantAttributeCombinationFromReader(IDataReader dataReader)
{
var item = new DBProductVariantAttributeCombination();
item.ProductVariantAttributeCombinationId = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeCombinationID");
item.ProductVariantId = NopSqlDataHelper.GetInt(dataReader, "ProductVariantID");
item.AttributesXml = NopSqlDataHelper.GetString(dataReader, "AttributesXML");
item.StockQuantity = NopSqlDataHelper.GetInt(dataReader, "StockQuantity");
item.AllowOutOfStockOrders = NopSqlDataHelper.GetBoolean(dataReader, "AllowOutOfStockOrders");
return(item);
}
/// <summary>
/// Gets a product variant attribute combination
/// </summary>
/// <param name="productVariantAttributeCombinationId">Product variant attribute combination identifier</param>
/// <returns>Product variant attribute combination</returns>
public override DBProductVariantAttributeCombination GetProductVariantAttributeCombinationById(int productVariantAttributeCombinationId)
{
DBProductVariantAttributeCombination item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantAttributeCombinationLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ProductVariantAttributeCombinationID", DbType.Int32, productVariantAttributeCombinationId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetProductVariantAttributeCombinationFromReader(dataReader);
}
}
return(item);
}
/// <summary>
/// Updates a product variant attribute combination
/// </summary>
/// <param name="productVariantAttributeCombinationId">Product variant attribute combination identifier</param>
/// <param name="productVariantId">The product variant identifier</param>
/// <param name="attributesXml">The attributes</param>
/// <param name="stockQuantity">The stock quantity</param>
/// <param name="allowOutOfStockOrders">The value indicating whether to allow orders when out of stock</param>
/// <returns>Product variant attribute combination</returns>
public override DBProductVariantAttributeCombination UpdateProductVariantAttributeCombination(int productVariantAttributeCombinationId,
int productVariantId,
string attributesXml,
int stockQuantity,
bool allowOutOfStockOrders)
{
DBProductVariantAttributeCombination item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantAttributeCombinationUpdate");
db.AddInParameter(dbCommand, "ProductVariantAttributeCombinationID", DbType.Int32, productVariantAttributeCombinationId);
db.AddInParameter(dbCommand, "ProductVariantID", DbType.Int32, productVariantId);
db.AddInParameter(dbCommand, "AttributesXML", DbType.Xml, attributesXml);
db.AddInParameter(dbCommand, "StockQuantity", DbType.Int32, stockQuantity);
db.AddInParameter(dbCommand, "AllowOutOfStockOrders", DbType.Int32, allowOutOfStockOrders);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetProductVariantAttributeCombinationById(productVariantAttributeCombinationId);
}
return(item);
}