////////////////////////////////////////////////////////////// // GET: /Eleves/ReadEleves public ActionResult ReadEleves() { IList <EleveModels> models = new List <EleveModels>(); using (EleveRepository repository = new EleveRepository()) { IQueryable <Pupils> a = repository.All(); models = repository.All().Select(x => new EleveModels { id = x.Id, firstName = x.FirstName, lastName = x.LastName, sexe = x.Sex, birthdayDate = x.BirthdayDate, tuteurId = x.Tutor_Id, classroomId = x.Classroom_Id, levelId = x.Level_Id // tuteurs = // classroom = // level = // result = }).ToList(); } return(View(models)); }
// EXPORT EXCEL public ActionResult ExportExcel() { GridView gv = new GridView(); IList <EleveModels> models = new List <EleveModels>(); using (EleveRepository repository = new EleveRepository()) { IQueryable <Pupils> a = repository.All(); gv.DataSource = repository.All().Select(x => new EleveModels { id = x.Id, firstName = x.FirstName, lastName = x.LastName, sexe = x.Sex, birthdayDate = x.BirthdayDate, tuteurId = x.Tutor_Id, classroomId = x.Classroom_Id, levelId = x.Level_Id }).ToList(); } gv.DataBind(); Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment; filename=Liste_élèves.xls"); Response.ContentType = "application/ms-excel"; Response.Charset = ""; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); gv.RenderControl(htw); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); return(RedirectToAction("ReadEleves")); }