private void Wizard_OnFinishClick(object sender, RoutedEventArgs e) { ConfigFileHelper configFile = new ConfigFileHelper(); DatabaseUpdater databaseUpdateProvider = new DatabaseUpdater(); DatabaseFileHelper.ResetDatabaseReadOnlyFlag(); if (rdoSQLServer.IsChecked.HasValue && rdoSQLServer.IsChecked.Value) configFile.SaveConfigFile(model.CreateConnectionString(txtPassword.Password)); else { if (databaseUpdateProvider.IsDatabaseVersionCorrect(GetConnectionString(true))) configFile.SaveConfigFileForSqlExpress2008(txtServerName.Text); else configFile.SaveConfigFileForSqlExpress2005(txtServerName.Text); } _isWizardFinished = true; _mainWindow.Visibility = Visibility.Visible; ConfigurationManager.RefreshSection("connectionStrings"); Bootstrapper.Configure(); databaseUpdateProvider.InitializeDatabase(GetConnectionString(false)); _mainWindow.RefreshData(); _mainWindow.SetRecentItems(); Close(); }
private string GetConnectionString(bool isTest) { if (rdoSQLServer.IsChecked.HasValue && rdoSQLServer.IsChecked.Value) return model.CreateConnectionString(txtPassword.Password); else if (isTest) return model.CreateConnectionStringForSETest(txtServerName.Text); else { DatabaseUpdater databaseUpdateProvider = new DatabaseUpdater(); if (databaseUpdateProvider.IsDatabaseVersionCorrect(model.CreateConnectionStringForSETest(txtServerName.Text))) return model.CreateConnectionStringForSE2008(txtServerName.Text); else return model.CreateConnectionStringForSE2005(txtServerName.Text); } }
private void wizardPageDbValidation_PageShow(object sender, RoutedEventArgs e) { lstValidationIssues.Items.Add("Below are possible issues with your system:"); lstValidationIssues.Items.Add("------------------------------------------------------------------------------------------------------"); DatabaseUpdater databaseUpdateProvider = new DatabaseUpdater(); bool isSql2008r2 = databaseUpdateProvider.IsDatabaseVersionCorrect(GetConnectionString(true)); //if (rdoSQLServer.IsChecked.HasValue && rdoSQLServer.IsChecked.Value) //{ // if (isSql2008r2 == false) // { // lstValidationIssues.Items.Add( // "You are not using SQL 2008, ensure that you have the DTC (Distributed Transaction Coordinator) enabled for network access. See the Scutex Documentation for more information."); // } //} //else //{ // if (isSql2008r2 == false) // { // lstValidationIssues.Items.Add( // "You are not using SQL Express 2008 R2, it's recommended that you have the latest version. See the Scutex Documentation for more information."); // } //} if (lstValidationIssues.Items.Count == 2) lstValidationIssues.Items.Add("No issues detected."); pdgValidateDatabaseProgress.IsIndeterminate = false; lblDbValidateText.Content = "System validation complete, please review issues below."; wizardPageDbValidation.CanNext = true; }