private void AlimenterListeOffre()
{
lstOffre = new ObservableCollection <OVOffre>();
String loadOffre = "SELECT Identifiant, Libelle, Reference, DateDebutPublication, DateFinPublication, DateDebutContrat, DateFinContrat, DescriptionPoste, DescriptionProfil, NombresPoste, IdentifiantClient, IdentifiantMetier, IdentifiantContrat FROM offre";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = loadOffre;
MySqlDataAdapter ad = new MySqlDataAdapter();
ad.SelectCommand = cmd;
cmd.Connection = connect.con;
DataSet ds = new DataSet();
ad.Fill(ds);
foreach (DataRowView rowView in ds.Tables[0].DefaultView)
{
OVOffre ovOffre = new OVOffre();
ovOffre.Identifiant = int.Parse(rowView["Identifiant"].ToString());
ovOffre.Libelle = rowView["Libelle"].ToString();
ovOffre.Reference = rowView["Reference"].ToString();
ovOffre.DateDebutPublication = Convert.ToDateTime(rowView["DateDebutPublication"].ToString());
ovOffre.DateFinPublication = Convert.ToDateTime(rowView["DateFinPublication"].ToString());
ovOffre.DateDebutContrat = Convert.ToDateTime(rowView["DateDebutContrat"].ToString());
ovOffre.DateFinContrat = Convert.ToDateTime(rowView["DateFinContrat"].ToString());
ovOffre.DescriptionPoste = rowView["DescriptionPoste"].ToString();
ovOffre.DescriptionProfil = rowView["DescriptionProfil"].ToString();
ovOffre.NombresPoste = int.Parse(rowView["NombresPoste"].ToString());
ovOffre.IdentifiantClient = int.Parse(rowView["IdentifiantClient"].ToString());
ovOffre.IdentifiantMetier = int.Parse(rowView["IdentifiantMetier"].ToString());
ovOffre.IdentifiantContrat = int.Parse(rowView["IdentifiantContrat"].ToString());
lstOffre.Add(ovOffre);
}
}
private void listBoxOffre_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
OVOffre ovOffre = new OVOffre();
ovOffre = (OVOffre)listBoxOffre.SelectedItem;
string IdOffreChanged = ovOffre.Identifiant.ToString();
string connectionString = "SERVER=localhost" + ";" + "DATABASE=megacastingv2" + ";" + "UID=root" + ";" + "PASSWORD="******";";
string Query = @"SELECT * FROM offre WHERE Identifiant = '" + IdOffreChanged + "';";
MySqlConnection MyConn = new MySqlConnection(connectionString);
MySqlCommand MyCommand = new MySqlCommand(Query, MyConn);
MySqlDataReader MyReader;
MyConn.Open();
MyReader = MyCommand.ExecuteReader();
//Remplir TextBox selon client selectionné
tbLibelleEts.Text = ovOffre.Libelle;
tbRef.Text = ovOffre.Reference;
dpDebutPub.Text = ovOffre.DateDebutPublication.ToString();
dpFinPub.Text = ovOffre.DateFinPublication.ToString();
dpDebutCtr.Text = ovOffre.DateDebutContrat.ToString();
dpFinCtr.Text = ovOffre.DateFinContrat.ToString();
tbDescPoste.Text = ovOffre.DescriptionPoste;
tbDescProfil.Text = ovOffre.DescriptionProfil;
tbNbPoste.Text = ovOffre.NombresPoste.ToString();
cbIdClt.Text = ovOffre.IdentifiantClient.ToString();
cbIdMetier.Text = ovOffre.IdentifiantMetier.ToString();
cbIdCtr.Text = ovOffre.IdentifiantContrat.ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
