private void cbInterface_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbInterface.SelectedItem.GetType() == typeof(SynapseInterface))
{
if (SynapseCore.Database.DBFunction.ConnectionManager.ActiveConnections > 0)
{
Hashtable connToRemove = new Hashtable();
foreach (DBConnection conn in SynapseCore.Database.DBFunction.ConnectionManager.Connections.Values)
{
if (conn.Name != "Default")
{
conn.Close();
connToRemove.Add(conn.Name, conn.Connection);
}
}
foreach (string conn in connToRemove.Keys)
{
SynapseCore.Database.DBFunction.ConnectionManager.Connections.Remove(conn);
}
}
selectedInterface = (SynapseInterface)cbInterface.SelectedItem;
txType.Text = selectedInterface.DBTYPE;
txConnectionString.Text = selectedInterface.CONNECTIONSTRING;
txQuery.Text = selectedInterface.TABLESQUERY;
txMessage.Text = "";
}
}
public override void initForm(SynapseCore.Security.Tools.SecureAndTranslateMode Mode)
{
base.initForm(SynapseCore.Security.Tools.SecureAndTranslateMode.Secure);
var Interfaces = SynapseInterface.Load();
cbInterface.Items.Clear();
foreach (SynapseInterface Interf in Interfaces.OrderBy(x => x.FriendlyName.ToString()).ToList())
{
cbInterface.Items.Add(Interf);
}
cbInterface.DisplayMember = "FriendlyName";
//cb_Module.DisplayMember = "TECHNICALNAME";
cbInterface.ValueMember = "ID";
cbInterface.SelectedItem = cbInterface.Items[0];
txOracleHome.Text = Environment.GetEnvironmentVariable("ORACLE_HOME");
txPath.Text = Environment.GetEnvironmentVariable("PATH");
txRegistry.Text = key.GetValue("").ToString();
//string val = key.GetValue("").ToString();
}
private static void setTo(SynapseInterface Int)
{
ReportOrigin _reportOrigin = new ReportOrigin();
_reportOrigin.ORIGIN = Origin.Interface;
_reportOrigin.TECHNICALNAME = Int.TECHNICALNAME;
_reportOrigin.DBTYPE = (DatabaseType)Enum.Parse(typeof(DatabaseType), Int.DBTYPE, true);
_reportOrigin.DBCONNECTION = Int.TECHNICALNAME;
_reportOrigin.FriendlyName = new LabelBag();
_reportOrigin.FriendlyName.Labels = new List <SynapseLabel>();
foreach (SynapseLanguage lang in SynapseLanguage.LoadFromQuery("SELECT * FROM SYNAPSE_LANGUAGE ORDER BY CODE"))
{
SynapseLabel newlabel = new SynapseLabel();
newlabel.LABELID = 0;
newlabel.LANGUAGE = lang.CODE;
newlabel.TEXT = Int.TECHNICALNAME;
_reportOrigin.FriendlyName.Labels.Add(newlabel);
}
_reportOrigin._MODULEID = 0;
_reportOrigin.INTERFACEID = Int.ID;
_reportOrigin._TYPE = Int.TYPE;
_reportOrigin.CONNECTIONSTRING = Int.CONNECTIONSTRING;
_reportOrigin.TABLESQUERY = Int.TABLESQUERY;
_reportOrigin.VIEWSQUERY = Int.VIEWSQUERY;
_reportOrigin.FIELDSQUERY = Int.FIELDSQUERY;
_reportOrigin.ORACLE_HOME = Int.ORACLE_HOME;
GlobalVariables.selectedOrigin = _reportOrigin;
}
private void treeReport_DoubleClick(object sender, EventArgs e)
{
if (treeReport.SelectedObject != null)
{
if (treeReport.SelectedObject is Category)
{
if (treeReport.IsExpanded(treeReport.SelectedObject))
{
treeReport.Collapse(treeReport.SelectedObject);
}
else
{
treeReport.Expand(treeReport.SelectedObject);
}
}
else
{
Definition _report = (Definition)treeReport.SelectedObject;
// If the Report List is mixed between Modue & Interface, reset the origin for each report
if (_InterfaceID != 0)
{
if (_report.FK_INTERFACE != 0)
{
ReportOrigin.setTo(SynapseInterface.LoadByID(_report.FK_INTERFACE));
}
else
{
ReportOrigin.setTo(SynapseModule.LoadByID(_report.FK_MODULE));
}
}
string pageTitle = string.Empty;
if (_report.ADDCATEGORY)
{
pageTitle = Category.LoadByID(_report.FK_CATEGORY).LABEL.ToString() + " - " + _report.LABEL.ToString();
}
else
{
pageTitle = _report.LABEL.ToString();
}
TabPage _page = new TabPage(pageTitle);
reportControl _rep = new reportControl();
_rep.ReportId = _report.ID;
_rep.IsForDesign = false;
_rep.Dock = DockStyle.Fill;
_rep.Load();
_page.Controls.Add(_rep);
tabControl1.TabPages.Add(_page);
_page.ImageKey = "report";
tabControl1.SelectedIndex = tabControl1.TabPages.Count - 1;
tabControl1.Visible = true;
_rep.Focus();
}
}
}
public override void initForm(SynapseCore.Security.Tools.SecureAndTranslateMode Mode)
{
base.initForm(Mode);
var Modules = FormUser.Modules;
var Interfaces = SynapseInterface.LoadAvailable();
if (Modules.Count > 1 || Interfaces.Count > 1)
{
cb_Module.Items.Clear();
foreach (SynapseModule Mod in Modules)
{
cb_Module.Items.Add(Mod);
}
foreach (SynapseInterface Interf in Interfaces)
{
cb_Module.Items.Add(Interf);
}
cb_Module.DisplayMember = "FriendlyName";
//cb_Module.DisplayMember = "TECHNICALNAME";
cb_Module.ValueMember = "ID";
cb_Module.SelectedItem = cb_Module.Items[0];
}
else
{
if (Modules.Count == 1)
{
ReportOrigin.setTo(Modules[0]);
this.DialogResult = DialogResult.OK;
this.Close();
}
if (Interfaces.Count == 1)
{
ReportOrigin.setTo(Interfaces[0]);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
