private DBProductVariantAttribute GetProductVariantAttributeFromReader(IDataReader dataReader)
{
DBProductVariantAttribute productVariantAttribute = new DBProductVariantAttribute();
productVariantAttribute.ProductVariantAttributeID = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeID");
productVariantAttribute.ProductVariantID = NopSqlDataHelper.GetInt(dataReader, "ProductVariantID");
productVariantAttribute.ProductAttributeID = NopSqlDataHelper.GetInt(dataReader, "ProductAttributeID");
productVariantAttribute.TextPrompt = NopSqlDataHelper.GetString(dataReader, "TextPrompt");
productVariantAttribute.IsRequired = NopSqlDataHelper.GetBoolean(dataReader, "IsRequired");
productVariantAttribute.AttributeControlTypeID = NopSqlDataHelper.GetInt(dataReader, "AttributeControlTypeID");
productVariantAttribute.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return(productVariantAttribute);
}
/// <summary>
/// Gets a product variant attribute mapping
/// </summary>
/// <param name="ProductVariantAttributeID">Product variant attribute mapping identifier</param>
/// <returns>Product variant attribute mapping</returns>
public override DBProductVariantAttribute GetProductVariantAttributeByID(int ProductVariantAttributeID)
{
DBProductVariantAttribute productVariantAttribute = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariant_ProductAttribute_MappingLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ProductVariantAttributeID", DbType.Int32, ProductVariantAttributeID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
productVariantAttribute = GetProductVariantAttributeFromReader(dataReader);
}
}
return(productVariantAttribute);
}
/// <summary>
/// Gets product variant attribute mappings by product identifier
/// </summary>
/// <param name="ProductVariantID">The product variant identifier</param>
/// <returns>Product variant attribute mapping collection</returns>
public override DBProductVariantAttributeCollection GetProductVariantAttributesByProductVariantID(int ProductVariantID)
{
DBProductVariantAttributeCollection productVariantAttributes = new DBProductVariantAttributeCollection();
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariant_ProductAttribute_MappingLoadByProductVariantID");
db.AddInParameter(dbCommand, "ProductVariantID", DbType.Int32, ProductVariantID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBProductVariantAttribute productVariantAttribute = GetProductVariantAttributeFromReader(dataReader);
productVariantAttributes.Add(productVariantAttribute);
}
}
return(productVariantAttributes);
}
/// <summary>
/// Updates the product variant attribute mapping
/// </summary>
/// <param name="ProductVariantAttributeID">The product variant attribute mapping identifier</param>
/// <param name="ProductVariantID">The product variant identifier</param>
/// <param name="ProductAttributeID">The product attribute identifier</param>
/// <param name="TextPrompt">The text prompt</param>
/// <param name="IsRequired">The value indicating whether the entity is required</param>
/// <param name="AttributeControlTypeID">The attribute control type identifier</param>
/// <param name="DisplayOrder">The display order</param>
/// <returns>Product variant attribute mapping</returns>
public override DBProductVariantAttribute UpdateProductVariantAttribute(int ProductVariantAttributeID, int ProductVariantID,
int ProductAttributeID, string TextPrompt, bool IsRequired, int AttributeControlTypeID, int DisplayOrder)
{
DBProductVariantAttribute productVariantAttribute = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariant_ProductAttribute_MappingUpdate");
db.AddInParameter(dbCommand, "ProductVariantAttributeID", DbType.Int32, ProductVariantAttributeID);
db.AddInParameter(dbCommand, "ProductVariantID", DbType.Int32, ProductVariantID);
db.AddInParameter(dbCommand, "ProductAttributeID", DbType.Int32, ProductAttributeID);
db.AddInParameter(dbCommand, "TextPrompt", DbType.String, TextPrompt);
db.AddInParameter(dbCommand, "IsRequired", DbType.Boolean, IsRequired);
db.AddInParameter(dbCommand, "AttributeControlTypeID", DbType.Int32, AttributeControlTypeID);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, DisplayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
productVariantAttribute = GetProductVariantAttributeByID(ProductVariantAttributeID);
}
return(productVariantAttribute);
}
/// <summary>
/// Updates the product variant attribute mapping
/// </summary>
/// <param name="productVariantAttributeId">The product variant attribute mapping identifier</param>
/// <param name="productVariantId">The product variant identifier</param>
/// <param name="productAttributeId">The product attribute identifier</param>
/// <param name="textPrompt">The text prompt</param>
/// <param name="isRequired">The value indicating whether the entity is required</param>
/// <param name="attributeControlTypeId">The attribute control type identifier</param>
/// <param name="displayOrder">The display order</param>
/// <returns>Product variant attribute mapping</returns>
public override DBProductVariantAttribute UpdateProductVariantAttribute(int productVariantAttributeId,
int productVariantId, int productAttributeId, string textPrompt, bool isRequired,
int attributeControlTypeId, int displayOrder)
{
DBProductVariantAttribute item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariant_ProductAttribute_MappingUpdate");
db.AddInParameter(dbCommand, "ProductVariantAttributeID", DbType.Int32, productVariantAttributeId);
db.AddInParameter(dbCommand, "ProductVariantID", DbType.Int32, productVariantId);
db.AddInParameter(dbCommand, "ProductAttributeID", DbType.Int32, productAttributeId);
db.AddInParameter(dbCommand, "TextPrompt", DbType.String, textPrompt);
db.AddInParameter(dbCommand, "IsRequired", DbType.Boolean, isRequired);
db.AddInParameter(dbCommand, "AttributeControlTypeID", DbType.Int32, attributeControlTypeId);
db.AddInParameter(dbCommand, "DisplayOrder", DbType.Int32, displayOrder);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetProductVariantAttributeById(productVariantAttributeId);
}
return(item);
}
