public string FindByTextToJson(string text)
{
var merge = (from subdist in _subdistrict.SubDistrictData()
join dist in _district.DistrictData() on subdist.DistrictId equals dist.DistrictId
join pro in _province.ProvinceData() on dist.ProvinceId equals pro.ProvinceId
join pos in _postcode.PostcodeData() on dist.DistrictId equals pos.DistrictId
join reg in _region.RegionData() on pro.RegionId equals reg.RegionId
where subdist.SubDistrictNameTh.Contains(text) || subdist.SubDistrictNameEn.Contains(text) ||
dist.DistrictNameTh.Contains(text) || dist.DistrictNameEn.Contains(text) ||
pro.ProvinceNameTh.Contains(text) || pro.ProvinceNameEn.Contains(text) ||
pos.Postcode.Contains(text)
select new { subdist, dist, pro, pos, reg });
var result = merge.GroupBy(x => x.dist.DistrictId).Select(g => g.First());
return(JsonConvert.SerializeObject(result));
}
public void DistrictDataIsNotNull()
{
Assert.NotNull(_district.DistrictData());
}
/// <summary>
/// Get all district
/// </summary>
/// <returns>Json format</returns>
public string GetDistrictToJson()
{
return(JsonConvert.SerializeObject(_district.DistrictData()));
}
