public override void Add(Student student)
{
using (var db = new UniversityProgramContext())
{
db.Students.Add(student);
db.SaveChanges();
}
}
public override void Add(Subject subject)
{
using (var db = new UniversityProgramContext())
{
db.Subjects.Add(subject);
db.SaveChanges();
}
}
public override void Add(Professor professeur)
{
using (var db = new UniversityProgramContext())
{
db.Professors.Add(professeur);
db.SaveChanges();
}
}
public override void Update(Subject subject)
{
using (var db = new UniversityProgramContext())
{
var entity = db.Subjects.FirstOrDefault(item => item.Id == subject.Id);
db.Subjects.Update(entity);
db.SaveChanges();
}
}
public override void Delete(Student student)
{
using (var db = new UniversityProgramContext())
{
var entity = db.Students.FirstOrDefault(item => item.Id == student.Id);
db.Students.Remove(entity);
db.SaveChanges();
}
}
public override void Delete(Professor professeur)
{
using (var db = new UniversityProgramContext())
{
var entity = db.Professors.FirstOrDefault(item => item.Id == professeur.Id);
db.Professors.Remove(entity);
db.SaveChanges();
}
}
public override void Update(Professor prof)
{
using (var db = new UniversityProgramContext())
{
var entity = db.Professors.FirstOrDefault(item => item.Id == prof.Id);
if (entity != null)
{
db.Professors.Update(entity);
db.SaveChanges();
}
}
}
public override IEnumerable <Subject> GetAll()
{
using (var db = new UniversityProgramContext())
return(db.Subjects.Include(item => item.Professor).ToList());
}
public override IEnumerable <Student> GetAll()
{
using (var db = new UniversityProgramContext())
return(db.Students.ToList());
}
public IEnumerable <Professor> Search(string name)
{
using (var db = new UniversityProgramContext())
return(db.Professors.Where(item => item.Name == name).ToList());
}
public override IEnumerable <Professor> GetAll()
{
using (var db = new UniversityProgramContext())
return(db.Professors.ToList());
}
