private void ButtonAddAggregate_Click(object sender, EventArgs e)
{
var column = ((CustomColumn)ComboBoxAggregateColumns.SelectedItem).Column;
AggregatedColumn aggregatedColumn = null;
switch (ComboBoxAggregations.SelectedItem.ToString())
{
case "Count":
aggregatedColumn = column.Count();
break;
case "Avg":
aggregatedColumn = column.Avg();
break;
case "Sum":
aggregatedColumn = column.Sum();
break;
case "Min":
aggregatedColumn = column.Min();
break;
case "Max":
aggregatedColumn = column.Max();
break;
}
var text = string.Format("\t.Select(_queryTransformer.Columns[{0}].{1}())",
_queryTransformer.Columns.IndexOf(column), ComboBoxAggregations.SelectedItem);
_sourceCodeTransformer.Add(text);
// Add an aggregate to the query - if any aggregates are added, all other columns will be removed from the query.
_queryTransformer.Aggregations.Add(aggregatedColumn);
CounterAggregations.Text = _queryTransformer.Aggregations.Count.ToString();
ClearFieldsAggregate();
}
private void ButtonAddAggregate_OnClick(object sender, RoutedEventArgs e)
{
var column = (OutputColumn)ComboBoxColumnAggregate.SelectedItem;
AggregatedColumn aggregatedColumn = null;
switch (ComboBoxFunction.SelectedItem.ToString())
{
case "Count":
aggregatedColumn = column.Count();
break;
case "Avg":
aggregatedColumn = column.Avg();
break;
case "Sum":
aggregatedColumn = column.Sum();
break;
case "Min":
aggregatedColumn = column.Min();
break;
case "Max":
aggregatedColumn = column.Max();
break;
}
// Add an aggregate to the query - if any aggregates are added, all other columns will be removed from the query.
_queryTransformer.Aggregations.Add(aggregatedColumn);
CounterAggregations.Text = _queryTransformer.Aggregations.Count.ToString();
ClearFieldsAggregate();
}
