public IEnumerable <Room> List() { var db = new VetDbContext(); IList <Room> rooms = db.Rooms.ToList(); return(rooms); }
public void Update(Room entity) { var db = new VetDbContext(); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); }
public Room GetById(int id) { var db = new VetDbContext(); var room = db.Rooms.Find(id); return(room); }
public IEnumerable <Doctor> List() { var db = new VetDbContext(); IList <Doctor> doctors = db.Doctors.ToList(); return(doctors); }
public IEnumerable <Room> GetByFilters(Room entity) { var db = new VetDbContext(); var rooms = db.Rooms.Where(x => x.Location == entity.Location && x.Name == entity.Name).ToList(); return(rooms); }
public Doctor GetById(int id) { var db = new VetDbContext(); var doctor = db.Doctors.Find(id); return(doctor); }
public IEnumerable <Doctor> GetByFilters(Doctor entity) { var db = new VetDbContext(); var doctors = db.Doctors.Where(x => x.DNI == entity.DNI && x.Enrollment == entity.Enrollment).ToList(); return(doctors); }
public Room Insert(Room entity) { var db = new VetDbContext(); db.Rooms.Add(entity); db.SaveChanges(); return(entity); }
public void Delete(int id) { var db = new VetDbContext(); var room = db.Rooms.Find(id); db.Rooms.Remove(room); db.SaveChanges(); }
public Doctor Insert(Doctor entity) { var db = new VetDbContext(); db.Doctors.Add(entity); db.SaveChanges(); return(entity); }
public void Delete(int id) { var db = new VetDbContext(); var doctor = db.Doctors.Find(id); db.Doctors.Remove(doctor); db.SaveChanges(); }