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