public SelectorToolConfig() { // Open xml myFileFuncs = new FileFunctions(); string strAppDLL = System.Reflection.Assembly.GetExecutingAssembly().Location; string strFolder = myFileFuncs.GetDirectoryName(strAppDLL); // Get the XML file string strXMLFile = strFolder + @"\AODataSelector.xml"; // Read the file. XmlDocument xmlConfig = new XmlDocument(); xmlConfig.Load(strXMLFile); XmlNode currNode = xmlConfig.DocumentElement.FirstChild; // This gets us the DataSelector. xmlDataSelector = (XmlElement)currNode; // Get all of the detail into the object FileDSN = xmlDataSelector["FileDSN"].InnerText; ConnectionString = xmlDataSelector["ConnectionString"].InnerText; LogFilePath = xmlDataSelector["LogFilePath"].InnerText; DefaultExtractPath = xmlDataSelector["DefaultExtractPath"].InnerText; DefaultQueryPath = xmlDataSelector["DefaultQueryPath"].InnerText; DefaultFormat = xmlDataSelector["DefaultFormat"].InnerText; DatabaseSchema = xmlDataSelector["DatabaseSchema"].InnerText; IncludeWildcard = xmlDataSelector["IncludeWildcard"].InnerText; ExcludeWildcard = xmlDataSelector["ExcludeWildcard"].InnerText; RecMax = xmlDataSelector["RecMax"].InnerText; DefaultSetSymbology = xmlDataSelector["DefaultSetSymbology"].InnerText; LayerLocation = xmlDataSelector["LayerLocation"].InnerText; EnableSpatialPlotting = xmlDataSelector["EnableSpatialPlotting"].InnerText; }
// Class constructor. public ArcMapFunctions(IApplication theApplication) { // Set the application for the class to work with. // Note the application can be got at from a command / tool by using // IApplication pApp = ArcMap.Application - then pass pApp as an argument. this.thisApplication = theApplication; myFileFuncs = new FileFunctions(); }
public SelectorToolConfig() { // Open xml myFileFuncs = new FileFunctions(); string strAppDLL = System.Reflection.Assembly.GetExecutingAssembly().Location; string strFolder = myFileFuncs.GetDirectoryName(strAppDLL); // Get the XML file path //string strXMLFile = strFolder + @"\AODataSelector.xml"; string strXMLFile = Settings.Default.XMLFile; // If the XML file path is blank or doesn't exist if (String.IsNullOrEmpty(strXMLFile) || (!myFileFuncs.FileExists(strXMLFile))) { // Prompt the user for the correct file path string strFolder2 = GetConfigFilePath(); if (!String.IsNullOrEmpty(strFolder2)) strXMLFile = strFolder2 + @"\DataSelector.xml"; // Check the new file path exists if (myFileFuncs.FileExists(strXMLFile)) { Settings.Default.XMLFile = strXMLFile; Settings.Default.Save(); } else { MessageBox.Show("XML File not found."); } } // Read the file. XmlDocument xmlConfig = new XmlDocument(); xmlConfig.Load(strXMLFile); XmlNode currNode = xmlConfig.DocumentElement.FirstChild; // This gets us the DataSelector. xmlDataSelector = (XmlElement)currNode; // Get all of the detail into the object FileDSN = xmlDataSelector["FileDSN"].InnerText; ConnectionString = xmlDataSelector["ConnectionString"].InnerText; LogFilePath = xmlDataSelector["LogFilePath"].InnerText; DefaultExtractPath = xmlDataSelector["DefaultExtractPath"].InnerText; DefaultQueryPath = xmlDataSelector["DefaultQueryPath"].InnerText; DefaultFormat = xmlDataSelector["DefaultFormat"].InnerText; DatabaseSchema = xmlDataSelector["DatabaseSchema"].InnerText; IncludeWildcard = xmlDataSelector["IncludeWildcard"].InnerText; ExcludeWildcard = xmlDataSelector["ExcludeWildcard"].InnerText; RecMax = xmlDataSelector["RecMax"].InnerText; DefaultSetSymbology = xmlDataSelector["DefaultSetSymbology"].InnerText; LayerLocation = xmlDataSelector["LayerLocation"].InnerText; EnableSpatialPlotting = xmlDataSelector["EnableSpatialPlotting"].InnerText; }
public frmDataSelector() { InitializeComponent(); // Fill with the relevant. myConfig = new SelectorToolConfig(); // Should find the config file automatically. myArcSDEFuncs = new ESRISQLServerFunctions(); myADOFuncs = new ADOSQLServerFunctions(); myFileFuncs = new FileFunctions(); // fill the list box with SQL tables string strSDE = myConfig.GetSDEName(); string strIncludeWildcard = myConfig.GetIncludeWildcard(); string strExcludeWildcard = myConfig.GetExcludeWildcard(); //MessageBox.Show(strSDE); IWorkspace wsSQLWorkspace = myArcSDEFuncs.OpenArcSDEConnection(strSDE); List<string> strTableList = myArcSDEFuncs.GetTableNames(wsSQLWorkspace, strIncludeWildcard, strExcludeWildcard); foreach (string strItem in strTableList) { lstTables.Items.Add(strItem); } // Close the SQL connection wsSQLWorkspace = null; // However keep the Config and SQLFuncs objects alive for use later in the form. }
public SelectorToolConfig() { // Open xml myFileFuncs = new FileFunctions(); string strXMLFile = null; bool blFoundXML = false; LoadedXML = true; try { // Get the XML file strXMLFile = Settings.Default.XMLFile; // If the XML file path is blank or doesn't exist if (String.IsNullOrEmpty(strXMLFile) || (!myFileFuncs.FileExists(strXMLFile))) { // Prompt the user for the correct file path string strFolder = GetConfigFilePath(); if (!String.IsNullOrEmpty(strFolder)) strXMLFile = strFolder + @"\DataSelector.xml"; } // Check the xml file path exists if (myFileFuncs.FileExists(strXMLFile)) { Settings.Default.XMLFile = strXMLFile; Settings.Default.Save(); blFoundXML = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error " + ex.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } // Read the file. if (blFoundXML) { FoundXML = true; XmlDocument xmlConfig = new XmlDocument(); xmlConfig.Load(strXMLFile); XmlNode currNode = xmlConfig.DocumentElement.FirstChild; // This gets us the DataSelector. xmlDataSelector = (XmlElement)currNode; // Get all of the detail into the object try { LogFilePath = xmlDataSelector["LogFilePath"].InnerText; } catch { MessageBox.Show("Could not locate the item 'LogFilePath' in the XML file"); LoadedXML = false; return; } try { FileDSN = xmlDataSelector["FileDSN"].InnerText; } catch { MessageBox.Show("Could not locate the item 'FileDSN' in the XML file"); LoadedXML = false; return; } try { ConnectionString = xmlDataSelector["ConnectionString"].InnerText; } catch { MessageBox.Show("Could not locate the item 'ConnectionString' in the XML file"); LoadedXML = false; return; } try { DefaultExtractPath = xmlDataSelector["DefaultExtractPath"].InnerText; } catch { MessageBox.Show("Could not locate the item 'DefaultExtractPath' in the XML file"); LoadedXML = false; return; } try { DefaultQueryPath = xmlDataSelector["DefaultQueryPath"].InnerText; } catch { MessageBox.Show("Could not locate the item 'DefaultQueryPath' in the XML file"); LoadedXML = false; return; } try { DefaultFormat = xmlDataSelector["DefaultFormat"].InnerText; } catch { MessageBox.Show("Could not locate the item 'DefaultFormat' in the XML file"); LoadedXML = false; return; } try { DatabaseSchema = xmlDataSelector["DatabaseSchema"].InnerText; } catch { MessageBox.Show("Could not locate the item 'DatabaseSchema' in the XML file"); LoadedXML = false; return; } try { IncludeWildcard = xmlDataSelector["IncludeWildcard"].InnerText; } catch { MessageBox.Show("Could not locate the item 'IncludeWildcard' in the XML file"); LoadedXML = false; return; } try { ExcludeWildcard = xmlDataSelector["ExcludeWildcard"].InnerText; } catch { MessageBox.Show("Could not locate the item 'ExcludeWildcard' in the XML file"); LoadedXML = false; return; } try { RecMax = xmlDataSelector["RecMax"].InnerText; } catch { MessageBox.Show("Could not locate the item 'RecMax' in the XML file"); LoadedXML = false; return; } try { DefaultSetSymbology = xmlDataSelector["DefaultSetSymbology"].InnerText; } catch { MessageBox.Show("Could not locate the item 'DefaultSetSymbology' in the XML file"); LoadedXML = false; return; } try { LayerLocation = xmlDataSelector["LayerLocation"].InnerText; } catch { MessageBox.Show("Could not locate the item 'LayerLocation' in the XML file"); LoadedXML = false; return; } try { EnableSpatialPlotting = xmlDataSelector["EnableSpatialPlotting"].InnerText; } catch { MessageBox.Show("Could not locate the item 'EnableSpatialPlotting' in the XML file"); LoadedXML = false; } } else { FoundXML = false; // this has to be checked first; all other properties are empty. } }
bool blOpenForm; // This tracks all the way through whether the form is initialising correctly. public frmDataSelector() { InitializeComponent(); blOpenForm = true; // Fill with the relevant. myConfig = new SelectorToolConfig(); // Should find the config file automatically. if (myConfig.GetFoundXML() == false) { MessageBox.Show("XML file not found; form cannot load.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); blOpenForm = false; } else if (myConfig.GetLoadedXML() == false) { MessageBox.Show("Error loading XML File; form cannot load.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); blOpenForm = false; } myArcSDEFuncs = new ArcSDEFunctions(); mySQLServerFuncs = new SQLServerFunctions(); myFileFuncs = new FileFunctions(); // fill the list box with SQL tables string strSDE = myConfig.GetSDEName(); if (!myFileFuncs.FileExists(strSDE) && blOpenForm) { MessageBox.Show("ArcSDE connection file " + strSDE + " not found. Cannot load Data Selector", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); blOpenForm = false; } IWorkspace wsSQLWorkspace = null; if (blOpenForm) { try { wsSQLWorkspace = myArcSDEFuncs.OpenArcSDEConnection(strSDE); } catch (Exception ex) { MessageBox.Show("Cannot open ArcSDE connection " + strSDE + ". Error is " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); blOpenForm = false; } } if (blOpenForm) { string strIncludeWildcard = myConfig.GetIncludeWildcard(); string strExcludeWildcard = myConfig.GetExcludeWildcard(); string strDefaultFormat = myConfig.GetDefaultFormat(); cmbOutFormat.Text = strDefaultFormat; List<string> strTableList = myArcSDEFuncs.GetTableNames(wsSQLWorkspace, strIncludeWildcard, strExcludeWildcard); foreach (string strItem in strTableList) { lstTables.Items.Add(strItem); } // Close the SQL connection wsSQLWorkspace = null; // However keep the Config and SQLFuncs objects alive for use later in the form. } else // Something has gone wrong during initialisation; don't load form. { Load += (s, e) => Close(); return; } }