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