Ejemplo n.º 1
0
        // gets a note from the content provider
        public static Note getNote(Activity activity, Uri uri)
        {
            Note note = null;

            // can we find a matching note?
            ICursor cursor = activity.ManagedQuery(uri, FULL_PROJECTION, null, null, null);
            // cursor must not be null and must return more than 0 entry
            if (!(cursor == null || cursor.Count == 0)) {

                // create the note from the cursor
                cursor.MoveToFirst();
                string noteContent = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.NOTE_CONTENT));
                string noteTitle = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.TITLE));
                string noteChangeDate = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.MODIFIED_DATE));
                string noteTags = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.TAGS));
                string noteGUID = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.GUID));
                int noteDbid = cursor.GetInt(cursor.GetColumnIndexOrThrow(Note.ID));

                note = new Note();
                note.setTitle(noteTitle);
                note.setXmlContent(stripTitleFromContent(noteContent, noteTitle));
                note.setLastChangeDate(noteChangeDate);
                note.setTags(noteTags);
                note.setGuid(noteGUID);
                note.setDbId(noteDbid);
            }
            cursor.Close();
            return note;
        }
Ejemplo n.º 2
0
        // gets a note from the content provider, based on guid
        public static Note getNoteByGuid(Activity activity, string guid)
        {
            Uri notes = Tomdroid.CONTENT_URI;

            string[] whereArgs = new string[1];
            whereArgs[0] = guid;

            // The note identifier is the guid
            ContentResolver cr = activity.ContentResolver;
            ICursor cursor = cr.Query(notes,
                    FULL_PROJECTION,
                    Note.GUID + "= ?",
                    whereArgs,
                    null);
            activity.StartManagingCursor(cursor);
            if (cursor == null || cursor.Count == 0) {
                cursor.Close();
                return null;
            }
            else {
                cursor.MoveToFirst();
                string noteContent = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.NOTE_CONTENT));
                string noteTitle = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.TITLE));
                string noteChangeDate = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.MODIFIED_DATE));
                string noteTags = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.TAGS));
                string noteGUID = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.GUID));
                int noteDbid = cursor.GetInt(cursor.GetColumnIndexOrThrow(Note.ID));

                Note note = new Note();
                note.setTitle(noteTitle);
                note.setXmlContent(stripTitleFromContent(noteContent, noteTitle));
                note.setLastChangeDate(noteChangeDate);
                note.addTag(noteTags);
                note.setGuid(noteGUID);
                note.setDbId(noteDbid);
                cursor.Close();
                return note;
            }
        }
Ejemplo n.º 3
0
        // this function gets all non-deleted notes as notes in an array
        public static Note[] getAllNotesAsNotes(Activity activity, bool includeNotebookTemplates)
        {
            Uri uri = Tomdroid.CONTENT_URI;
            string where = "("+Note.TAGS + " NOT LIKE '%" + "system:deleted" + "%')";
            string orderBy;
            if (!includeNotebookTemplates) {
                where += " AND (" + Note.TAGS + " NOT LIKE '%" + "system:template" + "%')";
            }
            orderBy = Note.MODIFIED_DATE + " DESC";
            ICursor cursor = activity.ManagedQuery(uri, FULL_PROJECTION, where, null, orderBy);
            if (cursor == null || cursor.Count == 0) {
                TLog.d(TAG, "no notes in cursor");
                return null;
            }
            TLog.d(TAG, "{0} notes in cursor",cursor.Count);
            Note[] notes = new Note[cursor.Count];
            cursor.MoveToFirst();
            int key = 0;

            while(!cursor.IsAfterLast) {
                string noteContent = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.NOTE_CONTENT));
                string noteTitle = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.TITLE));
                string noteChangeDate = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.MODIFIED_DATE));
                string noteTags = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.TAGS));
                string noteGUID = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.GUID));
                int noteDbid = cursor.GetInt(cursor.GetColumnIndexOrThrow(Note.ID));

                Note note = new Note();
                note.setTitle(noteTitle);
                note.setXmlContent(stripTitleFromContent(noteContent, noteTitle));
                note.setLastChangeDate(noteChangeDate);
                note.addTag(noteTags);
                note.setGuid(noteGUID);
                note.setDbId(noteDbid);
                notes[key++] = note;
                cursor.MoveToNext();
            }
            cursor.Close();
            return notes;
        }