public void UpdateCal(){
			if (!SyncCalendar) {
				SyncCalendar = true;

				Note n;
				foreach (String[] e in getEvents()) {
					//Debug.WriteLine (e);
					/*
					 * 0=id
					 * 1=title
					 * 2=dstart
					 * 3=dend
					 * 4=desc
					 * 5=loc
					 */
					n = new Note (e [1], mstoDateTime (e [2]), e [5], e [4], "");
					n.CalId = int.Parse (e [0]);
					Debug.WriteLine (n.titleText);
					Debug.WriteLine (n.TimeStamp);
					database.CalendarInsertOrUpdateNote (n);
				}

				SyncCalendar = false;
			}
		}
 public int CalendarInsertOrUpdateNote(Note note)
 {
     if (database.Table<Note> ().Where (x => x.CalId == note.CalId).Count () > 0) {
         var n = database.Table<Note> ().First (t => t.CalId == note.CalId);
         note.NoteId = n.NoteId;
         note.Attendees = n.Attendees;
     }
     return InsertOrUpdateNote (note);
 }
 public int InsertOrUpdateNote(Note note)
 {
     return database.Table<Note> ().Where (x => x.NoteId == note.NoteId).Count () > 0
         ? database.Update (note) : database.Insert (note);
 }