/// <summary> /// Creates a new instance of the <see cref="SqlServerDatabaseSetupScreen"/> class. /// </summary> public SqlServerDatabaseSetupScreen() { m_sqlServerSetup = new SqlServerSetup(); m_sqlServerSetup.DataProviderString = "AssemblyName={System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089}; ConnectionType=System.Data.SqlClient.SqlConnection; AdapterType=System.Data.SqlClient.SqlDataAdapter"; InitializeComponent(); this.Loaded += new RoutedEventHandler(SqlServerDatabaseSetupScreen_Loaded); }
// Occurs when the user chooses to test their database connection. private void TestConnectionButton_Click(object sender, RoutedEventArgs e) { try { SqlServerSetup testSqlServerSetup = new SqlServerSetup(); testSqlServerSetup.ConnectionString = m_sqlServerSetup.ConnectionString; testSqlServerSetup.DataProviderString = m_sqlServerSetup.DataProviderString; testSqlServerSetup.DatabaseName = null; testSqlServerSetup.Timeout = "5"; using (AdoDataConnection connection = testSqlServerSetup.OpenConnection()) { } MessageBox.Show("Database connection succeeded."); } catch { string failMessage = "Database connection failed." + " Please check your username and password." + " Additionally, you may need to modify your connection under advanced settings."; MessageBox.Show(failMessage); } }
public void Setup() { ConfigFileManager.CopyWebConfig(); ConfigFileManager.CopyConnectionStringsConfig(); ConfigFileManager.CopyRoadkillConfig(); SqlServerSetup.RecreateLocalDbData(); }
public void Setup() { SqlServerSetup.RecreateLocalDbData(); string sqlFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Integration", "Import", "screwturn3.sql"); string sqlCommands = File.ReadAllText(sqlFile); using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); using (SqlCommand command = connection.CreateCommand()) { command.CommandText = sqlCommands; command.ExecuteNonQuery(); } } }
public void TearDown() { Console.WriteLine("~~~~~~~~~~~~ Installer acceptance tests teardown ~~~~~~~~~~~~"); string sitePath = Settings.WEB_PATH; try { // Remove any attachment folders used by the installer tests string installerTestsAttachmentsPath = Path.Combine(sitePath, "AcceptanceTests"); Directory.Delete(installerTestsAttachmentsPath, true); Console.WriteLine("Deleted temp attachment folders for installer tests"); } catch { } // Reset the db and web.config back for all other acceptance tests SqlServerSetup.RecreateLocalDbData(); ConfigFileManager.CopyConnectionStringsConfig(); Console.WriteLine("Copied databases and web.config back for installer tests"); Console.WriteLine("~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"); }
public void Setup() { string url = ConfigurationManager.AppSettings["url"]; if (string.IsNullOrEmpty(url)) { url = "http://localhost:9876"; } Console.WriteLine("============ Acceptance tests setup ============"); SqlServerSetup.RecreateLocalDbData(); ConfigFileManager.CopyRoadkillConfig(); BaseUrl = url; LoginUrl = BaseUrl + "/user/login"; LogoutUrl = BaseUrl + "/user/logout"; Driver = AcceptanceTestsSetup.Driver; IsWindowsAuthTests = (ConfigurationManager.AppSettings["useWindowsAuth"] == "true"); Console.WriteLine("================================================="); }
private IDbConnection OpenNewConnection() { IDbConnection connection = null; try { string databaseType = m_state["newDatabaseType"].ToString(); string connectionString = string.Empty; string dataProviderString = string.Empty; if (databaseType == "SQLServer") { SqlServerSetup sqlServerSetup = m_state["sqlServerSetup"] as SqlServerSetup; connectionString = sqlServerSetup.ConnectionString; dataProviderString = sqlServerSetup.DataProviderString; if (string.IsNullOrWhiteSpace(dataProviderString)) { dataProviderString = "AssemblyName={System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089}; ConnectionType=System.Data.SqlClient.SqlConnection; AdapterType=System.Data.SqlClient.SqlDataAdapter"; } } else if (databaseType == "MySQL") { MySqlSetup mySqlSetup = m_state["mySqlSetup"] as MySqlSetup; connectionString = mySqlSetup.ConnectionString; dataProviderString = mySqlSetup.DataProviderString; if (string.IsNullOrWhiteSpace(dataProviderString)) { dataProviderString = "AssemblyName={MySql.Data, Version=6.5.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d}; ConnectionType=MySql.Data.MySqlClient.MySqlConnection; AdapterType=MySql.Data.MySqlClient.MySqlDataAdapter"; } } else if (databaseType == "Oracle") { OracleSetup oracleSetup = m_state["oracleSetup"] as OracleSetup; connectionString = oracleSetup.ConnectionString; dataProviderString = oracleSetup.DataProviderString; if (string.IsNullOrWhiteSpace(dataProviderString)) { dataProviderString = OracleSetup.DefaultDataProviderString; } } else if (databaseType == "PostgreSQL") { PostgresSetup postgresSetup = m_state["postgresSetup"] as PostgresSetup; connectionString = postgresSetup.ConnectionString; dataProviderString = PostgresSetup.DataProviderString; } else { string destination = m_state["sqliteDatabaseFilePath"].ToString(); connectionString = "Data Source=" + destination + "; Version=3"; dataProviderString = "AssemblyName={System.Data.SQLite, Version=1.0.99.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139}; ConnectionType=System.Data.SQLite.SQLiteConnection; AdapterType=System.Data.SQLite.SQLiteDataAdapter"; } if (!string.IsNullOrEmpty(connectionString) && !string.IsNullOrEmpty(dataProviderString)) { Dictionary <string, string> dataProviderSettings = dataProviderString.ParseKeyValuePairs(); string assemblyName = dataProviderSettings["AssemblyName"]; string connectionTypeName = dataProviderSettings["ConnectionType"]; Assembly assembly = Assembly.Load(new AssemblyName(assemblyName)); Type connectionType = assembly.GetType(connectionTypeName); connection = (IDbConnection)Activator.CreateInstance(connectionType); connection.ConnectionString = connectionString; connection.Open(); } } catch (Exception ex) { MessageBox.Show("Failed to open new database connection: " + ex.Message, "Configuration Error", MessageBoxButton.OK, MessageBoxImage.Error); if (connection != null) { connection.Dispose(); } connection = null; } return(connection); }
public void TestFixtureSetup() { SqlServerSetup.RecreateLocalDbData(); }
// Gets a database connection to the SQL Server database configured earlier in the setup. private IDbConnection GetSqlServerConnection() { SqlServerSetup sqlSetup = m_state["sqlServerSetup"] as SqlServerSetup; return((sqlSetup == null) ? null : new SqlConnection(sqlSetup.ConnectionString)); }
/// <summary> /// Called when all startup conditions have been meet. The database is now /// accessible as well. /// </summary> private void FinalStartUp() { if ((_notification != null) && _notification.IsLoaded && _notification.IsVisible) { _notification.Close(); } // Disable AlwaysUseDefaults which was being used prior to this... ConfigurationManager.AlwaysUseDefaults = false; // Task Manager Protection // SettingManager.SetStoreSetting("DontDisableTaskManager", 0); int?isDisabled = SettingManager.GetInt32("DontDisableTaskManager"); if (isDisabled.HasValue && (isDisabled.Value == 1)) { BeginStartup(); return; } if (!TaskManagerServiceHelper.IsInstalled) { if (PosDialogWindow.ShowDialog(Types.Strings.DoYouWantToInstallTheTaskManagerAccessService, Types.Strings.InstallService, DialogButtons.YesNo, false) == DialogButton.Yes) { new Thread(TaskManagerServiceHelper.InstallThread).Start(); } } else if (!TaskManagerServiceHelper.IsStarted) { if (PosDialogWindow.ShowDialog(Types.Strings.DoYouWantToStartTheTaskManagerAccessService, Types.Strings.StartService, DialogButtons.YesNo, false) == DialogButton.Yes) { new Thread(TaskManagerServiceHelper.StartThread).Start(); } } else { TaskManagerServiceHelper.IsTaskManagerDisabled = true; } // Install the SQL Assembly (if one is pending installation) if (Updater.InstallSQLAssembly()) { #if DEBUG PosDialogWindow.ShowDialog("New SQL Assembly Installed", Types.Strings.Information); #endif } // Apply any required database patches at runtime SqlServerSetup.ApplyDatabasePatches(); // Check to make sure the model classes and the tables match if (!DataModelBase.ValidateDatabase()) { #if DEBUG string results = DataModelBase.InvalidDatabaseReport(); PosDialogWindow.ShowDialog( results, "Invalid Database Report"); #else PosDialogWindow.ShowDialog( Strings.TheDatabaseDesignCurrentlyBeingUsedIsIncorrectForThisVersionOfTempos, Strings.StartupError); #endif UserControlManager.ShowTaskbar(true); Application.Current.Shutdown(); return; } // Enable user control UserControlManager.Enable(ConfigurationManager.UseKeyboardHook); UserControlManager.ShowTaskbar(false); // Start-up MainWindow Show(); _mainWindow = new MainWindow(); _mainWindow.Show(); }
private void DoFinishInstallThreadStart() { SqlServerSetup.FinishInstall(); Dispatcher.Invoke((Action)(FinalStartUp)); }