public DataSet CreateShare(ShareRequest request)
        {
            IDBParameter p_user  = _dalInfra.getParameter("UserId", OracleDbType.Varchar2, request.UserId);
            IDBParameter p_docId = _dalInfra.getParameter("DocId", OracleDbType.Varchar2, request.DocId);

            return(_dalInfra.ExecuteSPQuery(_conn, "CREATE_SHARE", p_docId, p_user));
        }
Пример #2
0
        public DataSet CreateDoc(CreateDocsRequest request)
        {
            IDBParameter p_owner   = _dalInfra.getParameter("Owner", OracleDbType.Varchar2, request.DocData.Owner);
            IDBParameter p_docId   = _dalInfra.getParameter("DocId", OracleDbType.Varchar2, request.DocData.DocId);
            IDBParameter p_docUrl  = _dalInfra.getParameter("DocUrl", OracleDbType.Varchar2, request.DocData.DocUrl);
            IDBParameter p_docName = _dalInfra.getParameter("DocName", OracleDbType.Varchar2, request.DocData.DocName);

            return(_dalInfra.ExecuteSPQuery(_conn, "CREATE_DOC", p_owner, p_docId, p_docName, p_docUrl));
        }
        public DataSet CreateMarker(CreateMarkerRequest request)
        {
            IDBParameter P_OWNER      = _dalInfra.getParameter("P_OWNER", OracleDbType.Varchar2, request.MarkerData.Owner);
            IDBParameter P_DOCID      = _dalInfra.getParameter("P_DOCID", OracleDbType.Varchar2, request.MarkerData.DocId);
            IDBParameter P_MARKERID   = _dalInfra.getParameter("P_MARKERID", OracleDbType.Varchar2, request.MarkerData.MarkerId);
            IDBParameter P_MARKERTYPE = _dalInfra.getParameter("P_MARKERTYPE", OracleDbType.Varchar2, request.MarkerData.MarkerType);
            IDBParameter P_MARKERLOC  = _dalInfra.getParameter("P_MARKERLOC", OracleDbType.Varchar2, JsonConvert.SerializeObject(request.MarkerData.MarkerLoc));
            IDBParameter P_FORECOL    = _dalInfra.getParameter("P_FORECOL", OracleDbType.Varchar2, request.MarkerData.ForeColor);
            IDBParameter P_BACKCOL    = _dalInfra.getParameter("P_BACKCOL", OracleDbType.Varchar2, request.MarkerData.BackColor);

            return(_dalInfra.ExecuteSPQuery(_conn, "CREATE_MARKER", P_OWNER, P_DOCID, P_MARKERID, P_MARKERTYPE,
                                            P_MARKERLOC, P_FORECOL, P_BACKCOL));
        }
 public DataSet GetUser(string userId)
 {
     return(_dalInfra.ExecuteSPQuery(_conn, "GET_USER", getIdParam(userId)));
 }