private void ButtonAddSorting_Click(object sender, EventArgs e)
{
var column = ((CustomColumn)ComboBoxSortingColumns.SelectedItem).Column;
if (!column.IsSupportSorting)
{
return;
}
SortedColumn sortedColumn = null;
switch (ComboBoxSortings.SelectedItem.ToString())
{
case "Asc":
sortedColumn = column.Asc();
break;
case "Desc":
sortedColumn = column.Desc();
break;
}
var text = string.Format("\t.OrderBy(_queryTransformer.Columns[{0}], {1})",
_queryTransformer.Columns.IndexOf(column),
(ComboBoxSortings.SelectedItem.ToString() == "Asc").ToString().ToLower());
// Add sorting to the query - the sort order of original query will be overridden.
_queryTransformer.OrderBy(sortedColumn);
CounterSortings.Text = _queryTransformer.Sortings.Count.ToString();
BoxResultSql.Text = _queryTransformer.SQL;
ClearFieldsSorting();
_sourceCodeTransformer.Add(text);
}
private void ButtonAddSorting_OnClick(object sender, RoutedEventArgs e)
{
var column = (OutputColumn)ComboBoxColumnsSorting.SelectedItem;
if (!column.IsSupportSorting)
{
return;
}
SortedColumn sortedColumn = null;
if (ComboBoxSorting.SelectedValue == null)
{
return;
}
switch (ComboBoxSorting.SelectedValue.ToString())
{
case "Asc":
sortedColumn = column.Asc();
break;
case "Desc":
sortedColumn = column.Desc();
break;
}
// Add sorting to the query - the sort order of original query will be overridden.
_queryTransformer.OrderBy(sortedColumn);
CounterSortingActive.Text = _queryTransformer.Sortings.Count.ToString();
ClearFieldsSorting();
}
