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