// 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();
}
private void InsertDB(List <List <String> > T)
{
for (int i = 1; i < T.Count; i++)
{
List <String> line = T[i];
// Create an instance of Class Articles
string description = line[0];
string refArticle = line[1];
string marque = line[2];
string famile = line[3];
string sousFamile = line[4];
string prixHT = line[5];
Articles artcle = new Articles(description, refArticle, marque, famile, sousFamile, prixHT);
ArticlesDAO ad = new ArticlesDAO();
ad.connectionDB(artcle);
}
}
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();
}
