private void button1_Click(object sender, EventArgs e) { Module monMod = BDDExterne.GetModule(listBoxModuleDisponible.SelectedValue.ToString()); int newNumMod = BDDExterne.getMaxNumModuleByDevis(monDevis.devId.ToString()); newNumMod++; foreach (Parametre item in monMod.modParametres) { string query = @"INSERT INTO public.precise(id, id_parametre, id_devis, valeur, num_module) VALUES ('" + Guid.NewGuid().ToString() + "' , '" + item.parId.ToString() + "', '" + monDevis.devId.ToString() + "',0, " + newNumMod + ")"; if (BDDExterne.Insert(query) == false) { MessageBox.Show("echec insert"); } } dataModuleDevis.Clear(); foreach (Module item in BDDExterne.GetModulesByDevis(monDevis.devId.ToString())) { dataModuleDevis.Add(new ComboxItem() { Value = item.modId, Text = item.modLibele }); } listBoxModuleDevis.DataSource = null; listBoxModuleDevis.Items.Clear(); listBoxModuleDevis.DisplayMember = "Text"; listBoxModuleDevis.ValueMember = "Value"; listBoxModuleDevis.DataSource = dataModuleDevis; // ---- monDevis = BDDExterne.GetDevis(monDevis.devId.ToString()); labelNomClient.Text = monDevis.devClient.cliNom + " " + monDevis.devClient.cliPrenom; labelDevisDateCreation.Text = monDevis.devDateCreation.ToShortDateString(); foreach (Module item in BDDExterne.GetAllModules()) { data.Add(new ComboxItem() { Value = item.modId, Text = item.modLibele }); } listBoxModuleDisponible.DisplayMember = "Text"; listBoxModuleDisponible.ValueMember = "Value"; listBoxModuleDisponible.DataSource = data; foreach (Module item in BDDExterne.GetModulesByDevis(monDevis.devId.ToString())) { dataModuleDevis.Add(new ComboxItem() { Value = item.modId, Text = item.modLibele }); } listBoxModuleDevis.DisplayMember = "Text"; listBoxModuleDevis.ValueMember = "Value"; listBoxModuleDevis.DataSource = dataModuleDevis; }