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);
return sqlDatabase;
}
private void _InitializeTabPageSqlDatabaseSettings(SqlDatabaseSettings pSqlDatabaseSettings)
{
lbSQLServerSettings.Text = string.Format(" {0}: {1} {2}: {3} {4}: ****",
"Server.Text", TechnicalSettings.DatabaseServerName,
"Login.Text", TechnicalSettings.DatabaseLoginName,
"Password.Text");
lbSQLDatabaseSettingsName.Text = string.Format("{0}: {1} {2}: {3} {4}: {5}",
"Database.Text", pSqlDatabaseSettings.Name,
"BranchCode.Text", pSqlDatabaseSettings.BranchCode,
"Size.Text", pSqlDatabaseSettings.Size);
lbSQLDatabaseSettingsVersion.Text = string.Format("{0}: {1}", "Version.Text", pSqlDatabaseSettings.Version);
buttonSave.Visible = true;
btnDatabaseConnection.Visible = false;
if (pSqlDatabaseSettings.Version != TechnicalSettings.SoftwareVersion)
{
tBDatabaseSettingsSchemaResult.Text = "";
lbSQLDatabaseSettingsUpgradeNeedfull.Visible = true;
lbSQLDatabaseSettingsUpgradeNeedfull.Text = "UpgradeYourDatabase.Text";
buttonSQLDatabaseSettingsUpgrade.Text = string.Format("{0} {1}","обновить до ", TechnicalSettings.SoftwareVersion);
buttonSQLDatabaseSettingsUpgrade.Enabled = true;
buttonSQLDatabaseSettingsUpgrade.Tag = pSqlDatabaseSettings;
}
else
{
lbSQLDatabaseSettingsUpgradeNeedfull.Visible = false;
buttonSQLDatabaseSettingsUpgrade.Text = "Upgrade.Text";
buttonSQLDatabaseSettingsUpgrade.Enabled = false;
_CheckDatabaseStructure(pSqlDatabaseSettings.Name);
}
labelResult.Text = string.Empty;
tableLayoutPanelDatabaseSettings.Controls.Add(groupBoxSQLSettings, 0, 0);
tableLayoutPanelDatabaseSettings.Controls.Add(groupBoxSaveSettings, 0, 3);
}