/// <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; } }