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