/// <summary> /// Search hospitals in database using Location option /// </summary> /// <param name="latitude">Latitide</param> /// <param name="longitude">Longitude</param> /// <param name="distance">Distance between 2 locations</param> /// <returns>List[HospitalEntity] that contains a list of Hospitals</returns> public static async Task <List <HospitalEntity> > LocationSearchHospital(double latitude, double longitude, double distance) { List <HospitalEntity> hospitalList = null; // Search for suitable hospitals in database using (LinqDBDataContext data = new LinqDBDataContext()) { hospitalList = await Task.Run(() => (from h in data.SP_LOCATION_SEARCH_HOSPITAL(latitude, longitude, distance) select new HospitalEntity() { Hospital_ID = h.Hospital_ID, Hospital_Name = h.Hospital_Name, Address = h.Address, Ward_ID = h.Ward_ID, District_ID = h.District_ID, City_ID = h.City_ID, Phone_Number = h.Phone_Number, Coordinate = h.Coordinate, Is_Active = h.Is_Active, Rating = h.Rating }).ToList()); } // Return list of hospitals return(hospitalList); }