/// <summary>
/// Load all doctor in Doctor_Speciality
/// </summary>
/// <param name="SpecialityID"></param>
/// <returns>List[DoctorEnity] that contains list of doctor with appropriate Speciality code</returns>
public static async Task <List <Doctor> > LoadDoctorInDoctorSpecialityAsyn(int SpecialityID, int HospitalID)
{
List <Doctor> doctorList = new List <Doctor>();
Doctor doctor = null;
List <SP_LOAD_DOCTOR_BY_SPECIALITYIDResult> result = null;
// Take doctor in specific speciality in database
using (LinqDBDataContext data = new LinqDBDataContext())
{
result = await Task.Run(() =>
data.SP_LOAD_DOCTOR_BY_SPECIALITYID(SpecialityID, HospitalID).ToList());
}
// Assign value for each doctor
foreach (SP_LOAD_DOCTOR_BY_SPECIALITYIDResult r in result)
{
doctor = new Doctor();
doctor.Doctor_ID = r.Doctor_ID;
doctor.First_Name = r.First_Name;
doctor.Last_Name = r.Last_Name;
doctor.Degree = r.Degree;
doctor.Experience = r.Experience;
doctor.Working_Day = r.Working_Day;
doctor.Photo_ID = r.Photo_ID;
doctorList.Add(doctor);
}
Appointment app = new Appointment();
return(doctorList);
}
