public string GetCountryWithKeyWords(string CountryName)
{
DataTable dt = Connection.GetSQLTable("SELECT g.CountryID,g.Country,ck.keywords FROM gdscountries g INNER JOIN countrykeywords ck" +
" ON g.countryid = ck.countryid WHERE keywords LIKE '" + CountryName + "%' LIMIT 1");
//List<CLayer.GDSCountry> result = new List<CLayer.GDSCountry>();
string result = string.Empty;
foreach (DataRow dr in dt.Rows)
{
CLayer.GDSCountry obj = new CLayer.GDSCountry();
obj.CountryID = Connection.ToInteger(dr["CountryID"]);
obj.Country = Connection.ToString(dr["Country"]);
//obj.IATACode = Connection.ToString(dr["IATACode"]);
//obj.UPSCode = Connection.ToString(dr["UPSCode"]);
//obj.CurrencyCode = Connection.ToString(dr["CurrencyCode"]);
//obj.CurrencyName = Connection.ToString(dr["CurrencyName"]);
result = obj.Country;
}
return(result);
}
public List <CLayer.GDSCountry> GetGDSCountry(string CountryName)
{
//string CountryFromKeyWord = GetCountryWithKeyWords(CountryName);
//CountryName = string.IsNullOrEmpty(CountryFromKeyWord) ? CountryName : CountryFromKeyWord;
DataTable dt = Connection.GetSQLTable("SELECT c.CountryID,C.Name AS Country,g.IATACode,g.UPSCode,g.CurrencyCode,g.CurrencyName " +
" FROM Country c INNER JOIN gdscountries g ON g.country=c.name WHERE country like '" + CountryName + "%'");
List <CLayer.GDSCountry> result = new List <CLayer.GDSCountry>();
foreach (DataRow dr in dt.Rows)
{
CLayer.GDSCountry obj = new CLayer.GDSCountry();
obj.CountryID = Connection.ToInteger(dr["CountryID"]);
obj.Country = Connection.ToString(dr["Country"]);
obj.IATACode = Connection.ToString(dr["IATACode"]);
obj.UPSCode = Connection.ToString(dr["UPSCode"]);
obj.CurrencyCode = Connection.ToString(dr["CurrencyCode"]);
obj.CurrencyName = Connection.ToString(dr["CurrencyName"]);
result.Add(obj);
}
return(result);
}
