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 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 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;
}
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;
}
public static Boolean AjouterDevis(Devis monDevis)
{
try
{
NpgsqlConnection conn;
conn = new NpgsqlConnection(chaineConnection);
conn.Open();
NpgsqlCommand MyCmd = null;
// id, nom ,tel,numrue,codepostal,ville,pays,mail,nom rue
// id,fouNom fouTel, fouAdrNumero, fouAdrRue, fouAdrCodePostal,fouVille, fouPays, fouMail
string query = @"INSERT INTO public.devis(id, status, date_creation, ""id_Client"", ""id_Salarie"")VALUES ('" + monDevis.devId.ToString() + "'," + monDevis.devStatut + ", '" + DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + "', '" + monDevis.devClient.cliId.ToString() + "','" + monDevis.devSalarie.salId.ToString() + "');";
Debug.WriteLine(query);
MyCmd = new NpgsqlCommand(query, conn);
MyCmd.ExecuteNonQuery(); //Exécution
conn.Close();
return(true);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return(false);
}
}
