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