private List <Core.Entities.NoteData> DoGetNotes(string sql, List <SqlParameter> dbParams) { var db = new Server.DB(); var dt = db.Select(sql, dbParams.ToArray()); return(new DataAdapter().TransformDataTable(dt)); }
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())); }