public void Update(Patient entity) { var db = new VetDbContext(); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); }
public IEnumerable <Appointment> List() { var db = new VetDbContext(); IList <Appointment> appointments = db.Appointments.Include(a => a.Doctor).Include(a => a.Patient).Include(a => a.Patient.Owner).Include(a => a.Room).ToList(); return(appointments); }
public IEnumerable <Patient> List() { var db = new VetDbContext(); IList <Patient> patients = db.Patients.Include(a => a.Owner).ToList(); return(patients); }
public Patient GetById(int id) { var db = new VetDbContext(); var patient = db.Patients.Include(a => a.Owner).Where(x => x.Id == id).Single(); return(patient); }
public Appointment GetById(int id) { var db = new VetDbContext(); var appointment = db.Appointments.Include(a => a.Doctor).Include(a => a.Patient).Include(a => a.Patient.Owner).Include(a => a.Room).Where(x => x.Id == id).Single(); return(appointment); }
public IEnumerable <Client> List() { var db = new VetDbContext(); IList <Client> clients = db.Clients.ToList(); return(clients); }
public Client GetById(int id) { var db = new VetDbContext(); var client = db.Clients.Find(id); return(client); }
public IEnumerable <Client> GetByFilters(Client entity) { var db = new VetDbContext(); var clients = db.Clients.Where(x => x.DNI == entity.DNI).ToList(); return(clients); }
public Patient Insert(Patient entity) { var db = new VetDbContext(); db.Patients.Add(entity); db.SaveChanges(); return(entity); }
public IEnumerable <Patient> GetByFilters(Patient entity) { var db = new VetDbContext(); var patients = db.Patients.Include(a => a.Owner). Where(x => x.ClientId == entity.ClientId && x.Name == entity.Name).ToList(); return(patients); }
public void Delete(int id) { var db = new VetDbContext(); var patient = db.Patients.Include(a => a.Owner).Where(x => x.Id == id).Single(); db.Patients.Remove(patient); db.SaveChanges(); }
public Appointment Insert(Appointment entity) { var db = new VetDbContext(); db.Appointments.Add(entity); db.SaveChanges(); return(entity); }
public void Delete(int id) { var db = new VetDbContext(); var client = db.Clients.Find(id); db.Clients.Remove(client); db.SaveChanges(); }
public JsonResult GetEvents() { using (VetDbContext dc = new VetDbContext()) { var events = dc.Turnos.ToList(); return(new JsonResult { Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
private IEnumerable <Appointment> GetPatientAppointmentsByDate(Appointment entity) { var db = new VetDbContext(); var appointments = db.Appointments .Include(a => a.Doctor) .Include(a => a.Patient) .Include(a => a.Patient.Owner) .Include(a => a.Room) .Where(x => x.PatientId == entity.PatientId && x.Date == entity.Date && x.Hour == entity.Hour).ToList(); return(appointments); }
public void Delete(int id) { var db = new VetDbContext(); var appointment = db.Appointments.Include(a => a.Doctor). Include(a => a.Patient). Include(a => a.Patient.Owner). Include(a => a.Room). Where(x => x.Id == id).Single(); db.Appointments.Remove(appointment); db.SaveChanges(); }