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;
}
}
}
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);
};
}
}
private void b_Click(object sender, RoutedEventArgs e)
{
if (C3.SelectedDate == null)
{
MessageBoxResult result = MessageBox.Show("Error : Aucune date sélectionnée");
}
else if (StringCheck(C1.Text) && StringCheck(C2.Text))
{
MessageBoxResult result = MessageBox.Show("Error : Aucun Titre sélectionné");
}
else
{
//lier les eux objets
using (var db = new BBD_projetEntities())
{
BO.Competence t = (BO.Competence)list2.SelectedItem;
DAL.Competence objet = null;
test2.Content = Actif.ToString();
var objet2 = new DAL.IntituleCompetence();
if (list2.SelectedItem != null)
{
objet = new DAL.Competence()
{
Actuel = this.Actuel,
Id_CompetenceActuel = t.Id_CompetenceActuel,
Annee = C3.SelectedDate.ToString(),
Actif = this.Actif
};
}
else
{
objet = new DAL.Competence()
{
Actuel = this.Actuel,
Id_CompetenceActuel = null,
Annee = C3.SelectedDate.ToString(),
Actif = this.Actif
};
}
if (list.SelectedItem == null)
{
objet2 = new DAL.IntituleCompetence()
{
intitule = C1.Text,
Description = C2.Text,
Id_Langue = 3,
Competence = objet
};
}
else
{
objet2 = new DAL.IntituleCompetence()
{
intitule = C1.Text,
Description = C2.Text,
Id_Langue = ((int)list.SelectedValue),
Competence = objet
};
}
objet.IntituleCompetences.Add(objet2);
db.Competences.Add(objet);
db.SaveChanges();
ListViewCompetence l = new ListViewCompetence();
this.NavigationService.Navigate(new Uri("ListViewCompetence.xaml", UriKind.Relative));
}
}
}
private void b_Click(object sender, RoutedEventArgs e)
{
using (var db = new BBD_projetEntities())
{
BO.Competence t = (BO.Competence)list2.SelectedItem;
DAL.Competence objet = null;
var objet2 = new DAL.IntituleCompetence();
test2.Content = Actif.ToString();
IEnumerable <IntituleCompetence> req = null;
if (((int?)list.SelectedValue) != null)
{
req = (from c in db.IntituleCompetences
where c.Id_Competence == Competence.Id_Competence && c.Id_Langue == ((int)list.SelectedValue)
select new
{
Competence = c.Competence,
Id_Langue = c.Id_Langue,
Id_Competence = c.Id_Competence,
Description = c.Description,
intitule = c.intitule,
Langue = c.Langue
}).ToList().Select(c => new DAL.IntituleCompetence
{
Competence = c.Competence,
Id_Langue = c.Id_Langue,
Id_Competence = c.Id_Competence,
Description = c.Description,
intitule = c.intitule,
Langue = c.Langue
});
}
if (!(req == null) || (req != null && req.ToList().Count > 0))
{
var o = new BO.IntituleCompetence(req.ToList()[0]);
var IcObjet = db.IntituleCompetences.Find(o.Id_Competence, o.Id_Langue);
IcObjet.intitule = C1.Text;
IcObjet.Description = C2.Text;
if (list.SelectedItem == null)
{
IcObjet.Id_Langue = db.LangueParDefaut();
}
else
{
IcObjet.Id_Langue = ((int)list.SelectedValue);
}
}
else
{
if (list.SelectedItem == null)
{
var LangueParDef = db.LangueParDefaut();
if ((from c in db.IntituleCompetences
where c.Id_Competence == Competence.Id_Competence && c.Id_Langue == LangueParDef
select new { }).Count() > 1)
{
objet2 = new DAL.IntituleCompetence()
{
intitule = C1.Text,
Description = C2.Text,
Id_Langue = db.LangueParDefaut(),
Id_Competence = Competence.Id_Competence,
Competence = db.Competences.Find(Competence.Id_Competence),
Langue = db.Langues.Find(db.LangueParDefaut())
};
System.Diagnostics.Debug.WriteLine(objet2.intitule);
System.Diagnostics.Debug.WriteLine(objet2.Description);
System.Diagnostics.Debug.WriteLine(objet2.Id_Langue);
System.Diagnostics.Debug.WriteLine(objet2.Id_Competence);
db.IntituleCompetences.Add(objet2);
}
else
{
//work
var IcObjet = db.IntituleCompetences.Find(Competence.Id_Competence, db.LangueParDefaut());
IcObjet.intitule = C1.Text;
IcObjet.Description = C2.Text;
}
}
else
{
objet2 = new DAL.IntituleCompetence()
{
intitule = C1.Text,
Description = C2.Text,
Id_Langue = ((int)list.SelectedValue),
Id_Competence = Competence.Id_Competence
};
db.IntituleCompetences.Add(objet2);
}
}
var DALCompetence = db.Competences.Find(Competence.Id_Competence);
if (list2.SelectedValue != null)
{
DALCompetence.Id_CompetenceActuel = t.Id_Competence;
}
/* System.Diagnostics.Debug.WriteLine(C3.SelectedDate == null);
* System.Diagnostics.Debug.WriteLine(C3.SelectedDate != null);
* System.Diagnostics.Debug.WriteLine(!(C3.SelectedDate == null));*/
if (C3.SelectedDate != null)
{
DALCompetence.Annee = C3.SelectedDate.ToString();
}
if (DALCompetence.Actif == this.Actif)
{
DALCompetence.Actif = this.Actif;
}
System.Diagnostics.Debug.WriteLine(C3.SelectedDate.ToString());
System.Diagnostics.Debug.WriteLine(DALCompetence.Annee);
System.Diagnostics.Debug.WriteLine(!(C3.SelectedDate == null));
db.SaveChanges();
ListViewCompetence l = new ListViewCompetence();
this.NavigationService.Navigate(new Uri("ListViewCompetence.xaml", UriKind.Relative));
}
}
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);
};
}
}
