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