// GET: Finparticipantesal
public ActionResult Index()
{
if (Session["username"] == null)
{
return(RedirectToAction("Login", "Uno"));
}
else
{
List <byte> copied = new List <byte>();
List <byte> result = new List <byte>();
ViewBag.CandidatasList = db.tbl_candidatas;
ViewBag.JuecesList = db.tbl_users_jueces.Where(x => x.tipo == "U").ToList();
// Agregar rango a List && Conversion de ObjetoResult a List
ViewBag.Notario = db.tbl_users_jueces.Where(x => x.tipo == "N").ToList();
foreach (var z in db.tbl_candidatas)
{
var m = db.PromediarNotas(z.id);
// Agregar rango a List && Conversion de ObjetoResult a List
copied.AddRange(m.Where(x => x.HasValue).Select(x => x.Value));
}
ViewBag.participantes = copied;
return(View(db.tbl_users_jueces.Where(x => x.tipo == "U").Count()));
}
}