public List <Etudiant> GetStudentsByFiliere(string filiere)
{
EtudiantEntities e = new EtudiantEntities();
var x = from item in e.Etudiants
where item.filiere == filiere
select item;
List <Etudiant> l = new List <Etudiant>();
foreach (var item in x)
{
Etudiant ee = new Etudiant();
ee.nom = item.nom;
ee.cne = item.cne;
ee.date_naissance = item.date_naissance;
ee.email = item.email;
ee.filiere = item.filiere;
ee.note = item.note;
ee.picture = item.picture;
ee.prenom = item.prenom;
l.Add(ee);
}
return(l);
}
public void DeleteStudent(string cne)
{
int CNE = int.Parse(cne);
EtudiantEntities e = new EtudiantEntities();
var x = (from item in e.Etudiants
where item.cne == CNE
select item).SingleOrDefault();
e.Etudiants.Remove(x);
e.SaveChanges();
}
public Dictionary <string, string[]> GetAllStudents()
{
EtudiantEntities e = new EtudiantEntities();
var x = from item in e.Etudiants
select item;
Dictionary <string, string[]> d = new Dictionary <string, string[]>();
foreach (var item in x)
{
string[] s = new string[] { item.nom + " " + item.prenom, item.picture };
d.Add(item.cne.ToString(), s);
}
return(d);
}
public Etudiant getStudent(int cne)
{
EtudiantEntities e = new EtudiantEntities();
var x = (from item in e.Etudiants
where item.cne == cne
select item).SingleOrDefault();
Etudiant ee = new Etudiant();
ee.nom = x.nom;
ee.cne = x.cne;
ee.date_naissance = x.date_naissance;
ee.email = x.email;
ee.filiere = x.filiere;
ee.note = x.note;
ee.picture = x.picture;
ee.prenom = x.prenom;
return(ee);
}
public Dictionary <string, int> GetFilieresStats()
{
EtudiantEntities e = new EtudiantEntities();
var x = from item in e.Filieres
select item;
Dictionary <string, int> d = new Dictionary <string, int>();
foreach (var item in x)
{
var y = from iitem in e.Etudiants
where iitem.filiere == item.id
select iitem;
d.Add(item.nom_filiere, y.Count());
}
// Add your operation implementation here
return(d);
}
public List <Filiere> GetAllFilieres()
{
EtudiantEntities e = new EtudiantEntities();
var x = from item in e.Filieres
select item;
List <Filiere> l = new List <Filiere>();
foreach (var item in x)
{
var f = new Filiere();
f.id = item.id;
f.nom_filiere = item.nom_filiere;
f.responsable = item.responsable;
l.Add(f);
}
return(l);
}
