public List <Core.Entities.NoteData> GetAllNotes() { var sql = new Server.SQLBuilder(); var tuple = sql.SelectAll(); return(DoGetNotes(tuple.Item1, tuple.Item2)); }
public int CreateNote(string ID, string title, string body) { var sql = new Server.SQLBuilder(); var tuple = sql.Insert(ID, title, body); var db = new Server.DB(); return(db.Insert(tuple.Item1, tuple.Item2.ToArray())); }
public Core.Entities.NoteData GetNoteById(string ID) { var sql = new Server.SQLBuilder(); var tuple = sql.SelectByID(ID); var list = DoGetNotes(tuple.Item1, tuple.Item2); return(list.Count > 0 ? list[0] : new Core.Entities.NoteData() { ID = "-1" }); }