private Dictionary<string, object> BuildDataAccessFromSelection() { // Will be building SQL Where Clauses for each possible selected thing string MapUnitPolysSearch = "MapUnitPolys_ID = '"; string DataSourcePolysSearch = "DataSourcePolys_ID = '"; string OtherPolysSearch = "OtherPolys_ID = '"; string ContactsAndFaultsSearch = "ContactsAndFaults_ID = '"; string GeologicLinesSearch = "GeologicLines_ID = '"; string StationsSearch = "Stations_ID = '"; string GenericSamplesSearch = "GenericSamples_ID = '"; string OrientationPointsSearch = "OrientationPoints_ID = '"; string GlossarySearch = "Glossary_ID = '"; string DataSourcesSearch = "DataSources_ID = '"; string DescriptionOfMapUnitsSearch = "DescriptionOfMapUnits_ID = '"; // This object will be populated and returned Dictionary<string, object> dataAccessClasses = new Dictionary<string, object>(); #region Selected FEATURES // Get an enumeration of the selected features IEnumFeature selectionEnum = ArcMap.Document.FocusMap.FeatureSelection as IEnumFeature; // Loop through the features to build queries to find the features IRow thisFeature = selectionEnum.Next() as IRow; while (thisFeature != null) { // Get the Table Name string tableName = (thisFeature.Table as IDataset).Name; // Parse the table name in order to strip out unneccessary bits of SDE tables ISQLSyntax nameParser = (ISQLSyntax)m_theWorkspace; string parsedDbName, parsedOwnerName, parsedTableName; nameParser.ParseTableName(tableName, out parsedDbName, out parsedOwnerName, out parsedTableName); // Build the SQL Where Clause depending on the table... switch (parsedTableName) { case "MapUnitPolys": MapUnitPolysSearch += thisFeature.get_Value(thisFeature.Table.FindField("MapUnitPolys_ID")) + "' OR MapUnitPolys_ID = '"; break; case "DataSourcePolys": DataSourcePolysSearch += thisFeature.get_Value(thisFeature.Table.FindField("DataSourcePolys_ID")) + "' OR DataSourcePolys_ID = '"; break; case "OtherPolys": OtherPolysSearch += thisFeature.get_Value(thisFeature.Table.FindField("OtherPolys_ID")) + "' OR OtherPolys_ID = '"; break; case "ContactsAndFaults": ContactsAndFaultsSearch += thisFeature.get_Value(thisFeature.Table.FindField("ContactsAndFaults_ID")) + "' OR ContactsAndFaults_ID = '"; break; case "GeologicLines": GeologicLinesSearch += thisFeature.get_Value(thisFeature.Table.FindField("GeologicLines_ID")) + "' OR GeologicLines_ID = '"; break; case "Stations": StationsSearch += thisFeature.get_Value(thisFeature.Table.FindField("Stations_ID")) + "' OR Stations_ID = '"; break; case "GenericSamples": GenericSamplesSearch += thisFeature.get_Value(thisFeature.Table.FindField("GenericSamples_ID")) + "' OR GenericSamples_ID = '"; break; case "OrientationPoints": OrientationPointsSearch += thisFeature.get_Value(thisFeature.Table.FindField("OrientationPoints_ID")) + "' OR OrientationPoints_ID = '"; break; } // Iterate the enumeration thisFeature = selectionEnum.Next(); } #region "Build Dictionary" // Clean up the Where Clauses, create the data access classes, and then add it to the dictionary // MapUnitPolys if (MapUnitPolysSearch != "MapUnitPolys_ID = '") { MapUnitPolysSearch = MapUnitPolysSearch.Remove(MapUnitPolysSearch.Length - 23); MapUnitPolysAccess MapUnitPolysRecords = new MapUnitPolysAccess(m_theWorkspace); MapUnitPolysRecords.AddMapUnitPolys(MapUnitPolysSearch); dataAccessClasses.Add("MapUnitPolys", MapUnitPolysRecords); } if (DataSourcePolysSearch != "DataSourcePolys_ID = '") { DataSourcePolysSearch = DataSourcePolysSearch.Remove(DataSourcePolysSearch.Length - 25); DataSourcePolysAccess DataSourcePolysRecords = new DataSourcePolysAccess(m_theWorkspace); DataSourcePolysRecords.AddDataSourcePolys(DataSourcePolysSearch); dataAccessClasses.Add("DataSourcePolys", DataSourcePolysRecords); } // OtherPolys if (OtherPolysSearch != "OtherPolys_ID = '") { OtherPolysSearch = OtherPolysSearch.Remove(OtherPolysSearch.Length - 23); OtherPolysAccess OtherPolysRecords = new OtherPolysAccess(m_theWorkspace); OtherPolysRecords.AddOtherPolys(OtherPolysSearch); dataAccessClasses.Add("OtherPolys", OtherPolysRecords); } // ContactsAndFaults if (ContactsAndFaultsSearch != "ContactsAndFaults_ID = '") { ContactsAndFaultsSearch = ContactsAndFaultsSearch.Remove(ContactsAndFaultsSearch.Length - 28); ContactsAndFaultsAccess ContactsAndFaultsRecords = new ContactsAndFaultsAccess(m_theWorkspace); ContactsAndFaultsRecords.AddContactsAndFaults(ContactsAndFaultsSearch); dataAccessClasses.Add("ContactsAndFaults", ContactsAndFaultsRecords); } // GeologicLines if (GeologicLinesSearch != "GeologicLines_ID = '") { GeologicLinesSearch = GeologicLinesSearch.Remove(GeologicLinesSearch.Length - 24); GeologicLinesAccess GeologicLinesRecords = new GeologicLinesAccess(m_theWorkspace); GeologicLinesRecords.AddGeologicLines(GeologicLinesSearch); dataAccessClasses.Add("GeologicLines", GeologicLinesRecords); } // Stations if (StationsSearch != "Stations_ID = '") { StationsSearch = StationsSearch.Remove(StationsSearch.Length - 19); StationsAccess StationsRecords = new StationsAccess(m_theWorkspace); StationsRecords.AddStations(StationsSearch); dataAccessClasses.Add("Stations", StationsRecords); } // GenericSamples if (GenericSamplesSearch != "GenericSamples_ID = '") { GenericSamplesSearch = GenericSamplesSearch.Remove(GenericSamplesSearch.Length - 23); GenericSamplesAccess GenericSamplesRecords = new GenericSamplesAccess(m_theWorkspace); GenericSamplesRecords.AddGenericSamples(GenericSamplesSearch); dataAccessClasses.Add("GenericSamples", GenericSamplesRecords); } // OrientationPoints if (OrientationPointsSearch != "OrientationPoints_ID = '") { OrientationPointsSearch = OrientationPointsSearch.Remove(OrientationPointsSearch.Length - 32); OrientationPointsAccess OrientationPointsRecords = new OrientationPointsAccess(m_theWorkspace); OrientationPointsRecords.AddOrientationPoints(OrientationPointsSearch); dataAccessClasses.Add("OrientationPoints", OrientationPointsRecords); } #endregion #endregion #region Selected TABLE ROWS // Loop through the tables in the map IStandaloneTableCollection tableCollection = ArcMap.Document.FocusMap as IStandaloneTableCollection; for (int i = 0; i <= tableCollection.StandaloneTableCount - 1; i++) { // Get one of the tables IStandaloneTable thisTable = tableCollection.StandaloneTable[i]; string tableName = null; if (thisTable.Table == null) tableName = thisTable.Name; else tableName = (thisTable.Table as IDataset).Name; // Parse the table name in order to strip out unneccessary bits of SDE tables ISQLSyntax nameParser = (ISQLSyntax)m_theWorkspace; string parsedDbName, parsedOwnerName, parsedTableName; nameParser.ParseTableName(tableName, out parsedDbName, out parsedOwnerName, out parsedTableName); // Find the selection ITableSelection selectedRows = thisTable as ITableSelection; ISelectionSet theSelection = selectedRows.SelectionSet; // Iterate if there are no selected rows if (theSelection == null) continue; else if (theSelection.Count == 0) continue; // Loop through selected rows, build the where clauses up. ICursor theCursor; theSelection.Search(null, false, out theCursor); IRow theRow = theCursor.NextRow(); while (theRow != null) { switch (parsedTableName) { case "Glossary": GlossarySearch += theRow.get_Value(thisTable.Table.FindField("Glossary_ID")) + "' OR Glossary_ID = '"; break; case "DataSources": DataSourcesSearch += theRow.get_Value(thisTable.Table.FindField("DataSources_ID")) + "' OR DataSources_ID = '"; break; case "DescriptionOfMapUnits": DescriptionOfMapUnitsSearch += theRow.get_Value(thisTable.Table.FindField("DescriptionOfMapUnits_ID")) + "' OR DescriptionOfMapUnits_ID = '"; break; } // Iterate theRow = theCursor.NextRow(); } } #region Build Dictionary // Clean up the Where Clauses, create the data access classes, and then add it to the dictionary // Glossary if (GlossarySearch != "Glossary_ID = '") { GlossarySearch = GlossarySearch.Remove(GlossarySearch.Length - 19); GlossaryAccess GlossaryRecords = new GlossaryAccess(m_theWorkspace); GlossaryRecords.AddGlossary(GlossarySearch); dataAccessClasses.Add("Glossary", GlossaryRecords); } // DataSources if (DataSourcesSearch != "DataSources_ID = '") { DataSourcesSearch = DataSourcesSearch.Remove(DataSourcesSearch.Length - 22); DataSourcesAccess DataSourcesRecords = new DataSourcesAccess(m_theWorkspace); DataSourcesRecords.AddDataSources(DataSourcesSearch); dataAccessClasses.Add("DataSources", DataSourcesRecords); } // DescriptionOfMapUnits if (DescriptionOfMapUnitsSearch != "DescriptionOfMapUnits_ID = '") { DescriptionOfMapUnitsSearch = DescriptionOfMapUnitsSearch.Remove(DescriptionOfMapUnitsSearch.Length - 32); DescriptionOfMapUnitsAccess DescriptionOfMapUnitsRecords = new DescriptionOfMapUnitsAccess(m_theWorkspace); DescriptionOfMapUnitsRecords.AddDescriptionOfMapUnits(DescriptionOfMapUnitsSearch); dataAccessClasses.Add("DescriptionOfMapUnits", DescriptionOfMapUnitsRecords); } #endregion #endregion // Okay! Return the dictionary that has been built return dataAccessClasses; }