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"
});
}
