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