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);
}