/// <summary> /// Load list of facility of hospital /// </summary> /// <param name="hospitalID"></param> /// <returns></returns> public static async Task <List <FacilityEntity> > LoadFacilityOfHospitalAsync(int hospitalID) { List <FacilityEntity> facilityList = new List <FacilityEntity>(); List <SP_LOAD_FACILITY_IN_HOSPITAL_FACILITYResult> result; FacilityEntity facility = null; using (LinqDBDataContext data = new LinqDBDataContext()) { result = await Task.Run(() => data.SP_LOAD_FACILITY_IN_HOSPITAL_FACILITY(hospitalID).ToList()); foreach (SP_LOAD_FACILITY_IN_HOSPITAL_FACILITYResult r in result) { facility = new FacilityEntity(); facility.Facility_ID = r.Facility_ID; facility.Facility_Name = r.Facility_Name; facility.Type_ID = r.Facility_Type; facility.Type_Name = r.Type_Name; facilityList.Add(facility); } } return(facilityList); }