public SamplesViewDlg() { SamplesCollection = new ObservableCollection <Sample>(); InitializeComponent(); lbSamples.ItemsSource = SamplesCollection; grdMain.DataContext = this; try { fFields = Properties.Settings.Default.PreviousFilter; } catch { } if (fFields == null) { fFields = new SampleFilterFields(); } }
private void FilterCommand_Executed(object sender, ExecutedRoutedEventArgs e) { SamplesFilterDlg dlg = new SamplesFilterDlg(); if (fFields != null) { dlg.Filter = fFields; } if (dlg.ShowDialog() == true) { fFields = dlg.Filter; FilterText = "(([SamplingDate] >= '" + fFields.StartDate.Month.ToString() + '/' + fFields.StartDate.Day.ToString() + '/' + fFields.StartDate.Year.ToString() + "') AND ([SamplingDate] <= '" + fFields.EndDate.Month.ToString() + '/' + fFields.EndDate.Day.ToString() + '/' + fFields.EndDate.Year.ToString() + "'))"; if (fFields.LabNumber != null && fFields.LabNumber != string.Empty) { FilterText += "AND ([LabNumber] = N'" + fFields.LabNumber + "')"; } } }