public void Unregister(IDBConnect dbConnect)
{
_dbConnects.Remove(dbConnect);
List <int> removeIDs = new List <int>();
foreach (var result in SQLResultManager.Instance.GetSQLResults(dbConnect))
{
removeIDs.Add(SQLResultManager.Instance.GetID(result));
}
removeIDs.ForEach(x => SQLResultManager.Instance.Remove(x));
}
public void Register(IDBConnect dbConnect)
{
if (_dbConnects.Any(x => x.Title.Equals(dbConnect.Title)))
{
throw new ApplicationException("Connecton Name exists!");
}
//retrieve DB list
//retrieve Table listfor each DB
_dbConnects.Add(dbConnect);
}
private void SetConnect(IDBConnect connect, ISQLExecutor sqlExecutor)
{
if (_exec == null)
{
_exec = sqlExecutor;
}
LinkedDBConnect = connect;
lblConnect.Text = connect.Title;
lblAccount.Text = connect.Account;
lblElapsed.Text = "";
btnStop.Enabled = false;
}
public SQLResult CreateSQLResult(int id, IDBConnect connect, ISQLExecutor sqlExecutor)
{
if (_bind.ContainsKey(id))
{
throw new ApplicationException("id(" + id + ") already exists");
}
var ret = _bind[id] = new SQLResult(connect, sqlExecutor)
{
Visible = false
}; //Visible = false to prevent Flicker
return(ret);
}
private Control AddSQLResult(int bufID, IDBConnect connect, ISQLExecutor sqlExecutor)
{
var ctr = SQLResultManager.Instance.CreateSQLResult(bufID, connect, sqlExecutor);
ctr.Height = _defaultSQLResultHeight;
ctr.Visible = false;//prevent Flicker
var ret = Win32.SetParent(ctr.Handle, nppData._nppHandle);
if (ret == null || ret == IntPtr.Zero)
{
System.Windows.Forms.MessageBox.Show("setparent fail");
}
if (hSplitBar == null)
{
hSplitBar = CreateSplitBar();
}
return(ctr);
}
/// <summary>
/// Class that executes database queries for the Login Controller, injects the database
/// </summary>
public LoginQueries(IDBConnect _connection)
{
connection = _connection;
}
public void setDBConnectInstance(IDBConnect db)
{
dbConnector = db;
}
public void setDBConnectInstance(IDBConnect db)
{
dbConnector = db;
}
public IEnumerable <SQLResult> GetSQLResults(IDBConnect connect)
{
return(_bind.Where(x => x.Value.LinkedDBConnect == connect).Select(x => x.Value));
}
/// <summary>
/// Class for all the methods that control the registering proccess, injects the database
/// </summary>
public RegisterController(IDBConnect _connection)
{
registerQueries = new RegisterQueries(_connection);
}
/// <summary>
/// Class that executes database queries for the Blog Post Controller, injects the database
/// </summary>
public BlogPostQueries(IDBConnect _connection)
{
connection = _connection;
}
/// <summary>
/// Class that executes database queries for the Login Controller, injects the database
/// </summary>
public RegisterQueries(IDBConnect _connection)
{
connection = _connection;
}
public IntegrationOperations(IDBConnect databaseBridge)
{
this.databaseBridge = databaseBridge;
}
/// <summary>
/// Class for all the methods that control the Blogging proccess, injects the database
/// </summary>
public BlogPostController(IDBConnect _connection)
{
blogPostQueries = new BlogPostQueries(_connection);
}
/// <summary>
/// Class for all the methods that control the login proccess, injects the database
/// </summary>
public LoginController(IDBConnect _connection)
{
loginQueries = new LoginQueries(_connection);
}
public SQLResult(IDBConnect connect, ISQLExecutor sqlExecutor)
{
InitializeComponent();
Init();
SetConnect(connect, sqlExecutor);
}
