public ActionResult Approval(string empleado, decimal axo, bool ismanager = false) { if (!Login()) { return(RedirectToAction("NoUser", "Home", null)); } if (!ismanager) { empleado = Convert.ToString(Session["EmployeeNo"]); } var objetivoHeader = db.t_objetivos.Include(t => t.t_empleados).Include(t => t.t_plantas).Where(x => x.empleado == empleado && x.axo == axo).ToList().ElementAt(0); if (objetivoHeader.estatus != "EN") { return(RedirectToAction("Create", new { empleado = objetivoHeader.empleado, axo = objetivoHeader.axo })); } ViewBag.Objective = objetivoHeader; try { ViewBag.Manager = objetivoHeader.t_empleados.t_empleados2.nombre; if (objetivoHeader.t_empleados.t_empleados2.empleado == Convert.ToString(Session["EmployeeNo"])) { ViewBag.FirstManager = true; } else { ViewBag.FirstManager = false; } } catch { ViewBag.Manager = null; } try { ViewBag.Manager2 = objetivoHeader.t_empleados.t_empleados2.t_empleados2.nombre; } catch { ViewBag.Manager2 = null; } var ObjectivesDet = db.t_objetidet.Include(t => t.t_objetivos).Where(x => x.empleado == objetivoHeader.empleado && x.axo == objetivoHeader.axo); ViewBag.ObjectivesDet = ObjectivesDet; empleadoTress add = new empleadoTress(); add = add.datosTress(empleado.Substring(3, empleado.Length - 3), empleado.Substring(0, 3)); ViewBag.infoTress = add; return(View()); }
// GET: t_usuarios/Details/5 public ActionResult Details(string empleado) { MyDirects ndirect = new MyDirects(); empleadoTress add = new empleadoTress(); add = add.datosTress(empleado.Substring(3, empleado.Length - 3), empleado.Substring(0, 3)); t_empleados t_empleados = db.t_empleados.Find(empleado); ndirect.nombre = t_empleados.nombre; ndirect.empleado = t_empleados.empleado; ndirect.usuario = t_empleados.t_usuarios.usuario; ndirect.sextra1 = t_empleados.t_usuarios.email; ndirect.depto = add.depto; ndirect.puesto = add.puesto; try { ndirect.manager1 = t_empleados.t_empleados21.nombre; } catch { ndirect.manager1 = ""; } ViewBag.details = ndirect; return(View()); }
public ActionResult DirectReports() { if (!Login()) { return(RedirectToAction("NoUser", "Home", null)); } string empleado = Convert.ToString(Session["EmployeeNo"]); //Si el empleado que quiere ingresar no esta como supervisor y el año de los objetivos no es el actual, regresar al menu var t_merit = db.t_merit.Include(t => t.t_empleados).Include(t => t.t_empleados1).Where(x => x.supervisor == empleado && x.axo == System.DateTime.Now.Year).ToList(); if (!t_merit.Any()) { return(RedirectToAction("Index", "Home", null)); } var t_meridet = db.t_meridet.Include(t => t.t_califica).Include(t => t.t_empleados).Include(t => t.t_jobcode).Include(t => t.t_merit).Where(x => x.supervisor == empleado && x.axo == System.DateTime.Today.Year).ToList(); var directs = new List <MyDirects>(); string estado = ""; foreach (var item in t_meridet) { switch (item.estatus) { case "PE": estado = "Waiting For Aproval"; break; case "AP": estado = "Approved"; break; default: estado = "No Merit"; break; } MyDirects ndirect = new MyDirects(); empleadoTress add = new empleadoTress(); add = add.datosTress(item.empleado.Substring(3, item.empleado.Length - 3), item.empleado.Substring(0, 3)); ndirect.empleado = item.empleado; ndirect.nombre = item.nombre; ndirect.estatusm4 = estado; ndirect.axom4 = item.axo; ndirect.puesto = add.puesto; ndirect.foto = add.btImagen; ndirect.meritrec = Convert.ToDecimal(item.sugerido_porc); directs.Add(ndirect); } ViewBag.Directos = directs; return(View()); }
public bool Login() { string username = Convert.ToString(User.Identity.Name).Substring(11).ToLower(); Session["userAccount"] = username; var t_usuarios = db.t_usuarios.Find(username); Session["Rol"] = t_usuarios.rol; if (t_usuarios == null) { //si usuario no esta return(false); } else { var nombreusuario = t_usuarios.nombre.Split(' '); ViewBag.userFirstName = nombreusuario[0]; ViewBag.userRol = t_usuarios.rol.ToString(); var empleado = db.t_empleados.Where(x => x.usuario == username).ToList(); if (empleado.Any()) { var config1 = db.t_config_m1.Where(x => x.clave == "01").ToList(); ViewBag.Axo = config1[0].axo_activo; Session["userNo"] = empleado[0].empleado; ViewBag.userNo = empleado[0].empleado; string numempleado = empleado[0].empleado; if (empleado[0].planta == "686") { empleadoTress add = new empleadoTress(); add = add.datosTress(numempleado.Substring(3, numempleado.Length - 3), numempleado.Substring(0, 3)); ViewBag.userJobPosition = add.puesto; ViewBag.userImage = "data:image/png;base64," + Convert.ToBase64String(add.btImagen, 0, add.btImagen.Length); } Session["EmployeeNo"] = empleado[0].empleado; return(true); } else { //si el nombre del usuario no existe en empleados return(false); } } }
public bool Login() { string username = Convert.ToString(User.Identity.Name).Substring(11).ToLower(); Session["userAccount"] = username; var t_usuarios = db.t_usuarios.Find(username); Session["Rol"] = t_usuarios.rol; if (t_usuarios == null) { //si usuario no esta return(false); } else { var nombreusuario = t_usuarios.nombre.Split(' '); ViewBag.userFirstName = nombreusuario[0]; var empleado = db.t_empleados.Where(x => x.usuario == username).ToList(); if (empleado.Any()) { Session["userNo"] = empleado[0].empleado; string numempleado = empleado[0].empleado; if (empleado[0].planta == "686") { empleadoTress add = new empleadoTress(); add = add.datosTress(numempleado.Substring(3, numempleado.Length - 3), numempleado.Substring(0, 3)); ViewBag.userJobPosition = add.puesto; } Session["EmployeeNo"] = empleado[0].empleado; return(true); } else { //si el nombre del usuario no existe en empleados return(false); } } }
// GET: t_usuarios/Delete/5 public ActionResult Delete(string empleado) { if (!Login()) { return(RedirectToAction("NoUser", "Home", null)); } t_usuarios user = db.t_usuarios.Find(Convert.ToString(Session["userAccount"])); if (user.rol != "ADMCO") { return(RedirectToAction("Index", "Home", null)); } MyDirects ndirect = new MyDirects(); empleadoTress add = new empleadoTress(); add = add.datosTress(empleado.Substring(3, empleado.Length - 3), empleado.Substring(0, 3)); t_empleados t_empleados = db.t_empleados.Find(empleado); ndirect.nombre = t_empleados.nombre; ndirect.empleado = t_empleados.empleado; ndirect.usuario = t_empleados.t_usuarios.usuario; ndirect.sextra1 = t_empleados.t_usuarios.email; ndirect.depto = add.depto; ndirect.puesto = add.puesto; try { ndirect.manager1 = t_empleados.t_empleados21.nombre; } catch { ndirect.manager1 = ""; } ViewBag.details = ndirect; return(View()); }
public ActionResult Start(string sparame, int sparamx) { if (!Login()) { return(RedirectToAction("NoUser", "Home", null)); } var budgetAxo = db.t_budget_pta.Where(x => x.axo == sparamx).ToList(); decimal dBudget = 0; if (budgetAxo.Any()) { if (decimal.TryParse(budgetAxo[0].budget.ToString(), out dBudget)) { ViewBag.Budget = dBudget; } } ViewBag.userNo = sparame; ViewBag.Axo = sparamx; var meritList = db.sp_view_merit_year(sparamx).ToList(); ViewBag.Merit = meritList; ViewBag.craeteMerit = true; if (meritList.ToList().Count > 0) { ViewBag.craeteMerit = false; } empleadoTress add = new empleadoTress(); add = add.datosTress(sparame.Substring(3, sparame.Length - 3), sparame.Substring(0, 3)); ViewBag.infoTress = add; return(View()); }
public ActionResult DirectReports() { if (!Login()) { return(RedirectToAction("NoUser", "Home", null)); } string empleado = Convert.ToString(Session["EmployeeNo"]); var t_empleados = db.t_empleados.Include(t => t.t_plantas).Include(t => t.t_usuarios).Include(t => t.t_empleados2).Where(x => x.supervisor == empleado).ToList(); var t_objetivos = db.t_objetivos.Include(t => t.t_empleados).Include(t => t.t_plantas).Where(x => x.t_empleados.t_empleados2.empleado == empleado && x.estatus != "CA").ToList(); var query = (from l1 in t_empleados join l2 in t_objetivos on l1.empleado equals l2.empleado into leftJ from lj in leftJ.DefaultIfEmpty() select new MyDirects { empleado = l1.empleado, nombre = l1.nombre, axo = lj?.axo ?? Decimal.Zero, estatus = lj?.estatus ?? String.Empty }).ToList(); int i = 0; foreach (var item in query) { empleadoTress add = new empleadoTress(); add = add.datosTress(item.empleado.Substring(3, item.empleado.Length - 3), item.empleado.Substring(0, 3)); query.ElementAt(i).puesto = add.puesto; query.ElementAt(i).foto = add.btImagen; i++; } ViewBag.Directos = query; return(View()); }
public ActionResult NewUser(string planta, int iempleado, string usuario, string email, string rol, string supervisor, string manager) { string empleado = Convert.ToString(iempleado); usuario = usuario.ToLower(); if (existeUser(usuario)) { return(RedirectToAction("NewUser", "t_usuarios", new { alert = "1" })); } if (existeEmployee(planta + empleado)) { return(RedirectToAction("NewUser", "t_usuarios", new { alert = "2" })); } empleadoTress add = new empleadoTress(); add = add.datosTress(empleado, planta); if (add.nombre == null) { return(RedirectToAction("NewUser", "t_usuarios", new { alert = "3" })); } t_usuarios t_usuarios = new t_usuarios(); t_empleados t_empleado = new t_empleados(); t_usuarios.usuario = usuario; t_usuarios.nombre = add.nombre; t_usuarios.planta = planta; t_usuarios.email = email; t_usuarios.activo = "1"; t_usuarios.rol = rol; t_usuarios.f_id = System.DateTime.Now; t_empleado.empleado = planta + empleado; t_empleado.nombre = add.nombre; t_empleado.usuario = usuario; t_empleado.f_id = System.DateTime.Now; t_empleado.planta = planta; if (supervisor == "") { t_empleado.supervisor = null; } else { t_empleado.supervisor = supervisor; } if (manager == "") { t_empleado.gerente = null; } else { t_empleado.gerente = manager; } if (ModelState.IsValid) { db.t_usuarios.Add(t_usuarios); db.SaveChanges(); db.t_empleados.Add(t_empleado); db.SaveChanges(); return(RedirectToAction("Index", "t_usuarios", null)); } return(View()); }
public ActionResult IndexModule4D() { if (!Login()) { return(RedirectToAction("NoUser", "Home", null)); } string planta = Convert.ToString(Session["Plant"]); var configplanta = db.t_plantas.Find(planta); if (Convert.ToString(Session["userAccount"]) != configplanta.direct_email) { return(RedirectToAction("Index", "Home", null)); } string empleado = Convert.ToString(Session["EmployeeNo"]); var t_merit = db.t_merit.Include(t => t.t_empleados).Include(t => t.t_empleados1).Where(x => x.axo == System.DateTime.Now.Year && (x.autoriza == empleado || x.supervisor == empleado)).OrderBy(x => x.supervisor).ToList(); var t_meridet = db.t_meridet.Include(t => t.t_califica).Include(t => t.t_empleados).Include(t => t.t_jobcode).Include(t => t.t_merit).Where(x => x.supervisor == empleado && x.axo == System.DateTime.Today.Year).OrderBy(x => x.supervisor).ToList(); var t_meridet2 = db.t_meridet.Include(t => t.t_califica).Include(t => t.t_empleados).Include(t => t.t_jobcode).Include(t => t.t_merit).Where(x => x.axo == System.DateTime.Today.Year && x.supervisor.Substring(0, 3) == planta).OrderBy(x => x.supervisor).ToList(); double approve = 0; decimal totalbudget = 0; decimal totalspent = 0; decimal totalavailable = 0; bool mstatus = true; string smstatus = ""; string istatus = ""; string estado = ""; string iconocal = ""; string colorcal = ""; var departments = new List <MyDirects>(); var directs = new List <MyDirects>(); foreach (var item in t_meridet2) { if (item.estatus == "AP") { approve++; } } foreach (var item in t_merit) { totalbudget = Convert.ToDecimal(totalbudget + item.budget_imp); totalspent = Convert.ToDecimal(totalspent + item.budget_spen); switch (item.estatus) { case "PE": istatus = "In Process"; mstatus = false; break; case "AP": istatus = "Completed"; mstatus = false; break; default: istatus = "Autorized"; break; } MyDirects ndirect = new MyDirects(); empleadoTress add = new empleadoTress(); add = add.datosTress(item.supervisor.Substring(3, item.supervisor.Length - 3), item.supervisor.Substring(0, 3)); ndirect.empleado = item.supervisor; ndirect.depto = item.depto; ndirect.nombre = item.nombre; ndirect.foto = add.btImagen; ndirect.dextra1 = Convert.ToDecimal(item.budget_imp); ndirect.dextra2 = Convert.ToDecimal(item.budget_spen); ndirect.estatusm4 = istatus; ndirect.sextra1 = (Math.Round((ndirect.dextra2 / ndirect.dextra1) * 100)).ToString() + "%"; departments.Add(ndirect); } if (mstatus) { smstatus = "Completed"; } else { smstatus = "In Process"; } foreach (var item in t_meridet) { switch (item.estatus) { case "PE": estado = "Pending"; break; case "AP": estado = "Approved"; break; default: estado = "No Merit"; break; } switch (item.calificacion) { case "EE": iconocal = "<i class='fas fa-medal'></i>"; colorcal = "warning-color-dark"; break; case "ME": iconocal = "<i class='fas fa-thumbs-up'></i>"; colorcal = "success-color"; break; case "NI": iconocal = "<i class='fas fa-exclamation'></i>"; colorcal = "warning-color"; break; case "FE": iconocal = "<i class='fas fa-thumbs-down'></i>"; colorcal = "danger-color"; break; default: iconocal = "<i class='fas fa-minus'></i>"; colorcal = "stylish-color"; break; } MyDirects ndirect = new MyDirects(); empleadoTress add = new empleadoTress(); add = add.datosTress(item.empleado.Substring(3, item.empleado.Length - 3), item.empleado.Substring(0, 3)); ndirect.manager1 = item.supervisor; ndirect.empleado = item.empleado; ndirect.nombre = item.nombre; ndirect.estatusm4 = estado; ndirect.axom4 = item.axo; ndirect.puesto = item.puesto; ndirect.foto = add.btImagen; ndirect.meritrec = Convert.ToDecimal(item.sugerido_porc); ndirect.iconoresult = iconocal; ndirect.coloriconoresult = colorcal; ndirect.lump = Convert.ToDecimal(item.lump_imp); directs.Add(ndirect); } totalavailable = totalbudget - totalspent; ViewBag.budgetper = t_merit.ElementAt(0).budget_porc; ViewBag.tbudget = totalbudget; ViewBag.tspent = totalspent; ViewBag.tavailable = totalavailable; ViewBag.statusmerit = smstatus; ViewBag.ApproveCount = approve; string aper = Math.Round((approve / t_meridet2.Count) * 100).ToString() + "%"; ViewBag.ApprovePer = aper; ViewBag.MCount = t_meridet2.Count; ViewBag.percent = Math.Round((ViewBag.tspent / ViewBag.tbudget) * 100); ViewBag.departments = departments; ViewBag.directs = directs; return(View()); }
public ActionResult IndexModule4(string empleado = "") { if (!Login()) { return(RedirectToAction("NoUser", "Home", null)); } if (empleado == "") { empleado = Convert.ToString(Session["EmployeeNo"]); var configplanta = db.t_plantas.Find(Convert.ToString(Session["Plant"])); if (Convert.ToString(Session["userAccount"]) == configplanta.direct_email) { return(RedirectToAction("IndexModule4D", "t_merit", null)); } } var t_merit = db.t_merit.Include(t => t.t_empleados).Include(t => t.t_empleados1).Where(x => x.supervisor == empleado && x.axo == System.DateTime.Now.Year).ToList(); if (!t_merit.Any()) { return(RedirectToAction("Index", "Home", null)); } var t_meridet = db.t_meridet.Include(t => t.t_califica).Include(t => t.t_empleados).Include(t => t.t_jobcode).Include(t => t.t_merit).Where(x => x.supervisor == empleado && x.axo == System.DateTime.Today.Year).ToList(); var directs = new List <MyDirects>(); string estado = ""; string iconocal = ""; string colorcal = ""; double approve = 0; foreach (var item in t_meridet) { switch (item.estatus) { case "PE": estado = "Pending"; break; case "AP": estado = "Approved"; approve++; break; default: estado = "No Merit"; break; } switch (item.calificacion) { case "EE": iconocal = "<i class='fas fa-medal'></i>"; colorcal = "warning-color-dark"; break; case "ME": iconocal = "<i class='fas fa-thumbs-up'></i>"; colorcal = "success-color"; break; case "NI": iconocal = "<i class='fas fa-exclamation'></i>"; colorcal = "warning-color"; break; case "FE": iconocal = "<i class='fas fa-thumbs-down'></i>"; colorcal = "danger-color"; break; default: iconocal = "<i class='fas fa-minus'></i>"; colorcal = "stylish-color"; break; } MyDirects ndirect = new MyDirects(); empleadoTress add = new empleadoTress(); add = add.datosTress(item.empleado.Substring(3, item.empleado.Length - 3), item.empleado.Substring(0, 3)); ndirect.manager1 = item.supervisor; ndirect.empleado = item.empleado; ndirect.nombre = item.nombre; ndirect.estatusm4 = estado; ndirect.axom4 = item.axo; ndirect.puesto = item.puesto; ndirect.foto = add.btImagen; ndirect.meritrec = Convert.ToDecimal(item.sugerido_porc); ndirect.iconoresult = iconocal; ndirect.coloriconoresult = colorcal; ndirect.lump = Convert.ToDecimal(item.lump_imp); directs.Add(ndirect); } ViewBag.ApproveCount = approve; ViewBag.Directos = directs; string aper = Math.Round((approve / directs.Count) * 100).ToString() + "%"; ViewBag.ApprovePer = aper; ViewBag.merit = t_merit.ElementAt(0); ViewBag.available = t_merit.ElementAt(0).budget_imp - t_merit.ElementAt(0).budget_spen; ViewBag.percent = Convert.ToString(Math.Round(Convert.ToDouble((t_merit.ElementAt(0).budget_spen / t_merit.ElementAt(0).budget_imp) * 100))); string statusmerit = ""; switch (t_merit.ElementAt(0).estatus) { case "PE": statusmerit = "In Process"; break; case "AP": statusmerit = "Completed"; break; case "AU": statusmerit = "Autorized"; break; case "AA": statusmerit = "Aplied"; break; default: statusmerit = "No Merit"; break; } ViewBag.statusmerit = statusmerit; return(View()); }
public ActionResult MeritProcess(string empleado, decimal axo, string supervisor) { if (!Login()) { return(RedirectToAction("NoUser", "Home", null)); } var t_merit = db.t_merit.Include(t => t.t_empleados).Include(t => t.t_empleados1).Where(x => x.supervisor == supervisor && x.axo == System.DateTime.Now.Year).ToList(); if (!t_merit.Any()) { return(RedirectToAction("Index", "Home", null)); } ViewBag.spent = t_merit.ElementAt(0).budget_spen; ViewBag.available = t_merit.ElementAt(0).budget_imp - t_merit.ElementAt(0).budget_spen; ViewBag.percent = Convert.ToString(Math.Round((ViewBag.available / t_merit.ElementAt(0).budget_imp) * 100)); var t_meridet = db.t_meridet.Find(supervisor, axo, empleado); MyDirects ndirect = new MyDirects(); empleadoTress add = new empleadoTress(); add = add.datosTress(empleado.Substring(3, empleado.Length - 3), empleado.Substring(0, 3)); ndirect.empleado = empleado; ndirect.nombre = t_meridet.nombre; ndirect.depto = add.depto; ndirect.puesto = add.puesto; ndirect.foto = add.btImagen; string iconocal = ""; string colorcal = ""; switch (t_meridet.calificacion) { case "EE": iconocal = "<i class='fas fa-medal'></i>"; colorcal = "warning-color-dark"; break; case "ME": iconocal = "<i class='fas fa-thumbs-up'></i>"; colorcal = "success-color"; break; case "NI": iconocal = "<i class='fas fa-exclamation'></i>"; colorcal = "warning-color"; break; case "FE": iconocal = "<i class='fas fa-thumbs-down'></i>"; colorcal = "danger-color"; break; default: iconocal = "<i class='fas fa-minus'></i>"; colorcal = "stylish-color"; break; } ViewBag.colorcal = colorcal; ViewBag.iconocal = iconocal; try { ndirect.manager1 = t_meridet.t_empleados.t_empleados2.nombre; } catch { ndirect.manager1 = null; } try { ndirect.manager2 = t_meridet.t_empleados.t_empleados2.t_empleados2.nombre; } catch { ndirect.manager2 = null; } ViewBag.direct = ndirect; ViewBag.merit = t_meridet; ViewBag.bamount = Math.Truncate(100 * (Convert.ToDouble((t_meridet.salario_axo * t_meridet.budget_porc) / 100))) / 100; ViewBag.maxmerit = ViewBag.bamount * 2; decimal meritg1 = Convert.ToDecimal((t_meridet.t_califica.rango_ini * t_merit.ElementAt(0).budget_porc)) / 100; decimal meritg2 = Convert.ToDecimal((t_meridet.t_califica.rango_fin * t_merit.ElementAt(0).budget_porc)) / 100; ViewBag.merithstatus = t_merit.ElementAt(0).estatus; ViewBag.meritg1 = meritg1; ViewBag.meritg2 = meritg2; return(View()); }
// GET: t_objetidet/Create public ActionResult Create(string empleado, decimal axo) { if (!Login()) { return(RedirectToAction("NoUser", "Home", null)); } empleado = Convert.ToString(Session["EmployeeNo"]); int totalweight = 0; var objetivoHeader = db.t_objetivos.Include(t => t.t_empleados).Include(t => t.t_plantas).Where(x => x.empleado == empleado && x.axo == axo).ToList().ElementAt(0); if (objetivoHeader.estatus != "PE") { return(RedirectToAction("Approval", new { empleado = objetivoHeader.empleado, axo = objetivoHeader.axo })); } ViewBag.Objective = objetivoHeader; try { ViewBag.Manager = objetivoHeader.t_empleados.t_empleados2.nombre; } catch { ViewBag.Manager = null; } try { ViewBag.Manager2 = objetivoHeader.t_empleados.t_empleados2.t_empleados2.nombre; } catch { ViewBag.Manager2 = null; } var ObjectivesDet = db.t_objetidet.Include(t => t.t_objetivos).Where(x => x.empleado == objetivoHeader.empleado && x.axo == objetivoHeader.axo); foreach (var item in ObjectivesDet) { totalweight = totalweight + Convert.ToInt16(item.peso); } ViewBag.TotalWeight = totalweight; ViewBag.ObjectivesQty = ObjectivesDet.ToList().Count(); ViewBag.ObjectivesDet = ObjectivesDet; try { ViewBag.NextObjective = ObjectivesDet.OrderByDescending(x => x.consec).ToList().ElementAt(0).consec + 1; } catch { ViewBag.NextObjective = 1; } if (objetivoHeader.n_aprobado != null) { ViewBag.Rechazado = "1"; } else { ViewBag.Rechazado = "0"; } empleadoTress add = new empleadoTress(); add = add.datosTress(empleado.Substring(3, empleado.Length - 3), empleado.Substring(0, 3)); ViewBag.infoTress = add; ViewBag.folio = new SelectList(db.t_objetivos, "folio", "folio"); ViewBag.planta = new SelectList(db.t_plantas, "planta", "planta"); return(View()); }
public ActionResult MenuModule1() { if (!Login()) { return(RedirectToAction("NoUser", "Home", null)); } bool newobj = false; string empleado = Convert.ToString(Session["EmployeeNo"]); ViewBag.empleado = empleado; var t_objetivos = db.t_objetivos.Include(t => t.t_empleados).Include(t => t.t_plantas).Where(x => x.empleado == empleado).OrderByDescending(x => x.axo).ToList(); var t_empleados = db.t_empleados.Include(t => t.t_plantas).Include(t => t.t_usuarios).Include(t => t.t_empleados2).Where(x => x.supervisor == empleado).ToList(); var t_empleado = db.t_empleados.Find(empleado); ViewBag.Empoyee = t_empleado; try { ViewBag.Manager = t_empleado.t_empleados2.nombre; } catch { ViewBag.Manager = null; } try { ViewBag.Manager2 = t_empleado.t_empleados2.t_empleados2.nombre; } catch { ViewBag.Manager2 = null; } var t_config_m1 = db.t_config_m1.ToList().ElementAt(0); int i = 0; if (t_objetivos.Any()) { foreach (var item in t_objetivos) { if (item.axo == t_config_m1.axo_activo) { i++; } } } else { newobj = true; } if (i == 0) { newobj = true; } if (System.DateTime.Now >= t_config_m1.f_objini && newobj) { ViewBag.NewObjective = "1"; ViewBag.NewYear = t_config_m1.axo_activo; } if (t_empleados.Any()) { ViewBag.DReports = "1"; } empleadoTress add = new empleadoTress(); ViewBag.DTRESS = add.datosTress(empleado.Substring(3, empleado.Length - 3), empleado.Substring(0, 3)); return(View(t_objetivos)); }