public Groupe()
{
InitializeComponent();
Date.BlackoutDates.Add(new CalendarDateRange(new DateTime(1990, 1, 1),
DateTime.Now.AddDays(-1)));
using (var db = new BBD_projetEntities())
{
var val = db.LangueParDefaut();
var participant = from employe in db.Employes
select new BO.Employe
{
Nom = employe.Nom,
Prenom = employe.Prenom,
Service = employe.Service,
Id_Employe = employe.Id_Employe
};
var competence = from c in db.Competences
where c.Actif == true && c.Actuel == 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
};
//Particpant
ListViewParticipant.ItemsSource = participant.ToList();
ListViewParticipant.MouseDoubleClick += (sender, e) =>
{
var Nouveauparticipant = ((BO.Employe)ListViewParticipant.SelectedItem);
var verifdoublons = 0;
foreach (var x in ListParticipant)
{
if (x.Id_Employe == Nouveauparticipant.Id_Employe)
{
verifdoublons = 1;
}
}
if (verifdoublons == 0)
{
ListParticipant.Add(Nouveauparticipant);
foreach (var x in ListBoxTuteur.ItemsSource)
{
System.Diagnostics.Debug.WriteLine(((BO.Employe)x).Nom);
}
ListBoxTuteur.Items.Refresh();
}
};
//Tuteur
ListBoxTuteur.ItemsSource = ListParticipant;
ListBoxTuteur.SelectionChanged += (sender, e) =>
{
Tuteur = ((BO.Employe)ListBoxTuteur.SelectedItem);
};
//Competence
ListViewCompetence.ItemsSource = competence.ToList();
ListViewCompetence.SelectionChanged += (sender, e) =>
{
Competence = ((BO.Competence)ListViewCompetence.SelectedItem);
};
}
}
public ModificationEmploye(BO.Employe employe)
{
InitializeComponent();
Employe = employe;
Service.Text = Employe.Service;
Entreprise.Text = Employe.Entreprise;
Metier.Text = Employe.Metier;
Nom.Text = Employe.Nom;
Prenom.Text = Employe.Prenom;
DateArrivee.SelectedDate = Employe.DateArrive;
LinkedIn.Text = Employe.LinkedIn;
if (Employe.DateDepart != null)
{
DateDepart.SelectedDate = Employe.DateDepart;
}
else
{
DateDepart.SelectedDate = null;
DateDepart.DisplayDate = DateTime.Now;
}
ChefDeService.IsChecked = Employe.EstChefDeService;
Admin.IsChecked = Employe.EstAdmin;
Actif.IsChecked = Employe.Actif;
Interne.IsChecked = Employe.EstInterne;
AdresseMail.Text = Employe.AdresseMail;
using (var db = new BBD_projetEntities())
{
var langue = from l in db.Langues
select new BO.Langue
{
Id_Langue = l.Id_Langue,
Default = l.Default,
Nom = l.Nom
};
var languePossede = from l in db.Langues
join lp in db.LanguePossedes
on l.Id_Langue equals lp.Id_Langue
where lp.Id_Employe == Employe.Id_Employe
select new BO.Langue
{
Id_Langue = l.Id_Langue,
Default = l.Default,
Nom = l.Nom
};
var Competence = from c in db.Competences
select new BO.Competence
{
Id_Competence = c.Id_Competence,
Actif = c.Actif,
Annee = c.Annee,
Actuel = c.Actuel,
Id_CompetenceActuel = c.Id_CompetenceActuel
};
foreach (var v in Competence)
{
v.IntituleCompetences = BO.IntituleCompetence.ListDALtoBO((from c in db.IntituleCompetences
where c.Id_Competence == v.Id_Competence
select c).ToList());
System.Diagnostics.Debug.WriteLine(v.IntituleCompetences.ToList().First().Intitule);
}
var CompetencePossede = from c in db.Competences
join ic in db.LiaisonCompetences
on c.Id_Competence equals ic.Id_Competence
where ic.Id_Employe == Employe.Id_Employe
select new BO.Competence
{
Id_Competence = c.Id_Competence,
Actif = c.Actif,
Annee = c.Annee,
Actuel = c.Actuel,
Id_CompetenceActuel = c.Id_CompetenceActuel
};
ListLangue = languePossede.ToList();
ListCompetence = CompetencePossede.ToList();
ListLangueOrigin = languePossede.ToList();
ListCompetenceOrigin = CompetencePossede.ToList();
ListViewCompetence.ItemsSource = Competence.ToList();
ListViewCompetence.MouseDoubleClick += (sender, e) =>
{
if (ListViewCompetence.SelectedItem is BO.Competence)
{
var NouvelleCompetence = ((BO.Competence)ListViewCompetence.SelectedItem);
var verifdoublons = 0;
foreach (var x in ListCompetence)
{
if (NouvelleCompetence != null)
{
if (x.Id_Competence == NouvelleCompetence.Id_Competence)
{
verifdoublons = 1;
}
}
}
if (verifdoublons == 0)
{
ListCompetence.Add(NouvelleCompetence);
ListBoxCompetence.Items.Refresh();
}
}
};
ListBoxLangue.ItemsSource = langue.ToList();
ListBoxLangue.MouseDoubleClick += (sender, e) =>
{
if (ListBoxLangue.SelectedItem is BO.Langue)
{
var NouvelleLangue = ((BO.Langue)ListBoxLangue.SelectedItem);
var verifdoublons = 0;
foreach (var x in ListLangue)
{
if (x.Id_Langue == NouvelleLangue.Id_Langue)
{
verifdoublons = 1;
}
}
if (verifdoublons == 0)
{
ListLangue.Add(NouvelleLangue);
ListBoxLangueSelection.Items.Refresh();
}
}
;
ListBoxCompetence.ItemsSource = ListCompetence;
ListBoxLangueSelection.ItemsSource = ListLangue;
};
}
}
public ModificationGroupe(BO.Groupe groupe)
{
InitializeComponent();
Date.BlackoutDates.Add(new CalendarDateRange(new DateTime(1990, 1, 1),
DateTime.Now.AddDays(-1)));
System.Diagnostics.Debug.WriteLine(groupe.Id_Groupe);
using (var db = new BBD_projetEntities())
{
Groupe = groupe;
Titre.Text = groupe.Titre;
ListBoxTuteur.ItemsSource = groupe.Participant;
Tuteur = groupe.Tuteur;
var val = db.LangueParDefaut();
var participant = from employe in db.Employes
select new BO.Employe
{
Nom = employe.Nom,
Prenom = employe.Prenom,
Service = employe.Service,
Id_Employe = employe.Id_Employe
};
var competence = from c in db.Competences
where c.Actif == true && c.Actuel == 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
};
var wow = competence.ToList();
var ListDeParticipant = participant.ToList();
System.Diagnostics.Debug.WriteLine(groupe.DateReunion);
if (DateTime.Now < groupe.DateReunion)
{
Date.SelectedDate = groupe.DateReunion;
}
//Competence
ListViewCompetence.ItemsSource = competence.ToList();
ListViewCompetence.SelectedIndex = wow.IndexOf(wow.Where(c => c.Id_Competence == groupe.Id_Competence).Select(c => c).FirstOrDefault());
Competence = wow.Where(c => c.Id_Competence == groupe.Id_Competence).Select(c => c).FirstOrDefault();
ListViewCompetence.SelectionChanged += (sender, e) =>
{
Competence = ((BO.Competence)ListViewCompetence.SelectedItem);
};
///Comment afficher correctement ce qui est dans al base de données
//Particpant
ListViewParticipant.ItemsSource = participant.ToList();
ListViewParticipant.MouseDoubleClick += (sender, e) =>
{
if (ListViewParticipant.SelectedItem is BO.Employe)
{
var Nouveauparticipant = ((BO.Employe)ListViewParticipant.SelectedItem);
var verifdoublons = 0;
foreach (var x in groupe.Participant)
{
if (x.Id_Employe == Nouveauparticipant.Id_Employe)
{
verifdoublons = 1;
}
}
if (verifdoublons == 0)
{
groupe.Participant.Add(Nouveauparticipant);
foreach (var x in ListBoxTuteur.ItemsSource)
{
System.Diagnostics.Debug.WriteLine(((BO.Employe)x).Nom);
}
ListBoxTuteur.Items.Refresh();
}
}
};
//Tuteur
System.Diagnostics.Debug.WriteLine(Groupe.Participant.IndexOf(Groupe.Participant.Where(c => c.Id_Employe == Tuteur.Id_Employe).FirstOrDefault()));
if (Tuteur != null)
{
ListBoxTuteur.SelectedIndex = Groupe.Participant.IndexOf(Groupe.Participant.Where(c => c.Id_Employe == Tuteur.Id_Employe).FirstOrDefault());
}
ListBoxTuteur.SelectionChanged += (sender, e) =>
{
Tuteur = ((BO.Employe)ListBoxTuteur.SelectedItem);
};
}
}
