/// <summary>
/// Search hospitals in database using normal option
/// </summary>
/// <returns></returns>
public async Task <List <HospitalEntity> > NormalSearchHospital()
{
List <HospitalEntity> hospitalList = null;
// Take input values
int cityId = this.CityID;
int districtId = this.DistrictID;
string whatPhrase = this.WhatPhrase;
// Search for suitable hospitals in database
using (LinqDBDataContext data = new LinqDBDataContext())
{
hospitalList = await Task.Run(() =>
(from h in data.SP_NORMAL_SEARCH_HOSPITAL(whatPhrase.Trim().ToLower(),
cityId, districtId)
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);
}
