/// <summary> /// Constructeur de la form AjouterArticle /// </summary> public AjouterArticle(FormMain Form, String PathToSave) { this.Form = Form; PathBdd = PathToSave; InitializeComponent(); SousFamillesDAO SousFamillesD = new SousFamillesDAO(PathBdd); List <SousFamilles> SousFamillesList = SousFamillesD.GetAllSousFamilles(); //remplissage des combobox foreach (SousFamilles Sf in SousFamillesList) { ComboBoxSousFamille.Items.Add(Sf); ComboBoxSousFamille.SelectedItem = ComboBoxSousFamille.Items[ComboBoxSousFamille.Items.IndexOf(Sf)]; } MarquesDAO MarquesD = new MarquesDAO(PathBdd); List <Marques> MarquesList = MarquesD.GetAllMarques(); foreach (Marques Mar in MarquesList) { ComboBoxMarque.Items.Add(Mar); ComboBoxMarque.SelectedItem = ComboBoxMarque.Items[ComboBoxMarque.Items.IndexOf(Mar)]; } }
// Chargement de la fenetre principale private void FormMain_Load(object sender, EventArgs e) { // listView1.ColumnClick += new ColumnClickEventHandler(ColumnClick); // Initialisation des variables Database data = new Database(); data.Connexion(); MarquesDAO marques = new MarquesDAO(data); SousFamilleDAO sousFamille = new SousFamilleDAO(data); FamilleDAO famille = new FamilleDAO(data); ArticlesDAO article = new ArticlesDAO(data); TreeNodeCollection nodes = treeView1.Nodes; // Recuperation des données ArrayList familyFound = famille.FindAll(); ArrayList marqueFound = marques.FindAll(); foreach (TreeNode n in nodes) { // Famille if (n.Name == "Familles") { foreach (string item in familyFound) { TreeNode newNode = new TreeNode(item); nodes[n.Index].Nodes.Insert(0, newNode); } // Sousfamille foreach (TreeNode n2 in nodes[n.Index].Nodes) { String nameFamily = n2.Text; ArrayList sousfamilyFound = sousFamille.Findbyfamily(nameFamily); foreach (string item in sousfamilyFound) { TreeNode newNode = new TreeNode(item); nodes[n.Index].Nodes[n2.Index].Nodes.Add(newNode); } } } // Marque else if (n.Name == "Marques") { foreach (string item in marqueFound) { TreeNode newNode = new TreeNode(item); nodes[n.Index].Nodes.Insert(0, newNode); } } } data.Close(); }
/** * Fonction that convert CSV ligne into data */ public void CSVLineToData(string readDescription, string readRefArticle, string readMarque, string readFamille, string readSous_famille, string Readprice) { ArticlesDAO DAOArticle = new ArticlesDAO(this); FamilleDAO DAOFamille = new FamilleDAO(this); MarquesDAO DAOMarque = new MarquesDAO(this); SousFamilleDAO DAOSSFamille = new SousFamilleDAO(this); Articles articles = new Articles(readDescription, readRefArticle, float.Parse(Readprice)); Familles familles = new Familles { refFamille = -1, familleName = readFamille }; Marques marques = new Marques { marqueName = readMarque }; SousFamilles sousfamille = new SousFamilles { sousFamilleName = readSous_famille }; // If famille doesn't exist if (!DAOFamille.Find <Familles>(ref familles)) { DAOFamille.CreateDAO <Familles>(ref familles); } // If Marque doesn't exist if (!DAOMarque.Find <Marques>(ref marques)) { DAOMarque.CreateDAO <Marques>(ref marques); } // If sousfamille doesn't exist if (!DAOSSFamille.Find <SousFamilles>(ref sousfamille)) { int id = DAOFamille.FindID <Familles>(ref familles); Familles NEwfamille = new Familles(id); sousfamille = new SousFamilles(readSous_famille, id); DAOSSFamille.CreateDAO <SousFamilles>(ref sousfamille); } // If Article doesn't exist if (!DAOArticle.Find <Articles>(ref articles)) { int idMarque = DAOMarque.FindID <Marques>(ref marques); int idSousFamille = DAOSSFamille.FindID <SousFamilles>(ref sousfamille); articles = new Articles(readDescription, readRefArticle, idMarque, idSousFamille, float.Parse(Readprice)); DAOArticle.CreateDAO <Articles>(ref articles); } else // else quantite +1 { articles.quantite += DAOArticle.Count <Articles>(ref articles); DAOArticle.Update <Articles>(ref articles); } }
//combox initialiser public void Marque_Box_Initialiser() { this.ComboBox_Marque.Items.Clear(); MarquesDAO Marque_DAO = new MarquesDAO(); List <Marques> MarquesListe = Marque_DAO.GetAll(); int CountM = 0; for (CountM = 0; CountM < MarquesListe.Count; CountM++) { this.ComboBox_Marque.Items.Add(MarquesListe[CountM].Ref_Marque_Operation); } }
/// <summary> /// Constructeur de la form ModifierArticle /// </summary> public ModifierArticle(FormMain Form, String PathToSave) { this.Form = Form; PathBdd = PathToSave; InitializeComponent(); Articles Ar = (Articles)Form.GetListView().SelectedItems[0].Tag; this.TextBoxDescription.Text = Ar.GetDescription(); AncienNom = Ar.GetDescription(); SousFamillesDAO SousFamillesD = new SousFamillesDAO(PathBdd); List <SousFamilles> SousFamillesList = SousFamillesD.GetAllSousFamilles(); //implémentation des combobox String SF = Form.GetListView().SelectedItems[0].SubItems[3].Text; foreach (SousFamilles Sf in SousFamillesList) { ComboBoxSousFamille.Items.Add(Sf); if (SF.Equals(Sf.GetNom())) { ComboBoxSousFamille.SelectedItem = ComboBoxSousFamille.Items[ComboBoxSousFamille.Items.IndexOf(Sf)]; } } MarquesDAO MarquesD = new MarquesDAO(PathBdd); List <Marques> MarquesList = MarquesD.GetAllMarques(); String M = Form.GetListView().SelectedItems[0].SubItems[4].Text; foreach (Marques Mar in MarquesList) { ComboBoxMarque.Items.Add(Mar); if (M.Equals(Mar.GetNom())) { ComboBoxMarque.SelectedItem = ComboBoxMarque.Items[ComboBoxMarque.Items.IndexOf(Mar)]; } } NumericUpDown.Value = Ar.GetQuantite(); }
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { // Initialisation listView1.Columns.Clear(); listView1.Items.Clear(); listView1.Groups.Clear(); Database data = new Database(); data.Connexion(); if (e.Node.Name == "Tous les articles") { listView1.Columns.Add("Description", 200, HorizontalAlignment.Center); listView1.Columns.Add("Familles", 100, HorizontalAlignment.Center); listView1.Columns.Add("Sous-Familles", 50, HorizontalAlignment.Center); listView1.Columns.Add("Marques", 50, HorizontalAlignment.Center); listView1.Columns.Add("Quantite", 50, HorizontalAlignment.Center); ListViewGroup listViewGroup = new ListViewGroup("un"); listView1.Groups.Add(listViewGroup); ArticlesDAO articles = new ArticlesDAO(data); ArrayList array = articles.FindAll(); foreach (string[] list in array) { ListViewItem lvi = new ListViewItem(list); listView1.Items.Add(lvi); } } else if (e.Node.Name == "Familles") { listView1.Columns.Add("Familles", 200, HorizontalAlignment.Center); FamilleDAO articles = new FamilleDAO(data); ArrayList array = articles.FindAll(); foreach (string list in array) { ListViewItem lvi = new ListViewItem(list); listView1.Items.Add(lvi); } } else if (e.Node.Name == "Marques") { listView1.Columns.Add("Marques", 200, HorizontalAlignment.Center); MarquesDAO articles = new MarquesDAO(data); ArrayList array = articles.FindAll(); foreach (string list in array) { ListViewItem lvi = new ListViewItem(list); listView1.Items.Add(lvi); } } else if (e.Node.Parent.Name == "Familles") // Famille { listView1.Columns.Add("Description", 200, HorizontalAlignment.Center); listView1.Columns.Add("Sous-Familles", 200, HorizontalAlignment.Center); listView1.Columns.Add("Marques", 100, HorizontalAlignment.Center); listView1.Columns.Add("Quantite", 50, HorizontalAlignment.Center); ArticlesDAO articles = new ArticlesDAO(data); string name = e.Node.Text; ArrayList array = articles.FindbyFamily(name); foreach (string[] list in array) { ListViewItem lvi = new ListViewItem(list); listView1.Items.Add(lvi); } } else if (e.Node.Parent.Name == "Marques") // Marques { listView1.Columns.Add("Description", 100, HorizontalAlignment.Center); listView1.Columns.Add("Quantite", 50, HorizontalAlignment.Center); ArticlesDAO articles = new ArticlesDAO(data); string name = e.Node.Text; ArrayList array = articles.FindbyMarques(name); foreach (string[] list in array) { ListViewItem lvi = new ListViewItem(list); listView1.Items.Add(lvi); } } else if (e.Node.Parent.Parent.Name == "Familles") // Sous famille { listView1.Columns.Add("Description", 100, HorizontalAlignment.Center); listView1.Columns.Add("Marques", 100, HorizontalAlignment.Center); listView1.Columns.Add("Quantite", 50, HorizontalAlignment.Center); ArticlesDAO articles = new ArticlesDAO(data); string name = e.Node.Text; ArrayList array = articles.FindbySousFamille(name); foreach (string[] list in array) { ListViewItem lvi = new ListViewItem(list); listView1.Items.Add(lvi); } } data.Close(); }