public static void DeleteFacture(Facture facture) { SqlConnection sqlConnection = new SqlConnection(constr); sqlConnection.Open(); String command = "DELETE FROM " + table + " WHERE Id=@id ;"; SqlCommand sqlCommand = new SqlCommand(command, sqlConnection); using (sqlCommand) { sqlCommand.CommandType = CommandType.Text; sqlCommand.Parameters.AddWithValue("@id", facture.getid()); sqlCommand.ExecuteNonQuery(); } sqlCommand.Dispose(); sqlConnection.Close(); }
public static void AddFacture(Facture facture) { SqlConnection sqlConnection = new SqlConnection(constr); sqlConnection.Open(); String command = "INSERT INTO " + table + " VALUES(@Id , @num ,@date ,@fournisseur ," + " @pretID" + ",@produit,@Demand,@prix);"; SqlCommand sqlCommand = new SqlCommand(command, sqlConnection); using (sqlCommand) { sqlCommand.CommandType = CommandType.Text; sqlCommand.Parameters.AddWithValue("@Id", facture.getid()); sqlCommand.Parameters.AddWithValue("@num", facture.getNum()); sqlCommand.Parameters.AddWithValue("@date", facture.getDate()); sqlCommand.Parameters.AddWithValue("@fournisseur", facture.GetFournisseur().Id); if (facture.getprets_id() != 0) { sqlCommand.Parameters.AddWithValue("@pretID", facture.getprets_id()); } else { sqlCommand.Parameters.AddWithValue("@pretID", DBNull.Value); } sqlCommand.Parameters.AddWithValue("@produit", facture.getproduit()); if (facture.getdemand_id() != 0) { sqlCommand.Parameters.AddWithValue("@Demand", facture.getdemand_id()); } else { sqlCommand.Parameters.AddWithValue("@Demand", DBNull.Value); } sqlCommand.Parameters.AddWithValue("@prix", facture.getprix()); sqlCommand.ExecuteNonQuery(); } sqlCommand.Dispose(); sqlConnection.Close(); }