/// <summary> /// Load list of service of hospital /// </summary> /// <param name="hospitalID"></param> /// <returns></returns> public static async Task <List <ServiceEntity> > LoadServiceOfHospitalAsync(int hospitalID) { List <ServiceEntity> serviceList = new List <ServiceEntity>(); List <SP_LOAD_SERVICE_IN_HOSPITAL_SERVICEResult> result; ServiceEntity service = null; using (LinqDBDataContext data = new LinqDBDataContext()) { result = await Task.Run(() => data.SP_LOAD_SERVICE_IN_HOSPITAL_SERVICE(hospitalID).ToList()); foreach (SP_LOAD_SERVICE_IN_HOSPITAL_SERVICEResult r in result) { service = new ServiceEntity(); service.Service_ID = r.Service_ID; service.Service_Name = r.Service_Name; service.Type_ID = r.Service_Type; service.Type_Name = r.Type_Name; serviceList.Add(service); } } return(serviceList); }