public EmployeSession()
{
db = new AirAtlantiqueDBContext();
InitializeComponent();
var recup = MainWindow.envoi;
var reqES = from es in db.Employes_Sessions
where es.idSession == recup
orderby es.Employe.nom
select new { es.Employe.nom, es.Employe.prenom };
var reqID = from es in db.Employes_Sessions
where es.idSession == recup
orderby es.Employe.nom
select es.idEmploye;
var reqE = from e in db.Employes
where !reqID.Contains(e.id)
select new { e.nom, e.prenom };
foreach (var item in reqES)
{
LBoxEmployeSession.Items.Add(new Employe {
nom = item.nom, prenom = item.prenom
});
}
foreach (var item in reqE)
{
LBoxEmploye.Items.Add(new Employe {
nom = item.nom, prenom = item.prenom
});
}
}
public MainWindow()
{
db = new AirAtlantiqueDBContext();
InitializeComponent();
var req = from f in db.Formations select f.nom;
foreach (var item in req)
{
LBFormation.Items.Add(item);
}
}
