Guest User

Untitled

a guest
Mar 22nd, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.26 KB | None | 0 0
  1. @using (Html.BeginForm())
  2. {
  3. <p>
  4. Salon: @Html.DropDownList("sln", " ")
  5. Maestro:@Html.DropDownList("met", " ")
  6. Especilidad:@Html.DropDownList("epc", " ")
  7. Clave: @Html.TextBox("clv"," ")
  8. Materia:@Html.DropDownList("mtr", " ")
  9. Tutor:@Html.DropDownList("ttr", " ")
  10.  
  11. <input type="submit" value="Search" />
  12. </p>
  13. }
  14.  
  15. public ViewResult Index(int? page, string met, string ttr, string sln, string mtr, string epc, string clv)
  16. {
  17. const int pageSize = 20;
  18. int pageNumber = (page ?? 1);
  19.  
  20. var esTs = db.EstudianteTs.Include(t => t.MaestrosT).Include(t => t.TutorT).Include(t => t.SalonT).Include(t => t.MateriaT).Include(t => t.EspecialidadT);
  21.  
  22. var maestro = db.EstudianteTs.OrderBy(t => t.MaestrosT.Nombre).Select(t => t.MaestrosT.Nombre).Distinct();
  23.  
  24. ViewBag.met = new SelectList(maestro);
  25.  
  26. var tutor = db.EstudianteTs.OrderBy(t => t.TutorT.Nombre).Select(t => t.TutorT.Nombre).Distinct();
  27.  
  28. ViewBag.ttr = new SelectList(tutor);
  29.  
  30. var salon = db.EstudianteTs.OrderBy(t => t.SalonT.Salon).Select(t => t.SalonT.Salon).Distinct();
  31.  
  32. ViewBag.sln = new SelectList(salon);
  33.  
  34. var materia = db.EstudianteTs.OrderBy(t => t.MateriaT.Nombre).Select(t => t.MateriaT.Nombre).Distinct();
  35.  
  36. ViewBag.mtr = new SelectList(materia);
  37.  
  38. var especialidad = db.EstudianteTs.OrderBy(t => t.EspecialidadT.Nombre).Select(t => t.EspecialidadT.Nombre).Distinct();
  39.  
  40. ViewBag.epc = new SelectList(epc);
  41.  
  42. esTs = db.EstudianteTs.Where(s => (mtr == null) || (s.MateriaT.Materia.Contains(mtr)))
  43. .Where(s => (ttr == null) || (s.TutorT.Nombre.Contains(ttr)))
  44. .Where(s => (epc == null) || (s.EspecialidadT.Nombre.Contains(epc)))
  45. .Where(s => (met == null) || (s.MaestrosT.Nombre.Contains(met)))
  46. .Where(s => (clv == null) || (s.Clave.Contains(clv)))
  47. .Where(s => (sln== null) || s.SalonT.Salon.Contains(sln)));
  48.  
  49. return View(esTs.ToList().ToPagedList(pageNumber, pageSize));
  50. }
Add Comment
Please, Sign In to add comment