/// <summary> /// The add. /// </summary> /// <param name="product"> /// The product. /// </param> /// <param name="productAttributeValueSets"> /// The product attribute value sets. /// </param> /// <param name="pictureIDs"> /// The picture i ds. /// </param> /// <returns> /// The <see cref="int"/>. /// </returns> public int Add(Product product, List<Product_AttributeValueSet> productAttributeValueSets, List<string> pictureIDs, string masterPictureID) { var productID = 0; try { productID = this.productDA.Insert(product); //if (productAttributeValueSets != null && productAttributeValueSets.Count > 0) //{ // foreach (var productAttributeValueSet in productAttributeValueSets) // { // productAttributeValueSet.ProductID = productID; // this.productAttributeValueSetDA.Insert(productAttributeValueSet, transaction); // } //} foreach (var pictureID in pictureIDs) { var productPicture = new Product_Picture { ProductID = productID, PictureID = Convert.ToInt32(pictureID), IsMaster = pictureID == masterPictureID ? true : false }; this.productPictureDA.Insert(productPicture); } } catch (Exception exception) { throw new Exception(exception.Message); } return productID; }
/// <summary> /// The insert. /// </summary> /// <param name="productPicture"> /// The product picture. /// </param> /// <param name="transaction"> /// The transaction. /// </param> public void Insert(Product_Picture productPicture) { if (productPicture == null) { throw new ArgumentNullException("productPicture"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "ProductID", SqlDbType.Int, productPicture.ProductID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "PictureID", SqlDbType.Int, productPicture.PictureID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "IsMaster", SqlDbType.Bit, productPicture.IsMaster, ParameterDirection.Input) }; this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Product_Picture_Insert", parameters, null); }