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