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