/// <summary>
/// Поиск городов в регионе
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static List <locCityDTO> SearchCities(int regionId, string query, int rowsCount)
{
using (var dc = new LocateMeDataContext())
{
return((from c in dc.locCities where c.City.StartsWith(query) && c.RegionId == regionId select new locCityDTO {
City = c.City, Id = c.Id, CityType = c.CityType
}).Take(rowsCount).ToList());
}
}
/// <summary>
/// Поиск улиц в городе
/// </summary>
/// <param name="cityId"></param>
/// <param name="query"></param>
/// <param name="rowsCount"></param>
/// <returns></returns>
public static List <locStreetDTO> SearchStreets(int cityId, string query, int rowsCount)
{
using (var dc = new LocateMeDataContext())
{
return((from s in dc.locStreets where s.Street.StartsWith(query) && s.CityId == cityId select new locStreetDTO {
Street = s.Street, Id = s.Id, StreetType = s.StreetType
}).Take(rowsCount).ToList());
}
}
/// <summary>
/// Поиск регионов
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static List <locRegionDTO> SearchRegions(string query, int rowsCount)
{
using (var dc = new LocateMeDataContext())
{
var splitter = query.Split(' ');
List <locRegionDTO> regions = (from r in dc.locRegions where r.Region.Contains(query) select new locRegionDTO {
Id = r.Id, Region = r.Region
}).ToList();
return(ReversSearchResults(query, regions, rowsCount));
}
}
