/// <summary>
/// Modify a marque of the database.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_Modify_Click(object sender, EventArgs e)
{
var MarqueName = this.textBox_NewMarqueName.Text;
if (MarqueName == "")
{
MessageBox.Show("Please enter the Marque Name!", "ERROR");
return;
}
else if (MarqueName == this.label_Marque_Name.Text)
{
MessageBox.Show("MarqueName can't be the same before and after modification!", "ERROR");
this.textBox_NewMarqueName.Text = "";
return;
}
else if (MarqueName == "Familles")
{
MessageBox.Show("MarqueName can't be Familles!", "ERROR");
this.textBox_NewMarqueName.Text = "";
return;
}
else if (MarqueName == "Marques")
{
MessageBox.Show("MarqueName can't be Marques!", "ERROR");
this.textBox_NewMarqueName.Text = "";
return;
}
else if (MarqueName == "Tous les articles")
{
MessageBox.Show("MarqueName can't be Tous les articles!", "ERROR");
this.textBox_NewMarqueName.Text = "";
return;
}
else if (FamilleController.FindFamilleByFamilleName(MarqueName))
{
MessageBox.Show("This name has already been used by a Famille!", "ERROR");
this.textBox_NewMarqueName.Text = "";
return;
}
else if (SousFamilleController.FindSousFamilleBySousFamilleName(MarqueName))
{
MessageBox.Show("This name has already been used by a SousFamille!", "ERROR");
this.textBox_NewMarqueName.Text = "";
return;
}
else if (MarqueController.FindMarqueByMarqueName(MarqueName))
{
MessageBox.Show("Marque Already exsited!", "ERROR");
this.textBox_NewMarqueName.Text = "";
return;
}
else
{
Marques Marque = MarqueController.FindMarquesByMarqueName(this.label_Marque_Name.Text);
Marque.MarqueName = MarqueName;
MarqueDao.ModifyMarque(Marque);
if (MarqueController.FindMarqueByMarqueName(Marque.MarqueName))
{
MessageBox.Show("Modify succeed!");
this.Close();
}
else
{
MessageBox.Show("Modify Failed!");
}
}
}
/// <summary>
/// Add an article to the database.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_Add_Click(object sender, EventArgs e)
{
var RefArticle = this.textBox_RefArticle.Text;
var Description = this.textBoxDescription.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 (RefArticle == "")
{
MessageBox.Show("Please enter the RefArticle!", "ERROR");
}
else if (Description == "")
{
MessageBox.Show("Please enter the Description!", "ERROR");
}
else if (PrixHT == "")
{
MessageBox.Show("Please enter the Price!", "ERROR");
}
else if (Quantite == "")
{
MessageBox.Show("Please enter the Quantite!", "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 (RefArticle.Length >= 15)
{
MessageBox.Show("RefArticle is too long! The maximum length of the RefArticle is 15!");
}
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 (ArticleController.FindArticleByRefArticle(RefArticle))
{
MessageBox.Show("Article Already exsited!", "ERROR");
}
else
{
if (!SousFamilleController.FindSousFamilleBySousFamilleName(SousFamilleName))
{
var Result = MessageBox.Show("SousFamille doesn't exsite! Do you want to add a new SousFamille?", "Confirm Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (Result == DialogResult.OK)
{
AddSousFamille AddSousFamille = new AddSousFamille {
StartPosition = FormStartPosition.CenterParent
};
AddSousFamille.ShowDialog(this);
}
else
{
return;
}
}
if (!MarqueController.FindMarqueByMarqueName(MarqueName))
{
var Result = MessageBox.Show("Marque doesn't exsite! Do you want to add a new Marque?", "Confirm Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (Result == DialogResult.OK)
{
Marques NewMarque = new Marques(MarqueName);
NewMarque.RefMarque = MarqueDao.GetMaxRefMarque() + 1;
MarqueDao.AddMarque(NewMarque);
}
else
{
return;
}
}
SousFamilles SousFamille = SousFamilleController.FindSousFamillesBySousFamilleName(SousFamilleName);
Marques Marque = MarqueController.FindMarquesByMarqueName(MarqueName);
string Price = float.Parse(PrixHT).ToString();
Price = Price.Replace(".", ",");
Articles Article = new Articles(RefArticle, Description, FamilleController.FindFamillesByRefSousFamille(SousFamille.RefSousFamille), SousFamille, Marque, float.Parse(Price), int.Parse(Quantite));
ArticleDao.AddArticle(Article);
if (ArticleController.FindArticleByRefArticle(RefArticle))
{
MessageBox.Show("Add Article succeed!");
this.Close();
}
}
}
/// <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;
}
}
}