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é !!");
}
