private void Connect(SqlConnection sqlConnection)
{
try
{
sqlConnection.Open();
}
catch (Exception e)
{
OnDbConnection?.Invoke(this, new DbConnectionEventArgs(DateTime.Now, e.Message));
OnDbConnection?.Invoke(this, new DbConnectionEventArgs(DateTime.Now, sqlConnection.State.ToString()));
}
}
public DbManager()
{
ClientsSqlDataAdapter = new SqlDataAdapter();
DepositsSqlDataAdapter = new SqlDataAdapter();
CreditsSqlDataAdapter = new SqlDataAdapter();
PhysDataTable = new DataTable();
LegalDataTable = new DataTable();
DepositsDataTable = new DataTable();
CreditsDataTable = new DataTable();
var connectionStringBuilder = new SqlConnectionStringBuilder
{
DataSource = @"(localdb)\MSSQLLocalDB",
InitialCatalog = "Bank",
IntegratedSecurity = true,
Pooling = false
};
OnDbConnection?.Invoke(this, new DbConnectionEventArgs(DateTime.Now, $"Connection string: { connectionStringBuilder.ConnectionString}"));
commonSqlConnection = new SqlConnection(connectionStringBuilder.ConnectionString);
}
