public DataTable Data(GazetteerColumnHeaders gazetteerColumnHeaders)
{
DataTable dt = new DataTable();
dt.Columns.Add(gazetteerColumnHeaders.Level1Name);
dt.Columns.Add(gazetteerColumnHeaders.Level2Name);
dt.Columns.Add(gazetteerColumnHeaders.Level3Name);
dt.Columns.Add(gazetteerColumnHeaders.Level1Code);
dt.Columns.Add(gazetteerColumnHeaders.Level2Code);
dt.Columns.Add(gazetteerColumnHeaders.Level3Code);
foreach (var line in lines)
{
object[] values =
{
line.Item1[0], line.Item1[1], line.Item1[2],
line.Item2[0], line.Item2[1], line.Item2[2]
};
dt.LoadDataRow(values, true);
}
return dt;
}
private void SetColumnNames()
{
GazetteerColumnHeaders columnHeaders = new GazetteerColumnHeaders();
columnHeaders.Level1Code = cboLevel1Codes.SelectedValue as string;
columnHeaders.Level1Name = cboLevel1Names.SelectedValue as string;
columnHeaders.Level1AltName = cboLevel1AltNames.SelectedValue as string;
columnHeaders.Level2Code = cboLevel2Codes.SelectedValue as string;
columnHeaders.Level2Name = cboLevel2Names.SelectedValue as string;
columnHeaders.Level2AltName = cboLevel2AltNames.SelectedValue as string;
columnHeaders.Level3Code = cboLevel3Codes.SelectedValue as string;
columnHeaders.Level3Name = cboLevel3Names.SelectedValue as string;
columnHeaders.Level3AltName = cboLevel3AltNames.SelectedValue as string;
geoCoder.SetGazetteerColumns(columnHeaders);
}
private static GazetteerColumnHeaders GazetteerColumnNames()
{
GazetteerColumnHeaders gazetteerColumnHeaders = new GazetteerColumnHeaders();
gazetteerColumnHeaders.Level1Code = "ID1";
gazetteerColumnHeaders.Level2Code = "ID2";
gazetteerColumnHeaders.Level3Code = "ID3";
gazetteerColumnHeaders.Level1Name = "Name1";
gazetteerColumnHeaders.Level2Name = "Name2";
gazetteerColumnHeaders.Level3Name = "Name3";
return gazetteerColumnHeaders;
}