void FillList() { try { string vJahr = String.Format("'{0}-01-01 00:00:00'", cboJahrVon.SelectedValue); string bJahr = String.Format("'{0}-12-31 23:59:59'", cboJahrBis.SelectedValue); string filterJahr = String.Format("it.Datum >= DATETIME{0} and it.Datum <= DATETIME{1}", vJahr, bJahr); string filter = filterJahr; if (this.preFilter != string.Empty) { filter += " and " + preFilter; } int rpp = int.Parse(cboRecordsPerPage.Text); c1Filter.ResetFilter(filter, this.testListView, (bool)this.chkIncludePlatzhalter.IsChecked); //var temp = new NavigationRepository(db); //var ab = temp.GetBrunvollViewData(c1Filter.filterString, 0, rpp); // var query = from p in db.projekte where (p.datum >= new DateTime(2011,01,01)) && (p.firmenname == "Meier") select p; ProjekteViewSource.Source = GetData(0, rpp); ProjekteView = (ListCollectionView)ProjekteViewSource.View; this.MyPager.Reset(1, rpp, _recordCount); } catch (Exception ex) { Console.WriteLine(ex.Message); MessageBox.Show(ex.Message); } }
private void btnFilter_Click(object sender, RoutedEventArgs e) { int rpp; c1Filter.ResetFilter(this.testListView, (bool)this.chkIncludePlatzhalter.IsChecked); var temp = new NavigationRepository(db); if (cboRecordsPerPage.Text == "alle") { rpp = temp.RecordCount; } else { rpp = int.Parse(cboRecordsPerPage.Text); } var ab = temp.GetBrunvollViewData(c1Filter.filterString, 0, rpp); ProjekteViewSource.Source = ab; ProjekteView = (ListCollectionView)ProjekteViewSource.View; this.MyPager.Reset(1, rpp, temp.RecordCount); }