private void SzukajButton_Click(object sender, RoutedEventArgs e) { using (ImieninyContext ctx = new ImieninyContext(ImieninyContext.ConnectionString)) { ctx.CreateIfNotExists(); DodajList.ItemsSource = ctx.Tabela.Where(d => d.Znajomy == "Collapsed").Where(d => d.Imieniny == Szukane.Text).OrderBy(d => d.Imieniny).ToList(); } }
protected override void OnNavigatedTo(NavigationEventArgs e) { using (ImieninyContext ctx = new ImieninyContext(ImieninyContext.ConnectionString)) { ctx.CreateIfNotExists(); DodajList.ItemsSource = ctx.Tabela.Where(d => d.Znajomy == "Visible").ToList(); } }
protected override void OnNavigatedTo(NavigationEventArgs e) { using (ImieninyContext ctx = new ImieninyContext(ImieninyContext.ConnectionString)) { ctx.CreateIfNotExists(); MainLongListSelector.ItemsSource = ctx.Tabela.Where(d => d.Dzien == DateTime.Today.Day).Where(d => d.Miesiac == DateTime.Today.Month).ToList(); JutroList.ItemsSource = ctx.Tabela.Where(d => d.Dzien == DateTime.Today.AddDays(1).Day).Where(d => d.Miesiac == DateTime.Today.AddDays(1).Month).ToList(); ZnajomiList.ItemsSource = ctx.Tabela.Where(d => d.Znajomy == "Visible").ToList(); } }