private string searchAmphorInDB(string amphor, string provinceCode)
{
string _district = string.Empty;
if (provinceCode.isNotEmpty())
{
models.Provinces _provinceList = _liProvince.Where(p => p.ProvinceCode == provinceCode).FirstOrDefault();
if (_provinceList != null)
{
_district = _provinceList.liDistrict
.Where(d => d.District == amphor)
.Select(d => d.District)
.FirstOrDefault();
int _len = amphor.Length;
if (_district.isEmpty() && _len > 1)
{
_district = string.Empty;
string _tmp = string.Empty;
List <string> _li;
// #forward search
for (int i = 2; i <= _len; i++)
{
_tmp = amphor.Substring(0, i);
_li = _provinceList.liDistrict
.Where(p => p.District.StartsWith(_tmp))
.Select(d => d.District)
.ToList();
if (_li.Count == 1)
{
_district = _li[0];
}
}
if (_district.isEmpty())
{
// #backward search
for (int i = _len - 2; i > 0; i--)
{
_tmp = amphor.Substring(i);
_li = _provinceList.liDistrict
.Where(p => p.District.EndsWith(_tmp))
.Select(d => d.District)
.ToList();
if (_li.Count == 1)
{
_district = _li[0];
}
}
}
}
}
}
return(_district);
}
private string getProvinceCode(string province)
{
string _province = string.Empty;
models.Provinces _provinceList = _liProvince.Where(p => p.ProvinceName == province).FirstOrDefault();
if (_provinceList != null)
{
_province = _provinceList.ProvinceCode;
}
return(_province);
}
private string searchProvinceInDB(string province)
{
string _province = string.Empty;
models.Provinces _provinceList = _liProvince.Where(p => p.ProvinceName == province).FirstOrDefault();
if (_provinceList != null)
{
_province = _provinceList.ProvinceName;
}
else
{
string _tmp = string.Empty;
List <models.Provinces> _li;
int _len = province.Length;
if (_len > 1)
{
// #forward search
for (int i = 2; i <= _len; i++)
{
_tmp = province.Substring(0, i);
_li = _liProvince.Where(p => p.ProvinceName.StartsWith(_tmp)).ToList();
if (_li.Count == 1)
{
_province = _li[0].ProvinceName;
break;
}
}
if (_province.isEmpty())
{
// #backward search
for (int i = _len - 2; i > 0; i--)
{
_tmp = province.Substring(i);
_li = _liProvince.Where(p => p.ProvinceName.EndsWith(_tmp)).ToList();
if (_li.Count == 1)
{
_province = _li[0].ProvinceName;
break;
}
}
}
}
}
return(_province);
}