public void AjouterModifierProduit(Product produit, typeOperation operation) { var cmd = new SqlCommand(); if (operation == typeOperation.Ajout) { cmd.CommandText = @"Insert Product ( CategoryId, SupplierId, Name, UnitPrice, UnitsInStock) Values ( @IdCat, @IdFour, @nom, @prix, @stock) "; cmd.Parameters.Add(new SqlParameter { SqlDbType = SqlDbType.UniqueIdentifier, ParameterName = "@IdCat", Value = produit.CategoryId }); cmd.Parameters.Add(new SqlParameter { SqlDbType = SqlDbType.Int, ParameterName = "@IdFour", Value = produit.SupplierId }); cmd.Parameters.Add(new SqlParameter { SqlDbType = SqlDbType.NVarChar, ParameterName = "@nom", Value = produit.Name }); cmd.Parameters.Add(new SqlParameter { SqlDbType = SqlDbType.Money, ParameterName = "@prix", Value = produit.UnitPrice }); cmd.Parameters.Add(new SqlParameter { SqlDbType = SqlDbType.SmallInt, ParameterName = "@stock", Value = produit.UnitsInStock }); } else if (operation == typeOperation.Modification) { cmd.CommandText = @"Update Product set Name = @nom, CategoryId = @IdCat, SupplierId = @IdFour, UnitPrice = @prix, UnitsInStock = @stock where ProductId = @Id "; cmd.Parameters.Add(new SqlParameter { SqlDbType = SqlDbType.Int, ParameterName = "@Id", Value = produit.ProductId, }); cmd.Parameters.Add(new SqlParameter { SqlDbType = SqlDbType.NVarChar, ParameterName = "@nom", Value = produit.Name }); cmd.Parameters.Add(new SqlParameter { SqlDbType = SqlDbType.UniqueIdentifier, ParameterName = "@IdCat", Value = produit.CategoryId }); cmd.Parameters.Add(new SqlParameter { SqlDbType = SqlDbType.Int, ParameterName = "@IdFour", Value = produit.SupplierId }); cmd.Parameters.Add(new SqlParameter { SqlDbType = SqlDbType.Money, ParameterName = "@prix", Value = produit.UnitPrice }); cmd.Parameters.Add(new SqlParameter { SqlDbType = SqlDbType.SmallInt, ParameterName = "@stock", Value = produit.UnitsInStock }); } using (var cnx = new SqlConnection(Settings.Default.Northwind2Connect)) { cmd.Connection = cnx; cnx.Open(); cmd.ExecuteNonQuery(); } }
public void AjouterModifierProduit(Product produit, typeOperation operation) { throw new NotImplementedException(); }