/// <summary> /// The default names of the columns that contain the gazetteer data to be matched. /// </summary> /// <returns> /// The column names /// </returns> public GazetteerColumnHeaders DefaultGazetteerColumnHeaders() { GazetteerColumnHeaders columnHeaders = new GazetteerColumnHeaders(); GazetteerColumnsMapping columnsMapping = columnsMappingProvider.GetGazetteerColumnsMapping(gazetteerFileName); if (columnsMapping != null) { columnHeaders.Level1Code = columnsMapping.Level1Code; columnHeaders.Level2Code = columnsMapping.Level2Code; columnHeaders.Level3Code = columnsMapping.Level3Code; columnHeaders.Level1Name = columnsMapping.Level1Name; columnHeaders.Level2Name = columnsMapping.Level2Name; columnHeaders.Level3Name = columnsMapping.Level3Name; columnHeaders.Level1AltName = columnsMapping.Level1AltName; columnHeaders.Level2AltName = columnsMapping.Level2AltName; columnHeaders.Level3AltName = columnsMapping.Level3AltName; } return(columnHeaders); }
public void SaveGazetteerColumnsMapping(GazetteerColumnsMapping columnMapping) { bool exists = dbConnection.Query <int>( @"SELECT COUNT(*) FROM GazetteerColumnsMapping WHERE FileName=@FileName", new { columnMapping.FileName }).FirstOrDefault() > 0; if (!exists) { dbConnection.Execute( @"INSERT INTO GazetteerColumnsMapping ( FileName, Level1Code, Level1Name, Level1AltName, Level2Code, Level2Name, Level2AltName, Level3Code, Level3Name, Level3AltName ) VALUES ( @FileName, @Level1Code, @Level1Name, @Level1AltName, @Level2Code, @Level2Name, @Level2AltName, @Level3Code, @Level3Name, @Level3AltName )", new { columnMapping.FileName, columnMapping.Level1Code, columnMapping.Level1Name, columnMapping.Level1AltName, columnMapping.Level2Code, columnMapping.Level2Name, columnMapping.Level2AltName, columnMapping.Level3Code, columnMapping.Level3Name, columnMapping.Level3AltName, } ); } else { dbConnection.Execute( @"UPDATE GazetteerColumnsMapping SET Level1Code=@Level1Code, Level1Name=@Level1Name, Level1AltName=@Level1AltName, Level2Code=@Level2Code, Level2Name=@Level2Name, Level2AltName=@Level2AltName, Level3Code=@Level3Code, Level3Name=@Level3Name, Level3AltName=@Level3AltName WHERE FileName=@FileName", new { columnMapping.FileName, columnMapping.Level1Code, columnMapping.Level1Name, columnMapping.Level1AltName, columnMapping.Level2Code, columnMapping.Level2Name, columnMapping.Level2AltName, columnMapping.Level3Code, columnMapping.Level3Name, columnMapping.Level3AltName, } ); } }
public void SaveGazetteerColumnsMapping(GazetteerColumnsMapping columnMapping) { bool exists = dbConnection.Query<int>( @"SELECT COUNT(*) FROM GazetteerColumnsMapping WHERE FileName=@FileName", new {columnMapping.FileName}).FirstOrDefault() > 0; if (!exists) { dbConnection.Execute( @"INSERT INTO GazetteerColumnsMapping ( FileName, Level1Code, Level1Name, Level1AltName, Level2Code, Level2Name, Level2AltName, Level3Code, Level3Name, Level3AltName ) VALUES ( @FileName, @Level1Code, @Level1Name, @Level1AltName, @Level2Code, @Level2Name, @Level2AltName, @Level3Code, @Level3Name, @Level3AltName )", new { columnMapping.FileName, columnMapping.Level1Code, columnMapping.Level1Name, columnMapping.Level1AltName, columnMapping.Level2Code, columnMapping.Level2Name, columnMapping.Level2AltName, columnMapping.Level3Code, columnMapping.Level3Name, columnMapping.Level3AltName, } ); } else { dbConnection.Execute( @"UPDATE GazetteerColumnsMapping SET Level1Code=@Level1Code, Level1Name=@Level1Name, Level1AltName=@Level1AltName, Level2Code=@Level2Code, Level2Name=@Level2Name, Level2AltName=@Level2AltName, Level3Code=@Level3Code, Level3Name=@Level3Name, Level3AltName=@Level3AltName WHERE FileName=@FileName", new { columnMapping.FileName, columnMapping.Level1Code, columnMapping.Level1Name, columnMapping.Level1AltName, columnMapping.Level2Code, columnMapping.Level2Name, columnMapping.Level2AltName, columnMapping.Level3Code, columnMapping.Level3Name, columnMapping.Level3AltName, } ); } }