public IQueryable <Specialization> GetSpecializationsByDoctorId(int doctorId)
{
HospitalSystemDbContext context = new HospitalSystemDbContext();
IQueryable <Specialization> result = context.Specializations.Where(pl => pl.Doctors.Any(u => u.Id == doctorId));
return(result);
}
public IQueryable <Medicine> GetMedicineByPatientId(int patientId)
{
HospitalSystemDbContext context = new HospitalSystemDbContext();
IQueryable <Medicine> result = context.Medicines.Where(pl => pl.Patients.Any(u => u.Id == patientId));
return(result);
}
public PatientRepository(HospitalSystemDbContext context) : base(context)
{
}
public MedicineRepository(HospitalSystemDbContext context) : base(context)
{
}
public AppointmentRepository(HospitalSystemDbContext context) : base(context)
{
}
public DoctorRepository(HospitalSystemDbContext context) : base(context)
{
}
public SpecializationRepository(HospitalSystemDbContext context) : base(context)
{
}