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(); } } }
/// <summary> /// Add a marque to the database. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button_Add_Click(object sender, EventArgs e) { var MarqueName = this.textBox_MarqueName.Text; if (MarqueName == "") { MessageBox.Show("Please enter the Marque Name!", "ERROR"); return; } if (MarqueName == "Familles") { MessageBox.Show("MarqueName can't be Familles!", "ERROR"); this.textBox_MarqueName.Text = ""; return; } if (MarqueName == "Marques") { MessageBox.Show("MarqueName can't be Marques!", "ERROR"); this.textBox_MarqueName.Text = ""; return; } if (MarqueName == "Familles") { MessageBox.Show("MarqueName can't be Familles!", "ERROR"); this.textBox_MarqueName.Text = ""; return; } if (MarqueName == "Tous les articles") { MessageBox.Show("MarqueName can't be Tous les articles!", "ERROR"); this.textBox_MarqueName.Text = ""; return; } if (FamilleController.FindFamilleByFamilleName(MarqueName)) { MessageBox.Show("This name has already been used by a Famille!", "ERROR"); this.textBox_MarqueName.Text = ""; return; } if (SousFamilleController.FindSousFamilleBySousFamilleName(MarqueName)) { MessageBox.Show("This name has already been used by a SousFamille!", "ERROR"); this.textBox_MarqueName.Text = ""; return; } if (MarqueController.FindMarqueByMarqueName(MarqueName)) { MessageBox.Show("Marque Already exsited!", "ERROR"); this.textBox_MarqueName.Text = ""; return; } else { Marques Marque = new Marques(MarqueName); Marque.RefMarque = MarqueDao.GetMaxRefMarque() + 1; MarqueDao.AddMarque(Marque); if (MarqueController.FindMarqueByMarqueName(MarqueName)) { MessageBox.Show("Add Marque succeed!"); this.Close(); } } }
/// <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(); } } }
public void AddArticle(String RefArticle, String Description, String MarqueName, String FamilleName, String SousFamilleName, String PrixHT, String Quantite, Form Form) { 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 (!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(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 (FindArticleByRefArticle(RefArticle)) { MessageBox.Show("Article Already exsited!", "ERROR"); } else { if (!SousFamillesDao.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(Form); } else { return; } } if (!MarquesDao.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 = MarquesDao.GetMaxRefMarque() + 1; MarquesDao.AddMarque(NewMarque); } 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)); ArticlesDao.AddArticle(Article); if (ArticlesDao.FindArticleByRefArticle(RefArticle)) { MessageBox.Show("Add Article succeed!"); Form.Close(); } } }