private void DeleteButton_Click(object sender, RoutedEventArgs e) { using SQLiteCommand cmd = GlobalFunction.OpenDbConnection(); NoteDetails rowDetails = (NoteDetails)((FrameworkElement)sender).DataContext; cmd.CommandText = $"DELETE FROM notes WHERE noteId = {rowDetails.ID}"; cmd.ExecuteNonQuery(); noteCollection.Remove(noteCollection.Where(i => i.ID == rowDetails.ID).Single()); }
private void NotesDetails_Load(object sender, RoutedEventArgs e) { noteDataGrid.ItemsSource = noteCollection; List <NoteInfo> notes = Database.Get.Note.AllFromStudentId(studentId); foreach (NoteInfo note in notes) { int creationTimestamp = note.creationDate; DateTime creationDate = DateTimeOffset.FromUnixTimeSeconds(creationTimestamp).LocalDateTime; string creationDateString = creationDate.ToString("g", GlobalVariable.culture); NoteDetails noteDetail = new NoteDetails() { ID = note.noteId, CreationDate = creationDateString, Content = note.content }; noteCollection.Add(noteDetail); } }