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;
}
public static Boolean SupprimerModule(string id)
{
foreach (Module item in BDDExterne.GetAllModules())
{
if (item.modId.ToString() == id)
{
NpgsqlConnection conn;
conn = new NpgsqlConnection(chaineConnection);
conn.Open();
NpgsqlCommand MyCmd = null;
// id, nom ,tel,numrue,codepostal,ville,pays,mail,nom rue
string query = @"DELETE FROM module CASCADE WHERE id == '" + id;
Debug.WriteLine(query);
MyCmd = new NpgsqlCommand(query, conn);
MyCmd.ExecuteNonQuery(); //Exécution
conn.Close();
return(true);
}
}
return(false);
}
