/// <summary> /// Load the connection information from file, based on the selected environment. /// </summary> /// <param name="environmentName"></param> public static void LoadTeamConnectionsFileForVdw(string environmentName) { if (environmentName != null) { // Connection information (TEAM_connections). var connectionFileName = FormBase.VdwConfigurationSettings.TeamConnectionsPath + FormBase.GlobalParameters.JsonConnectionFileName + '_' + environmentName + FormBase.GlobalParameters.JsonExtension; FormBase.TeamConfigurationSettings.ConnectionDictionary = TeamConnectionFile.LoadConnectionFile(connectionFileName); if (FormBase.TeamConfigurationSettings.ConnectionDictionary is null) { FormBase.VdwConfigurationSettings.VdwEventLog.Add(Event.CreateNewEvent(EventTypes.Warning, $"The connection dictionary is empty.")); } else { foreach (var localConnection in FormBase.TeamConfigurationSettings.ConnectionDictionary) { FormBase.VdwConfigurationSettings.VdwEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"The connection key {localConnection.Value.ConnectionKey} is available as part of the {FormBase.VdwConfigurationSettings.ActiveEnvironment.environmentKey} environment.")); } } } else { FormBase.VdwConfigurationSettings.VdwEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"The working environment has not been set, no connections have been loaded.")); } }
/// <summary> /// Manage the event when the environment selection changes. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void comboBoxEnvironments_SelectedIndexChanged(object sender, EventArgs e) { if (_formLoading == false) { // Retrieve the object from the event. var localComboBox = (ComboBox)sender; var localComboBoxSelection = (KeyValuePair <TeamWorkingEnvironment, string>)localComboBox.SelectedItem; var selectedItem = localComboBoxSelection.Key; // Get the full environment from the in-memory dictionary. var localEnvironment = TeamEnvironmentCollection.EnvironmentDictionary[selectedItem.environmentInternalId]; // Set the working environment in memory. GlobalParameters.WorkingEnvironment = localEnvironment.environmentKey; GlobalParameters.WorkingEnvironmentInternalId = localEnvironment.environmentInternalId; // Update the root path file with the new working directory. UpdateRootPathFile(); // Initialise new environment in configuration settings. UpdateEnvironment(localEnvironment); foreach (TabPage customTabPage in tabControlConnections.TabPages) { if ((customTabPage.Name == "tabPageConnectionMain") || (customTabPage.Name == "tabPageConnectionNewTab")) { // Do nothing, as only the two standard Tab Pages exist. } else { // Remove the Tab Page from the Tab Control tabControlConnections.Controls.Remove((customTabPage)); } } var connectionFileName = GlobalParameters.ConfigurationPath + GlobalParameters.JsonConnectionFileName + '_' + GlobalParameters.WorkingEnvironment + GlobalParameters.JsonExtension; TeamConfiguration.ConnectionDictionary = TeamConnectionFile.LoadConnectionFile(connectionFileName); comboBoxMetadataConnection.Items.Clear(); AddConnectionTabPages(); try { LocalInitialiseConnections(GlobalParameters.ConfigurationPath + GlobalParameters.ConfigFileName + '_' + GlobalParameters.WorkingEnvironment + GlobalParameters.FileExtension); } catch (Exception ex) { richTextBoxInformation.AppendText("Errors occurred trying to load the configuration file, the message is " + ex + ". No default values were loaded. \r\n\r\n"); } //var selectedItemComboBox = new KeyValuePair<TeamConnectionProfile, string>(TeamConfigurationSettings.MetadataConnection, TeamConfigurationSettings.MetadataConnection.ConnectionKey); if (TeamConfiguration.MetadataConnection is null) { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"No metadata connection is set.")); } else { comboBoxMetadataConnection.SelectedIndex = comboBoxMetadataConnection.FindStringExact(TeamConfiguration.MetadataConnection.ConnectionKey); } // Report back to the event log. GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"The environment was changed to {localEnvironment.environmentName}.")); } }
public FormMain() { InitializeComponent(); // Set the version of the build for everything const string versionNumberForTeamApplication = "v1.6.3"; Text = "TEAM - Taxonomy for ETL Automation Metadata " + versionNumberForTeamApplication; GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"The TEAM root path is {GlobalParameters.RootPath}.")); GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"The TEAM script path is {GlobalParameters.ScriptPath}.")); richTextBoxInformation.AppendText("Initialising the application.\r\n\r\n"); // Root paths (mandatory TEAM directories) // Make sure the application and custom location directories exist as per the start-up default. try { LocalTeamEnvironmentConfiguration.InitialiseEnvironmentPaths(); } catch (Exception ex) { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Error, $"An error was encountered while creating the standard TEAM paths: \r\n\r\n{ex}")); } #region Load the root path configuration settings (user defined paths and working environment) // Load the root file, to be able to locate the (customisable) configuration file. // This file contains the configuration directory, the output directory and the working environment. string rootPathFileName = GlobalParameters.CorePath + GlobalParameters.PathFileName + GlobalParameters.FileExtension; try { LocalTeamEnvironmentConfiguration.LoadRootPathFile(rootPathFileName, GlobalParameters.ConfigurationPath, GlobalParameters.OutputPath); GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"The core configuration file {rootPathFileName} has been loaded.")); } catch { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Error, $"The core configuration file {rootPathFileName} could not be loaded. Is there a Configuration directory in the TEAM installation location?")); } // Environments file string environmentFile = GlobalParameters.CorePath + GlobalParameters.JsonEnvironmentFileName + GlobalParameters.JsonExtension; try { TeamEnvironmentCollection.LoadTeamEnvironmentCollection(environmentFile); GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"The environment file {environmentFile} has been loaded.")); } catch { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Error, $"The environment file {environmentFile} could not be loaded. Does the file exists in the designated (root) location?")); } #endregion #region Check if user configured paths exists (now that they have been loaded from the root file), and create dummy Configuration and Validation files if necessary // Configuration Path try { FileHandling.InitialisePath(GlobalParameters.ConfigurationPath); GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"The user defined configuration path {GlobalParameters.ConfigurationPath} is available.")); } catch { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Error, "The directories required to operate TEAM are not available and can not be created. Do you have administrative privileges in the installation directory to create these additional directories?")); } // Output Path try { FileHandling.InitialisePath(GlobalParameters.OutputPath); GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"The user defined output path {GlobalParameters.OutputPath} is available.")); } catch { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Error, "The directories required to operate TEAM are not available and can not be created. Do you have administrative privileges in the installation directory to create these additional directories?")); } // Create a dummy configuration file if it does not exist. var configurationFileName = GlobalParameters.ConfigurationPath + GlobalParameters.ConfigFileName + '_' + GlobalParameters.WorkingEnvironment + GlobalParameters.FileExtension; try { if (!File.Exists(configurationFileName)) { TeamConfiguration.CreateDummyEnvironmentConfigurationFile(configurationFileName); GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"A new configuration file {configurationFileName} was created.")); } else { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"The existing configuration file {configurationFileName} was detected.")); } } catch { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Error, $"An issue was encountered creating or detecting the configuration paths for {configurationFileName}.")); } // Create a default validation file if the file does not exist as expected. var validationFileName = GlobalParameters.ConfigurationPath + GlobalParameters.ValidationFileName + '_' + GlobalParameters.WorkingEnvironment + GlobalParameters.FileExtension; try { ValidationSetting.CreateDummyValidationFile(validationFileName); } catch { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Error, $"An issue was encountered creating or detecting the configuration paths for {validationFileName}.")); } // Create a default json configuration file if the file does not exist as expected. var jsonConfigurationFileName = GlobalParameters.ConfigurationPath + GlobalParameters.JsonExportConfigurationFileName + '_' + GlobalParameters.WorkingEnvironment + GlobalParameters.FileExtension; try { JsonExportSetting.CreateDummyJsonConfigurationFile(jsonConfigurationFileName); } catch { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Error, $"An issue was encountered creating or detecting the configuration paths for {jsonConfigurationFileName}.")); } #endregion // Load the connections file for the respective environment. var connectionFileName = GlobalParameters.ConfigurationPath + GlobalParameters.JsonConnectionFileName + '_' + GlobalParameters.WorkingEnvironment + GlobalParameters.JsonExtension; TeamConfiguration.ConnectionDictionary = TeamConnectionFile.LoadConnectionFile(connectionFileName); #region Load configuration file // Load the available configuration file into memory. var configurationFile = GlobalParameters.ConfigurationPath + GlobalParameters.ConfigFileName + '_' + GlobalParameters.WorkingEnvironment + GlobalParameters.FileExtension; try { // Load the configuration file. TeamConfiguration.LoadTeamConfigurationFile(configurationFile); GlobalParameters.EnvironmentMode = TeamConfiguration.EnvironmentMode; // Retrieve the events into the main event log. GlobalParameters.TeamEventLog.MergeEventLog(TeamConfiguration.ConfigurationSettingsEventLog); GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, $"The user configuration settings ({configurationFile}) have been loaded.")); } catch { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Error, $"An issue was encountered loading the user configuration file ({configurationFile}).")); } #endregion //FormBase.EnvironmentVersion.GetEnvironmentVersionsFromFile(Path.GetDirectoryName(configurationFile)); TeamVersionList.LoadVersionList(GlobalParameters.CorePath + GlobalParameters.VersionFileName + GlobalParameters.JsonExtension); // Load the pattern definition file. try { GlobalParameters.PatternDefinitionList = LoadPatternDefinition.DeserializeLoadPatternDefinition(GlobalParameters.LoadPatternPath + GlobalParameters.LoadPatternDefinitionFile); GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Information, "The pattern definition file was loaded successfully.")); } catch { GlobalParameters.TeamEventLog.Add(Event.CreateNewEvent(EventTypes.Error, "An issue was encountered loading the pattern definition file.")); } // Report the events (including errors) back to the user int errorCounter = 0; foreach (Event individualEvent in GlobalParameters.TeamEventLog) { if (individualEvent.eventCode == (int)EventTypes.Error) { errorCounter++; } } if (errorCounter > 0) { richTextBoxInformation.AppendText( $"{errorCounter} error(s) have been found at startup. Please check the Event Log in the menu.\r\n\r\n"); } TestConnections(); //Startup information richTextBoxInformation.AppendText("\r\nApplication initialised - the Taxonomy of ETL Automation Metadata (TEAM). \r\n"); richTextBoxInformation.AppendText("Welcome to version " + versionNumberForTeamApplication + ".\r\n\r\n"); labelWorkingEnvironment.Text = GlobalParameters.WorkingEnvironment; //+"("+GlobalParameters.WorkingEnvironmentInternalId+")"; labelEnvironmentMode.Text = GlobalParameters.EnvironmentMode.ToString(); }