private Collection <MsSqlFeatureLayer> GetMsSql2008FeatureLayers()
{
if (LayerInfo != null)
{
MsSqlServerDataRepositoryItem serverItem = Parent.Parent.Parent.Parent.Parent as MsSqlServerDataRepositoryItem;
if (serverItem != null)
{
LayerInfo.TableName = TableName;
LayerInfo.DatabaseName = DatabaseName;
LayerInfo.SchemaName = SchemaName;
Collection <string> newColumnNames = LayerInfo.CollectColumnsFromTable();
FeatureIdColumnWindow featureIdColumnWindow = new FeatureIdColumnWindow(newColumnNames);
featureIdColumnWindow.Owner = Application.Current.MainWindow;
featureIdColumnWindow.WindowStartupLocation = WindowStartupLocation.CenterOwner;
if (featureIdColumnWindow.ShowDialog().GetValueOrDefault())
{
GetLayersParameters layerParameters = new GetLayersParameters();
layerParameters.CustomData["TableName"] = TableName;
layerParameters.CustomData["SchemaName"] = SchemaName;
layerParameters.CustomData["DatabaseName"] = DatabaseName;
layerParameters.CustomData["IdColumn"] = featureIdColumnWindow.FeatureIdColumn;
layerParameters.CustomData["ServerName"] = serverItem.Name;
layerParameters.CustomData["UserName"] = serverItem.UserName;
layerParameters.CustomData["Password"] = serverItem.Password;
Collection <MsSqlFeatureLayer> newLayers = new Collection <MsSqlFeatureLayer>();
try
{
newLayers = GisEditor.LayerManager.GetLayers <MsSqlFeatureLayer>(layerParameters);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Unable to Load Layer(s)", MessageBoxButton.OK, MessageBoxImage.Error);
}
if (newLayers != null && newLayers.Count > 0)
{
return(newLayers);
}
}
}
}
return(new Collection <MsSqlFeatureLayer>());
}
