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