private static List <Note> ReadDescribedNotes(SQLiteDataReader reader) { try { List <Note> notes = new List <Note>(); while (reader.Read()) { DescribedNote describedNote = new DescribedNote(); describedNote.Id = reader.GetInt32(0); describedNote.Name = reader.GetString(1); describedNote.CurrentState = (Note.State)reader.GetInt32(2); describedNote.Comment = reader.GetString(3); describedNote.Description = reader.GetString(4); notes.Add(describedNote); } return(notes); } catch (Exception ex) { Log.Error(string.Format("Can not read described notes:{0}{1}", Environment.NewLine, ex.ToString())); return(new List <Note>()); } }
public DescribedNoteForm(MainForm mainForm, NoteTable editedTable, Mode mode) : base(mainForm, editedTable, mode) { InitializeComponent(); Text = GetFormText(); submitButton.Text = GetSubmitButtonText(); DescribedNote describedNote = _editedNote as DescribedNote; if (describedNote != null) { nameTextBox.Text = describedNote.Name; descriptionRichTextBox.Text = describedNote.Description; stateComboBox.SelectedIndex = (int)describedNote.CurrentState; commentRichTextBox.Text = describedNote.Comment; } KeyDown += delegate(object o, KeyEventArgs e) { if (e.KeyCode == Keys.Enter && e.Modifiers == Keys.Control) { submitButton.PerformClick(); } }; }
private static bool InsertDescribedNote(List <Note> notes, SQLiteCommand describedNoteInsertCommand) { bool inserted = false; try { using (SQLiteConnection connection = Database.CreateConnection()) { connection.Open(); describedNoteInsertCommand.Connection = connection; if (connection.State == System.Data.ConnectionState.Open) { using (SQLiteTransaction transaction = connection.BeginTransaction()) { foreach (Note note in notes) { DescribedNote describedNote = note as DescribedNote; if (describedNote == null) { Log.Error("Try to insert incorrect note"); continue; } describedNoteInsertCommand.Parameters[0].Value = describedNote.Name; describedNoteInsertCommand.Parameters[1].Value = (int)describedNote.CurrentState; describedNoteInsertCommand.Parameters[2].Value = describedNote.Comment; describedNoteInsertCommand.Parameters[3].Value = describedNote.Description; describedNoteInsertCommand.Prepare(); describedNoteInsertCommand.ExecuteNonQuery(); describedNote.Id = (int)connection.LastInsertRowId; inserted = true; } transaction.Commit(); } } connection.Close(); describedNoteInsertCommand.Connection = null; } } catch (Exception ex) { Log.Error(string.Format("Can not execute command: {0}{1}{2}{3}", Environment.NewLine, (describedNoteInsertCommand != null) ? describedNoteInsertCommand.CommandText : "", Environment.NewLine, ex.ToString())); return(false); } return(inserted); }
private void submitButton_Click(object sender, EventArgs e) { DescribedNote describedNote = (_editedNote != null && _editedNote is DescribedNote) ? _editedNote as DescribedNote : new DescribedNote(); describedNote.Name = nameTextBox.Text; describedNote.Description = descriptionRichTextBox.Text; describedNote.CurrentState = (Note.State)stateComboBox.SelectedIndex; describedNote.Comment = commentRichTextBox.Text; SubmitNote(describedNote); Close(); }
public override void UpdateNote(Note note) { DescribedNote describedNote = note as DescribedNote; if (describedNote == null) { return; } CurrentRow.Cells[(int)Index.Name].Value = describedNote.Name; CurrentRow.Cells[(int)Index.Description].Value = describedNote.Description; CurrentRow.Cells[(int)Index.State].Value = States[(int)describedNote.CurrentState]; CurrentRow.Cells[(int)Index.Comment].Value = describedNote.Comment; }
public override Note GetNoteFromSelectedRow() { if (CurrentRow == null) { return(null); } DescribedNote describedNote = new DescribedNote(); describedNote.Id = CurrentRow.Cells[(int)Index.Id].Value.ToString().ToIntOrException(); describedNote.Name = CurrentRow.Cells[(int)Index.Name].Value.ToString(); describedNote.Description = CurrentRow.Cells[(int)Index.Description].Value.ToString(); describedNote.CurrentState = CurrentRow.Cells[(int)Index.State].Value.ToString().ToNoteState(); describedNote.Comment = CurrentRow.Cells[(int)Index.Comment].Value.ToString(); return(describedNote); }
private static bool UpdateDescribedNote(Note note, SQLiteCommand describedNoteUpdateCommand) { DescribedNote describedNote = note as DescribedNote; if (describedNote == null || describedNote.Id < 0) { Log.Error("Try to save incorrect described note note"); return(false); } describedNoteUpdateCommand.Parameters[0].Value = describedNote.Id; describedNoteUpdateCommand.Parameters[1].Value = describedNote.Name; describedNoteUpdateCommand.Parameters[2].Value = (int)describedNote.CurrentState; describedNoteUpdateCommand.Parameters[3].Value = describedNote.Comment; describedNoteUpdateCommand.Parameters[4].Value = describedNote.Description; describedNoteUpdateCommand.Prepare(); return(ExecuteNonQuery(describedNoteUpdateCommand) == 1); }
public override bool AddNote(Note note) { if (note is DescribedNote) { DescribedNote describedNote = note as DescribedNote; Rows.Add(new string[] { describedNote.Id.ToString(), describedNote.Name, describedNote.Description, States[(int)describedNote.CurrentState], describedNote.Comment }); return(true); } return(false); }