public ResponseModel AccederUsuario(string nomusuario, string clave) { var rm = new ResponseModel(); //clave = HashHelper.MD5(clave); try { using (var context = new MatriculasContext()) { var usuario = context.T_GENM_USUARIO.Where(x => x.NOMBRE_USUARIO == nomusuario) .Where(x => x.CONTRASENA == clave).SingleOrDefault(); if (usuario != null) { SessionHelper.AddUserToSession(usuario.ID_USUARIO.ToString()); rm.SetResponse(true); rm.tipoUsuario = usuario.ID_TIPO_USUARIO.ToString(); } else { rm.SetResponse(false, "Usuario y/o clave incorrectos"); } } } catch (Exception) { throw; } return(rm); }
public void GuardarAlumno() { try { using (var context = new MatriculasContext()) { this.ID_USUARIO_REG = 1; this.FLG_ESTADO = "1"; context.Entry(this).State = EntityState.Added; context.SaveChanges(); } } catch (Exception E) { throw; } }
public List <T_GENM_AULA> listarAula() { var aulas = new List <T_GENM_AULA>(); try { using (var context = new MatriculasContext()) { aulas = context.T_GENM_AULA.Where(x => x.FLG_ESTADO == "1").ToList(); } } catch (Exception ex) { throw; } return(aulas); }
public List <T_GENM_GRUPO> ListarGrupo() { var grupos = new List <T_GENM_GRUPO>(); try { using (var context = new MatriculasContext()) { grupos = context.T_GENM_GRUPO.Where(x => x.FLG_ESTADO == "1").ToList(); } } catch (Exception ex) { throw; } return(grupos); }
public List <T_GENM_ALUMNO> ListarAlumnos() { var alumnos = new List <T_GENM_ALUMNO>(); try { using (var context = new MatriculasContext()) { alumnos = context.T_GENM_ALUMNO.ToList(); } } catch (Exception ex) { throw; } return(alumnos); }
public List <T_MAE_SEMESTRE> listarSemestre() { var semestre = new List <T_MAE_SEMESTRE>(); try { using (var context = new MatriculasContext()) { semestre = context.T_MAE_SEMESTRE.Where(x => x.FLG_ESTADO == "1").ToList(); } } catch (Exception ex) { throw; } return(semestre); }
public void Guardar() { try { using (var context = new MatriculasContext()) { this.ID_TIPO_ASIGNATURA = 1; this.ID_CICLO_PLAN = 1; this.ID_USUARIO_REG = 1; context.Entry(this).State = EntityState.Added; context.SaveChanges(); } } catch (Exception E) { throw; } }
public List <T_GENM_ASIGNATURA> ListarAsignaturas() { var asignaturas = new List <T_GENM_ASIGNATURA>(); try { using (var context = new MatriculasContext()) { asignaturas = context.T_GENM_ASIGNATURA.ToList(); } } catch (Exception ex) { throw; } return(asignaturas); }