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