public void Delete(int num_matricula)
{
using (GlobalDbContext dbContext = new GlobalDbContext())
{
Alumno alumno = dbContext.Alumnos(true)
.Where(s => s.Num_Matricula == num_matricula)
.FirstOrDefault();
if (alumno != null)
{
dbContext.Remove(alumno);
dbContext.SaveChanges();
}
}
}
public void Update(int num_matricula, int dni, string nombre)
{
using (GlobalDbContext dbContext = new GlobalDbContext())
{
Alumno alumno = dbContext.Alumnos(true)
.Where(s => s.Num_Matricula == num_matricula)
.FirstOrDefault();
if (alumno != null)
{
alumno.Dni = dni;
alumno.Nombre = nombre;
dbContext.SaveChanges();
}
}
}
public List <Alumno> GetAlumnos(string buscarText)
{
using (GlobalDbContext dbContext = new GlobalDbContext())
{
IQueryable <Alumno> query = dbContext.Alumnos();
if (!string.IsNullOrEmpty(buscarText))
{
query = query.Where(c =>
c.Nombre.Contains(buscarText)
);
}
query = query.OrderBy(alumno => alumno.Nombre);
return(query.ToList());
}
}
