public List<SearchItem> GetAirports()
{
var airportsList = new List<SearchItem>();
try
{
var db = new MySqlDatabase(DbConfiguration.DatabaseRead);
DataSet dataSet = db.ExecuteQuery(CommandBuilder.BuildGetAirportsCommand(db.Connection));
foreach (DataRow row in dataSet.Tables[0].Rows)
{
var item = new SearchItem
{
Name = row["AirportName"] as string,
Code = row["AirportCode"] as string,
CityName = row["CityName"] as string,
CountryCode = row["CountryCode"] as string
};
airportsList.Add(item);
}
}
catch (Exception ex)
{
DBExceptionLogger.LogException(ex, Source, "GetAirports", Severity.Critical);
}
return airportsList;
}
private static Document IndexDocument(SearchItem item)
{
var doc = new Document();
doc.Add(new Field("SearchKey", (item.FullTextColumn ?? item.Code), Field.Store.NO, Field.Index.ANALYZED));
doc.Add(new Field("Type", "Airport", Field.Store.YES, Field.Index.NOT_ANALYZED));
doc.Add(new Field("Name", item.Name, Field.Store.YES, Field.Index.NOT_ANALYZED));
doc.Add(new Field("Code", item.Code ?? string.Empty, Field.Store.YES, Field.Index.NOT_ANALYZED));
doc.Add(new Field("CityName", item.CityName ?? string.Empty, Field.Store.YES, Field.Index.NOT_ANALYZED));
doc.Add(new Field("CountryCode", item.CountryCode ?? string.Empty, Field.Store.YES, Field.Index.NOT_ANALYZED));
return doc;
}