private bool TestConnection(Database.tsysClient client)
{
try
{
SqlConnectionStringBuilder connBuilder = GetSqlConnectionStringBuilder(client);
if (connBuilder != null)
{
using (SqlConnection sqlConnection = new SqlConnection(connBuilder.ConnectionString))
{
// Überprüfe ob eine Verbindung zur Datenbank möglich ist.
sqlConnection.Open();
sqlConnection.Close();
return(true);
}
}
return(false);
}
catch
{
return(false);
}
}
private void AddClient()
{
this.ucDefault1.PostEditor();
Database.tsysClient client = new Database.tsysClient();
int datasourceindex = this.tsysClientBindingSource.Add(client);
gridViewClient.FocusedRowHandle = gridViewClient.GetRowHandle(datasourceindex);
}
private void Item2_Click(object sender, EventArgs e)
{
using (Wookie.Tools.ImagePicker.ImagePicker imagePicker = new Tools.ImagePicker.ImagePicker())
{
if (tsysClientBindingSource.Current != null && imagePicker.ShowDialog() == DialogResult.OK)
{
Database.tsysClient element = (Database.tsysClient)tsysClientBindingSource.Current;
element.Image = Wookie.Tools.Image.Converter.GetBinaryFromImage(imagePicker.SelectedImage);
}
}
}
private SqlConnectionStringBuilder GetSqlConnectionStringBuilder(Database.tsysClient client)
{
if (client == null)
{
return(null);
}
SqlConnectionStringBuilder connBuilder = new SqlConnectionStringBuilder();
if (client.Datasource != null)
{
connBuilder.DataSource = client.Datasource;
}
if (client.UserID != null)
{
connBuilder.UserID = client.UserID;
}
if (client.Password != null)
{
connBuilder.Password = client.Password;
}
if (client.InitialCatalog != null)
{
connBuilder.InitialCatalog = client.InitialCatalog;
}
if (client.FailoverPartner != null)
{
connBuilder.FailoverPartner = client.FailoverPartner;
}
if (client.Encrypt.HasValue)
{
connBuilder.Encrypt = client.Encrypt.Value;
}
if (client.PersistSecurityInfo.HasValue)
{
connBuilder.PersistSecurityInfo = client.PersistSecurityInfo.Value;
}
if (client.ConnectTimeout.HasValue)
{
connBuilder.ConnectTimeout = client.ConnectTimeout.Value;
}
if (client.ConnectRetryCount.HasValue)
{
connBuilder.ConnectRetryCount = client.ConnectRetryCount.Value;
}
if (client.ConnectRetryInterval.HasValue)
{
connBuilder.ConnectRetryInterval = client.ConnectRetryInterval.Value;
}
if (client.PacketSize.HasValue)
{
connBuilder.PacketSize = client.PacketSize.Value;
}
if (client.Pooling.HasValue)
{
connBuilder.Pooling = client.Pooling.Value;
}
return(connBuilder);
}
