public void AddMarque(String MarqueName, AddMarque AddMarque)
{
if (FamillesDao.FindFamilleByFamilleName(MarqueName))
{
MessageBox.Show("This name has already been used by a Famille!", "ERROR");
AddMarque.textBox_MarqueName.Text = "";
return;
}
if (SousFamillesDao.FindSousFamilleBySousFamilleName(MarqueName))
{
MessageBox.Show("This name has already been used by a SousFamille!", "ERROR");
AddMarque.textBox_MarqueName.Text = "";
return;
}
if (MarquesDao.FindMarqueByMarqueName(MarqueName))
{
MessageBox.Show("Marque Already exsited!", "ERROR");
AddMarque.textBox_MarqueName.Text = "";
return;
}
else
{
Marques Marque = new Marques(MarqueName);
Marque.RefMarque = MarquesDao.GetMaxRefMarque() + 1;
MarquesDao.AddMarque(Marque);
if (MarquesDao.FindMarqueByMarqueName(MarqueName))
{
MessageBox.Show("Add Marque succeed!");
AddMarque.Close();
}
}
}
private void ajouterToolStripMenuItem3_Click(object sender, EventArgs e)
{
AddMarque Add_Marque = new AddMarque();
Add_Marque.ShowDialog(this);
if (Add_Marque.DialogResult == DialogResult.OK)
{
listView_ShowBD_DataBinding();
this.ToolStripStatusLabel.Text = "You have added a brand!";
}
}
private string Add_Marque()
{
AddMarque AddMarque = new AddMarque()
{
StartPosition = FormStartPosition.CenterParent
};
AddMarque.ShowDialog(this);
if (AddMarque.textBox_MarqueName.Text != "")
{
MarqueNames.Add(AddMarque.textBox_MarqueName.Text);
}
return(AddMarque.textBox_MarqueName.Text);
}
public void FindAndModifyArticle(String RefArticle, String Description, String MarqueName, String FamilleName, String SousFamilleName, String PrixHT, String Quantite, ModifyArticle Form)
{
if (Description == "")
{
MessageBox.Show("Please enter the Description!", "ERROR");
}
else if (MarqueName == "")
{
MessageBox.Show("Please enter the Marque Name!", "ERROR");
}
else if (FamilleName == "")
{
MessageBox.Show("Please enter the Famille Name!", "ERROR");
}
else if (SousFamilleName == "")
{
MessageBox.Show("Please enter the SousFamille Name!", "ERROR");
}
else if (PrixHT == "")
{
MessageBox.Show("Please enter the Price!", "ERROR");
}
else if (Quantite == "")
{
MessageBox.Show("Please enter the Quantite!", "ERROR");
}
else if (!PrixHT.Contains(","))
{
MessageBox.Show("In our software, you must enter a price with ',' instead of '.'. If you want to enter an integer, please enter like '5,0'.");
}
else if (!int.TryParse(Quantite, out var Number))
{
MessageBox.Show("Please enter the right quantity!");
}
else
{
if (!SousFamillesDao.FindSousFamilleBySousFamilleName(SousFamilleName))
{
if (MessageBox.Show("SousFamille doesn't exsite! Do you want to add a new SousFamille?", "Confirm Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
AddSousFamille AddSousFamille = new AddSousFamille {
StartPosition = FormStartPosition.CenterParent
};
AddSousFamille.ShowDialog(Form);
}
else
{
return;
}
}
if (!MarquesDao.FindMarqueByMarqueName(MarqueName))
{
if (MessageBox.Show("Marque doesn't exsite! Do you want to add a new Marque?", "Confirm Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
AddMarque AddMarque = new AddMarque {
StartPosition = FormStartPosition.CenterParent
};
AddMarque.ShowDialog(Form);
}
else
{
return;
}
}
SousFamilles SousFamille = SousFamillesDao.FindSousFamillesBySousFamilleName(SousFamilleName);
Marques Marque = MarquesDao.FindMarquesByMarqueName(MarqueName);
Articles Article = new Articles(RefArticle, Description, FamillesDao.FindFamillesByRefSousFamille(SousFamille.RefSousFamille), SousFamille, Marque, double.Parse(PrixHT), int.Parse(Quantite));
if (!CompareArticles(ArticlesDao.FindArticlesByRefArticle(Article.RefArticle), Article))
{
ArticlesDao.ModifyArticle(Article);
if (ArticlesDao.FindArticleByRefArticle(Article.RefArticle))
{
MessageBox.Show("Modify succeed!");
Form.Close();
}
}
else
{
MessageBox.Show("The article can't be the same before and after modification!");
return;
}
}
}
/// <summary>
/// Modify an article of the database.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_Modify_Click(object sender, EventArgs e)
{
var Description = this.textBox_Description.Text;
var MarqueName = this.comboBox_Marque.Text;
var FamilleName = this.comboBox_Famille.Text;
var SousFamilleName = this.comboBox_SousFamille.Text;
var PrixHT = this.textBox_PrixHT.Text;
var Quantite = this.textBox_Quantite.Text;
if (Description == "")
{
MessageBox.Show("Please enter the Description!", "ERROR");
}
else if (MarqueName == "")
{
MessageBox.Show("Please enter the Marque Name!", "ERROR");
}
else if (FamilleName == "")
{
MessageBox.Show("Please enter the Famille Name!", "ERROR");
}
else if (SousFamilleName == "")
{
MessageBox.Show("Please enter the SousFamille Name!", "ERROR");
}
else if (PrixHT == "")
{
MessageBox.Show("Please enter the Price!", "ERROR");
}
else if (Quantite == "")
{
MessageBox.Show("Please enter the Quantite!", "ERROR");
}
else if (!float.TryParse(PrixHT, out var Prix))
{
MessageBox.Show("Please enter the right price!");
}
else if (!int.TryParse(Quantite, out var Number))
{
MessageBox.Show("Please enter the right quantity!");
}
else
{
if (!SousFamilleController.FindSousFamilleBySousFamilleName(SousFamilleName))
{
if (MessageBox.Show("SousFamille doesn't exsite! Do you want to add a new SousFamille?", "Confirm Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
AddSousFamille AddSousFamille = new AddSousFamille {
StartPosition = FormStartPosition.CenterParent
};
AddSousFamille.ShowDialog(this);
}
else
{
return;
}
}
if (!MarqueController.FindMarqueByMarqueName(MarqueName))
{
if (MessageBox.Show("Marque doesn't exsite! Do you want to add a new Marque?", "Confirm Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
AddMarque AddMarque = new AddMarque {
StartPosition = FormStartPosition.CenterParent
};
AddMarque.ShowDialog(this);
}
else
{
return;
}
}
SousFamilles SousFamille = SousFamilleController.FindSousFamillesBySousFamilleName(SousFamilleName);
Marques Marque = MarqueController.FindMarquesByMarqueName(MarqueName);
Articles Article = new Articles(this.label_ReferenceArticle.Text, Description, FamilleController.FindFamillesByRefSousFamille(SousFamille.RefSousFamille), SousFamille, Marque, float.Parse(PrixHT), int.Parse(Quantite));
if (!ArticleController.CompareArticles(ArticleController.FindArticlesByRefArticle(Article.RefArticle), Article))
{
ArticleDao.ModifyArticle(Article);
if (ArticleController.FindArticleByRefArticle(Article.RefArticle))
{
MessageBox.Show("Modify succeed!");
this.Close();
}
}
else
{
MessageBox.Show("The article can't be the same before and after modification!");
return;
}
}
}
