public override void Execute()
{
ParameterCollectionUIOptionsFactory factory = new ParameterCollectionUIOptionsFactory();
var options = factory.Create(_collector, BasicActivator.CoreChildProvider);
var n = _parameterName;
var d = _datatype;
var v = _value;
if (n == null)
{
// get user to type the name of the parameter
if (BasicActivator.TypeText(new DialogArgs
{
EntryLabel = "Name",
TaskDescription = "A name is required for the paramater. It must start with '@' e.g. @myparameter. Do not add spaces or start the name with a number.",
WindowTitle = "Add Paramater"
}, 99, "@myVariable", out string name, false))
{
// user did type a name
n = name;
}
else
{
// user cancelled typing the parameter name
return;
}
}
public override void Execute()
{
var parameterCollectionUI = new ParameterCollectionUI();
ParameterCollectionUIOptionsFactory factory = new ParameterCollectionUIOptionsFactory();
var options = factory.Create(_collector);
parameterCollectionUI.SetUp(options);
Activator.ShowWindow(parameterCollectionUI, true);
}
private void RefreshUIFromDatabase()
{
tbID.Text = ExtractionFilterParameterSet.ID.ToString();
tbName.Text = ExtractionFilterParameterSet.Name;
tbDescription.Text = ExtractionFilterParameterSet.Description;
ParameterCollectionUIOptionsFactory factory = new ParameterCollectionUIOptionsFactory();
var options = factory.Create(ExtractionFilterParameterSet);
parameterCollectionUI1.SetUp(options, Activator);
}
private void btnImport_Click(object sender, EventArgs e)
{
if (_allowImportAsCatalogue)
{
var ui = new ConfigureCatalogueExtractabilityUI(Activator, Importer, "Existing Table", _projectSpecific)
{
TargetFolder = TargetFolder
};
ui.ShowDialog();
TableInfoCreatedIfAny = ui.TableInfoCreated;
}
else
{
// logic to add credentials
// parent.SetCredentials();
Importer.DoImport(out var ti, out var cols);
if (ti is DatabaseEntity de)
{
Activator.Publish(de);
}
TableInfoCreatedIfAny = ti;
}
try
{
DialogResult = DialogResult.OK;
var ti = TableInfoCreatedIfAny;
if (ti != null)
{
if (ti.IsTableValuedFunction && ti.GetAllParameters().Any())
{
var options = new ParameterCollectionUIOptionsFactory().Create(ti);
ParameterCollectionUI.ShowAsDialog(Activator, options, true);
}
MessageBox.Show("Successfully imported table '" + ti + "'");
}
Close();
}
catch (SqlException exception)
{
MessageBox.Show("Problem importing table :" + exception.Message);
}
}
public override void SetDatabaseObject(IActivateItems activator, ConcreteFilter databaseObject)
{
_loading = true;
base.SetDatabaseObject(activator, databaseObject);
Catalogue = databaseObject.GetCatalogue();
_extractionFilter = databaseObject;
ParameterCollectionUIOptionsFactory factory = null;
ParameterCollectionUIOptions options = null;
try
{
factory = new ParameterCollectionUIOptionsFactory();
options = factory.Create(databaseObject, activator.CoreChildProvider);
}
catch (Exception e)
{
Activator.KillForm(ParentForm, e);
return;
}
//collapse panel 1 unless there are parameters
splitContainer1.Panel1Collapsed = !options.ParameterManager.ParametersFoundSoFarInQueryGeneration.Values.Any(v => v.Any());
parameterCollectionUI1.SetUp(options, Activator);
CommonFunctionality.AddToMenu(new ExecuteCommandViewFilterMatchData(Activator, databaseObject, ViewType.TOP_100));
CommonFunctionality.AddToMenu(new ExecuteCommandViewFilterMatchData(Activator, databaseObject, ViewType.Aggregate));
CommonFunctionality.AddToMenu(new ExecuteCommandViewFilterMatchGraph(Activator, databaseObject));
CommonFunctionality.AddToMenu(new ExecuteCommandBrowseLookup(Activator, databaseObject));
CommonFunctionality.AddToMenu(new ExecuteCommandPublishFilter(Activator, databaseObject, databaseObject.GetCatalogue()));
FigureOutGlobalsAndAutoComplete();
QueryEditor.Text = _extractionFilter.WhereSQL;
CommonFunctionality.AddChecks(databaseObject);
CommonFunctionality.StartChecking();
QueryEditor.ReadOnly = ReadOnly;
tbFilterName.ReadOnly = ReadOnly;
tbFilterDescription.ReadOnly = ReadOnly;
cbIsMandatory.Enabled = !ReadOnly;
_loading = false;
}
private void btnImport_Click(object sender, EventArgs e)
{
if (_allowImportAsCatalogue)
{
var ui = new ConfigureCatalogueExtractabilityUI(Activator, Importer, "Existing Table", null);
ui.ShowDialog();
TableInfoCreatedIfAny = ui.TableInfoCreated;
}
else
{
// logic to add credentials
// parent.SetCredentials();
TableInfo ti;
ColumnInfo[] cols;
Importer.DoImport(out ti, out cols);
Activator.RefreshBus.Publish(this, new RefreshObjectEventArgs(ti));
TableInfoCreatedIfAny = ti;
}
try
{
DialogResult = DialogResult.OK;
var ti = TableInfoCreatedIfAny;
if (ti.IsTableValuedFunction && ti.GetAllParameters().Any())
{
var options = new ParameterCollectionUIOptionsFactory().Create(ti);
ParameterCollectionUI.ShowAsDialog(options, true);
}
MessageBox.Show("Successfully imported table '" + ti + "'");
Close();
}
catch (SqlException exception)
{
MessageBox.Show("Problem importing table :" + exception.Message);
}
}
