Exemple #1
0
        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));
        }
Exemple #2
0
        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()));
        }