private void LoadlistViewNobMudYrd() { // SentinelDirectorAssistantManager.SentinelDirectorAssistantList //var conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), FileUtils.FullDataPath); //listViewNobMudYrd.Items.Clear(); //var SentinelDirectorAssistantDataset_ = conn.Table<SentinelDirectorAssistantDataset>().ToList(); SentinelDirectorAssistantManager.Clear(); //foreach (var x in SentinelDirectorAssistantDataset_) //{ // SentinelDirectorAssistant mdyrd = new SentinelDirectorAssistant { FullName = x.FullName }; // mdyrd.UnwantedDays[0] = x.NotMonday; // mdyrd.UnwantedDays[1] = x.NotTuesday; // mdyrd.UnwantedDays[2] = x.NotWednesday; // mdyrd.UnwantedDays[3] = x.NotThursday; // mdyrd.UnwantedDays[4] = x.NotFriday; // SentinelDirectorAssistantManager.SentinelDirectorAssistantList.Add(mdyrd); //} Listele(); }
private void checkBoxIstenmeyenGunler_Checkeds(object sender, RoutedEventArgs e) { string a = (listViewNobMudYrd.SelectedItem as SentinelDirectorAssistant).FullName;//(((sender as CheckBox).Content) as TextBlock).Text; SentinelDirectorAssistant seçilinöb = SentinelDirectorAssistantManager.AdaGöreBul(a); int x = Convert.ToInt32((sender as CheckBox).Tag); bool ischecked = (sender as CheckBox).IsChecked ?? false; seçilinöb.UnwantedDays[x] = ischecked; var conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), FileUtils.FullDataPath); string FullName = (listViewNobMudYrd.SelectedItem as SentinelDirectorAssistant).FullName; var row = conn.Query <SentinelDirectorAssistantDataset>("select * from SentinelDirectorAssistantDataset where FullName=?", FullName).FirstOrDefault(); if (row != null) { if (x == 0) { row.NotMonday = ischecked; } if (x == 1) { row.NotTuesday = ischecked; } if (x == 2) { row.NotWednesday = ischecked; } if (x == 3) { row.NotThursday = ischecked; } if (x == 4) { row.NotFriday = ischecked; } } conn.Update(row); }