/// <summary>
/// Export datas in a CSV file.
/// </summary>
/// <param name="Filename">Path of the CSV file.</param>
public void Export(string Filename)
{
List <ParserModel> ListToWrite = new List <ParserModel>();
/* Creating data objects */
Console.WriteLine("[Debug: Bacchus.view.CSVManagerViewModel.readCSV] Getting data objects.");
List <ArticlesModel> Articles = ArticlesDao.SelectAll();
foreach (ArticlesModel Article in Articles)
{
ParserModel ElementToAdd = new ParserModel();
ElementToAdd.Description = Article.Description;
ElementToAdd.Ref = Article.RefArticle;
ElementToAdd.Marque = Article.Marque.Nom;
ElementToAdd.Famille = Article.SousFamille.Famille.Nom;
ElementToAdd.SousFamille = Article.SousFamille.Nom;
ElementToAdd.Prix = Article.PrixHT;
ListToWrite.Add(ElementToAdd);
}
if (WriteCSV(ListToWrite, Filename))
{
AdvertBox("Le transfert a été effectué avec succès.", "information");
ExportWindow.Close();
}
}
/// <summary>
/// Get all the Articles saved in Database.
/// </summary>
public void ShowAllArticles()
{
List <ArticlesModel> ArticleToVis = ArticlesDao.SelectAll();
TypeShown = "Articles";
ListToDisplay.Clear();
ListToDisplay.Columns.Add("Description", -2, HorizontalAlignment.Left);
ListToDisplay.Columns.Add("Famille", -2, HorizontalAlignment.Left);
ListToDisplay.Columns.Add("Sous-Famille", -2, HorizontalAlignment.Left);
ListToDisplay.Columns.Add("Marque", -2, HorizontalAlignment.Left);
ListToDisplay.Columns.Add("Quantite", -2, HorizontalAlignment.Left);
foreach (ArticlesModel Article in ArticleToVis)
{
var Item = new ListViewItem(Article.Description, 0);
Item.SubItems.Add(Article.SousFamille.Famille.Nom);
Item.SubItems.Add(Article.SousFamille.Nom);
Item.SubItems.Add(Article.Marque.Nom);
Item.SubItems.Add(Article.Quantite.ToString());
ListToDisplay.Items.Add(Item);
Item.Name = Article.RefArticle;
}
}
