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