/// <summary> /// This event is fired when the Test Database Connection button is clieccked. /// </summary> private void TestDatabaseConnectionButton_Click(object sender, EventArgs e) { try { // set the connectionTest bool connectionTest = false; // Set the connectionString string connectionString = this.ConnectionStringTextBox.Text; // test for a connectionString bool hasConnectionString = (!String.IsNullOrEmpty(connectionString)); // if a connection string has been established if (hasConnectionString) { // set the dataConnector SQLDatabaseConnector dataConnector = new SQLDatabaseConnector(); // set the connection string dataConnector.ConnectionString = connectionString; // Test the connection connectionTest = SQLDatabaseTester.TestDatabaseConnection(dataConnector); // if the connection test passed if (connectionTest) { // Show success icon PassedImage.Visible = true; } else { // Show a success message FailedImage.Visible = false; } // Start the timer to hide the images in 3 seconds Timer.Start(); } else { // Show a warning message MessageBox.Show("You must build or enter a connection string.", "Missing Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception error) { // for debugging only string err = error.ToString(); // Show a success message MessageBox.Show("A connection to the database count not be estalished.", "Connection Test Failed", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/// <summary> /// This method returns the Create Xml File /// </summary> public bool ValidateCreateXmlFile() { // initial value bool isValid = false; // locals bool validXmlFile = false; bool sourceDatabaseConnectionPassed = false; // if the SourceDatabaseConnectionString exists and the OutputXmlFilePath exists if ((this.HasSourceDatabaseConnectionString) && (this.HasOutputXmlFilePath)) { // Create the SourceDatabaseConnector this.SourceDatabaseConnector = new SQLDatabaseConnector(); // Set the database connector this.SourceDatabaseConnector.ConnectionString = this.SourceDatabaseConnectionString; // Test the SourceDatabaseConnection sourceDatabaseConnectionPassed = SQLDatabaseTester.TestDatabaseConnection(this.SourceDatabaseConnector); // validate a valid Xml File Path validXmlFile = ValidateXmlFile(this.OutputXmlFilePath, false); // if the sourceDatabaseConnectionPassed and the validXmlFile if ((sourceDatabaseConnectionPassed) && (validXmlFile)) { // Set to true isValid = true; } else if ((!sourceDatabaseConnectionPassed) && (!validXmlFile)) { // Set to true this.InvalidReason = "The 'Source Database Connection' failed to connect and the 'Output Xml File' is not valid."; } else if (!sourceDatabaseConnectionPassed) { // Set to true this.InvalidReason = "The 'Source Database Connection' failed to connect."; } else if (!validXmlFile) { // Set to true this.InvalidReason = "The 'Output Xml File' is not valid."; } } else if ((!this.HasSourceDatabaseConnectionString) && (!HasOutputXmlFilePath)) { // Set to true this.InvalidReason = "The 'Source Database Connection' must be set and 'Output Xml File' must be set."; } else if (!this.HasSourceDatabaseConnectionString) { // Set to true this.InvalidReason = "The 'Source Database Connection' must be set."; } else if (!this.HasOutputXmlFilePath) { // Set to true this.InvalidReason = "The 'Output Xml File' must be set."; } // return value return(isValid); }
/// <summary> /// This method returns the Xml File And SQL Database /// </summary> public bool ValidateXmlFileAndSQLDatabase() { // initial value bool isValid = false; // local bool targetDatabaseConnectionPassed = false; bool sourceXmlFileIsValid = false; // if the SourceXmlFilePath exists and the TargetDatabaseConnectionString exists if ((this.HasSourceXmlFilePath) && (this.HasTargetDatabaseConnectionString)) { // Create The TargetDatabaseConnector this.targetDatabaseConnector = new SQLDatabaseConnector(); // Set the ConnectionString this.TargetDatabaseConnector.ConnectionString = this.TargetDatabaseConnectionString; // test the TargetDatabaseConnector targetDatabaseConnectionPassed = SQLDatabaseTester.TestDatabaseConnection(this.TargetDatabaseConnector); // set the sourceXmlFileIsValid sourceXmlFileIsValid = ValidateXmlFile(this.SourceXmlFilePath, true); // For now set this to valid, the Xml isValid = ((targetDatabaseConnectionPassed) && (sourceXmlFileIsValid)); // if the value for isValid is false if (!isValid) { // if the TargetDatabaseConnectionPassed is false and the sourceXmlFile is not valid if ((!targetDatabaseConnectionPassed) && (!sourceXmlFileIsValid)) { // The Source Xml File is not valid this.InvalidReason = "The 'Source Xml File' is not valid and the 'Target Database Connection' failed to connect"; } else if (!targetDatabaseConnectionPassed) { // The Source Xml File is not valid this.InvalidReason = "The 'Target Database Connection' failed to connect"; } else { // The Source Xml File is not valid this.InvalidReason = "The 'Source Xml File' is not valid"; } } } else if ((!this.HasTargetDatabaseConnectionString) && (!sourceXmlFileIsValid)) { // If the InvalidReason this.InvalidReason = "The 'Target Connection String' and the 'Source Xml File' must both be set"; } else if (!this.HasTargetDatabaseConnectionString) { // If the InvalidReason this.InvalidReason = "The 'Target Connection String' must be set."; } else if (!this.HasSourceXmlFilePath) { // If the InvalidReason this.InvalidReason = "The 'Source Xml File' must be set"; } // return value return(isValid); }
/// <summary> /// This method returns the Two SQL Databases /// </summary> public bool ValidateTwoSQLDatabases() { // initial value bool isValid = false; // if the SourceDatabaseConnectionString and the TargetDatabaseConnectionString if ((this.HasSourceDatabaseConnectionString) && (this.HasTargetDatabaseConnectionString)) { // Create a new instance of a 'SQLDatabaseConnector' object. this.SourceDatabaseConnector = new SQLDatabaseConnector(); this.TargetDatabaseConnector = new SQLDatabaseConnector(); // Set the Source & Target ConnectionString this.SourceDatabaseConnector.ConnectionString = this.SourceDatabaseConnectionString; this.TargetDatabaseConnector.ConnectionString = this.TargetDatabaseConnectionString; // test the sourceConnectionTested bool sourceConnectionTested = SQLDatabaseTester.TestDatabaseConnection(this.SourceDatabaseConnector); bool targetConnectionTested = SQLDatabaseTester.TestDatabaseConnection(this.TargetDatabaseConnector); // if both connections tested if ((sourceConnectionTested) && (targetConnectionTested)) { // this is a valid connection isValid = true; } else if ((!sourceConnectionTested) && (targetConnectionTested)) { // Set the InvalidReason this.InvalidReason = "The source and target connections failed to connect."; } else if (!sourceConnectionTested) { // Set the InvalidReason this.InvalidReason = "The source connection failed to connect."; } else { // The Target Connection Failed this.InvalidReason = "The target connection failed to connect."; } } else if ((!this.HasSourceDatabaseConnectionString) && (!this.HasTargetDatabaseConnectionString)) { // Set the InvalidReason this.InvalidReason = "The 'Source Connection String' and the 'Target Connection String' must both be set"; } else if (!this.HasSourceDatabaseConnectionString) { // Set the InvalidReason this.InvalidReason = "The 'Source Connection String' must be set"; } else if (!this.HasTargetDatabaseConnectionString) { // Set the InvalidReason this.InvalidReason = "The 'Target Connection String' must be set"; } // return value return(isValid); }
/// <summary> /// This event is fired when the Test Database Connection button is clieccked. /// </summary> private void TestDatabaseConnectionButton_Click(object sender, EventArgs e) { try { // set the connectionTest bool connectionTest = false; // Set the connectionString string connectionString = this.ConnectionstringControl.Text; // test for a connectionString bool hasConnectionString = (!String.IsNullOrEmpty(connectionString)); // if a connection string has been established if (hasConnectionString) { // set the dataConnector SQLDatabaseConnector dataConnector = new SQLDatabaseConnector(); // set the connection string dataConnector.ConnectionString = connectionString; // Test the connection connectionTest = SQLDatabaseTester.TestDatabaseConnection(dataConnector); // if the connection test passed if (connectionTest) { // Change the text to passed this.StatusLabel.Text = "Database Connection Test Passed."; // Show Success this.StatusImage.BackgroundImage = Properties.Resources.Success; // Set the text to the clipboard Clipboard.SetText(connectionString); // Show the CopiedImage and start the CopiedTimer ShowCopiedImage(); } else { // Show a success message this.StatusLabel.Text = "Database Connection Failed."; // Show Failure this.StatusImage.BackgroundImage = Properties.Resources.Failure; } // Show the StatusLabel and Image this.StatusLabel.Visible = true; this.StatusImage.Visible = true; } else { // Show a warning message MessageBox.Show("You must build or enter a connection string.", "Missing Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception error) { // for debugging only string err = error.ToString(); // Show a success message MessageBox.Show("A connection to the database count not be estalished.", "Connection Test Failed", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }