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);
}
