/// <summary>
/// Copy Constructor
/// </summary>
public GadgetParameters(IGadgetParameters parameters)
{
InputVariableList = parameters.InputVariableList;
CustomFilter = parameters.CustomFilter;
CustomSortColumnName = parameters.CustomSortColumnName;
StrataVariableNames = parameters.StrataVariableNames;
SortVariables = parameters.SortVariables;
}
/// <summary>
/// Copy Constructor
/// </summary>
public GadgetParameters(IGadgetParameters parameters)
{
InputVariableList = parameters.InputVariableList;
CustomFilter = parameters.CustomFilter;
CustomSortColumnName = parameters.CustomSortColumnName;
StrataVariableNames = parameters.StrataVariableNames;
SortVariables = parameters.SortVariables;
}
public WordCloudProperties(
DashboardHelper dashboardHelper,
IGadget gadget,
IGadgetParameters parameters
)
{
InitializeComponent();
this.DashboardHelper = dashboardHelper;
this.Gadget = gadget;
this.Parameters = (parameters as WordCloudParameters);
//List<FieldInfo> items = new List<FieldInfo>();
//List<string> fields = new List<string>();
List<string> fieldNames = new List<string>();
ColumnDataType columnDataType = ColumnDataType.Boolean | ColumnDataType.DateTime | ColumnDataType.Numeric | ColumnDataType.Text | ColumnDataType.UserDefined | ColumnDataType.UserDefined;
fieldNames = DashboardHelper.GetFieldsAsList(columnDataType);
///////FOR ENABLING MULTI-SELECT USING THE LISTVIEW IN THE FUTURE (As done in CombinedFrequency Properties) ////////////////////
//foreach (string fieldName in DashboardHelper.GetFieldsAsList(columnDataType))
//{
// items.Add(new FieldInfo()
// {
// Name = fieldName,
// DataType = DashboardHelper.GetColumnDbType(fieldName).ToString(),
// VariableCategory = VariableCategory.Field
// });
// fields.Add(fieldName);
//}
//foreach (string fieldName in DashboardHelper.GetAllGroupsAsList())
//{
// FieldInfo fieldInfo = new FieldInfo()
// {
// Name = fieldName,
// DataType = String.Empty,
// VariableCategory = VariableCategory.Group
// };
// items.Add(fieldInfo);
//}
//if (DashboardHelper.IsUsingEpiProject)
//{
// for (int i = 0; i < DashboardHelper.View.Pages.Count; i++)
// {
// items.Add(new FieldInfo()
// {
// Name = "Page " + (i + 1).ToString(),
// DataType = String.Empty,
// VariableCategory = VariableCategory.Page
// });
// }
//}
fieldNames.Sort();
cmbField.ItemsSource = fieldNames;
//cmbGroupField.ItemsSource = fields;
//CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(lvTextVariables.ItemsSource);
//PropertyGroupDescription groupDescription = new PropertyGroupDescription("VariableCategory");
//view.GroupDescriptions.Add(groupDescription);
RowFilterControl = new RowFilterControl(this.DashboardHelper, Dialogs.FilterDialogMode.ConditionalMode, (gadget as WordCloudControl).DataFilters, true);
RowFilterControl.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;
panelFilters.Children.Add(RowFilterControl);
}
private void PopulateDataSet(IGadgetParameters inputs = null, string filterstring = null)
{
DataTable unfilteredTable = new DataTable("unfilteredTable");
unfilteredTable.CaseSensitive = true;
if (inputs != null)
{
inputs.UpdateGadgetStatus(SharedStrings.DASHBOARD_GADGET_STATUS_CACHING_WAIT);
}
{
// if (ds == null || ds.Tables.Count == 0 || (ds.Tables[0].Rows.Count == 0 && ds.Tables[0].Columns.Count == 0))
if (true)
{
if (inputs != null)
{
inputs.UpdateGadgetStatus(SharedStrings.DASHBOARD_GADGET_STATUS_CACHING);
}
if (string.IsNullOrEmpty(filterstring))
{
unfilteredTable = DashboardHelper.Database.GetTableData(DashboardHelper.TableName);
}
else
{
Query selectQuery = DashboardHelper.Database.CreateQuery(filterstring);
unfilteredTable = DashboardHelper.Database.Select(selectQuery);
}
if (DashboardHelper.ConnectionsForRelate.Count > 0)
{
foreach (RelatedConnection conn in DashboardHelper.ConnectionsForRelate)
{
DataTable relatedTable = new DataTable();
relatedTable.CaseSensitive = true;
{
relatedTable = conn.db.GetTableData(conn.TableName);
relatedTable.TableName = conn.TableName;
}
}
}
DashboardHelper.AddSystemVariablesToTable(unfilteredTable);
DashboardHelper.AddPermanentVariablesToTable(unfilteredTable);
ds = new DataSet();
ds.Tables.Add(unfilteredTable); //ds.Tables.Add(ConvertTableColumns(unfilteredTable));
ds.Tables[0].CaseSensitive = true;
mainTable = ds.Tables[0];
#region Data Prep for values with spaces (Excel only)
if (DashboardHelper.Database.ConnectionDescription.Contains("Excel")) // only run if it's Excel
{
List <string> strColumnNames = DashboardHelper.GetFieldsAsList(ColumnDataType.Text);
foreach (DataRow row in ds.Tables[0].Rows)
{
foreach (string strColumnName in strColumnNames)
{
row[strColumnName] = row[strColumnName].ToString().Trim();
}
}
}
#endregion // Data Prep for values with trailing spaces
}
else
{
if (inputs != null)
{
inputs.UpdateGadgetStatus(SharedStrings.DASHBOARD_GADGET_STATUS_PROCESSING);
}
}
}
if (inputs != null)
{
inputs.UpdateGadgetStatus(SharedStrings.DASHBOARD_INSTRUCTIONS_FINISHED_CACHING);
inputs.UpdateGadgetProgress(0);
}
}
public WordCloudProperties(
DashboardHelper dashboardHelper,
IGadget gadget,
IGadgetParameters parameters
)
{
InitializeComponent();
this.DashboardHelper = dashboardHelper;
this.Gadget = gadget;
this.Parameters = (parameters as WordCloudParameters);
//List<FieldInfo> items = new List<FieldInfo>();
//List<string> fields = new List<string>();
List <string> fieldNames = new List <string>();
ColumnDataType columnDataType = ColumnDataType.Boolean | ColumnDataType.DateTime | ColumnDataType.Numeric | ColumnDataType.Text | ColumnDataType.UserDefined | ColumnDataType.UserDefined;
fieldNames = DashboardHelper.GetFieldsAsList(columnDataType);
///////FOR ENABLING MULTI-SELECT USING THE LISTVIEW IN THE FUTURE (As done in CombinedFrequency Properties) ////////////////////
//foreach (string fieldName in DashboardHelper.GetFieldsAsList(columnDataType))
//{
// items.Add(new FieldInfo()
// {
// Name = fieldName,
// DataType = DashboardHelper.GetColumnDbType(fieldName).ToString(),
// VariableCategory = VariableCategory.Field
// });
// fields.Add(fieldName);
//}
//foreach (string fieldName in DashboardHelper.GetAllGroupsAsList())
//{
// FieldInfo fieldInfo = new FieldInfo()
// {
// Name = fieldName,
// DataType = String.Empty,
// VariableCategory = VariableCategory.Group
// };
// items.Add(fieldInfo);
//}
//if (DashboardHelper.IsUsingEpiProject)
//{
// for (int i = 0; i < DashboardHelper.View.Pages.Count; i++)
// {
// items.Add(new FieldInfo()
// {
// Name = "Page " + (i + 1).ToString(),
// DataType = String.Empty,
// VariableCategory = VariableCategory.Page
// });
// }
//}
fieldNames.Sort();
cmbField.ItemsSource = fieldNames;
//cmbGroupField.ItemsSource = fields;
//CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(lvTextVariables.ItemsSource);
//PropertyGroupDescription groupDescription = new PropertyGroupDescription("VariableCategory");
//view.GroupDescriptions.Add(groupDescription);
RowFilterControl = new RowFilterControl(this.DashboardHelper, Dialogs.FilterDialogMode.ConditionalMode, (gadget as WordCloudControl).DataFilters, true);
RowFilterControl.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;
panelFilters.Children.Add(RowFilterControl);
lblConfigExpandedTitleTxt.Text = DashboardSharedStrings.GADGET_CONFIG_TITLE_WORDCLOUD;
tbtnVariables.Title = DashboardSharedStrings.GADGET_TABBUTTON_VARIABLES;
tbtnVariables.Description = DashboardSharedStrings.GADGET_TABDESC_WORDCLOUD;
tbtnDisplay.Title = DashboardSharedStrings.GADGET_TABBUTTON_DISPLAY;
tbtnDisplay.Description = DashboardSharedStrings.GADGET_TABDESC_DISPLAY;
tbtnFilters.Title = DashboardSharedStrings.GADGET_TABBUTTON_FILTERS;
tbtnFilters.Description = DashboardSharedStrings.GADGET_TABDESC_FILTERS;
tblockPanelVariablesTxt.Text = DashboardSharedStrings.GADGET_PANELHEADER_VARIABLES;
tblockPanelDisplayTxt.Text = DashboardSharedStrings.GADGET_PANELHEADER_DISPLAY;
tblockPanelDataFilterTxt.Text = DashboardSharedStrings.GADGET_PANELHEADER_DATA_FILTER;
tblockTitleTxt.Text = DashboardSharedStrings.GADGET_GADET_TITLE;
tblockDescTxt.Text = DashboardSharedStrings.GADGET_DESCRIPTION;
tblockTitleNDescSubheaderTxt.Text = DashboardSharedStrings.GADGET_PANELSUBHEADER_TITLENDESC;
tblockAnyFilterGadgetOnlyTxt.Text = DashboardSharedStrings.GADGET_FILTER_GADGET_ONLY;
tblockVariableToParseTxt.Text = DashboardSharedStrings.GADGET_VARIABLE_PARSE;
tblockWordsIgnoreTxt.Text = DashboardSharedStrings.GADGET_WORDS_IGNORE;
btnOKTxt.Text = DashboardSharedStrings.BUTTON_OK;
btnCancelTxt.Text = DashboardSharedStrings.BUTTON_CANCEL;
}
public CombinedFrequencyProperties(
DashboardHelper dashboardHelper,
IGadget gadget,
IGadgetParameters parameters
)
{
InitializeComponent();
this.DashboardHelper = dashboardHelper;
this.Gadget = gadget;
this.Parameters = (parameters as CombinedFrequencyParameters);
List<FieldInfo> items = new List<FieldInfo>();
List<string> fields = new List<string>();
ColumnDataType columnDataType = ColumnDataType.Boolean | ColumnDataType.Numeric | ColumnDataType.Text | ColumnDataType.UserDefined;
foreach (string fieldName in DashboardHelper.GetFieldsAsList(columnDataType))
{
items.Add(new FieldInfo()
{
Name = fieldName,
DataType = DashboardHelper.GetColumnDbType(fieldName).ToString(),
VariableCategory = VariableCategory.Field
});
fields.Add(fieldName);
}
foreach (string fieldName in DashboardHelper.GetAllGroupsAsList())
{
FieldInfo fieldInfo = new FieldInfo()
{
Name = fieldName,
DataType = String.Empty,
VariableCategory = VariableCategory.Group
};
items.Add(fieldInfo);
}
if (DashboardHelper.IsUsingEpiProject)
{
for (int i = 0; i < DashboardHelper.View.Pages.Count; i++)
{
items.Add(new FieldInfo()
{
Name = "Page " + (i + 1).ToString(),
DataType = String.Empty,
VariableCategory = VariableCategory.Page
});
}
}
fields.Sort();
lvGroupVariables.ItemsSource = items;
//cmbGroupField.ItemsSource = fields;
CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(lvGroupVariables.ItemsSource);
PropertyGroupDescription groupDescription = new PropertyGroupDescription("VariableCategory");
view.GroupDescriptions.Add(groupDescription);
RowFilterControl = new RowFilterControl(this.DashboardHelper, Dialogs.FilterDialogMode.ConditionalMode, (gadget as CombinedFrequencyControl).DataFilters, true);
RowFilterControl.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;
panelFilters.Children.Add(RowFilterControl);
}
public CombinedFrequencyProperties(
DashboardHelper dashboardHelper,
IGadget gadget,
IGadgetParameters parameters
)
{
InitializeComponent();
this.DashboardHelper = dashboardHelper;
this.Gadget = gadget;
this.Parameters = (parameters as CombinedFrequencyParameters);
List <FieldInfo> items = new List <FieldInfo>();
List <string> fields = new List <string>();
ColumnDataType columnDataType = ColumnDataType.Boolean | ColumnDataType.Numeric | ColumnDataType.Text | ColumnDataType.UserDefined;
//Commenting for EI-392
//foreach (string fieldName in DashboardHelper.GetFieldsAsList(columnDataType))
//{
// items.Add(new FieldInfo()
// {
// Name = fieldName,
// DataType = DashboardHelper.GetColumnDbType(fieldName).ToString(),
// VariableCategory = VariableCategory.Field
// });
// fields.Add(fieldName);
//}
foreach (string fieldName in DashboardHelper.GetAllGroupsAsList())
{
FieldInfo fieldInfo = new FieldInfo()
{
Name = fieldName,
DataType = String.Empty,
VariableCategory = VariableCategory.Group
};
items.Add(fieldInfo);
}
//Commenting for EI-392
//if (DashboardHelper.IsUsingEpiProject)
//{
// for (int i = 0; i < DashboardHelper.View.Pages.Count; i++)
// {
// items.Add(new FieldInfo()
// {
// Name = "Page " + (i + 1).ToString(),
// DataType = String.Empty,
// VariableCategory = VariableCategory.Page
// });
// }
//}
fields.Sort();
lvGroupVariables.ItemsSource = items;
//cmbGroupField.ItemsSource = fields;
CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(lvGroupVariables.ItemsSource);
PropertyGroupDescription groupDescription = new PropertyGroupDescription("VariableCategory");
view.GroupDescriptions.Add(groupDescription);
RowFilterControl = new RowFilterControl(this.DashboardHelper, Dialogs.FilterDialogMode.ConditionalMode, (gadget as CombinedFrequencyControl).DataFilters, true);
RowFilterControl.HorizontalAlignment = System.Windows.HorizontalAlignment.Left;
panelFilters.Children.Add(RowFilterControl);
#region Translation
tbtnVariables.Title = DashboardSharedStrings.GADGET_TABBUTTON_VARIABLES;
tbtnVariables.Description = DashboardSharedStrings.GADGET_TABDESC_COMBINEDFEQ;
tbtnSorting.Title = DashboardSharedStrings.GADGET_TABBUTTON_SORTING;
tbtnSorting.Description = DashboardSharedStrings.GADGET_TABDESC_SORTING;
tbtnDisplay.Title = DashboardSharedStrings.GADGET_TABBUTTON_DISPLAY;
tbtnDisplay.Description = DashboardSharedStrings.GADGET_TABDESC_DISPLAY;
tbtnFilters.Title = DashboardSharedStrings.GADGET_TABBUTTON_FILTERS;
tbtnFilters.Description = DashboardSharedStrings.GADGET_TABDESC_FILTERS;
tblockPanelVariablesTxt.Text = DashboardSharedStrings.GADGET_PANELHEADER_VARIABLES;
tblockPanelSortingTxt.Text = DashboardSharedStrings.GADGET_PANELHEADER_SORTING;
tblockPanelDisplayTxt.Text = DashboardSharedStrings.GADGET_PANELHEADER_DISPLAY;
tblockSortingSubheaderTxt.Text = DashboardSharedStrings.GADGET_PANELSUBHEADER_SORTING;
tblockGroupingSubheaderTxt.Text = DashboardSharedStrings.GADGET_PANELSUBHEADER_GROUPING;
tblockTitleNDescSubheaderTxt.Text = DashboardSharedStrings.GADGET_PANELSUBHEADER_TITLENDESC;
tblockTitleTxt.Text = DashboardSharedStrings.GADGET_GADET_TITLE;
tblockDescTxt.Text = DashboardSharedStrings.GADGET_DESCRIPTION;
tblockPanelOutputOptTxt.Text = DashboardSharedStrings.GADGET_OUTPUT_OPTIONS;
tblockSortMethod.Text = DashboardSharedStrings.GADGET_SORT_METHOD;
tblockAnyFilterGadgetOnlyTxt.Text = DashboardSharedStrings.GADGET_FILTER_GADGET_ONLY;
tblockVariablesToDisplayTxt.Text = DashboardSharedStrings.GADGET_VARIABLES_TO_DISPLAY;
tblockCombineMode.Text = DashboardSharedStrings.GADGET_COMBINE_MODE;
checkboxShowDenominatorTxt.Text = DashboardSharedStrings.GADGET_SHOW_DENOMINATOR;
lblConfigExpandedTitleTxt.Text = DashboardSharedStrings.GADGET_CONFIG_TITLE_COMBINEDFEQ;
tblockPanelDataFilterTxt.Text = DashboardSharedStrings.GADGET_PANELHEADER_DATA_FILTER;
checkboxSortHighLowTxt.Text = DashboardSharedStrings.GADGET_SORT_HI_LOW;
btnOKTxt.Text = DashboardSharedStrings.BUTTON_OK;
btnCancelTxt.Text = DashboardSharedStrings.BUTTON_CANCEL;
#endregion // Translation
}
