private void GetDomainUsers()
{
CmsWebServiceClient cmsWebServiceClient = new CmsWebServiceClient(Utils.WcfBinding, Utils.WcfEndPoint);
EventHandler<GetActiveDirectoryUsersCompletedEventArgs> eventHandler = null;
eventHandler =
(s1, e1) =>
{
var activeDirectoryContacts = e1.Result;
UsersDataGrid.ItemsSource = activeDirectoryContacts;
cmsWebServiceClient.GetActiveDirectoryUsersCompleted -= eventHandler;
//sort by Contact column
UsersDataGrid.SortDescriptors.Clear();
ColumnSortDescriptor descriptor = new ColumnSortDescriptor();
descriptor.Column = (GridViewDataColumn)UsersDataGrid.Columns["Contact"];
descriptor.SortDirection = ListSortDirection.Ascending;
UsersDataGrid.SortDescriptors.Add(descriptor);
IsBusyIndicator.IsBusy = false;
};
cmsWebServiceClient.GetActiveDirectoryUsersCompleted += eventHandler;
cmsWebServiceClient.GetActiveDirectoryUsersAsync();
}
private void Sorting(object sender, GridViewSortingEventArgs e)
{
if (e.Column.UniqueName == "CustomerID")
{
e.Cancel = true;
ColumnSortDescriptor descriptor = (from d in grid.SortDescriptors.OfType <ColumnSortDescriptor>()
where object.Equals(d.Column, grid.Columns["CompanyName"])
select d).FirstOrDefault();
if (descriptor == null)
{
grid.SortDescriptors.Add(new ColumnSortDescriptor()
{
Column = grid.Columns["CompanyName"],
SortDirection = ListSortDirection.Ascending
});
e.Column.SortingState = SortingState.Ascending;
}
else
{
descriptor.SortDirection = descriptor.SortDirection == ListSortDirection.Ascending ?
ListSortDirection.Descending : ListSortDirection.Ascending;
e.Column.SortingState = descriptor.SortDirection == ListSortDirection.Ascending ?
SortingState.Ascending : SortingState.Descending;
}
}
}
void OnMenuItemClick(object sender, RoutedEventArgs e)
{
RadContextMenu menu = (RadContextMenu)sender;
GridViewHeaderCell cell = menu.GetClickedElement <GridViewHeaderCell>();
RadMenuItem clickedItem = ((RadRoutedEventArgs)e).OriginalSource as RadMenuItem;
GridViewColumn column = cell.Column;
if (clickedItem.Parent is RadMenuItem)
{
return;
}
string header = Convert.ToString(clickedItem.Tag);
using (grid.DeferRefresh())
{
ColumnSortDescriptor sd = (from d in grid.SortDescriptors.OfType <ColumnSortDescriptor>()
where d.Column == column
select d).FirstOrDefault();
if (header.Contains("Ascending"))
{
if (sd != null)
{
grid.SortDescriptors.Remove(sd);
}
ColumnSortDescriptor newDescriptor = new ColumnSortDescriptor();
newDescriptor.Column = column;
newDescriptor.SortDirection = ListSortDirection.Ascending;
grid.SortDescriptors.Add(newDescriptor);
}
else if (header.Contains("Descending"))
{
if (sd != null)
{
grid.SortDescriptors.Remove(sd);
}
ColumnSortDescriptor newDescriptor = new ColumnSortDescriptor();
newDescriptor.Column = column;
newDescriptor.SortDirection = ListSortDirection.Descending;
grid.SortDescriptors.Add(newDescriptor);
}
else if (header.Contains("Clear"))
{
if (sd != null)
{
grid.SortDescriptors.Remove(sd);
}
}
}
}
public Example()
{
InitializeComponent();
var csd = new ColumnSortDescriptor() { Column = this.radGridView.Columns["Country"] };
this.radGridView.SortDescriptors.Add(csd);
var cgd = new ColumnGroupDescriptor() { Column = this.radGridView.Columns["Country"] };
this.radGridView.GroupDescriptors.Add(cgd);
}
public MainPage()
{
InitializeComponent();
model = this.Resources["MyViewModel"] as MyViewModel;
ColumnSortDescriptor csd = new ColumnSortDescriptor()
{
Column = this.clubsGrid.Columns["StadiumCapacity"],
SortDirection = ListSortDirection.Descending
};
this.clubsGrid.SortDescriptors.Add(csd);
model.MySortingToolTip = "Descending Order";
}
public MainWindow()
{
InitializeComponent();
model = this.Resources["MyViewModel"] as MyViewModel;
ColumnSortDescriptor csd = new ColumnSortDescriptor()
{
Column = this.clubsGrid.Columns["StadiumCapacity"],
SortDirection = ListSortDirection.Descending
};
this.clubsGrid.SortDescriptors.Add(csd);
model.MySortingToolTip = "Descending Order";
}
//сортування GridView за підрозділом
private void OrderByRadioButton3_Checked(object sender, RoutedEventArgs e)
{
//очищення попередніх критеріїв сортування
this.RadGridView.SortDescriptors.Clear();
ColumnSortDescriptor csd = new ColumnSortDescriptor()
{
//сортуємо за стовпцем [DepartmentName]
Column = this.RadGridView.Columns["DepartmentName"],
//сортування за висхідним порядком
SortDirection = ListSortDirection.Ascending
};
this.RadGridView.SortDescriptors.Add(csd);
}
private void OnClearSort(object parameter)
{
GridViewHeaderCell cell = parameter as GridViewHeaderCell;
if (cell != null && cell.Column != null && cell.Column.CanSort() && cell.Column.DataControl != null && cell.Column.SortingState != SortingState.None)
{
RadGridView grid = cell.Column.DataControl as RadGridView;
ColumnSortDescriptor sd = (from d in grid.SortDescriptors.OfType <ColumnSortDescriptor>()
where object.Equals(d.Column, cell.Column)
select d).FirstOrDefault();
if (sd != null)
{
grid.SortDescriptors.Remove(sd);
}
}
}
private static void Sort(GridViewHeaderCell cell, ListSortDirection sortDirection)
{
RadGridView grid = cell.Column.DataControl as RadGridView;
ColumnSortDescriptor sd = (from d in grid.SortDescriptors.OfType<ColumnSortDescriptor>()
where object.Equals(d.Column, cell.Column)
select d).FirstOrDefault();
if (sd != null)
{
grid.SortDescriptors.Remove(sd);
}
ColumnSortDescriptor newDescriptor = new ColumnSortDescriptor();
newDescriptor.Column = cell.Column;
newDescriptor.SortDirection = sortDirection;
grid.SortDescriptors.Add(newDescriptor);
}
public Example()
{
InitializeComponent();
var csd = new ColumnSortDescriptor()
{
Column = this.radGridView.Columns["Country"]
};
this.radGridView.SortDescriptors.Add(csd);
var cgd = new ColumnGroupDescriptor()
{
Column = this.radGridView.Columns["Country"]
};
this.radGridView.GroupDescriptors.Add(cgd);
}
private static void Sort(GridViewHeaderCell cell, ListSortDirection sortDirection)
{
RadGridView grid = cell.Column.DataControl as RadGridView;
ColumnSortDescriptor sd = (from d in grid.SortDescriptors.OfType <ColumnSortDescriptor>()
where object.Equals(d.Column, cell.Column)
select d).FirstOrDefault();
if (sd != null)
{
grid.SortDescriptors.Remove(sd);
}
ColumnSortDescriptor newDescriptor = new ColumnSortDescriptor();
newDescriptor.Column = cell.Column;
newDescriptor.SortDirection = sortDirection;
grid.SortDescriptors.Add(newDescriptor);
}
/// <summary>
/// The OnMenuItemClick.
/// </summary>
/// <param name="sender">The sender<see cref="object"/>.</param>
/// <param name="e">The e<see cref="RoutedEventArgs"/>.</param>
public void OnMenuItemClick(object sender, RoutedEventArgs e)
{
RadContextMenu menu = (RadContextMenu)sender;
GridViewHeaderCell cell = menu.GetClickedElement <GridViewHeaderCell>();
GridViewColumn column = cell.Column;
string header = string.Empty;
if (((RadRoutedEventArgs)e).OriginalSource is RadMenuItem clickedItem)
{
if (clickedItem?.Parent is RadMenuItem)
{
return;
}
else
{
header = (string)clickedItem !.Header ?? string.Empty;
}
}
using (_grid.DeferRefresh())
{
ColumnSortDescriptor sd = (from d in _grid.SortDescriptors.OfType <ColumnSortDescriptor>()
where object.Equals(d.Column, column)
select d).FirstOrDefault();
if (header !.Contains("Sort Ascending"))
{
if (sd != null)
{
_grid.SortDescriptors.Remove(sd);
}
ColumnSortDescriptor newDescriptor = new ColumnSortDescriptor
{
Column = column,
SortDirection = ListSortDirection.Ascending,
};
_grid.SortDescriptors.Add(newDescriptor);
}
public Example()
{
InitializeComponent();
ColumnSortDescriptor salesSortDescriptor = new ColumnSortDescriptor();
salesSortDescriptor.Column = this.radGridView.Columns[1];
salesSortDescriptor.SortDirection = System.ComponentModel.ListSortDirection.Descending;
this.radGridView.SortDescriptors.Add(salesSortDescriptor);
SalesContext context = new SalesContext();
EntityQuery<Year> distinctOrderYearsQuery = context.GetDistinctOrderYearsQuery();
context.Load<Year>(distinctOrderYearsQuery
, LoadBehavior.RefreshCurrent
, this.OnDistinctOrderYearsLoaded
, null);
this.loadTimer = new DispatcherTimer();
loadTimer.Interval = new TimeSpan(0, 0, 0, 0, 500);
loadTimer.Tick += this.OnLoadTimerTick;
loadTimer.Start();
}
void OnMenuItemClick(object sender, RoutedEventArgs e)
{
RadContextMenu menu = (RadContextMenu)sender;
GridViewHeaderCell cell = menu.GetClickedElement<GridViewHeaderCell>();
RadMenuItem clickedItem = ((RadRoutedEventArgs)e).OriginalSource as RadMenuItem;
GridViewColumn column = cell.Column;
if (clickedItem.Parent is RadMenuItem)
return;
string header = Convert.ToString(clickedItem.Tag);
using (grid.DeferRefresh())
{
ColumnSortDescriptor sd = (from d in grid.SortDescriptors.OfType<ColumnSortDescriptor>()
where d.Column == column
select d).FirstOrDefault();
if (header.Contains("Ascending"))
{
if (sd != null)
{
grid.SortDescriptors.Remove(sd);
}
ColumnSortDescriptor newDescriptor = new ColumnSortDescriptor();
newDescriptor.Column = column;
newDescriptor.SortDirection = ListSortDirection.Ascending;
grid.SortDescriptors.Add(newDescriptor);
}
else if (header.Contains("Descending"))
{
if (sd != null)
{
grid.SortDescriptors.Remove(sd);
}
ColumnSortDescriptor newDescriptor = new ColumnSortDescriptor();
newDescriptor.Column = column;
newDescriptor.SortDirection = ListSortDirection.Descending;
grid.SortDescriptors.Add(newDescriptor);
}
else if (header.Contains("Clear"))
{
if (sd != null)
{
grid.SortDescriptors.Remove(sd);
}
}
}
}
