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(); } }
private void UsunButton_Click(object sender, RoutedEventArgs e) { using (ImieninyContext ctx = new ImieninyContext(ImieninyContext.ConnectionString)) { Button _button = (Button)sender; var bla = (from p in ctx.Tabela where p.Id == (int)_button.Tag select p).Single(); bla.Znajomy = "Collapsed"; ctx.SubmitChanges(); 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(); } }