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