public void deleteFromOperationClient(OperationClient op) { try { string req = "DELETE FROM operationclient WHERE codeoperationclient like '" + op.Code + "';"; commande.CommandText = req; commande.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message + "delete into ope client"); } }
public void insertIntoOperationClient(OperationClient op) { try { string req = "insert into operationclient values('" + op.Code + "','" + op.Client.Code + "','" + op.Paiement.ModePaiement + "','" + op.Paiement.Montant + "','" + op.Paiement.Regler + "','" + op.Paiement.Reste + "','" + op.Designation + "','" + op.Quantite + "','" + op.PrixUnitaire + "','" + op.DateOperation.Year + "-" + op.DateOperation.Month + "-" + op.DateOperation.Day + "')"; commande.CommandText = req; commande.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message + "insert into ope client"); } }
public ModifyOperationClient(OperationClient operation) { InitializeComponent(); this.operation = operation; }