public void dataGrid_Sorting(object sender, Microsoft.Windows.Controls.DataGridSortingEventArgs e)
{
SumRecord.RemoveFromList(allRecords);
}
private void MainDataGrid_Sorting(object sender, Microsoft.Windows.Controls.DataGridSortingEventArgs e)
{
//var columnPopup = new GridHeaderColumn();
//int columnHeaderIndex = e.Column.DisplayIndex;
//string dbColumn = String.Empty;
//MainWindow mw = (MainWindow)GetTopLevelControl(this.MainDataGrid);
//DependencyObject parent = GetRVC(this.MainDataGrid);
//if (parent != null)
//{
// ResultViewControl rvc = (ResultViewControl)parent;
// int selectedColumnCount = rvc.SelectTabCntrl._SelectedColCollection.Count;
// int totalCount = rvc.SelectTabCntrl.lstToSelecteColFrom.Items.Count;
// if (selectedColumnCount == 0 || selectedColumnCount == null)
// {
// for (int i = 0; i < totalCount; i++)
// {
// if (i == columnHeaderIndex)
// {
// dbColumn = rvc.SelectTabCntrl.lstToSelecteColFrom.Items[i].ToString();
// }
// }
// }
// else
// {
// for (int i = 0; i < selectedColumnCount; i++)
// {
// if (i == columnHeaderIndex)
// {
// dbColumn = rvc.SelectTabCntrl._SelectedColCollection[i].ToString();
// }
// }
// }
//}
//string columnHeader = e.Column.SortMemberPath;
//MainWindow mainWindow = (MainWindow)GetTopLevelControl(this);
//if (mainWindow.queryBuilder == null)
//{
// mainWindow.queryBuilder = MainWindow.LatestQueryBuilder;
//}
//connectionString = ConfigurationManager.AppSettings["DefaultDBConn"];
//DataTable dataTable = new DataTable();
//DataSet columnds = new DataSet();
//SQLBuilder.Clauses.Column column = new SQLBuilder.Clauses.Column();
//column.Name = dbColumn;
//column.Format = "";
//column.AliasName = "";
//dataTable = MySQLData.DataAccess.ADODataBridge.getColumnStats(connectionString, mainWindow.queryBuilder, column);
//columnPopup.ColumnDataGrid.DataContext = dataTable;
//columnPopup.Show();
//e.Handled = true;
//bool sortAscending = true;
//if (e.Column.SortMemberPath != currentSortColumn)
//{
// currentSortColumn = e.Column.SortMemberPath;
// currentSortDirection = "Ascending";
// sortAscending = true;
//}
//else
//{
// switch (currentSortDirection)
// {
// case "Ascending":
// currentSortDirection = "Descending";
// sortAscending = false;
// break;
// case "Descending":
// currentSortDirection = "Ascending";
// sortAscending = true;
// break;
// case null:
// currentSortDirection = "Ascending";
// sortAscending = true;
// break;
// }
//}
//currentSortColumnIndex = e.Column.DisplayIndex.ToString();
//Mouse.OverrideCursor = Cursors.Wait;
//result.Sort(e.Column.SortMemberPath, sortAscending);
//Mouse.OverrideCursor = null;
//if (RowCurrenPage != 0 && RowCurrenPage > 0)
//{
// RowCurrenPage = 1;
// getPageInfo(RowCurrenPage, result.rowPageSize, result.TotalIRows, out startRow, out EndCurrentPageRow);
// this.lblRowNumber.Content = "Row " + startRow.ToString() + " - " + EndCurrentPageRow.ToString() + " Of " + result.TotalIRows.ToString();
// this.lblPageNumber.Content = "Page " + RowCurrenPage.ToString() + " Of " + rowToatlPage.ToString();
//}
}
