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 SqlServerRestoreSource(ISqlServerSettings settings, ILogger logger)
{
_settings = settings;
_logger = logger;
}
public SqlServerBackupSource(ISqlServerSettings settings, ILogger logger)
{
_settings = settings;
_logger = logger;
}
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)
{
}
