Example #1
0
 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();
     }
 }
Example #2
0
        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 + "')";
                }
            }
        }