public object GetValue(int i)
{
object v_ret = null;
if (i >= _shapeFileDataReader.FieldCount)
{
try
{
// Get shape and reproject if necessary
IGeometry geom = _shapeFileDataReader.Geometry;
if (_coordTransform != null)
{
geom = ShapeFileHelper.ReprojectGeometry(_shapeFileDataReader.Geometry, _coordTransform);
}
// Convert to sqltype
if (_spatialType == enSpatialType.both)
{
v_ret = SqlServerHelper.ConvertToSqlType(geom, _srid, i == _shapeFileDataReader.FieldCount + 1, _curRowIndex);
}
else
{
v_ret = SqlServerHelper.ConvertToSqlType(geom, _srid, _spatialType == enSpatialType.geography, _curRowIndex);
}
}
catch (Exception ex)
{
if (_errorHandler != null)
{
var args = new ShapeImportExceptionEventArgs(ex, false, this.DumpCurrentRecord(), this.Geometry, _curRowIndex);
_errorHandler(this, args);
if (args.Ignore)
{
v_ret = null;
}
}
else
{
throw;
}
}
}
else
{
//Type fieldType = _shapeFileDataReader.GetFieldType(i);
v_ret = _shapeFileDataReader.GetValue(i);
}
return(v_ret);
}
public void ImportShapeFile(string connectionString,
string targetCoordSystem,
bool recreateTable,
enSpatialType spatialType,
int SRID,
string tableName,
string schema,
string IdColName,
string geomcolName,
List <string> fieldsToImport)
{
_worker = new BackgroundWorker();
_worker.WorkerSupportsCancellation = true;
_worker.WorkerReportsProgress = true;
_worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_worker_RunWorkerCompleted);
_worker.ProgressChanged += new ProgressChangedEventHandler(_worker_ProgressChanged);
_worker.DoWork += new DoWorkEventHandler(delegate(object sender, DoWorkEventArgs e)
{
try
{
#region Work
MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Worker started");
_worker.ReportProgress(0, "Starting...");
#region Init ICoordinateTransformation
_transform = null;
if (!string.IsNullOrWhiteSpace(targetCoordSystem))
{
//string v_targetCoordSys = "GEOGCS[\"WGS 84\",DATUM[\"WGS_1984\",SPHEROID[\"WGS 84\",6378137,298.257223563,AUTHORITY[\"EPSG\",\"7030\"]],AUTHORITY[\"EPSG\",\"6326\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4326\"]]";
ICoordinateSystem csSource = ProjNet.Converters.WellKnownText.CoordinateSystemWktReader.Parse(this.CoordinateSystem) as ICoordinateSystem;
ICoordinateSystem csTarget = ProjNet.Converters.WellKnownText.CoordinateSystemWktReader.Parse(targetCoordSystem) as ICoordinateSystem;
_transform = new CoordinateTransformationFactory().CreateFromCoordinateSystems(csSource, csTarget);
}
#endregion Init ICoordinateTransformation
using (ShapefileDataReader shapeDataReader = new ShapefileDataReader(_shapeFile, GeometryFactory.Default))
{
using (SqlConnection db = new SqlConnection(connectionString))
{
MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Opening SQL connection");
db.Open();
SqlTransaction transaction = db.BeginTransaction(IsolationLevel.Serializable);
try
{
#region Create destination table
DbaseFieldDescriptor[] fields = (from field in shapeDataReader.DbaseHeader.Fields
where fieldsToImport.Contains(field.Name)
select field).ToArray();
List <SqlColumnDescriptor> sqlFields = ShapeFileHelper.TranslateDbfTypesToSql(fields);
MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Create SQL table " + tableName);
string sqlScriptCreateTable = SqlServerModel.GenerateCreateTableScript(tableName, schema, sqlFields, spatialType, recreateTable, geomcolName, IdColName);
DataTable dataTable = SqlServerModel.GenerateDataTable(tableName, sqlFields, spatialType, recreateTable, geomcolName, IdColName);
new SqlCommand(sqlScriptCreateTable, db, transaction).ExecuteNonQuery();
#endregion
#region Read shape file
int numRecord = 0;
while (shapeDataReader.Read())
{
numRecord++;
try
{
#region Shape feature import
if (_worker.CancellationPending)
{
break;
}
IGeometry geom = shapeDataReader.Geometry;
IGeometry geomOut = null; // BUGGY GeometryTransform.TransformGeometry(GeometryFactory.Default, geom, trans.MathTransform);
if (_transform == null)
{
geomOut = geom;
}
else
{
geomOut = ShapeFileHelper.ReprojectGeometry(geom, _transform);
}
#region Prepare insert
// Set geom SRID
geomOut.SRID = SRID;
List <object> SqlNativeGeomList = new List <object>();
List <object> properties = new List <object>();
switch (spatialType)
{
#region geography
case enSpatialType.geography:
try
{
SqlNativeGeomList.Add(SqlServerHelper.ConvertToSqlType(geomOut, SRID, true, numRecord));
}
catch (Exception exGeomConvert)
{
MapBindTrace.Source.TraceData(TraceEventType.Error, 1, "Error Converting geography : ", exGeomConvert);
var args = new ShapeImportExceptionEventArgs(exGeomConvert, false, shapeDataReader.DumpCurrentRecord(), shapeDataReader.Geometry, numRecord);
if (this.Raise_Error(args))
{
if (args.Ignore)
{
SqlNativeGeomList = new List <object>();
}
else
{
break;
}
}
else
{
break;
}
}
break;
#endregion
#region geometry
case enSpatialType.geometry:
try
{
SqlNativeGeomList.Add(SqlServerHelper.ConvertToSqlType(geomOut, SRID, false, numRecord));
}
catch (Exception exGeomConvert)
{
MapBindTrace.Source.TraceData(TraceEventType.Error, 1, "Error Converting geometry : ", exGeomConvert);
var args = new ShapeImportExceptionEventArgs(exGeomConvert, false, shapeDataReader.DumpCurrentRecord(), shapeDataReader.Geometry, numRecord);
if (this.Raise_Error(args))
{
if (args.Ignore)
{
SqlNativeGeomList = new List <object>();
}
else
{
break;
}
}
else
{
break;
}
}
break;
#endregion
#region both
case enSpatialType.both:
bool geomConverted = false;
try
{
SqlNativeGeomList.Add(SqlServerHelper.ConvertToSqlType(geomOut, SRID, false, numRecord));
geomConverted = true;
SqlNativeGeomList.Add(SqlServerHelper.ConvertToSqlType(geomOut, SRID, true, numRecord));
}
catch (Exception exGeomConvert)
{
MapBindTrace.Source.TraceData(TraceEventType.Error, 1, "Error Converting geometry or geography : ", exGeomConvert);
var args = new ShapeImportExceptionEventArgs(exGeomConvert, false, shapeDataReader.DumpCurrentRecord(), shapeDataReader.Geometry, numRecord);
if (this.Raise_Error(args))
{
if (args.Ignore)
{
if (geomConverted)
{
SqlNativeGeomList.Add(null);
}
else
{
SqlNativeGeomList.AddRange(new object[] { null, null });
}
}
else
{
break;
}
}
else
{
break;
}
}
break;
#endregion
}
// Get Attributes
for (int i = 0; i < fields.Length; i++)
{
properties.Add(shapeDataReader[fields[i].Name]);
}
// Fill in-memory datatable
DataRow row = SqlServerModel.GetNewDataTableRow(dataTable, tableName, SqlNativeGeomList, properties);
dataTable.Rows.Add(row);
#endregion
//if (numRecord % 10 == 0)
_worker.ReportProgress((int)((numRecord * 100f) / this.RecordCount), string.Format("Reading {0} records", numRecord));
#endregion
}
catch (Exception exGeom)
{
MapBindTrace.Source.TraceData(TraceEventType.Error, 1, "Error Converting geometry : ", exGeom);
this.Raise_Error(new ShapeImportExceptionEventArgs(exGeom, true, shapeDataReader.DumpCurrentRecord(), shapeDataReader.Geometry, numRecord));
}
}
#endregion Read shape file
#region Bulk insert
if (!_worker.CancellationPending)
{
using (SqlBulkCopy bulk = new SqlBulkCopy(db, SqlBulkCopyOptions.Default, transaction))
{
try
{
bulk.DestinationTableName = SqlServerModel.GenerateFullTableName(tableName, schema);
bulk.BulkCopyTimeout = 3600; // 1 hour timeout
bulk.NotifyAfter = 10;
bulk.SqlRowsCopied += (o, args) =>
{
if (_worker.CancellationPending)
{
args.Abort = true;
}
else
{
_worker.ReportProgress((int)((args.RowsCopied * 100f) / this.RecordCount), string.Format("Writing {0} records", args.RowsCopied));
}
};
_worker.ReportProgress(0, string.Format("Writing {0} records", 0));
bulk.WriteToServer(dataTable);
bulk.Close();
}
catch (OperationAbortedException ex)
{
MapBindTrace.Source.TraceData(TraceEventType.Error, 1, "Error inserting: ", ex);
bulk.Close();
}
}
}
#endregion
if (_worker.CancellationPending)
{
MapBindTrace.Source.TraceEvent(TraceEventType.Warning, 1, "Rolling back transaction");
transaction.Rollback();
}
else
{
#region Create spatial index
MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Create spatial index");
_worker.ReportProgress(100, "Creating index...");
// Create spatial index
string sqlScriptCreateIndex = SqlServerModel.GenerateCreateSpatialIndexScript(tableName, schema, geomcolName, SqlServerHelper.GetBoundingBox(this.Bounds), spatialType, enSpatialIndexGridDensity.MEDIUM);
SqlCommand v_createdIndexcmd = new SqlCommand(sqlScriptCreateIndex, db, transaction);
v_createdIndexcmd.CommandTimeout = 3600;
v_createdIndexcmd.ExecuteNonQuery();
#endregion
MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Commit transaction");
transaction.Commit();
}
}
catch (Exception ex)
{
MapBindTrace.Source.TraceData(TraceEventType.Error, 2, "Error: ", ex);
MapBindTrace.Source.TraceEvent(TraceEventType.Warning, 2, "Rolling back transaction");
transaction.Rollback();
if (!this.Raise_Error(new ShapeImportExceptionEventArgs(ex, true)))
{
throw;
}
}
MapBindTrace.Source.TraceEvent(TraceEventType.Verbose, 2, "closing DB");
db.Close();
}
}
#endregion
}
catch (Exception ex)
{
MapBindTrace.Source.TraceData(TraceEventType.Error, 3, "Error: ", ex);
this.Raise_Error(new ShapeImportExceptionEventArgs(ex, true));
}
});
Trace.CorrelationManager.StartLogicalOperation("ImportShapeFile Worker");
_worker.RunWorkerAsync();
Trace.CorrelationManager.StopLogicalOperation();
}