public override void Connect_To_Database(StorageConfig config)
{
myConfig = config as MsSQLConfig;
if (myConfig == null)
{
throw new Exception("Database Config is NULL");
}
try
{
myDBConn = new SqlConnection(ConnectionString);
myDBConn.Open();
if (myDBConn.State != System.Data.ConnectionState.Open)
{
throw new Exception("Unable to Open Database. Storage:" + config.Name);
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
private void cmdAddMsSQLStorage_Click(object sender, RoutedEventArgs e)
{
string val = "Storage_" + (grdStorages.Items.Count + 1);
if (DotNetSiemensPLCToolBoxLibrary.General.InputBox.Show("Storage-Name", "Name of the Storage", ref val) == DialogResult.OK)
{
foreach (var tmp in ProtokollerConfiguration.ActualConfigInstance.Storages)
{
if (tmp.Name.ToLower().Trim() == val.ToLower().Trim())
{
MessageBox.Show("A Storage with this Name already Exists!", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
MsSQLConfig storage = new MsSQLConfig()
{
Name = val
};
ProtokollerConfiguration.ActualConfigInstance.Storages.Add(storage);
}
}
