private void insertFeatureIntoDataTable(Feature feature, DbCommand command) { string uniqKey = feature.UniqKey; if (IdValueNeeded != null) { IdNeededEventArgs args = new IdNeededEventArgs(feature); IdValueNeeded(this, args); uniqKey = args.Id; } string title = feature.Title; int featureType = (int)feature.FeatureType; byte[] spatialData = SpatialDataBytesFromFeature(feature); BoundingRectangle featureBounds = feature.BoundingRectangle; command.CommandText = "insert into " + _dataTableName + "(" + UniqKeyField + ", " + TitleField + ", " + FeatureTypeField + ", " + SpatialDataField + ", " + MinXField + ", " + MinYField + ", " + MaxXField + ", " + MaxYField + ") values " + "(@" + UniqKeyField + ", @" + TitleField + ", @" + FeatureTypeField + ", @" + SpatialDataField + ", " + "@" + MinXField + ", @" + MinYField + ", @" + MaxXField + ", @" + MaxYField + ")"; addParameter(command, UniqKeyField, uniqKey); addParameter(command, TitleField, title); addParameter(command, FeatureTypeField, featureType); addParameter(command, SpatialDataField, spatialData); addParameter(command, MinXField, featureBounds.MinX); addParameter(command, MinYField, featureBounds.MinY); addParameter(command, MaxXField, featureBounds.MaxX); addParameter(command, MaxYField, featureBounds.MaxY); command.ExecuteNonQuery(); command.Parameters.Clear(); }
private void insertFeatureIntoDataTable(Feature feature, DbCommand command) { string uniqKey = feature.UniqKey; if (IdValueNeeded != null) { IdNeededEventArgs args = new IdNeededEventArgs(feature); IdValueNeeded(this, args); uniqKey = args.Id; } string title = feature.Title; int featureType = (int)feature.FeatureType; byte[] spatialData = SpatialDataBytesFromFeature(feature); BoundingRectangle featureBounds = feature.BoundingRectangle; command.CommandText = "insert into " + _dataTableName + "(" + UniqKeyField + ", " + TitleField + ", " + FeatureTypeField + ", " + SpatialDataField + ", " + MinXField + ", " + MinYField + ", " + MaxXField + ", " + MaxYField + ") values " + "(@" + UniqKeyField + ", @" + TitleField + ", @" + FeatureTypeField + ", @" + SpatialDataField + ", " + "@" + MinXField + ", @" + MinYField + ", @" + MaxXField + ", @" + MaxYField + ")"; addParameter(command, UniqKeyField, uniqKey); addParameter(command, TitleField, title); addParameter(command, FeatureTypeField, featureType); addParameter(command, SpatialDataField, spatialData); addParameter(command, MinXField, featureBounds.MinX); addParameter(command, MinYField, featureBounds.MinY); addParameter(command, MaxXField, featureBounds.MaxX); addParameter(command, MaxYField, featureBounds.MaxY); command.ExecuteNonQuery(); command.Parameters.Clear(); }