public MainWindow()
{
InitializeComponent();
WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
myDataHandler = this.InitializeListBox_PlayerList;
GOLFDB.ProcessRecord(myDataHandler);
}
private void GridViewColumnHeaderClickedHandler(object sender, RoutedEventArgs e)
{
GridViewColumnHeader headerClicked =
e.OriginalSource as GridViewColumnHeader;
ListSortDirection direction;
if (headerClicked != null)
{
if (headerClicked.Role != GridViewColumnHeaderRole.Padding)
{
if (_lastHeaderClicked != null && headerClicked != _lastHeaderClicked)
{
direction = ListSortDirection.Ascending;
}
else
{
if (_lastDirection == ListSortDirection.Ascending)
{
direction = ListSortDirection.Descending;
}
else
{
direction = ListSortDirection.Ascending;
}
}
string header = headerClicked.Column.Header as string;
string SQL = " ORDER BY ";
switch (header)
{
case "ID": SQL += GOLFDB.ID; break;
case "Title": SQL += GOLFDB.Title; break;
case "First Name": SQL += GOLFDB.FirstName + "+" + GOLFDB.SurName; break;
case "Last Name": SQL += GOLFDB.SurName + "+" + GOLFDB.FirstName; break;
case "Gender": SQL += GOLFDB.Gender; break;
case "Handicap": SQL += GOLFDB.Handicap; break;
case "DOB": SQL += GOLFDB.DOB; break;
case "Street": SQL += GOLFDB.Street; break;
case "Suburb": SQL += GOLFDB.Suburb; break;
case "City": SQL += GOLFDB.City; break;
case "Available": SQL += "[" + GOLFDB.Availiable_Week_Days + "]"; break;
}
SQL += " " + (direction == ListSortDirection.Ascending ? "ASC" : "DESC");
this.ListView_Players.Items.Clear();
GOLFDB.ProcessRecord(myDataHandler, SQL);
_lastHeaderClicked = headerClicked;
_lastDirection = direction;
}
}
}