public DataSet GetSharedUsers(string docID) { IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output); IDBParameter param = _infraDAL.getParameter("P_DOCID", "Varchar2", docID); return(_infraDAL.ExecuteSPQuery(_conn, "GETSHAREDUSERES", param, output)); }
public DataSet UnSubscribeUser(string email) { IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output); IDBParameter param = _infraDAL.getParameter("P_USERID", "Varchar2", email); return(_infraDAL.ExecuteSPQuery(_conn, "REMOVEUSER", param, output)); }
public DataSet GetSharedUsers(DocumentRequest documentRequest) { p = _paramConverter.ConvertToParameter(documentRequest, "docID"); var data = dal.ExecSPQuery("getShare", con, p); return(data); }
public DataSet GetDocuments(string docID) { IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output); IDBParameter param = _infraDAL.getParameter("P_OWNER", "Varchar2", docID); return(_infraDAL.ExecuteSPQuery(_conn, "GETDOCUMENTS", param, output)); }
public DataSet RemoveDocument(string docID) { IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output); IDBParameter param = _infraDAL.getParameter("P_DOCID", "Varchar2", docID); return(_infraDAL.ExecuteSPQuery(_conn, "REMOVEDOCUMENT", param, output)); }
public DataSet GetMarkers(IDBConnection conn, string docID) { IDBParameter docIDParam = _dal.CreateParameter("P_DOC_ID", docID); IDBParameter outParam = _dal.GetOutParameter(); return(_dal.ExecuteSPQuery(conn, "GETMARKERS", docIDParam, outParam)); }
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 GetSharedDocuments(string userID) { IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output); IDBParameter param = _infraDAL.getParameter("P_USERID", "Varchar2", userID); return(_infraDAL.ExecuteSPQuery(_conn, "GETSHAREDDOCUMENTS", param, output)); }
public DataSet GetDocument(IDBConnection conn, string docID) { IDBParameter docIDParam = _dal.CreateParameter("P_DOC_ID", docID); IDBParameter outParam = _dal.GetOutParameter(); return(_dal.ExecuteSPQuery(conn, "GETDOCUMENT", docIDParam, outParam)); }
public DataSet GetSharedDocumentsForUser(UserRequest userRequest) { p = _paramConverter.ConvertToParameter(userRequest, "UserID"); var data = dal.ExecSPQuery("DocsIParticipateIn", con, p); return(data); }
// remove sharing with specific users public DataSet RemoveShare(ShareRequest request) { IDBParameter p_docId = _dalInfra.getParameter("DocId", OracleDbType.Varchar2, request.DocId); IDBParameter p_userId = _dalInfra.getParameter("UserId", OracleDbType.Varchar2, request.UserId); return(_dalInfra.ExecuteSPQuery(_conn, "REMOVE_SHARE", p_docId, p_userId)); }
//users public void CreateUser(IDBConnection conn, User user) { IDBParameter userName = _dal.CreateParameter("P_USERNAME", user.UserName); IDBParameter userID = _dal.CreateParameter("P_USERID", user.UserID); _dal.ExecuteSPQuery(conn, "CreateUser", userID, userName); }
public DataSet Login(IDBConnection conn, string userID) { IDBParameter userIDParam = _dal.CreateParameter("UserID", userID); IDBParameter outParam = _dal.GetOutParameter(); return(_dal.ExecuteSPQuery(conn, "Login", userIDParam, outParam)); }
//share public void CreateShare(IDBConnection conn, Share share) { IDBParameter docID = _dal.CreateParameter("P_DOC_ID", share.DocID); IDBParameter userID = _dal.CreateParameter("P_USER_ID", share.UserID); _dal.ExecuteSPQuery(conn, "CREATESHARE", docID, userID); }
public DataSet RemoveMarker(MarkerKeysRequest request) { IDBParameter P_DOCID = _dalInfra.getParameter("P_DOCID", OracleDbType.Varchar2, request.DocId); IDBParameter P_MARKERID = _dalInfra.getParameter("P_MARKERID", OracleDbType.Varchar2, request.MarkerId); return(_dalInfra.ExecuteSPQuery(_conn, "REMOVE_MARKER", P_DOCID, P_MARKERID)); }
public DataSet GetMarker(string docID) { IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output); IDBParameter param = _infraDAL.getParameter("P_DocID", "Varchar2", docID); return(_infraDAL.ExecuteSPQuery(_conn, "GETMARKERS", param, output)); }
public DataSet GetDocuments(IDBConnection conn, string userID) { IDBParameter userIDParam = _dal.CreateParameter("P_USER_ID", userID); IDBParameter outParam = _dal.GetOutParameter(); return(_dal.ExecuteSPQuery(conn, "GETDOCUMENTS", userIDParam, outParam)); }
public DataSet GetMarkers(string DocID) { IDBParameter docId = _dal.InParameter("DOC_ID", DocID); IDBParameter outParam = _dal.OutParameter(); return(_dal.ExecuteSPQuery(_connection, "SP_GET_MARKERS", docId, outParam)); }
public DataSet GetMarker(string markerID) { IDBParameter markerId = _dal.InParameter("MARKER_ID", markerID); IDBParameter outParam = _dal.OutParameter(); return(_dal.ExecuteSPQuery(_connection, "SP_GET_MARKER", markerId, outParam)); }
public DataSet GetDocuments(string UserID) { IDBParameter userId = _dal.InParameter("USER_ID", UserID); IDBParameter outParam = _dal.OutParameter(); return(_dal.ExecuteSPQuery(_connection, "SP_GET_DOCUMENTS", userId, outParam)); }
public DataSet GetDocument(string DocID) { IDBParameter docId = _dal.InParameter("DOC_ID", DocID); IDBParameter outParam = _dal.OutParameter(); return(_dal.ExecuteSPQuery(_connection, "SP_GET_DOCUMENT", docId, outParam)); }
public DataSet GetLog(string logName) { IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output); IDBParameter param1 = _infraDAL.getParameter("P_LOGNAME", "Varchar2", logName); var retval = _infraDAL.ExecuteSPQuery(_conn, "GETLOG", param1, output); return(retval); }
public DataSet CreateShare(string DocID, string UserID) { IDBParameter docId = _dal.InParameter("DOC_ID", DocID); IDBParameter userId = _dal.InParameter("USER_ID", UserID); IDBParameter outParam = _dal.OutParameter(); return(_dal.ExecuteSPQuery(_connection, "SP_CREATE_SHARE", docId, userId, outParam)); }
public DataSet CreateUser(string UserID, string UserName) { IDBParameter userId = _dal.InParameter("USER_ID", UserID); IDBParameter userName = _dal.InParameter("USER_NAME", UserName); IDBParameter outParam = _dal.OutParameter(); return(_dal.ExecuteSPQuery(_connection, "SP_CREATE_USER", userId, userName, outParam)); }
public DataSet CreateUser(string email, string userName) { IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output); IDBParameter param = _infraDAL.getParameter("P_USERID", "Varchar2", email); IDBParameter param1 = _infraDAL.getParameter("P_USERNAME", "Varchar2", userName); return(_infraDAL.ExecuteSPQuery(_conn, "CREATEUSER", param, param1, output)); }
public DataSet UnSubscribe(string UserID, string UserName) { IDBParameter userId = _dal.InParameter("USER_ID", UserID); IDBParameter userName = _dal.InParameter("USER_NAME", UserName); IDBParameter outParam = _dal.OutParameter(); return(_dal.ExecuteSPQuery(_connection, "SP_UNSUBSCRIBE", userId, userName, outParam)); }
public DataSet RemoveMarker(string docID, string markerID) { IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output); IDBParameter param = _infraDAL.getParameter("P_DocID", "Varchar2", docID); IDBParameter param1 = _infraDAL.getParameter("P_MarkerID", "Varchar2", markerID); return(_infraDAL.ExecuteSPQuery(_conn, "REMOVEMARKER", param, param1, output)); }
public DataSet RemoveSharedDocument(string docID, string userID) { IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output); IDBParameter param = _infraDAL.getParameter("P_DOCID", "Varchar2", docID); IDBParameter param1 = _infraDAL.getParameter("P_USERID", "Varchar2", userID); return(_infraDAL.ExecuteSPQuery(_conn, "REMOVESHARE", param, param1, output)); }
// documents public void CreateDocument(IDBConnection conn, Document document) { IDBParameter docID = _dal.CreateParameter("P_DOCUMENT_ID", document.DocID); IDBParameter userID = _dal.CreateParameter("P_USER_ID", document.UserID); IDBParameter imageURL = _dal.CreateParameter("P_IMAGE_URL", document.ImageURL); IDBParameter documentName = _dal.CreateParameter("P_DOCUMENT_NAME", document.DocumentName); _dal.ExecuteSPQuery(conn, "CreateDocument", docID, userID, imageURL, documentName); }
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)); }