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());
}
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);
}
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 !! ");
}
}
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 !!! ");
}
}
public static void CommandeAjouter()
{
ArticleDAL.Add(GetArticleFormUser());
}
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);
}