Ejemplo n.º 1
0
        public static void CommandeModifier()
        {
            Console.Write(" Reference de l'article à modifier : ");
            int Ref = int.Parse(Console.ReadLine());

            Console.WriteLine("\n < Nouvelles Données > ");
            ArticleDAL.Update(Ref, GetArticleFormUser());
        }
Ejemplo n.º 2
0
        public static void CommandeSupprimer()
        {
            Console.ForegroundColor = ConsoleColor.Blue;
            Console.Write(" Reference de l'article a supprimer : ");
            int Ref = int.Parse(Console.ReadLine());

            ArticleDAL.Delete(Ref);
        }
Ejemplo n.º 3
0
        public static void CommandeAfficherTout()
        {
            List <Article> list = ArticleDAL.SelectAll();

            if (list.Count != 0)
            {
                Console.WriteLine("   _________________________________");
                Console.WriteLine("  | Ref  |   Designation  |  Prix   |");
                Console.WriteLine("  |------|----------------|---------|");
                Show(list);
            }
            else
            {
                Console.WriteLine(" La base de données est vide !! ");
            }
        }
Ejemplo n.º 4
0
        public static void CommandeChercherParReference()
        {
            Article Art = new Article();

            Console.Write(" Reference de l'article : ");
            int Ref = int.Parse(Console.ReadLine());

            Console.WriteLine();

            Art = ArticleDAL.SelectByRef(Ref);

            if (Art != null)
            {
                Console.ForegroundColor = ConsoleColor.Green;
                Console.WriteLine("   _________________________________");
                Console.WriteLine("  | Ref  |   Designation  |  Prix   |");
                Console.WriteLine("  |------|----------------|---------|");
                Show(Art);
            }
            else
            {
                Console.WriteLine(" Reference non valide !!! ");
            }
        }
Ejemplo n.º 5
0
 public static void CommandeAjouter()
 {
     ArticleDAL.Add(GetArticleFormUser());
 }
Ejemplo n.º 6
0
        public static void Menu()
        {
            string Link = @"C:\Users\kevin\Documents\vente.accdb";

            bool Quit = false;


            ArticleDAL.ConnectTo(Link);


            do
            {
                Console.ResetColor();
                Console.ForegroundColor = ConsoleColor.White;

                int Choice;
                Console.WriteLine("\n");
                Console.WriteLine("           - Main -                             ");
                Console.WriteLine(" -------------------------------");
                Console.WriteLine(" 1. Afficher tout                            ");
                Console.WriteLine(" 2. Ajouter un Article                   ");
                Console.WriteLine(" 3. Supprimer un Article             ");
                Console.WriteLine(" 4. Modifier un Article                 ");
                Console.WriteLine(" 5. Rechercher par Reference    ");
                Console.WriteLine(" 6. Quitter                                     ");
                Console.WriteLine(" 7. Vider la console                       ");
                Console.WriteLine("--------------------------------");
                Console.Write(" ==> : ");
                Choice = int.Parse(Console.ReadLine());

                switch (Choice)
                {
                case 1:
                {
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine();
                    CommandeAfficherTout();
                    Console.WriteLine("\n");
                    break;
                }

                case 2:
                {
                    Console.ForegroundColor = ConsoleColor.Blue;
                    Console.WriteLine();
                    CommandeAjouter();
                    Console.WriteLine("\n");
                    break;
                }

                case 3:
                {
                    Console.ForegroundColor = ConsoleColor.Green;
                    Console.WriteLine();
                    CommandeSupprimer();
                    Console.WriteLine("\n");
                    break;
                }

                case 4:
                {
                    Console.ForegroundColor = ConsoleColor.Yellow;
                    Console.WriteLine();
                    CommandeModifier();
                    Console.WriteLine("\n");
                    break;
                }

                case 5:
                {
                    Console.ForegroundColor = ConsoleColor.DarkCyan;
                    Console.WriteLine();
                    CommandeChercherParReference();
                    Console.WriteLine("\n");
                    break;
                }

                case 6:
                    Quit = true;
                    break;

                case 7:
                {
                    Console.Clear();
                    break;
                }
                }
            } while (Quit != true);
        }