private static SqlDatabaseSettings _GetDatabaseInfos(string pDatabaseName, SqlConnection pSqlConnection) { SqlDatabaseSettings sqlDatabase = new SqlDatabaseSettings { Name = pDatabaseName }; string version = DatabaseManager.GetDatabaseVersion(pDatabaseName, pSqlConnection); if (string.IsNullOrEmpty(version)) return null; sqlDatabase.Version = version; sqlDatabase.Size = DatabaseManager.GetDatabaseSize(pDatabaseName, pSqlConnection); string code = DatabaseManager.GetDatabaseBranchCode(pDatabaseName, pSqlConnection); if (string.IsNullOrEmpty(code)) code = DatabaseManager.GetDatabaseBranchCodeFromBranches(pDatabaseName, pSqlConnection); sqlDatabase.BranchCode = code; return sqlDatabase; }
private void InitializeTabPageSqlDatabaseSettings(SqlDatabaseSettings pSqlDatabaseSettings) { lblSQLServerSettings.Text = string.Format(" {0}: {1} {2}: {3} {4}: ****", MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "Server.Text"), TechnicalSettings.UseDemoDatabase ? @"(LocalDB)\v11.0" : TechnicalSettings.DatabaseServerName, MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "Login.Text"), TechnicalSettings.UseDemoDatabase ? "" : TechnicalSettings.DatabaseLoginName, MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "Password.Text")); lblSQLDatabaseSettingsName.Text = string.Format("{0}: {1} {2}: {3} {4}: {5}", MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "Database.Text"), pSqlDatabaseSettings.Name, MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "BranchCode.Text"), pSqlDatabaseSettings.BranchCode, MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "Size.Text"), pSqlDatabaseSettings.Size); lblSQLDatabaseSettingsVersion.Text = string.Format("{0}: {1}", MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "Version.Text"), pSqlDatabaseSettings.Version); btnSave.Visible = true; btnDatabaseConnection.Visible = false; if (pSqlDatabaseSettings.Version != TechnicalSettings.SoftwareVersion) { tBDatabaseSettingsSchemaResult.Text = ""; lblDatabaseSettingsMessage.Visible = true; lblDatabaseSettingsMessage.Text = MultiLanguageStrings.GetString( Ressource.FrmDatabaseSettings, "UpgradeYourDatabase.Text"); btnSQLDatabaseSettingsUpgrade.Text = string.Format("{0} {1} {2}", MultiLanguageStrings.GetString( Ressource.FrmDatabaseSettings, "Upgrade.Text"), MultiLanguageStrings.GetString( Ressource.FrmDatabaseSettings, "To.Text"), TechnicalSettings.SoftwareVersion); btnSQLDatabaseSettingsUpgrade.Enabled = true; btnSQLDatabaseSettingsUpgrade.Tag = pSqlDatabaseSettings; } else { lblDatabaseSettingsMessage.Visible = false; btnSQLDatabaseSettingsUpgrade.Text = string.Format(MultiLanguageStrings.GetString( Ressource.FrmDatabaseSettings, "Upgrade.Text")); btnSQLDatabaseSettingsUpgrade.Enabled = false; CheckDatabaseStructure(pSqlDatabaseSettings.Name); } lblResultMessage.Text = string.Empty; tableLayoutPanelDatabaseSettings.Controls.Add(groupBoxSQLSettings, 0, 0); tableLayoutPanelDatabaseSettings.Controls.Add(groupBoxSaveSettings, 0, 3); }