private void saveAsClick(object sender, RoutedEventArgs e) { title = clickTitle.Text; note = clickNote.Text; Microsoft.Win32.SaveFileDialog save = new Microsoft.Win32.SaveFileDialog(); save.FileName = title; save.DefaultExt = ".txt"; save.Filter = "Text documents (.txt)|*.txt"; Nullable <bool> result = save.ShowDialog(); if (result == true) { path = save.FileName; System.IO.File.WriteAllText(path, note); } con.Open(); noteworthyDataSet = new NoteworthyDataSet(); NoteworthyDataSetTableAdapters.MyNotesTableAdapter myNotesTldAdp = new NoteworthyDataSetTableAdapters.MyNotesTableAdapter(); myNotesTldAdp.Connection.ConnectionString = con.ConnectionString; myNotesTldAdp.InsertQuery(title, path, "#FFFFFFFF"); noteworthyDataSet.AcceptChanges(); myNotesTldAdp.Update(noteworthyDataSet.MyNotes); con.Close(); }
private void DeleteNote(object sender, RoutedEventArgs e) { Button bt = sender as Button; con.Open(); NoteworthyDataSet noteworthyDataSet = new NoteworthyDataSet(); NoteworthyDataSetTableAdapters.MyNotesTableAdapter myNotesTldAdp = new NoteworthyDataSetTableAdapters.MyNotesTableAdapter(); myNotesTldAdp.Connection.ConnectionString = con.ConnectionString; string path; var res = MessageBox.Show("Are you sure you want to delete this note?", "Delete", MessageBoxButton.YesNo, MessageBoxImage.Question); if (res == MessageBoxResult.Yes) { path = myNotesTldAdp.GetPath((noteToChange.Content as TextBlock).Text); File.Delete(path); myNotesTldAdp.DeleteQuery((noteToChange.Content as TextBlock).Text); } noteworthyDataSet.AcceptChanges(); myNotesTldAdp.Update(noteworthyDataSet.MyNotes); con.Close(); Bind(); }
private void NoteColorPurple(object sender, RoutedEventArgs e) { noteToChange.Background = PurpleColor.Background; con.Open(); NoteworthyDataSet noteworthyDataSet = new NoteworthyDataSet(); NoteworthyDataSetTableAdapters.MyNotesTableAdapter myNotesTldAdp = new NoteworthyDataSetTableAdapters.MyNotesTableAdapter(); myNotesTldAdp.Connection.ConnectionString = con.ConnectionString; myNotesTldAdp.UpdateColor("#FFCF89EA", (noteToChange.Content as TextBlock).Text); noteworthyDataSet.AcceptChanges(); myNotesTldAdp.Update(noteworthyDataSet.MyNotes); con.Close(); }
private void OnNoteClick(object sender, RoutedEventArgs e) { Button bt = sender as Button; con.Open(); NoteworthyDataSet noteworthyDataSet = new NoteworthyDataSet(); NoteworthyDataSetTableAdapters.MyNotesTableAdapter myNotesTldAdp = new NoteworthyDataSetTableAdapters.MyNotesTableAdapter(); myNotesTldAdp.Connection.ConnectionString = con.ConnectionString; string path = myNotesTldAdp.GetPath((bt.Content as TextBlock).Text); con.Close(); TakeANote tNoteDlg = new TakeANote((bt.Content as TextBlock).Text, path); this.Visibility = Visibility.Collapsed; tNoteDlg.ShowDialog(); this.Visibility = Visibility.Visible; Bind(); }