public CreateCompetence()
{
InitializeComponent();
this.DataContext = this;
using (var db = new BBD_projetEntities())
{
var val = db.LangueParDefaut();
var req = from c in db.OffrantParCompetenceAvecLangueEtIntituleActu(8, 3)
select c;
foreach (var v in req)
{
this.DataContext = v.Description;
}
var req2 = from c in db.Langues
select c;
var List = BO.Langue.ListDALtoBO(req2.ToList());
list.ItemsSource = List;
list.SelectedValuePath = "Id_Langue";
var req3 = from c in db.Competences
where c.Actuel == true && c.Actif == true
select new BO.Competence {
Actuel = c.Actuel,
IntituleCompetence = c.IntituleCompetences.Where(b => b.Id_Langue == val).Select(b => b.intitule).FirstOrDefault(),
Annee = c.Annee,
Id_Competence = c.Id_Competence,
Id_CompetenceActuel = c.Id_CompetenceActuel
};
list.SelectedIndex = List.IndexOf(List.Where(c => c.Id_Langue == val).Select(c => c).FirstOrDefault());
list2.ItemsSource = req3.ToList();
C3.SelectedDate = DateTime.Now;
}
}
public ModificationCompetence(BO.Competence competence)
{
InitializeComponent();
Competence = competence;
using (var db = new BBD_projetEntities())
{
var val = db.LangueParDefaut();
var req = from c in db.OffrantParCompetenceAvecLangueEtIntituleActu(8, 3)
select c;
foreach (var v in req)
{
this.DataContext = v.Description;
}
var req2 = from c in db.Langues
select c;
var List = BO.Langue.ListDALtoBO(req2.ToList());
list.ItemsSource = List;
list.SelectedValuePath = "Id_Langue";
var req3 = from c in db.Competences
where c.Actuel == true && c.Actif == true
select new BO.Competence
{
Actuel = c.Actuel,
IntituleCompetence = c.IntituleCompetences.Where(b => b.Id_Langue == val).Select(b => b.intitule).FirstOrDefault(),
Annee = c.Annee,
Id_Competence = c.Id_Competence,
Id_CompetenceActuel = c.Id_CompetenceActuel
};
list2.ItemsSource = req3.ToList();
//Actif
this.Actif = Competence.Actif;
if (this.Actif == true)
{
B_Actif.IsChecked = true;
}
//Actuel
this.Actuel = Competence.Actuel;
if (this.Actuel == true)
{
B_Actuel.IsChecked = true;
}
}
}