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(); //} }