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; }
public void refresh() { 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; }
public ListeModuleParDevis(string idDevis) { InitializeComponent(); monDevis = BDDExterne.GetDevis(idDevis); 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(idDevis)) { dataModuleDevis.Add(new ComboxItem() { Value = item.modId, Text = item.modLibele }); } listBoxModuleDevis.DisplayMember = "Text"; listBoxModuleDevis.ValueMember = "Value"; listBoxModuleDevis.DataSource = dataModuleDevis; }
private void listBoxParam_DoubleClick(object sender, EventArgs e) { if (BDDExterne.ModifierValeurParam(listBoxParam.SelectedValue.ToString(), Int32.Parse(Microsoft.VisualBasic.Interaction.InputBox("entrer la nouvelle valeur", "Title", "").ToString())) == false) { MessageBox.Show("Erreur modification de la valeur"); } listBoxParam.DataSource = null; listBoxParam.Items.Clear(); List <ComboxItem> listComboxItemParam = new List <ComboxItem>(); monDevis = BDDExterne.GetDevis(monDevis.devId.ToString()); foreach (Parametre monParam in monDevis.modules[listBoxModuleDevis.SelectedIndex].modParametres) { listComboxItemParam.Add(new ComboxItem() { Value = monParam.parIdValeur, Text = monParam.parNom + " " + monParam.parValeur + " " + monDevis.modules[listBoxModuleDevis.SelectedIndex].uniteUsage }); } listBoxParam.DisplayMember = "Text"; listBoxParam.ValueMember = "Value"; listBoxParam.DataSource = listComboxItemParam; }