public SystemProceduresNode(ServerVersionId @param)
{
base.Text = "System Stored Procedures";
Override.NodeAppearance.Image = 0;
Override.ActiveNodeAppearance.Image = 1;
Override.NodeAppearance.ForeColor = Color.Red;
}
public ServerConnectionSettings(ServerVersionId serverVersion, string serverName, string databaseName)
{
_version = serverVersion;
_server = serverName;
_database = databaseName;
_windowsAuthentication = true;
}
public SystemFunctionsNode(ServerVersionId @param)
{
base.Text = "System Functions";
Override.NodeAppearance.Image = 0;
Override.ActiveNodeAppearance.Image = 1;
Override.NodeAppearance.ForeColor = Color.Red;
}
public void Init(ServerVersionId pversion)
{
_view.Load += SelectDbForm_Load;
_view.StatusStripSelectDatabase.DoubleClick += StatusBarSelectDatabase_DoubleClick;
_view.btnTest.Click += btnTest_Click;
_view.chkWindowsAuthentication.CheckedChanged += cbWindowsAuthentication_CheckedChanged;
_view.btnSelect.Click += btnSelect_Click;
_view.btnCreate.Click += btnCreate_Click;
_view.btnDrop.Click += btnDrop_Click;
_view.txtServer.Validating += txtServer_Validating;
_view.txtDatabase.Validating += txtDatabase_Validating;
_view.cboVendors.SelectionChanged += cboVendors_SelectionChanged;
_view.cboVendors.Items.Clear();
foreach (ServerVersionId version in DatabaseManagerFactory.Instance.GetSupportedVendors())
{
ValueListItem item = _view.cboVendors.Items.Add(version);
if (version == pversion)
{
_view.cboVendors.SelectedItem = item;
}
}
//if (_view.cboVendors.Items.Count > 0)
//{
// _view.cboVendors.SelectedIndex = 0;
//}
setVersionSettings(pversion);
}
private ServerVersionId getSelectedServerVersion()
{
ValueListItem item = _view.cboVendors.SelectedItem;
ServerVersionId currentSetting = (ServerVersionId)item.DataValue;
return(currentSetting);
}
private void cboVendors_SelectionChanged(object sender, EventArgs e)
{
ValueListItem item = _view.cboVendors.SelectedItem;
ServerVersionId serverVersion = (ServerVersionId)item.DataValue;
setVersionSettings(serverVersion);
}
public SelectDatabasePresenter GetSelectDatabasePresenter(ServerVersionId serverVersion)
{
var view = new SelectDatabaseForm();
SelectDatabasePresenter presenter = SelectDatabasePresenter.Instance;
presenter.View = view;
presenter.Init(serverVersion);
return(presenter);
}
public ServerConnectionSettings(ServerVersionId serverVersion, string serverName, string databaseName, bool useWindowsAuthentication,
string userName, string userPassword)
{
_version = serverVersion;
_server = serverName;
_database = databaseName;
_windowsAuthentication = useWindowsAuthentication;
_user = userName;
_password = userPassword;
}
public AssembliesNode(ServerVersionId ver)
{
base.Text = "Assemblies";
Override.NodeAppearance.Image = 0;
Override.ActiveNodeAppearance.Image = 1;
if (ver == ServerVersionId.SQLite_3 || ver == ServerVersionId.ODBC_Access || ver == ServerVersionId.ODBC_Excel)
{
IsHidden = true;
}
}
public ProceduresNode(ServerVersionId ver)
{
base.Text = "Stored Procedures";
Override.NodeAppearance.Image = 0;
Override.ActiveNodeAppearance.Image = 1;
if (ver == ServerVersionId.SQLite_3)
{
IsHidden = true;
}
}
public FunctionsNode(ServerVersionId ver)
{
base.Text = "Functions";
Override.NodeAppearance.Image = 0;
Override.ActiveNodeAppearance.Image = 1;
if (ver == ServerVersionId.SQLite_3)
{
IsHidden = true;
}
}
private void txtDatabase_Validating(object sender, CancelEventArgs e)
{
ServerVersionId version = getSelectedServerVersion();
if (version == ServerVersionId.FireBird_2 || version == ServerVersionId.SQLite_3 ||
version == ServerVersionId.ODBC_Access || version == ServerVersionId.ODBC_Excel)
{
string dbFile = _view.txtDatabase.Text;
if (File.Exists(dbFile))
{
_view.txtServer.Text = Path.GetFileName(dbFile);
}
else
{
_view.erpServerNameRequired.SetError(_view.txtDatabase, "Database not found");
e.Cancel = true;
}
}
}
public ViewsNode(ServerVersionId @param)
{
base.Text = "Views";
Override.NodeAppearance.Image = 0;
Override.ActiveNodeAppearance.Image = 1;
}
private void setVersionSettings(ServerVersionId serverVersion)
{
// _view.ToolTipManager.Enabled = false;
_view.ToolTipManager.ResetUltraToolTip(_view.cboVendors);
_view.ToolTipManager.HideToolTip();
_currentVersion = serverVersion;
if (serverVersion == ServerVersionId.SQLite_3)
{
_view.chkWindowsAuthentication.Checked = false;
_view.chkWindowsAuthentication.Enabled = false;
_view.txtServer.Enabled = false;
_view.txtServer.Width = 100;
_view.txtUser.Enabled = false;
_view.txtPassword.Enabled = false;
setFileBasedDb(true, true, true);
if (_view.txtServer.Text.Equals("."))
{
_view.txtServer.Text = "";
}
}
else if (serverVersion == ServerVersionId.FireBird_2)
{
_view.chkWindowsAuthentication.Checked = false;
_view.chkWindowsAuthentication.Enabled = false;
_view.txtServer.Enabled = false;
_view.txtServer.Width = 100;
_view.txtUser.Enabled = false;
_view.txtPassword.Enabled = false;
setFileBasedDb(true, true, true);
if (_view.txtServer.Text.Equals("."))
{
_view.txtServer.Text = "";
}
if (!ElevationHelper.IsAdmin())
{
// TODO specify with privilege we need
var ctrl = _view.cboVendors;
UltraToolTipInfo tip = _view.ToolTipManager.GetUltraToolTip(ctrl);
if (string.IsNullOrEmpty(tip.ToolTipText))
{
var info = new UltraToolTipInfo("Requires elevation, please restart SQL8r with more privileges",
ToolTipImage.Warning, "Warning", DefaultableBoolean.Default);
_view.ToolTipManager.SetUltraToolTip(ctrl, info);
}
_view.ToolTipManager.ShowToolTip(ctrl, ctrl.PointToScreen(ctrl.Location));
}
}
else if (serverVersion == ServerVersionId.ODBC_Access || serverVersion == ServerVersionId.ODBC_Excel)
{
_view.chkWindowsAuthentication.Checked = false;
_view.chkWindowsAuthentication.Enabled = false;
_view.txtServer.Enabled = false;
_view.txtServer.Width = 100;
_view.txtUser.Enabled = false;
_view.txtPassword.Enabled = false;
setFileBasedDb(true, false, true);
if (_view.txtServer.Text.Equals("."))
{
_view.txtServer.Text = "";
}
}
else if (serverVersion == ServerVersionId.MySql_5)
{
_view.chkWindowsAuthentication.Checked = false;
_view.chkWindowsAuthentication.Enabled = false;
_view.txtServer.Enabled = true;
_view.txtServer.Width = _view.txtDatabase.Width;
_view.txtUser.Enabled = true;
_view.txtPassword.Enabled = true;
setFileBasedDb(false, false, false);
}
else if (serverVersion == ServerVersionId.SqlServer_2005 || serverVersion == ServerVersionId.SqlServer_2008)
{
_view.chkWindowsAuthentication.Enabled = true;
_view.chkWindowsAuthentication.Checked = true;
_view.txtServer.Enabled = true;
_view.txtServer.Width = _view.txtDatabase.Width;
_view.txtUser.Enabled = false;
_view.txtPassword.Enabled = false;
setFileBasedDb(false, false, false);
if (string.IsNullOrEmpty(_view.txtServer.Text))
{
_view.txtServer.Text = ".";
}
}
else
{
throw new SQL8rException(string.Format("Unsupported ServerVersionId: {0}", serverVersion));
}
}
