public Boolean Actualizar(Alumno objalumno)
{
bool exito = true;
try
{
using (var data = new bdnotasEntities())
{
using (var dbContextTransaction = data.Database.BeginTransaction())
{
Alumno alumnoactual = data.Alumno.Where(q => q.IdAlumno == objalumno.IdAlumno).FirstOrDefault();
alumnoactual.NomAlumno = objalumno.NomAlumno;
alumnoactual.ApeAlumno = objalumno.ApeAlumno;
alumnoactual.Idesp = objalumno.Idesp;
alumnoactual.PROCE = objalumno.PROCE;
data.SaveChanges();
dbContextTransaction.Commit();
}
}
}
catch (Exception ex)
{
exito = false;
}
return(exito);
}
public List <Alumno> Listar()
{
List <Alumno> lista = new List <Alumno>();
using (var data = new bdnotasEntities())
{
lista = data.Alumno.ToList();
}
return(lista);
}
public Alumno Obtener(String idalumno)
{
Alumno obj = new Alumno();
using (var data = new bdnotasEntities())
{
obj = data.Alumno.Where(q => q.IdAlumno == idalumno).FirstOrDefault();
}
return(obj);
}
public Boolean Eliminar(String idalumno)
{
bool exito = true;
try
{
using (var data = new bdnotasEntities())
{
exito = data.sp_MantEliminarAlumno(idalumno) > 0 ? true : false;
}
}
catch (Exception ex)
{
exito = false;
}
return(exito);
}
public Boolean Registrar(Alumno objalumno)
{
bool exito = true;
try
{
using (var data = new bdnotasEntities())
{
exito = data.sp_MantRegistrarAlumno(objalumno.NomAlumno, objalumno.ApeAlumno,
objalumno.Idesp, objalumno.PROCE) > 0 ? true : false;
}
}
catch (Exception ex)
{
exito = false;
}
return(exito);
}
