GetQueryController( System.Windows.Controls.DataGrid dataGrid, FilterData filterData, IEnumerable itemsSource) { if (dataGrid == null) { throw new ArgumentNullException(nameof(dataGrid)); } var query = DataGridExtensions.GetDataGridFilterQueryController(dataGrid); if (query == null) { //clear the filter if exists begin System.ComponentModel.ICollectionView view = System.Windows.Data.CollectionViewSource.GetDefaultView(dataGrid.ItemsSource); if (view != null) { view.Filter = null; } //clear the filter if exists end query = new QueryController(); DataGridExtensions.SetDataGridFilterQueryController(dataGrid, query); } query.ColumnFilterData = filterData; query.ItemsSource = itemsSource; query.CallingThreadDispatcher = dataGrid.Dispatcher; query.UseBackgroundWorker = DataGridExtensions.GetUseBackgroundWorkerForFiltering(dataGrid); return(query); }
public void ClearFilters() { var vw = GetView() as Views.PowerBIPerformanceDataView; var controller = DataGridExtensions.GetDataGridFilterQueryController(vw.PerformanceData); controller.ClearFilter(); }
public override void ClearFilters() { var vw = GetView() as Views.AllServerQueriesView; var controller = DataGridExtensions.GetDataGridFilterQueryController(vw.QueryEvents); controller.ClearFilter(); }
private void ApplicationStatusSelectionChanged(object sender, SelectionChangedEventArgs e) { var comboBox = sender as ComboBox; DataItem selectedItem = (DataItem)this.SampleGrid.CurrentItem; if (comboBox.SelectedItem == null || selectedItem.str_jobapplications_ApplicationStatus == ((EmployeeStatus)comboBox.SelectedItem).Name) { return; } //Create Connection SqlConnection thisConnection = new SqlConnection(@"Data Source=.\SQLEXPRESS02;Initial Catalog=IdealAutomateDB;Integrated Security=SSPI"); OpenConnection(thisConnection); try { // 1. Create Command // Sql Update Statement string updateSql = "UPDATE JobApplications " + "SET ApplicationStatus = @ApplicationStatus, DateApplied = @DateApplied, DateLastModified = @DateLastModified " + "WHERE JobUrl = @JobUrl"; SqlCommand UpdateCmd = new SqlCommand(updateSql, thisConnection); // 2. Map Parameters UpdateCmd.Parameters.Add("@ApplicationStatus", SqlDbType.NVarChar, 50, "ApplicationStatus"); UpdateCmd.Parameters.Add("@JobUrl", SqlDbType.NVarChar, 4000, "JobUrl"); UpdateCmd.Parameters.Add("@DateApplied", SqlDbType.DateTime); UpdateCmd.Parameters.Add("@DateLastModified", SqlDbType.DateTime); UpdateCmd.Parameters["@ApplicationStatus"].Value = ((EmployeeStatus)comboBox.SelectedItem).Name; UpdateCmd.Parameters["@JobUrl"].Value = selectedItem.str_jobapplications_JobUrl; if (comboBox.SelectedItem.ToString() == "Applied") { UpdateCmd.Parameters["@DateApplied"].Value = System.DateTime.Now; } else { UpdateCmd.Parameters["@DateApplied"].Value = DBNull.Value; } UpdateCmd.Parameters["@DateLastModified"].Value = System.DateTime.Now; UpdateCmd.ExecuteNonQuery(); this.SampleGrid.CommitEdit(); this.SampleGrid.CommitEdit(); var query = DataGridExtensions.GetDataGridFilterQueryController(SampleGrid); query.DoQuery(true); } catch (SqlException ex) { // Display error Console.WriteLine("Error: " + ex.ToString()); } // Close Connection thisConnection.Close(); // SetUpPlanets(); }
public void SetDefaultFilter(string column, string value) { var vw = this.GetView() as Views.AllServerQueriesView; var controller = DataGridExtensions.GetDataGridFilterQueryController(vw.QueryEvents); var filters = controller.GetFiltersForColumns(); var columnFilter = filters.FirstOrDefault(w => w.Key == column); if (columnFilter.Key != null) { columnFilter.Value.QueryString = value; controller.SetFiltersForColumns(filters); } }
public BrowserGrid() { InitializeComponent(); this.BrowserGridContextMenu = new BrowserGridContextMenu(); this.ContextMenu = this.BrowserGridContextMenu; FilterHandler = new FilterHandler(); FilterHandler.Handler += OnFilter; DataGridExtensions.SetFilterHandler(this, FilterHandler); FilterData = new FilterDatas(); DataGridExtensions.SetFilterDatas(this, FilterData); this.CommandBindings.Add(new CommandBinding(ApplicationCommands.SelectAll, SelectAll_Executed)); }
/// <summary> /// Gets the query controller. /// </summary> /// <param name="dataGrid">The data grid.</param> /// <param name="filterData">The filter data.</param> /// <param name="itemsSource">The items source.</param> /// <returns></returns> public static QueryController GetQueryController(System.Windows.Controls.DataGrid dataGrid, FilterData filterData, IEnumerable itemsSource) { var controller = DataGridExtensions.GetDataGridFilterQueryController(dataGrid); if (controller == null) { controller = new QueryController(); DataGridExtensions.SetDataGridFilterQueryController(dataGrid, controller); } controller.ColumnFilterData = filterData; controller.ItemsSource = itemsSource; controller.CallingThreadDispatcher = dataGrid.Dispatcher; controller.UseBackgroundWorker = DataGridExtensions.GetUseBackgroundWorkerForFiltering(dataGrid); return(controller); }
private void SetDefaultValues() { QueryController queryController = DataGridExtensions.GetDataGridFilterQueryController(this.SampleGrid); var filters = queryController.GetFiltersForColumns(); //var keywordFilter = filters.FirstOrDefault(w => w.Key == "str_jobapplications_Keyword"); //keywordFilter.Value.QueryString = "c"; var dateAddedFilter = filters.FirstOrDefault(w => w.Key == "dt_jobapplications_DateAdded"); dateAddedFilter.Value.QueryString = System.DateTime.Today.AddDays(-7).ToShortDateString(); dateAddedFilter.Value.Operator = DataGridFilterLibrary.Support.FilterOperator.GreaterThanOrEqual; //var positionAge = filters.FirstOrDefault(w => w.Key == "Position.Age"); //positionAge.Value.QueryString = "10"; //positionAge.Value.QueryStringTo = "20"; queryController.SetFiltersForColumns(filters); }
GetQueryController( System.Windows.Controls.DataGrid dataGrid, FilterData filterData, IEnumerable itemsSource) { QueryController query; query = DataGridExtensions.GetDataGridFilterQueryController(dataGrid); if (query == null) { query = new QueryController(); DataGridExtensions.SetDataGridFilterQueryController(dataGrid, query); } query.ColumnFilterData = filterData; query.ItemsSource = itemsSource; query.CallingThreadDispatcher = dataGrid.Dispatcher; query.UseBackgroundWorker = DataGridExtensions.GetUseBackgroundWorkerForFiltering(dataGrid); return(query); }