1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102
|
//mon controller
public ActionResult ListeEtudiant()
{
// affichage par defaut
if (ViewData["listetude"] == null)
{
var EtudiantListe = from et in _db.Etudiants
join etm in _db.EtudiantMatieres
on et.EtudiantId equals etm.EtudiantId
select new EtudiantModel
{
EtudiantId = et.EtudiantId,
FirstName = et.FirstName,
LastName = et.LastName,
Sexe = et.Sexe,
Numero = et.Numero,
Contact = et.contact,
Matricule = et.Matricule,
Email = et.Email,
Cycle = etm.Cycles,
options = etm.options,
groupe = etm.groupe,
Niveau = etm.Niveau
};
ViewData.Model = EtudiantListe;
}
//affichage apres filtrage en fontion de infos de la zone de recherche
if (ViewData["listetude"]!=null)
{
string query = "";
string select = "";
string from = "";
string where = "";
select = "SELECT * ";
from = " FROM Etudiant,EtudiantMatiere ";
where = " WHERE Etudiant.EtudiantId = EtudiantMatiere.EtudiantId ";
if (forme["FirstName"].Length > 0)
{
where = where + " AND Etudiant.FirstName LIKE '%" + forme["FirstName"] + "%'";
}
if (forme["Cycle"] !="0")
{
where = where + " AND EtudiantMatiere.Cycles LIKE '%" + forme["Cycle"] + "%'";
}
if (forme[" options"] !="0")
{
where = where + " AND EtudiantMatiere.options LIKE '%" + forme[" options"] + "%'";
}
if (forme[" groupe"]!="0")
{
where = where + " AND EtudiantMatiere.groupe LIKE '%" + forme[" groupe"] + "%'";
}
if (forme["Niveau"].Length > 0)
{
where = where + " AND EtudiantMatiere.Niveau LIKE '%" + forme["Niveau"] + "%'";
}
query = select + " " + from + " " + where;
var EtudiantListe = _db.ExecuteStoreQuery<EtudiantModel>(query).ToString();
ViewData.Model = EtudiantListe;
}
return View();
}
//
{
public ActionResult AddEtudiant(FormCollection form)
{
if(string.IsNullOrEmpty(form["Rechercher"]))
{
forme = form;
ViewData["listetude"] = "Initialiser";
ListeEtudiant();
return RedirectToAction("ListeEtudiant");
}
// notons que forme est variable FormeCollection global |
Partager