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 CreateUser(RegisterRequest request)
{
IDBParameter p_userId = getIdParam(request.Login.UserIdEmail);
IDBParameter p_userName = _dalInfra.getParameter("USERNAME", OracleDbType.Varchar2, request.UserName);
return(_dalInfra.ExecuteSPQuery(_conn, "CREATE_USER", p_userId, p_userName));
}
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));
}
