/// <summary>
/// Handles the DoWorker event for the worker
/// </summary>
/// <param name="sender">Object that fired the event</param>
/// <param name="e">.NET supplied event parameters</param>
protected override void worker_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e)
{
lock (syncLock)
{
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToProcessingState));
this.Dispatcher.BeginInvoke(new SimpleCallback(ClearResults));
AddDataGridDelegate addDataGrid = new AddDataGridDelegate(AddDataGrid);
try
{
Parameters.GadgetStatusUpdate += new GadgetStatusUpdateHandler(requestUpdateStatus);
Parameters.GadgetCheckForCancellation += new GadgetCheckForCancellationHandler(checkForCancellation);
if (this.DataFilters != null)
{
Parameters.CustomFilter = this.DataFilters.GenerateDataFilterString(false);
}
else
{
Parameters.CustomFilter = string.Empty;
}
List<DataTable> lineListTables = DashboardHelper.GenerateLineList(Parameters as LineListParameters);
if (lineListTables == null || lineListTables.Count == 0)
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), SharedStrings.NO_RECORDS_SELECTED);
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
Debug.Print("Line list thread cancelled");
return;
}
else if (lineListTables.Count == 1 && lineListTables[0].Rows.Count == 0)
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), SharedStrings.NO_RECORDS_SELECTED);
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
Debug.Print("Line list thread cancelled");
return;
}
else if (worker.CancellationPending)
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), SharedStrings.DASHBOARD_GADGET_STATUS_OPERATION_CANCELLED);
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
Debug.Print("Line list thread cancelled");
return;
}
else
{
string formatString = string.Empty;
foreach (DataTable listTable in lineListTables)
{
string strataValue = listTable.TableName;
if (listTable.Rows.Count == 0)
{
continue;
}
}
SetGadgetStatusMessage(SharedStrings.DASHBOARD_GADGET_STATUS_DISPLAYING_OUTPUT);
foreach (DataTable listTable in lineListTables)
{
string strataValue = listTable.TableName;
if (listTable.Rows.Count == 0)
{
continue;
}
string tableHeading = listTable.TableName;
SetCustomColumnSort(listTable);
if (listTable.Columns.Count == 0)
{
throw new ApplicationException("There are no columns to display in this list. If specifying a group variable, ensure the group variable contains data fields.");
}
int[] totals = new int[listTable.Columns.Count - 1];
this.Dispatcher.BeginInvoke(addDataGrid, listTable.AsDataView(), listTable.TableName);
}
//for(int i = 0; i < lineListTables.Count; i++)
//{
// lineListTables[i].Dispose();
//}
//lineListTables.Clear();
}
this.Dispatcher.BeginInvoke(new SimpleCallback(RenderFinish));
}
catch (Exception ex)
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), ex.Message);
}
finally
{
stopwatch.Stop();
Debug.Print("Line list gadget took " + stopwatch.Elapsed.ToString() + " seconds to complete with " + DashboardHelper.RecordCount.ToString() + " records and the following filters:");
Debug.Print(DashboardHelper.DataFilters.GenerateDataFilterString());
}
}
}
protected override void worker_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e)
{
lock (syncLock)
{
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToProcessingState));
this.Dispatcher.BeginInvoke(new SimpleCallback(ClearResults));
DrawFrequencyBordersDelegate drawBorders = new DrawFrequencyBordersDelegate(DrawOutputGridBorders);
AddDataGridDelegate addDataGrid = new AddDataGridDelegate(AddDataGrid);
System.Collections.Generic.Dictionary <string, System.Data.DataTable> Freq_ListSet = new Dictionary <string, System.Data.DataTable>();
try
{
DataTable dt = new DataTable();
bool booleanResults = false;
int fields = -1;
if (Parameters.ColumnNames.Count > 0)
{
//if (DashboardHelper.GetAllGroupsAsList().Contains(freqVar))
//{
dt = DashboardHelper.GenerateCombinedFrequencyTable(Parameters as CombinedFrequencyParameters, ref booleanResults, ref fields);
//fields = DashboardHelper.GetVariablesInGroup(freqVar).Count;
//}
}
else
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), "Something that should never fail has failed.");
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
return;
}
if (dt == null || dt.Rows.Count == 0)
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), SharedStrings.NO_RECORDS_SELECTED);
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
return;
}
else if (worker.CancellationPending)
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), SharedStrings.DASHBOARD_GADGET_STATUS_OPERATION_CANCELLED);
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
Debug.Print("Combined frequency thread cancelled");
return;
}
else
{
string formatString = string.Empty;
double count = Convert.ToDouble(dt.Compute("sum([count])", string.Empty));
string strataValue = dt.TableName;
int denominator = DashboardHelper.RecordCount;
if (!string.IsNullOrEmpty(Parameters.CustomFilter.Trim()))
{
string globalFilter = DashboardHelper.DataFilters.GenerateDataFilterString(false);
string gadgetFilter = Parameters.CustomFilter.Trim();
if (DashboardHelper.DataFilters.Count > 0)
{
gadgetFilter = "(" + gadgetFilter + ") AND (" + globalFilter + ")";
}
denominator = DashboardHelper.DataSet.Tables[0].Select(gadgetFilter).Count();
}
if (!booleanResults)
{
denominator = denominator * fields;
}
dt.Columns[0].ColumnName = DashboardSharedStrings.COL_HEADER_VALUE;
dt.Columns[1].ColumnName = DashboardSharedStrings.COL_HEADER_FREQUENCY;
dt.Columns.Add(new DataColumn(DashboardSharedStrings.COL_HEADER_PERCENT, typeof(double)));
dt.Columns.Add("LCL", typeof(System.Double));
dt.Columns.Add("UCL", typeof(System.Double));
foreach (System.Data.DataRow row in dt.Rows)
{
if (!row[DashboardSharedStrings.COL_HEADER_VALUE].Equals(DBNull.Value))
{
double pct = 0;
if (denominator > 0)
{
pct = Convert.ToDouble(row[DashboardSharedStrings.COL_HEADER_FREQUENCY]) / (double)denominator;
row[DashboardSharedStrings.COL_HEADER_PERCENT] = pct;
double lower = 0;
double upper = 0;
if (Convert.ToDouble(row[DashboardSharedStrings.COL_HEADER_FREQUENCY]) == (double)count)
{
lower = 0;
freq.ExactCI(Convert.ToDouble(row[DashboardSharedStrings.COL_HEADER_FREQUENCY]), (double)denominator, 95.0, ref lower, ref upper);
upper = 1;
}
else if (Convert.ToDouble(row[DashboardSharedStrings.COL_HEADER_FREQUENCY]) == 0.0)
{
upper = 0;
freq.ExactCI(Convert.ToDouble(row[DashboardSharedStrings.COL_HEADER_FREQUENCY]), (double)denominator, 95.0, ref lower, ref upper);
lower = 0;
}
else
{
if (denominator > 300)
{
freq.WILSON(Convert.ToDouble(row[DashboardSharedStrings.COL_HEADER_FREQUENCY]), (double)denominator, 1.96, ref lower, ref upper);
}
else
{
freq.ExactCI(Convert.ToDouble(row[DashboardSharedStrings.COL_HEADER_FREQUENCY]), (double)denominator, 95.0, ref lower, ref upper);
}
}
row["LCL"] = lower;
row["UCL"] = upper;
}
}
}
this.Dispatcher.BeginInvoke(addDataGrid, dt.AsDataView(), dt.TableName);
this.Dispatcher.BeginInvoke(new AddGridFooterDelegate(RenderFrequencyFooter), strataValue, denominator, fields, booleanResults);
//this.Dispatcher.BeginInvoke(drawBorders, strataValue);
this.Dispatcher.BeginInvoke(new SimpleCallback(RenderFinish));
//this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
}
}
catch (Exception ex)
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), ex.Message);
//this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
}
finally
{
//stopwatch.Stop();
//Debug.Print("Combined Frequency gadget took " + stopwatch.Elapsed.ToString() + " seconds to complete with " + dashboardHelper.RecordCount.ToString() + " records and the following filters:");
//Debug.Print(dashboardHelper.DataFilters.GenerateDataFilterString());
}
}
}
protected override void worker_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e)
{
lock (syncLock)
{
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToProcessingState));
this.Dispatcher.BeginInvoke(new SimpleCallback(ClearResults));
DrawFrequencyBordersDelegate drawBorders = new DrawFrequencyBordersDelegate(DrawOutputGridBorders);
AddDataGridDelegate addDataGrid = new AddDataGridDelegate(AddDataGrid);
System.Collections.Generic.Dictionary<string, System.Data.DataTable> Freq_ListSet = new Dictionary<string, System.Data.DataTable>();
try
{
DataTable dt = new DataTable();
bool booleanResults = false;
int fields = -1;
if (Parameters.ColumnNames.Count > 0)
{
//if (DashboardHelper.GetAllGroupsAsList().Contains(freqVar))
//{
dt = DashboardHelper.GenerateCombinedFrequencyTable(Parameters as CombinedFrequencyParameters, ref booleanResults, ref fields);
//fields = DashboardHelper.GetVariablesInGroup(freqVar).Count;
//}
}
else
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), "Something that should never fail has failed.");
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
return;
}
if (dt == null || dt.Rows.Count == 0)
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), SharedStrings.NO_RECORDS_SELECTED);
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
return;
}
else if (worker.CancellationPending)
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), SharedStrings.DASHBOARD_GADGET_STATUS_OPERATION_CANCELLED);
this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
Debug.Print("Combined frequency thread cancelled");
return;
}
else
{
string formatString = string.Empty;
double count = Convert.ToDouble(dt.Compute("sum([count])", string.Empty));
string strataValue = dt.TableName;
int denominator = DashboardHelper.RecordCount;
if (!string.IsNullOrEmpty(Parameters.CustomFilter.Trim()))
{
denominator = DashboardHelper.DataSet.Tables[0].Select(Parameters.CustomFilter.Trim()).Count();
}
if (!booleanResults)
{
denominator = denominator * fields;
}
dt.Columns[0].ColumnName = DashboardSharedStrings.COL_HEADER_VALUE;
dt.Columns[1].ColumnName = DashboardSharedStrings.COL_HEADER_FREQUENCY;
dt.Columns.Add(new DataColumn(DashboardSharedStrings.COL_HEADER_PERCENT, typeof(double)));
foreach (System.Data.DataRow row in dt.Rows)
{
if (!row[DashboardSharedStrings.COL_HEADER_VALUE].Equals(DBNull.Value))
{
double pct = 0;
if (count > 0)
{
pct = Convert.ToDouble(row[DashboardSharedStrings.COL_HEADER_FREQUENCY]) / (double)denominator;
row[DashboardSharedStrings.COL_HEADER_PERCENT] = pct;
}
}
}
this.Dispatcher.BeginInvoke(addDataGrid, dt.AsDataView(), dt.TableName);
this.Dispatcher.BeginInvoke(new AddGridFooterDelegate(RenderFrequencyFooter), strataValue, denominator, fields, booleanResults);
//this.Dispatcher.BeginInvoke(drawBorders, strataValue);
this.Dispatcher.BeginInvoke(new SimpleCallback(RenderFinish));
//this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
}
}
catch (Exception ex)
{
this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), ex.Message);
//this.Dispatcher.BeginInvoke(new SimpleCallback(SetGadgetToFinishedState));
}
finally
{
//stopwatch.Stop();
//Debug.Print("Combined Frequency gadget took " + stopwatch.Elapsed.ToString() + " seconds to complete with " + dashboardHelper.RecordCount.ToString() + " records and the following filters:");
//Debug.Print(dashboardHelper.DataFilters.GenerateDataFilterString());
}
}
}