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); }; } }