public static void saerchcompte(Compte V, int b)
{
V.setNum(b);
//UPDATE `compte` SET `Montant`=1234,`TypeCompt`='hello',`Numclient`=123 WHERE `NumCompte`=1
SqlCommand comm2 = new SqlCommand();
comm2.Connection = conan;
comm2.CommandText = "SELECT [Montant] FROM[dbo].[Compte] WHERE[NumCompte] = " + V.getNum() + "";
//comm2.CommandText = "SELECT * FROM[dbo].[Compte] WHERE[NumCompte] = 432879";
//V=(Compte)comm2.ExecuteScalar();
V.setMont((double)comm2.ExecuteScalar());
Console.WriteLine(V.getMont());
}
public static void Ajouter()
{
Console.Clear();
Console.WriteLine("==> entrer le numero de client ");
AjCli.setNum(int.Parse(Console.ReadLine()));
AjCmp.setNumclient(AjCli.getNum());
Console.WriteLine("==> entrer le nom ");
AjCli.setNom(Console.ReadLine());
Console.WriteLine("==> entrer le prenom ");
AjCli.setPrenom(Console.ReadLine());
Console.WriteLine("==> entrer le numero de GSM ");
AjCli.setGsm(Console.ReadLine());
Console.WriteLine("==> entrer E_mail ");
AjCli.setE_mail(Console.ReadLine());
Console.WriteLine("==> entrer le numero de compte ");
AjCmp.setNum(int.Parse(Console.ReadLine()));
Console.WriteLine("==> entrer le solde");
AjCmp.setMont(float.Parse(Console.ReadLine()));
Console.WriteLine("==> entrer le type ( courant/epargne)");
AjCmp.setType(Console.ReadLine());
ConnectionDb.Ajouter(AjCmp, AjCli);
AjCmp = new Compte();
AjCli = new Client();
}