public ClasseEtudiant convertEtudiant(etudiant e)
{
ClasseEtudiant etu = new ClasseEtudiant();
etu.Cne = e.cne;
etu.Nom = e.nom;
etu.Prenom = e.prenom;
etu.Filiere = e.Filiere.Nom_filiere;
try
{
etu.Date_naiss = (DateTime)e.date_naiss;
} catch (Exception ex)
{
etu.Date_naiss = new DateTime();
}
if (e.sexe.Equals('H'))
{
etu.Sexe = Gender.Homme;
}
else
{
etu.Sexe = Gender.Femme;
}
return(etu);
}
private etudiant getEtudiant()
{
ClasseEtudiant student = radDataForm1.CurrentItem as ClasseEtudiant;
var et = (from etudiant in db.etudiant
where etudiant.cne == student.Cne
select etudiant).SingleOrDefault();
return(et);
}
private void Data_DeletingItem(object sender, System.ComponentModel.CancelEventArgs e)
{
ClasseEtudiant et = radDataForm1.CurrentItem as ClasseEtudiant;
var x = (from c in db.etudiant
where c.cne == et.Cne
select c).SingleOrDefault();
db.etudiant.DeleteOnSubmit(x);
db.SubmitChanges();
}
private ObservableCollection <ClasseEtudiant> CreateEtudiants()
{
ProjetDataContext bd = new ProjetDataContext();
var data = from etudiant in bd.etudiant
join filiere in bd.Filiere
on etudiant.id_fil equals filiere.Id_filiere
select etudiant;
List <etudiant> list = data.ToList();
List <ClasseEtudiant> etudiants = new List <ClasseEtudiant>();
foreach (etudiant e in data)
{
ClasseEtudiant etu = convertEtudiant(e);
etudiants.Add(etu);
}
ObservableCollection <ClasseEtudiant> etudiantList = new ObservableCollection <ClasseEtudiant>(etudiants);
return(etudiantList);
}
private void RadDataForm1_AutoGeneratingField(object sender, Telerik.Windows.Controls.Data.DataForm.AutoGeneratingFieldEventArgs e)
{
ClasseEtudiant etudiant = this.radDataForm1.CurrentItem as ClasseEtudiant;
if (e.PropertyName == "Cne")
{
e.DataField.Label = "CNE";
e.DataField.IsEnabled = false;
}
if (e.PropertyName == "Filiere")
{
e.DataField.Description = "This is the initial salary!";
//e.DataField.MouseDoubleClick += new MouseButtonEventHandler(changeFiliere);
e.DataField.PreviewMouseDoubleClick += new MouseButtonEventHandler(changeFiliere);
}
if (etudiant.Sexe == Gender.Femme)
{
e.DataField.Foreground = new SolidColorBrush(Colors.Purple);
}
else
{
e.DataField.Foreground = new SolidColorBrush(Colors.Blue);
}
}
private void Data_EditEnding(object sender, Telerik.Windows.Controls.Data.DataForm.EditEndingEventArgs e)
{
ClasseEtudiant student = radDataForm1.CurrentItem as ClasseEtudiant;
var x = (from etudiant in db.etudiant
join filiere in db.Filiere
on etudiant.id_fil equals filiere.Id_filiere
where etudiant.cne == student.Cne
select etudiant).SingleOrDefault();
if (x != null)
{
x.nom = student.Nom;
x.prenom = student.Prenom;
x.date_naiss = student.Date_naiss;
if (student.Sexe == Gender.Femme)
{
x.sexe = 'F';
}
else if (student.Sexe == Gender.Homme)
{
x.sexe = 'H';
}
else
{
x.sexe = 'X';
}
db.SubmitChanges();
}
else
{
bool erreur = false;
ClasseEtudiant item = radDataForm1.CurrentItem as ClasseEtudiant;
etudiant et = new etudiant();
et.cne = item.Cne;
et.nom = item.Nom;
et.prenom = item.Prenom;
et.date_naiss = item.Date_naiss;
if (et.image == null)
{
et.image = "default.png";
}
if (student.Sexe == Gender.Femme)
{
et.sexe = 'F';
}
else if (student.Sexe == Gender.Homme)
{
et.sexe = 'H';
}
else
{
et.sexe = 'X';
}
bool find = false;
int id = 0;
var fil = from f in db.Filiere
select f;
foreach (Filiere f in fil)
{
if (f.Nom_filiere.Equals(item.Filiere))
{
find = true;
id = f.Id_filiere;
}
}
if (find)
{
et.id_fil = id;
}
else
{
MessageBox.Show("Veuillez Entrer une filiere valide !");
erreur = true;
}
if (!erreur)
{
db.etudiant.InsertOnSubmit(et);
db.SubmitChanges();
}
}
}