public override void DeleteNote(INote note) { SqliteNote sqNote = (note as SqliteNote); string command = String.Format("DELETE FROM Notes WHERE ID='{0}'", sqNote.ID); backend.Database.ExecuteScalar(command); }
public override void SaveNote(INote note) { SqliteNote sqNote = (note as SqliteNote); string text = backend.SanitizeText(sqNote.Text); string command = String.Format("UPDATE Notes SET Text='{0}' WHERE ID='{1}'", text, sqNote.ID); backend.Database.ExecuteScalar(command); }
public override TaskNote CreateNote(string text) { Debug.WriteLine ("Creating New Note Object : {0} (id={1})", text, id); text = backend.SanitizeText (text); var command = String.Format ( "INSERT INTO Notes (Task, Text) VALUES ('{0}','{1}'); SELECT last_insert_rowid();", id, text); var taskId = Convert.ToInt32 (backend.Database.ExecuteScalar (command)); var note = new SqliteNote (taskId, text); note.OnTextChangedAction = delegate { SaveNote (note); }; return note; }