private void InitializeTabPageSqlDatabaseSettings(SqlDatabaseSettings pSqlDatabaseSettings) { lblSQLServerSettings.Text = string.Format(" {0}: {1} {2}: {3} {4}: ****", MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "Server.Text"), TechnicalSettings.DatabaseServerName, MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "Login.Text"), 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); }
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 buttonRestore_Click(object sender, EventArgs e) { if (listViewDatabases.SelectedItems.Count == 0) { lblResultMessage.ForeColor = Color.Red; lblResultMessage.Text = string.Format(MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "SelectInList.Text")); return; } openFileDialog.FileName = ""; if (DialogResult.OK != openFileDialog.ShowDialog()) { return; } SqlDatabaseSettings sqlDatabase = (SqlDatabaseSettings)listViewDatabases.SelectedItems[0].Tag; btnRestore.Tag = sqlDatabase; DatabaseOperation dbo = new DatabaseOperation { Settings = sqlDatabase, File = openFileDialog.FileName }; _exitApplicationIfClose = true; groupBoxDatabaseManagement.Enabled = false; groupBoxSQLSettings.Enabled = false; btnSave.Enabled = false; lblResultMessage.ForeColor = Color.Black; lblResultMessage.Text = string.Format("{0} {1} {2}", MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "RestoreDatabase.Text.Text"), sqlDatabase.Name, MultiLanguageStrings.GetString(Ressource.FrmDatabaseSettings, "InProgress.Text")); bWDatabaseRestore.RunWorkerAsync(dbo); }
public List <SqlDatabaseSettings> GetSQLDatabasesSettings(string pDatabaseServerName, string pDatabaseLoginName, string pDatabasePassword) { SqlConnection connection = ConnectionManager.GeneralSqlConnection; try { connection.Open(); SQLInfoEnumerator sie = new SQLInfoEnumerator { SQLServer = pDatabaseServerName, Username = pDatabaseLoginName, Password = pDatabasePassword }; List <SqlDatabaseSettings> list = new List <SqlDatabaseSettings>(); foreach (string database in sie.EnumerateSQLServersDatabases()) { SqlDatabaseSettings sqlDatabase = _GetDatabaseInfos(database, connection); if (sqlDatabase == null) { continue; } list.Add(sqlDatabase); } connection.Close(); List <string> filter = TechnicalSettings.AvailableDatabases; return(list.FindAll(db => 0 == filter.Count || filter.Contains(db.Name))); } catch (Exception) { connection.Close(); throw; } }
public static void AddSqlDbContext(this IServiceCollection services, IConfiguration configuration) { SqlDatabaseSettings _settings = new SqlDatabaseSettings(); configuration.GetSection(nameof(SqlDatabaseSettings)).Bind(_settings); services.AddDbContextPool <SqlDBContext>(x => { x.UseSqlServer( // x.UseNpgsql( _settings.ServerUrl, y => { y.CommandTimeout(600); y.EnableRetryOnFailure(maxRetryCount: 100, maxRetryDelay: TimeSpan.FromSeconds(5), errorNumbersToAdd: null); // y.EnableRetryOnFailure(maxRetryCount: 100, maxRetryDelay: TimeSpan.FromSeconds(5), errorCodesToAdd: null); } ); x.EnableDetailedErrors(); x.EnableSensitiveDataLogging(); }); services.AddScoped <IPropertyRepository, PropertyRepository>(); services.AddScoped <IUnitOfWork, SqlUnitOfWork>(); }
private void InitializeTabPageSqlDatabaseSettings(string pDatabaseName) { SqlDatabaseSettings sqlDatabaseSettings = DatabaseServices.GetSQLDatabaseSettings(pDatabaseName); InitializeTabPageSqlDatabaseSettings(sqlDatabaseSettings); }
public FinanceContext(SqlDatabaseSettings settings) : base() { _settings = settings; }