static void Main(string[] args) { Magazin Mag = new Magazin(); Fournisseur F = new Fournisseur(); Article Art = new Article(); Connexion.ConnectTo(); //Operations.AjoutArticle(Art); //Operations.AjoutFournisseur(F); //Operations.AjoutMagazin(Mag); /* ----------------------------------*/ Operations.ArtPvX(); Console.WriteLine("\n"); Operations.LocMag(); Console.WriteLine("\n"); Operations.ArtCoulPoidsX(Art); Console.WriteLine("\n"); Operations.PoidsPaX(); Console.WriteLine("\n"); Operations.PaSupX(); Console.WriteLine("\n"); Operations.MargeB(); Console.WriteLine("\n"); Operations.MoyMaxMin(); Console.WriteLine("\n"); Operations.DiffCouleurArt(); Console.WriteLine("\n"); Operations.MoyPV(); Console.WriteLine("\n"); Operations.SomPV(); Console.WriteLine("\n"); Operations.FrsCouleurX(); Console.WriteLine("\n"); Operations.MinPvCoulX(); Console.WriteLine("\n"); Operations.GerantLocX(); Console.WriteLine("\n"); Operations.ArtPvSupX(); Console.WriteLine("\n"); Operations.MagLocX(); Console.WriteLine("\n"); Operations.ArtPrixVCher(); }
public static void AjoutMagazin(Magazin M) { Console.Write(" Num Magazin : "); M.NumMag = int.Parse(Console.ReadLine()); Console.Write(" Localisation : "); M.LocMag = Console.ReadLine(); Console.Write(" Nom du gerant : "); M.Gerant = Console.ReadLine(); cmd = new MySqlCommand(" Insert into magazin values(@NumMag, @LocMag, @GerantMag)", Connexion.Connect); cmd.Parameters.AddWithValue("@NumMag", M.NumMag); cmd.Parameters.AddWithValue("@LocMag", M.LocMag); cmd.Parameters.AddWithValue("@GerantMag", M.Gerant); cmd.ExecuteNonQuery(); Console.WriteLine(" Ajout effectué !!"); }