//////////////////////////////////////////////////////////////
// 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"));
}
