public DataSet CreateShareDocument(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, "CREATESHARE", param, param1, output));
}
public DataSet CreateDocument(string id, string ownerId, string name)
{
return(_infraDAL.ExecuteSPQuery(_conn, "CREATE_DOCUMENT",
_infraDAL.getParameter("p_id", "Varchar2", id),
_infraDAL.getParameter("p_owner", "Varchar2", ownerId),
_infraDAL.getParameter("p_name", "Varchar2", name)));
}
public DataSet CreateDocuments(string owner, string imageUrl, string documentName, string guid)
{
IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output);
IDBParameter param = _infraDAL.getParameter("P_OWNER", "Varchar2", owner);
IDBParameter param1 = _infraDAL.getParameter("P_IMAGEURL", "Varchar2", imageUrl);
IDBParameter param2 = _infraDAL.getParameter("P_DOCUMENTNAME", "Varchar2", documentName);
IDBParameter param3 = _infraDAL.getParameter("P_DOCID", "Varchar2", guid);
var retval = _infraDAL.ExecuteSPQuery(_conn, "CREATEDOCUMENT", param, param1, param2, param3, output);
return(retval);
}
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 CreateLog(string dataLog, string date, string logName)
{
IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output);
IDBParameter param1 = _infraDAL.getParameter("P_LOGCONTENT", "Varchar2", dataLog);
IDBParameter param2 = _infraDAL.getParameter("P_CREATEDDATE", "Varchar2", date);
IDBParameter param3 = _infraDAL.getParameter("P_LOGNAME", "Varchar2", logName);
var retval = _infraDAL.ExecuteSPQuery(_conn, "CREATELOG", param1, param2, param3, output);
return(retval);
}
public DataSet CreateUser(string id, string userName)
{
return(_infraDAL.ExecuteSPQuery(_conn, "CREATE_USER", _infraDAL.getParameter("p_id", "Varchar2", id),
_infraDAL.getParameter("p_userName", "Varchar2", userName), _infraDAL.getParameter("p_user", "RefCursor", ParameterDirection.Output)));
}
public DataSet CreateMarker(string docID, string markerID, string markerType, Decimal centerX,
Decimal centerY, Decimal rediusX, Decimal rediusY, string foreColor, string backColor, string userID)
{
IDBParameter output = _infraDAL.getParameter("RETVAL", "RefCursor", ParameterDirection.Output);
IDBParameter param = _infraDAL.getParameter("P_DocID", "Varchar2", docID);
IDBParameter param1 = _infraDAL.getParameter("P_MarkerID", "Varchar2", markerID);
IDBParameter param2 = _infraDAL.getParameter("P_MarkerType", "Varchar2", markerType);
IDBParameter param3 = _infraDAL.getParameter("P_CenterX", "Number", centerX);
IDBParameter param4 = _infraDAL.getParameter("P_CenterY", "Number", centerY);
IDBParameter param5 = _infraDAL.getParameter("P_RadiusX", "Number", rediusX);
IDBParameter param6 = _infraDAL.getParameter("P_RadiusY", "Number", rediusY);
IDBParameter param7 = _infraDAL.getParameter("P_ForeColor", "Varchar2", foreColor);
IDBParameter param8 = _infraDAL.getParameter("P_BackColor", "Varchar2", backColor);
IDBParameter param9 = _infraDAL.getParameter("P_UserID", "Varchar2", userID);
var retval = _infraDAL.ExecuteSPQuery(_conn, "CREATEMARKER", param, param1, param2, param3, param4, param5, param6, param7, param8, param9, output);
return(retval);
}
public DataSet CreateMarker(string id, string docId, string userID, string markerType, decimal centerX,
decimal centerY, decimal radiusX, decimal radiusY, string foreColor, string backColor)
{
return(_infraDAL.ExecuteSPQuery(_conn, "CREATE_MARKER",
_infraDAL.getParameter("p_id", "Varchar2", id),
_infraDAL.getParameter("p_doc_id", "Varchar2", docId),
_infraDAL.getParameter("p_user_id", "Varchar2", userID),
_infraDAL.getParameter("p_marker_type", "Varchar2", markerType),
_infraDAL.getParameter("p_center_x", "Varchar2", centerX),
_infraDAL.getParameter("p_center_y", "Varchar2", centerY),
_infraDAL.getParameter("p_radius_x", "Varchar2", radiusX),
_infraDAL.getParameter("p_radius_y", "Varchar2", radiusY),
_infraDAL.getParameter("p_fore_color", "Varchar2", foreColor),
_infraDAL.getParameter("p_back_color", "Varchar2", backColor)
));
}
public DataSet CreateShare(string userId, string docId)
{
return(_infraDAL.ExecuteSPQuery(_conn, "CREATE_SHARE", _infraDAL.getParameter("p_user_id", "Varchar2", userId),
_infraDAL.getParameter("p_doc_id", "Varchar2", docId)));
}