public WorkingHour GetById(long id)
{
using (var dbContext = new SoftTehnicaDbContext())
{
return(dbContext.WorkingHours.SingleOrDefault(x => x.Id == id));
}
}
public IList <Doctor> GetDoctors(Procedure procedure)
{
using (var dbContext = new SoftTehnicaDbContext())
{
return(dbContext.Doctors.Where(x => x.Procedures.Any(y => y.Id == procedure.Id)).ToList());
}
}
public Procedure GetById(long id)
{
using (var dbContext = new SoftTehnicaDbContext())
{
return(dbContext.Procedures.SingleOrDefault(x => x.Id == id));
}
}
public void Insert(WorkingHour workingHour)
{
using (var dbContext = new SoftTehnicaDbContext())
{
dbContext.WorkingHours.Add(workingHour);
dbContext.SaveChanges();
}
}
public void Insert(Doctor doctor)
{
using (var dbContext = new SoftTehnicaDbContext())
{
dbContext.Doctors.Add(doctor);
dbContext.SaveChanges();
}
}
public void Insert(Procedure procedure)
{
using (var dbContext = new SoftTehnicaDbContext())
{
dbContext.Procedures.Add(procedure);
dbContext.SaveChanges();
}
}
public User GetByUserName(string name)
{
using (var dbContext = new SoftTehnicaDbContext())
{
var dbUser = dbContext.Users.SingleOrDefault(x => x.UserName == name);
return(dbUser);
}
}
public bool IsValid(string userName, string password)
{
using (var dbContext = new SoftTehnicaDbContext())
{
var dbUser = dbContext.Users.SingleOrDefault(x => x.UserName == userName);
return(dbUser != null && dbUser.Password == password);
}
}
public IList <Procedure> GetAll()
{
using (var dbContext = new SoftTehnicaDbContext())
{
var d = dbContext.Procedures;
var e = d.ToList();
return(e);
//dbContext.Procedures.ToList();
}
}
public IList <Appointment> GetAll()
{
using (var dbContext = new SoftTehnicaDbContext())
{
return
(dbContext.Appointments.Include(x => x.Doctor)
.Include(x => x.Time)
.Include(x => x.Procedure)
.ToList());
}
}
public void Insert(Appointment appointment)
{
using (var dbContext = new SoftTehnicaDbContext())
{
dbContext.Entry(appointment.Doctor).State = EntityState.Unchanged;
dbContext.Entry(appointment.Procedure).State = EntityState.Unchanged;
dbContext.Entry(appointment.Time).State = EntityState.Unchanged;
dbContext.Appointments.Add(appointment);
dbContext.SaveChanges();
}
}
public IList <WorkingHour> GetFreeWorkingHours(long doctorId, DateTimeOffset date)
{
using (var dbContext = new SoftTehnicaDbContext())
{
var timeIds = dbContext.Appointments.Where(x => x.Doctor.Id == doctorId)
.Where(x => x.Date == date).Select(x => x.Time);
var t =
dbContext.WorkingHours.Where(y => y.Doctors.Any(x => x.Id == doctorId))
.Where(x => !timeIds.Any(y => y.Id == x.Id))
.ToList();
return(t);
}
}