public AddFamille() { InitializeComponent(); FamillyController Familly_Controller = new FamillyController(); Text_Box_Reference.Text = (Familly_Controller.GetMaxFamillyId() + 1).ToString(); }
/// <summary> /// Get the informations of the selected item /// </summary> /// <param name="SelectedFamily"></param> public void GetFamilyToModify(ListViewItem SelectedFamily) { FamillyController FamController = new FamillyController(); Familly FamilyToModify = new Familly(); FamilyToModify = FamController.GetFamillyByRef(Convert.ToInt32(SelectedFamily.Text)); this.txtBox_ReferenceF.Text = FamilyToModify.RefFamille1.ToString(); this.txtBox_NameF.Text = FamilyToModify.Nom1.ToString(); }
/// <summary> /// initialisation /// </summary> private void InitializeForm() { FamillyController Familly_Controller = new FamillyController(); List <Familly> List_Familly = Familly_Controller.GetAllFamilly(); foreach (Familly Familly in List_Familly) { this.comboBox_F.Items.Add(Familly.Nom1); } }
/// <summary> /// initialisation of the add subfamily form /// </summary> private void InitializeForm() { FamillyController Familly_Controller = new FamillyController(); List <Familly> List_Familly = Familly_Controller.GetAllFamilly(); SubFamillyController Sub_Familly_Controller = new SubFamillyController(); Text_Box_Reference.Text = (Sub_Familly_Controller.GetMaxSubFamillyId() + 1).ToString(); foreach (Familly Familly in List_Familly) { Combo_Box_Famille.Items.Add(Familly.Nom1); //Combo_Box_Famille.SelectedIndex = 0; } }
/// <summary> /// Subimit the modification of Family /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Btn_MF_Submit_Click(object sender, EventArgs e) { RefFamily = txtBox_ReferenceF.Text; NameFamily = txtBox_NameF.Text; int RefFamily_Int = int.Parse(RefFamily); FamillyController Family_Controller = new FamillyController(); Familly Family = Family_Controller.GetFamillyByRef(RefFamily_Int); Family_Controller.UpdateFamilly(RefFamily_Int, NameFamily); MessageBox.Show("Family modified successfully ;)", "Family modified", MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; this.Dispose(); }
/// <summary> /// load all the families to the family listiew /// </summary> private void LoadFamillies() { this.familleListView.Items.Clear(); FamillyController Familly_Controller = new FamillyController(); List <Familly> List_Familly = Familly_Controller.GetAllFamilly(); foreach (Familly Familly in List_Familly) { ListViewItem refItem = new ListViewItem(Convert.ToString(Familly.RefFamille1)); ListViewItem.ListViewSubItem nomItem = new ListViewItem.ListViewSubItem(refItem, Familly.Nom1); refItem.SubItems.Add(nomItem); familleListView.Items.Add(refItem); } }
/// <summary> /// delete a family and update it on time /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DeleteToolStripMenuItem1_Click(object sender, EventArgs e) { FamillyController Familly_Controller = new FamillyController(); if (SelectedFamily != null) { Response Response = Familly_Controller.DeleteFamilly(int.Parse(SelectedFamily.Text)); if (Response.State1) { LoadFamillies(); } else { MessageBox.Show(Response.Message1, "Failed", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
/// <summary> /// add subfamily /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Btn_Add_Sous_Famille_Click(object sender, EventArgs e) { String Reference = Text_Box_Reference.Text; String Name = Text_Box_Name.Text; int Familly_Index = Combo_Box_Famille.SelectedIndex; if (Familly_Index > -1 && !Reference.Equals("") && !Name.Equals("")) { try { int Reference_Int = int.Parse(Reference); SubFamillyController Sub_Familly_Controller = new SubFamillyController(); SubFamilly Sub_Familly = Sub_Familly_Controller.GetSubFamillyByRef(Reference_Int); List <Familly> List_Familly = new FamillyController().GetAllFamilly(); int Reference_Familly = List_Familly[Familly_Index].RefFamille1; if (Sub_Familly == null) { Sub_Familly_Controller.InsertSubFamilly(Reference_Int, Reference_Familly, Name); MessageBox.Show("Sub Familly added successfully ;)", "Sub Familly Added", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Sub Familly exists already in database", "Error Add Sub Familly", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } this.DialogResult = DialogResult.OK; this.Dispose(); } catch (FormatException e1) { MessageBox.Show(e1.Message, "Error Add Sub Familly", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Please fill in all the fields", "Error Add Sub Familly", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// load all the subfamilies /// </summary> private void LoadSubFamillies() { this.List_View_Sous_Famille.Items.Clear(); SubFamillyController Sub_Familly_Controller = new SubFamillyController(); List <SubFamilly> List_Sub_Familly = Sub_Familly_Controller.GetAllSubFamilly(); foreach (SubFamilly SubFamilly in List_Sub_Familly) { ListViewItem Item = new ListViewItem(Convert.ToString(SubFamilly.RefSousFamille1)); ListViewItem.ListViewSubItem Name_Item = new ListViewItem.ListViewSubItem(Item, SubFamilly.Nom1); Item.SubItems.Add(Name_Item); FamillyController Familly_Controller = new FamillyController(); Familly Familly = Familly_Controller.GetFamillyByRef(SubFamilly.RefFamille1.RefFamille1); ListViewItem.ListViewSubItem familly_Item = new ListViewItem.ListViewSubItem(Item, Familly != null ? Familly.Nom1 : ""); Item.SubItems.Add(familly_Item); List_View_Sous_Famille.Items.Add(Item); } }
/// <summary> /// add family button listner /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Btn_Add_Famille_Click(object sender, EventArgs e) { FamillyController Familly_Controller = new FamillyController(); String Reference = Text_Box_Reference.Text; String Name = Text_Box_Name.Text; if (!Reference.Equals("") && !Name.Equals("")) { try { int Reference_Int = int.Parse(Reference); Familly Familly = Familly_Controller.GetFamillyByRef(Reference_Int); if (Familly == null) { Familly_Controller.InsertFamilly(Reference_Int, Name); MessageBox.Show("Familly added successfully ;) ", "Added Successfully", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("This reference already exists in DataBase", "Error Add Familly", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } this.DialogResult = DialogResult.OK; this.Dispose(); } catch (FormatException e2) { MessageBox.Show(e2.Message, "Error add familly ", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Please fill in all fields", "Error Add Familly ", MessageBoxButtons.OK, MessageBoxIcon.Error); } }