public void Execute(IDictionary <string, string> settings) { Settings = settings != null ? new DictionarySettings(settings) : AmbientSettings.Settings; ExecuteCore(); }
/// <summary> /// Called when [create new company]. /// </summary> /// <param name="status">The status.</param> private void OnCreateNewCompany(SyncStatus status) { // Check Sql Settings ISqlServerSettings sqlSettings = this.Configurator.SqlSettings; if (string.IsNullOrEmpty(sqlSettings.Server)) { // TODO: Show Warning EditSqlServerSettingsForm editSqlSettinnsForm = new EditSqlServerSettingsForm(this.Configurator); if (this.SnapIn.Console.ShowDialog(editSqlSettinnsForm) == DialogResult.OK) { this.Configurator.ChangeSqlServerSettings( editSqlSettinnsForm.SqlServerName, editSqlSettinnsForm.UseWindowsAuth ? AuthenticationType.Windows : AuthenticationType.SqlServer, editSqlSettinnsForm.SqlServerUser, editSqlSettinnsForm.SqlServerPassword, editSqlSettinnsForm.IbnUserName, editSqlSettinnsForm.IbnUserPassword); } else { return; } } CreateCompanyForm createCompanyForm = new CreateCompanyForm(this.Configurator); if (this.SnapIn.Console.ShowDialog(createCompanyForm) == DialogResult.OK) { status.ReportProgress(0, 0, string.Format(SnapInResources.CompanyScopeNode_Action_Create_Progress, createCompanyForm.textBoxHost.Text)); string newCompanyId = string.Empty; //Thread.Sleep(10000); newCompanyId = this.Configurator.CreateCompany(createCompanyForm.textBoxCompanyName.Text, createCompanyForm.textBoxHost.Text, ((ILanguageInfo)createCompanyForm.comboBoxDefaultLanguage.SelectedItem).Locale, createCompanyForm.checkBoxIsActive.Checked, createCompanyForm.IisIPAddress, int.Parse(createCompanyForm.textBoxIisPort.Text), createCompanyForm.IisPool, createCompanyForm.textBoxAdminAccountName.Text, createCompanyForm.textBoxAdminPassword.Text, createCompanyForm.textBoxAdminFirstName.Text, createCompanyForm.textBoxAdminLastName.Text, createCompanyForm.textBoxAdminEmail.Text); // Refresh Company List Refresh(); // TODO: Navigate browser to form.NewCompanyId Url } }
public static void ExecuteNonQuery(string sql, ISqlServerSettings settings) { using (var connection = new SqlConnection(settings.DefaultConnectionString)) { SqlConnection.ClearPool(connection); using (var sqlCommand = new SqlCommand(sql, connection)) { connection.Open(); sqlCommand.ExecuteNonQuery(); } } }
public static T GetScalar <T>(string sql, ISqlServerSettings settings) { using (SqlConnection connection = new SqlConnection(settings.DefaultConnectionString)) { SqlConnection.ClearPool(connection); using (SqlCommand sqlCommand = new SqlCommand(sql, connection)) { connection.Open(); return((T)sqlCommand.ExecuteScalar()); } } }
public void Execute(Assembly asm) { Settings = new XmlSettingsParser(asm); SqlServerAdministrator = new SqlServerAdministrator(AmbientSettings.Settings ?? Settings); if (!string.IsNullOrEmpty(UserName)) { Logger.Log("Creating login and user '{0}' in database {1}", new object[] { UserName, Settings.DatabaseName }); SqlServerAdministrator.CreateLogin(UserName, Password); SqlServerAdministrator.CreateUser(UserName, false); } }
private void LoadSqlServerSettings() { ISqlServerSettings settings = this.Configurator.SqlSettings; // Init SqlServerConfigBlock if (string.IsNullOrEmpty(settings.Server)) { comboBoxSqlServer.Text = "(local)"; } else { comboBoxSqlServer.Text = settings.Server; } if (settings.Authentication == AuthenticationType.Windows) { comboBoxAuthentication.SelectedIndex = 0; } else { comboBoxAuthentication.SelectedIndex = 1; } if (string.IsNullOrEmpty(settings.AdminUser)) { textBoxUser.Text = "sa"; } else { textBoxUser.Text = settings.AdminUser; } textBoxPassword.Text = settings.AdminPassword; // IbnUserConfigBlock radioButtonEnterPassManually.Checked = true; if (string.IsNullOrEmpty(settings.PortalUser)) { textBoxIbnUser.Text = IbnConst.ProductFamilyShort; } else { textBoxIbnUser.Text = settings.PortalUser; } textBoxIbnUserPassword.Text = settings.PortalPassword; textBoxIbnUserPasswordRe.Text = settings.PortalPassword; }
/// <summary> /// Inits the SQL server settings block. /// </summary> private void InitSqlServerSettingsBlock() { IConfigurator configurator = GetConfigurator(); ISqlServerSettings settings = configurator.SqlSettings; //textBoxAdministratorSettings.Text = string.Format(CultureInfo.CurrentCulture, // SnapInResources.ServerFeaturesControl_AdministratorSettings_Format, // settings.Server, // settings.Authentication == AuthenticationType.Windows ? SnapInResources.Authentication_Windows_Name : SnapInResources.Authentication_SqlServer_Name, // settings.AdminUser); textBoxSqlServer.Text = settings.Server; textBoxSqlAuthentication.Text = settings.Authentication == AuthenticationType.Windows ? SnapInResources.Authentication_Windows_Name : SnapInResources.Authentication_SqlServer_Name; textBoxSqlAdminUser.Text = settings.AdminUser; textBoxSqlAccountForIbnPortal.Text = settings.PortalUser; }
internal static void CreateAspSite(IConfigurator configurator, Microsoft.ManagementConsole.Advanced.Console console, SyncStatus status) { // Check Sql Settings ISqlServerSettings sqlSettings = configurator.SqlSettings; bool sqlSettingsOK = !string.IsNullOrEmpty(sqlSettings.Server); if (!sqlSettingsOK) { // TODO: Show Warning EditSqlServerSettingsForm editSqlSettinnsForm = new EditSqlServerSettingsForm(configurator); if (console.ShowDialog(editSqlSettinnsForm) == DialogResult.OK) { configurator.ChangeSqlServerSettings( editSqlSettinnsForm.SqlServerName, editSqlSettinnsForm.UseWindowsAuth ? AuthenticationType.Windows : AuthenticationType.SqlServer, editSqlSettinnsForm.SqlServerUser, editSqlSettinnsForm.SqlServerPassword, editSqlSettinnsForm.IbnUserName, editSqlSettinnsForm.IbnUserPassword); sqlSettingsOK = true; } } if (sqlSettingsOK) { CreateAspForm createAspForm = new CreateAspForm(configurator); if (console.ShowDialog(createAspForm) == DialogResult.OK) { if (status != null) { status.ReportProgress(0, 0, SnapInResources.ServerFormView_Action_AspCreate_Progress); } configurator.CreateAspSite(createAspForm.textBoxHost.Text , createAspForm.IisIPAddress , int.Parse(createAspForm.textBoxIisPort.Text) , createAspForm.IisPool ); } } }
/// <summary> /// Gets the databases. /// </summary> /// <returns></returns> private string[] GetDatabases() { List <string> retVal = new List <string>(); ISqlServerSettings sqlSettings = this.Configurator.SqlSettings; if (sqlSettings != null) { try { using (SqlConnection connection = new SqlConnection(sqlSettings.AdminConnectionString)) { connection.Open(); using (SqlCommand cmd = connection.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT name FROM sysdatabases ORDER BY name ASC"; using (IDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { retVal.Add((string)reader["name"]); } } } } } catch (Exception ex) { System.Diagnostics.Trace.WriteLine(ex); } } return(retVal.ToArray()); }
public SqlServerBackupSource(ISqlServerSettings settings, ILogger logger) { _settings = settings; _logger = logger; }
protected ScriptedMigration(ISqlServerSettings settings) : this(new SqlServerAdministrator(settings ?? AmbientSettings.Settings)) { this.Settings = settings ?? AmbientSettings.Settings; }
public CreateWindowsLoginCommand(IQueryExecuter queryExecuter, ISqlServerSettings settings, string loginName) : base(queryExecuter, settings) { this.loginName = loginName; }
public CreateReferenceDataTables(ISqlServerSettings settings) : base(settings) { }
public DisableFullTextServiceCommand(IQueryExecuter queryExecuter, ISqlServerSettings settings) : base(queryExecuter, settings) { }
public DropDatabaseCommand(IQueryExecuter queryExecuter, ISqlServerSettings settings) : base(queryExecuter, settings) { }
protected CommandBase(IQueryExecuter queryExecuter, ISqlServerSettings settings) { this._queryExecuter = queryExecuter; this._settings = settings; }
public void Execute(IDictionary <string, string> settings, Assembly asm) { Settings = new DictionarySettings(settings); ExecuteCore(asm); }
public CreateLoginCommand(IQueryExecuter queryExecuter, ISqlServerSettings settings, string loginName, string loginPassword) : base(queryExecuter, settings) { this.loginName = loginName; this.loginPassword = loginPassword; }
public SetSimpleRecoveryCommand(IQueryExecuter queryExecuter, ISqlServerSettings settings) : base(queryExecuter, settings) { }
public CreateForeignKeys(ISqlServerSettings settings) : base(settings) { }
public void Execute(ISqlServerSettings serverSettings) { Settings = serverSettings ?? AmbientSettings.Settings; ExecuteCore(); }
public SqlServerRestoreSource(ISqlServerSettings settings, ILogger logger) { _settings = settings; _logger = logger; }
public void Execute(Assembly asm) { Settings = new XmlSettings(asm); ExecuteCore(asm); }
public void Execute(Assembly asm) { Settings = new XmlSettingsParser(asm); SqlServerAdministrator = new SqlServerAdministrator(Settings); EnsureDatabaseExists(); Logger.Log("Running migrations with connection string {0}", new object[] { Settings.DefaultConnectionString }); var migrator = new Migrator.Migrator(this.Provider, Settings.DefaultConnectionString, asm, Trace, Logger) { DryRun = this.DryRun }; MemoryStream logOutputStream = new MemoryStream(); using (MemoryStream logStream = new MemoryStream()) using (StreamWriter writer = new StreamWriter(logStream)) { migrator.Logger = new SqlScriptFileLogger(migrator.Logger, writer); this.RunMigration(migrator); logOutputStream = new MemoryStream(logStream.ToArray()); Logger.Log(GetStringFromStream(logOutputStream)); } }
public void Execute(ISqlServerSettings settings, Assembly asm) { Settings = settings; ExecuteCore(asm); }
public CreateDatabase(ISqlServerSettings settings) : base(settings) { }
public static bool CheckForeignKeyExists(ISqlServerSettings settings, string keyName) { return(Helpers.GetScalar <int>(string.Format("select \r\ncase (select 1 from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c\r\njoin INFORMATION_SCHEMA.TABLE_CONSTRAINTS fk ON c.CONSTRAINT_NAME = fk.CONSTRAINT_NAME\r\nwhere c.Constraint_Name = '{0}'\r\nand fk.Constraint_Type = 'FOREIGN KEY')\r\n\twhen 1 then 1\r\n\telse 0\r\nend", (object)keyName), settings) == 1); }
internal SqlServerAdministrator(IQueryExecuter queryExecuter, ISqlServerSettings settings) { this.queryExecuter = queryExecuter; this.settings = settings; }
public CreateEntryTables(ISqlServerSettings settings) : base(settings) { }
public SqlServerAdministrator(ISqlServerSettings settings) : this((IQueryExecuter) new SqlServerQueryExecuter(), settings) { }
public SqlServerInvoiceRepository(ISqlServerSettings settings) => this.settings = settings;
public SetSqlServer2005CompatibilityModeCommand(IQueryExecuter queryExecuter, ISqlServerSettings settings) : base(queryExecuter, settings) { }