Example #1
0
        public async Task <IActionResult> IndexMaestro(string user, string password)
        {
            try
            {
                tutoriasContext context = new tutoriasContext();

                var usuario = context.Maestro.FirstOrDefault(x => x.NumeroControl == user && x.ContraseƱa == password);

                if (usuario == null)
                {
                    ModelState.AddModelError("", "El usuario o la contraseƱa son incorrectos");
                    return(View());
                }
                else
                {
                    var claims = new List <Claim>
                    {
                        new Claim(ClaimTypes.Name, usuario.NumeroControl),
                        new Claim(ClaimTypes.Role, usuario.Rol),
                        new Claim("Id", usuario.NumeroControl.ToString()),
                    };
                    ClaimsIdentity  identity  = new ClaimsIdentity(claims, "login");
                    ClaimsPrincipal principal = new ClaimsPrincipal(identity);
                    await HttpContext.SignInAsync(principal);

                    TempData["dataM"] = user;
                    return(RedirectToAction("Index", "Maestro/Home", new { Id = user }));
                }
            }
            catch (Exception ex)
            {
                ModelState.AddModelError("", ex.Message);
                return(View());
            }
        }
Example #2
0
        public IEnumerable <Alumnosmateria> GetAlumnosMateriaById(string Id)
        {
            tutoriasContext context = new tutoriasContext();

            return(context.Alumnosmateria
                   .Include(x => x.IdMateriaNavigation)
                   .Where(x => x.IdAlumno == Id));
        }
Example #3
0
        public IEnumerable <Materia> GetMaterias()
        {
            tutoriasContext context = new tutoriasContext();

            return(context.Materia.Select(x => new Materia {
                Clave = x.Clave, Materia1 = x.Materia1
            }));
        }
Example #4
0
        public IEnumerable <Carrera> GetCarreras()
        {
            tutoriasContext context = new tutoriasContext();

            return(context.Carrera.Select(x => new Carrera {
                Id = x.Id, Carrera1 = x.Carrera1
            }).OrderBy(x => x.Carrera1));
        }
Example #5
0
        public IEnumerable <Semestre> GetSemestres()
        {
            tutoriasContext context = new tutoriasContext();

            return(context.Semestre.Select(x => new Semestre {
                NoSem = x.NoSem, Id = x.Id
            }).OrderBy(x => x.NoSem));
        }
Example #6
0
        public IEnumerable <Materia> GetMateriasbySemestre(int semestre)
        {
            tutoriasContext context = new tutoriasContext();

            return(context.Materia.Where(x => x.IdSemestreNavigation.NoSem == semestre)
                   .Select(x => new Materia
            {
                Clave = x.Clave,
                Materia1 = x.Materia1
            }));
        }
Example #7
0
 public Repository(tutoriasContext context)
 {
     Context = context;
 }
Example #8
0
 public Repository()
 {
     Context = new tutoriasContext();
 }