public static void SearchByReference()
{
Console.Title = "Par référence | Rechercher";
Console.Clear();
Console.WriteLine(FiggleFonts.Slant.Render(" Rechercher"));
Console.Write("Référence de l'article: ");
int searchByNumber;
bool input = int.TryParse(Console.ReadLine(), out searchByNumber);
if (input)
{
for (int i = 0; i < Stock.Count; i++)
{
if (Stock[i].Number.Equals(searchByNumber))
{
ConsoleMenu.DisplayTable(Stock[i].Number, Stock[i].Name, Stock[i].Price, Stock[i].Quantity);
}
}
}
else
{
ConsoleMenu.DisplayError("La valeur peut seulement être un chiffre, veuillez réessayer.");
}
Console.ReadKey();
}
public static void AddArticle()
{
Console.Clear();
Console.WriteLine(FiggleFonts.Slant.Render(" Ajouter"));
Console.Write("Numéro [0 = auto]: ");
int number = int.Parse(Console.ReadLine());
Console.Write("Nom: ");
string name = Console.ReadLine();
Console.Write("Prix: ");
float price = float.Parse(Console.ReadLine());
Console.Write("Quantité: ");
int quantity = int.Parse(Console.ReadLine());
bool numberExist = true;
if (number == 0)
{
number = GenerateId();
Stock.Add(new Article(number, name, price, quantity));
}
else
{
foreach (Article article in Stock)
{
if (article.Number.Equals(number))
{
ConsoleMenu.DisplayError("Ce numéro existe déjà, veuiller en saisir un nouveau.");
numberExist = false;
}
}
if (numberExist == true)
{
Stock.Add(new Article(number, name, price, quantity));
// TEST EXECUTION BDD
try {
using (var db = new Database())
{
db.Connection.Open();
using (var cmd = db.Connection.CreateCommand())
{
cmd.CommandText = @"INSERT INTO article VALUES (number, name, price, quantity)";
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
ConsoleMenu.DisplayTable(number, name, price, quantity);
Console.ReadKey();
}
public static void ShowAll()
{
Console.Clear();
Console.WriteLine(FiggleFonts.Slant.Render(" Articles"));
foreach (Article article in Stock)
{
ConsoleMenu.DisplayTable(article.Number, article.Name, article.Price, article.Quantity);
}
Console.ReadKey();
}
public static void DeleteArticle()
{
Console.Clear();
Console.WriteLine(FiggleFonts.Slant.Render(" Supprimer"));
Console.Write("Référence de l'article à supprimer: ");
int articleToDeleteById = int.Parse(Console.ReadLine());
for (int i = 0; i < Stock.Count; i++)
{
if (Stock[i].Number.Equals(articleToDeleteById))
{
ConsoleMenu.DisplayTable(Stock[i].Number, Stock[i].Name, Stock[i].Price, Stock[i].Quantity);
Stock.RemoveAt(i);
}
}
Console.WriteLine("Vous avez supprimé l'article");
Console.ReadKey();
}
public static void SearchByPriceInterval()
{
Console.Title = "Par Prix | Rechercher";
Console.Clear();
Console.WriteLine(FiggleFonts.Slant.Render(" Rechercher"));
Console.Write("Montant minimum: ");
float startPrice = float.Parse(Console.ReadLine());
Console.Write("Montant maximum: ");
float endPrice = float.Parse(Console.ReadLine());
//boucle for sur le nombre de ligne
foreach (Article article in Stock)
{ // if prix minimum entre prix max
if (article.Price >= (startPrice) && article.Price <= (endPrice))
{
ConsoleMenu.DisplayTable(article.Number, article.Name, article.Price, article.Quantity);
}
}
Console.ReadKey();
}
public static void SearchByName()
{
Console.Title = "Par Nom | Rechercher";
Console.Clear();
Console.WriteLine(FiggleFonts.Slant.Render(" Rechercher"));
Console.Write("Nom de l'article: ");
string nameInput = Console.ReadLine();
for (int i = 0; i < Stock.Count; i++)
{
if (Stock[i].Name.Equals(nameInput))
{
ConsoleMenu.DisplayTable(Stock[i].Number, Stock[i].Name, Stock[i].Price, Stock[i].Quantity);
}
else
{
ConsoleMenu.DisplayError("Erreur WIP.");
}
}
Console.ReadKey();
}