private void BindVariables()
{
List <object[]> taxonomyVariables = Global.Core.TaxonomyVariables.GetValues(
new string[] { "Id" },
new string[] { },
new object[] { }
);
foreach (object[] taxonomyVariable in taxonomyVariables)
{
VariableSelector1.Classes.VariableSelector variableSelector = new VariableSelector1.Classes.VariableSelector(
2057,
"TaxonomyVariables",
"Id=" + taxonomyVariable[0]
);
variableSelector.Settings.Dragable = true;
if (this.Definition.SelectedVariables.Contains((Guid)taxonomyVariable[0]))
{
pnlSelectedVariables.Controls.Add(variableSelector);
}
else
{
pnlAvailableVariables.Controls.Add(variableSelector);
}
}
}
private void BindVariables(Guid idHierarchy, string variableName, string existingVariables)
{
// Get all taxonomy chapters of the client.
List <object[]> studies = Global.Core.Studies.GetValues(
new string[] { "Id", "Name" },
new string[] { },
new object[] { }
);
WebUtilities.Controls.Panel pnlContainer = new WebUtilities.Controls.Panel();
List <object[]> Variables;
// Run through all taxonomy chapters.
foreach (object[] study in studies)
{
WebUtilities.Controls.Panel pnlTaxonomyChapter = new WebUtilities.Controls.Panel();
pnlTaxonomyChapter.CssClass = "TaxonomyChapterTitle";
HtmlGenericControl lblTaxonomyChapterTitle = new HtmlGenericControl("div");
lblTaxonomyChapterTitle.Attributes.Add("class", "TaxonomyChapterTitleLabel");
lblTaxonomyChapterTitle.InnerText = study[1].ToString();
lblTaxonomyChapterTitle.Attributes.Add("onclick", string.Format(
"HideTaxonomyChapter(this, '{0}');",
study[0]
));
pnlTaxonomyChapter.Controls.Add(lblTaxonomyChapterTitle);
WebUtilities.Controls.Panel pnlTaxonomyChapterVariables = new WebUtilities.Controls.Panel();
pnlTaxonomyChapterVariables.CssClass = "TaxonomyChapterVariables PnlVariableSelectors";
pnlTaxonomyChapterVariables.Attributes.Add("id", "TaxonomyChapterVariables" + study[0]);
string SQLQuery = "SELECT Id FROM Variables WHERE IdStudy='" + study[0] + "' AND Name LIKE '%" + variableName.Trim() + "%' ";
if (!string.IsNullOrEmpty(existingVariables))
{
SQLQuery = SQLQuery + " AND Id NOT IN ('" + existingVariables + "') ";
}
Variables = Global.Core.TaxonomyVariables.ExecuteReader(SQLQuery);
if (Variables.Count == 0)
{
continue;
}
// Run through all taxonomy variables.
foreach (object[] taxonomyVariable in Variables)
{
VariableSelector1.Classes.VariableSelector variableSelector = new VariableSelector1.Classes.VariableSelector(
2057,
"Variables",
"Id=" + taxonomyVariable[0].ToString()
);
//variableSelector.EnableCombine = false;
variableSelector.Render();
pnlTaxonomyChapterVariables.Controls.Add(variableSelector);
}
pnlTaxonomyChapter.Controls.Add(pnlTaxonomyChapterVariables);
pnlContainer.Controls.Add(pnlTaxonomyChapter);
}
// Get all taxonomy variables without a chapter.
Variables = Global.Core.Variables.GetValues(
new string[] { "Id" },
new string[] { "IdStudy" },
new object[] { DBNull.Value }
);
// Run through all taxonomy variables.
foreach (object[] taxonomyVariable in Variables)
{
VariableSelector1.Classes.VariableSelector variableSelector = new VariableSelector1.Classes.VariableSelector(
2057,
"Variables",
"Id=" + taxonomyVariable[0].ToString()
);
//variableSelector.EnableCombine = false;
variableSelector.Variable.Values.Add("Id", taxonomyVariable[0]);
variableSelector.Render();
pnlContainer.Controls.Add(variableSelector);
}
Response.Write(pnlContainer.ToHtml());
}
private void RenderLinkBiDefinition()
{
Table table = new Table();
table.Attributes.Add("id", "TableLinkBiDefinition");
table.CssClass = "TableLinkBiDefinition BackgroundColor7";
table.CellPadding = 0;
table.CellSpacing = 0;
pnlLinkBiDefinition.Controls.Add(table);
TableRow tableRowHeadline = new TableRow();
tableRowHeadline.CssClass = "TableRowHeadline Color1";
TableCell tableCellIcons = new TableCell();
TableCell tableCellHeadlineDimensions = new TableCell();
TableCell tableCellHeadlineMeasures = new TableCell();
tableCellIcons.CssClass = "TableCellHeadlineIcons";
tableCellHeadlineDimensions.CssClass = "TableCellHeadlineDimensions";
tableCellHeadlineMeasures.CssClass = "TableCellHeadlineMeasures";
tableCellIcons.Controls.Add(RenderTopLeftButtons(100));
tableCellHeadlineDimensions.Text = Global.LanguageManager.GetText("Dimensions");
tableCellHeadlineMeasures.Text = Global.LanguageManager.GetText("Measures");
tableCellHeadlineDimensions.Attributes.Add("onclick", string.Format(
"InitDragBox('boxVariableSearchControl');SearchVariables('{0}', '{1}');",
this.LinkBiDefinition.FileName.Replace("\\", "/"),
this.LinkBiDefinition.Settings.IdLanguage
));
tableCellHeadlineMeasures.Attributes.Add("onclick", string.Format(
"InitDragBox('boxVariableSearchControl');SearchVariables('{0}', '{1}');",
this.LinkBiDefinition.FileName.Replace("\\", "/"),
this.LinkBiDefinition.Settings.IdLanguage
));
tableRowHeadline.Cells.Add(tableCellIcons);
tableRowHeadline.Cells.Add(tableCellHeadlineDimensions);
tableRowHeadline.Cells.Add(tableCellHeadlineMeasures);
table.Rows.Add(tableRowHeadline);
TableRow tableRow = new TableRow();
tableRow.VerticalAlign = VerticalAlign.Top;
table.Rows.Add(tableRow);
TableCell tableCellDimensions = new TableCell();
TableCell tableCellMeasures = new TableCell();
tableCellDimensions.ColumnSpan = 2;
tableCellDimensions.CssClass = "TableCellDimension PnlVariableSelectors";
tableCellMeasures.CssClass = "TableCellMeasure PnlVariableSelectors";
tableRow.Cells.Add(tableCellDimensions);
tableRow.Cells.Add(tableCellMeasures);
Panel pnlDimensions = new Panel();
Panel pnlMeasures = new Panel();
pnlDimensions.CssClass = "PanelDimensions";
pnlMeasures.CssClass = "PanelMeasures";
pnlDimensions.Attributes.Add("DropArea", "True");
pnlMeasures.Attributes.Add("DropArea", "True");
pnlDimensions.Attributes.Add("DropAreaTypeRestriction", string.Join(",", new string[] {
VariableType.Single.ToString(),
VariableType.Multi.ToString()
}));
pnlDimensions.Attributes.Add("Source", this.LinkBiDefinition.FileName.Replace("\\", "/"));
pnlMeasures.Attributes.Add("Source", this.LinkBiDefinition.FileName.Replace("\\", "/"));
pnlDimensions.Attributes.Add("Path", "Report/Dimensions");
pnlMeasures.Attributes.Add("Path", "Report/Measures");
tableCellDimensions.Controls.Add(pnlDimensions);
tableCellMeasures.Controls.Add(pnlMeasures);
// Run through all dimensions of the definition.
foreach (LinkBiDefinitionDimension dimension in this.LinkBiDefinition.Dimensions)
{
VariableSelector1.Classes.VariableSelector ddlVariable = new VariableSelector1.Classes.VariableSelector(
this.LinkBiDefinition.Settings.IdLanguage, new VariableSelector1.Classes.DefinitionObject(
Global.Core,
this.LinkBiDefinition.FileName,
dimension.XmlNode
), false);
ddlVariable.ID = "ddlDimension" + dimension.Identity;
pnlDimensions.Controls.Add(ddlVariable);
}
int i = 0;
// Run through all measures of the definition.
foreach (LinkBiDefinitionDimension measure in this.LinkBiDefinition.Measures)
{
VariableSelector1.Classes.VariableSelector ddlVariable = new VariableSelector1.Classes.VariableSelector(
this.LinkBiDefinition.Settings.IdLanguage, new VariableSelector1.Classes.DefinitionObject(
Global.Core,
this.LinkBiDefinition.FileName,
measure.XmlNode
), false);
ddlVariable.ID = "ddlMeasure" + measure.Identity;
pnlMeasures.Controls.Add(ddlVariable);
i++;
}
if (this.LinkBiDefinition.Workflow.Selections.Count > 0)
{
pnlWorkflow.Controls.Add(this.LinkBiDefinition.Workflow);
}
else
{
pnlWorkflowContainer.Visible = false;
}
}
private void BindTaxonomyVariables(Guid idHierarchy, string variableName)
{
// Get all taxonomy chapters of the client.
List <object[]> taxonomyChapters = Global.Core.TaxonomyChapters.GetValues(
new string[] { "Id" },
new string[] { },
new object[] { }
);
WebUtilities.Controls.Panel pnlContainer = new WebUtilities.Controls.Panel();
List <object[]> taxonomyVariables;
// Run through all taxonomy chapters.
foreach (object[] taxonomyChapter in taxonomyChapters)
{
WebUtilities.Controls.Panel pnlTaxonomyChapter = new WebUtilities.Controls.Panel();
pnlTaxonomyChapter.CssClass = "TaxonomyChapterTitle";
HtmlGenericControl lblTaxonomyChapterTitle = new HtmlGenericControl("div");
lblTaxonomyChapterTitle.Attributes.Add("class", "TaxonomyChapterTitleLabel");
lblTaxonomyChapterTitle.InnerText = (string)Global.Core.TaxonomyChapterLabels.GetValue(
"Label",
new string[] { "IdTaxonomyChapter", "IdLanguage" },
new object[] { taxonomyChapter[0], 2057 }
);
lblTaxonomyChapterTitle.Attributes.Add("onclick", string.Format(
"HideTaxonomyChapter(this, '{0}');",
taxonomyChapter[0]
));
pnlTaxonomyChapter.Controls.Add(lblTaxonomyChapterTitle);
WebUtilities.Controls.Panel pnlTaxonomyChapterVariables = new WebUtilities.Controls.Panel();
pnlTaxonomyChapterVariables.CssClass = "TaxonomyChapterVariables PnlVariableSelectors";
pnlTaxonomyChapterVariables.Attributes.Add("id", "TaxonomyChapterVariables" + taxonomyChapter[0]);
taxonomyVariables = Global.Core.TaxonomyVariables.ExecuteReader(
"SELECT Id FROM TaxonomyVariables WHERE IdTaxonomyChapter='" + taxonomyChapter[0] + "' AND Name LIKE '%" + variableName.Trim() + "%' AND Id IN " +
"(SELECT IdTaxonomyVariable FROM TaxonomyVariableHierarchies WHERE IdHierarchy='" + idHierarchy + "') "
);
if (taxonomyVariables.Count == 0)
{
continue;
}
// Run through all taxonomy variables.
foreach (object[] taxonomyVariable in taxonomyVariables)
{
VariableSelector1.Classes.VariableSelector variableSelector = new VariableSelector1.Classes.VariableSelector(
2057,
"TaxonomyVariables",
"Id=" + taxonomyVariable[0].ToString()
);
//variableSelector.EnableCombine = false;
variableSelector.Render();
pnlTaxonomyChapterVariables.Controls.Add(variableSelector);
}
pnlTaxonomyChapter.Controls.Add(pnlTaxonomyChapterVariables);
pnlContainer.Controls.Add(pnlTaxonomyChapter);
}
// Get all taxonomy variables without a chapter.
taxonomyVariables = Global.Core.TaxonomyVariables.GetValues(
new string[] { "Id" },
new string[] { "IdTaxonomyChapter" },
new object[] { DBNull.Value }
);
// Run through all taxonomy variables.
foreach (object[] taxonomyVariable in taxonomyVariables)
{
VariableSelector1.Classes.VariableSelector variableSelector = new VariableSelector1.Classes.VariableSelector(
2057,
"TaxonomyVariables",
"Id=" + taxonomyVariable[0].ToString()
);
//variableSelector.EnableCombine = false;
variableSelector.Variable.Values.Add("Id", taxonomyVariable[0]);
variableSelector.Render();
pnlContainer.Controls.Add(variableSelector);
}
Response.Write(pnlContainer.ToHtml());
}