private DBProductVariantAttributeValue GetProductVariantAttributeValueFromReader(IDataReader dataReader)
{
DBProductVariantAttributeValue productVariantAttributeValue = new DBProductVariantAttributeValue();
productVariantAttributeValue.ProductVariantAttributeValueID = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeValueID");
productVariantAttributeValue.ProductVariantAttributeID = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeID");
productVariantAttributeValue.Name = NopSqlDataHelper.GetString(dataReader, "Name");
productVariantAttributeValue.PriceAdjustment = NopSqlDataHelper.GetDecimal(dataReader, "PriceAdjustment");
productVariantAttributeValue.WeightAdjustment = NopSqlDataHelper.GetDecimal(dataReader, "WeightAdjustment");
productVariantAttributeValue.IsPreSelected = NopSqlDataHelper.GetBoolean(dataReader, "IsPreSelected");
productVariantAttributeValue.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return productVariantAttributeValue;
}
private DBProductVariantAttributeValue GetProductVariantAttributeValueFromReader(IDataReader dataReader)
{
DBProductVariantAttributeValue productVariantAttributeValue = new DBProductVariantAttributeValue();
productVariantAttributeValue.ProductVariantAttributeValueID = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeValueID");
productVariantAttributeValue.ProductVariantAttributeID = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeID");
productVariantAttributeValue.Name = NopSqlDataHelper.GetString(dataReader, "Name");
productVariantAttributeValue.PriceAdjustment = NopSqlDataHelper.GetDecimal(dataReader, "PriceAdjustment");
productVariantAttributeValue.WeightAdjustment = NopSqlDataHelper.GetDecimal(dataReader, "WeightAdjustment");
productVariantAttributeValue.IsPreSelected = NopSqlDataHelper.GetBoolean(dataReader, "IsPreSelected");
productVariantAttributeValue.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(productVariantAttributeValue);
}
/// <summary>
/// Gets a product variant attribute value
/// </summary>
/// <param name="ProductVariantAttributeValueID">Product variant attribute value identifier</param>
/// <returns>Product variant attribute value</returns>
public override DBProductVariantAttributeValue GetProductVariantAttributeValueByID(int ProductVariantAttributeValueID)
{
DBProductVariantAttributeValue productVariantAttributeValue = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantAttributeValueLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ProductVariantAttributeValueID", DbType.Int32, ProductVariantAttributeValueID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
productVariantAttributeValue = GetProductVariantAttributeValueFromReader(dataReader);
}
}
return(productVariantAttributeValue);
}
/// <summary>
/// Gets product variant attribute values by product identifier
/// </summary>
/// <param name="ProductVariantAttributeID">The product variant attribute mapping identifier</param>
/// <returns>Product variant attribute mapping collection</returns>
public override DBProductVariantAttributeValueCollection GetProductVariantAttributeValues(int ProductVariantAttributeID)
{
DBProductVariantAttributeValueCollection productVariantAttributeValues = new DBProductVariantAttributeValueCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantAttributeValueLoadByProductVariantAttributeID");
db.AddInParameter(dbCommand, "ProductVariantAttributeID", DbType.Int32, ProductVariantAttributeID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBProductVariantAttributeValue productVariantAttributeValue = GetProductVariantAttributeValueFromReader(dataReader);
productVariantAttributeValues.Add(productVariantAttributeValue);
}
}
return(productVariantAttributeValues);
}
/// <summary>
/// Updates the product variant attribute value
/// </summary>
/// <param name="ProductVariantAttributeValueID">The product variant attribute value identifier</param>
/// <param name="ProductVariantAttributeID">The product variant attribute mapping identifier</param>
/// <param name="Name">The product variant attribute name</param>
/// <param name="PriceAdjustment">The price adjustment</param>
/// <param name="WeightAdjustment">The weight adjustment</param>
/// <param name="IsPreSelected">The value indicating whether the value is pre-selected</param>
/// <param name="DisplayOrder">The display order</param>
/// <returns>Product variant attribute value</returns>
public override DBProductVariantAttributeValue UpdateProductVariantAttributeValue(int ProductVariantAttributeValueID,
int ProductVariantAttributeID, string Name, decimal PriceAdjustment,
decimal WeightAdjustment, bool IsPreSelected, int DisplayOrder)
{
DBProductVariantAttributeValue productVariantAttributeValue = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantAttributeValueUpdate");
db.AddInParameter(dbCommand, "ProductVariantAttributeValueID", DbType.Int32, ProductVariantAttributeValueID);
db.AddInParameter(dbCommand, "ProductVariantAttributeID", DbType.Int32, ProductVariantAttributeID);
db.AddInParameter(dbCommand, "Name", DbType.String, Name);
db.AddInParameter(dbCommand, "PriceAdjustment", DbType.Decimal, PriceAdjustment);
db.AddInParameter(dbCommand, "WeightAdjustment", DbType.Decimal, WeightAdjustment);
db.AddInParameter(dbCommand, "IsPreSelected", DbType.Boolean, IsPreSelected);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
productVariantAttributeValue = GetProductVariantAttributeValueByID(ProductVariantAttributeValueID);
}
return(productVariantAttributeValue);
}
/// <summary>
/// Updates the product variant attribute value
/// </summary>
/// <param name="productVariantAttributeValueId">The product variant attribute value identifier</param>
/// <param name="productVariantAttributeId">The product variant attribute mapping identifier</param>
/// <param name="name">The product variant attribute name</param>
/// <param name="priceAdjustment">The price adjustment</param>
/// <param name="weightAdjustment">The weight adjustment</param>
/// <param name="isPreSelected">The value indicating whether the value is pre-selected</param>
/// <param name="displayOrder">The display order</param>
/// <returns>Product variant attribute value</returns>
public override DBProductVariantAttributeValue UpdateProductVariantAttributeValue(int productVariantAttributeValueId,
int productVariantAttributeId, string name,
decimal priceAdjustment, decimal weightAdjustment,
bool isPreSelected, int displayOrder)
{
DBProductVariantAttributeValue item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantAttributeValueUpdate");
db.AddInParameter(dbCommand, "ProductVariantAttributeValueID", DbType.Int32, productVariantAttributeValueId);
db.AddInParameter(dbCommand, "ProductVariantAttributeID", DbType.Int32, productVariantAttributeId);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "PriceAdjustment", DbType.Decimal, priceAdjustment);
db.AddInParameter(dbCommand, "WeightAdjustment", DbType.Decimal, weightAdjustment);
db.AddInParameter(dbCommand, "IsPreSelected", DbType.Boolean, isPreSelected);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetProductVariantAttributeValueById(productVariantAttributeValueId, 0);
}
return(item);
}
