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