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 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 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 void SPTestFound()
{
var expected = 1;
IDBParameter userId = _dal.CreateParameter("UserID", "*****@*****.**");
IDBParameter userName = _dal.CreateParameter("UserName", "zivZaarur");
DataSet ds = _dal.ExecuteSPQuery(_conn, "Login", userId, userName);
var actual = ds.Tables[0].Rows.Count;
Assert.AreEqual(expected, actual);
}
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 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 void CreateUserTest()
{
var expected = 1;
IDBParameter userId = _dal.InParameter("USER_ID", "*****@*****.**");
IDBParameter userName = _dal.InParameter("USER_NAME", "gil");
IDBParameter outParam = _dal.OutParameter();
DataSet ds = _dal.ExecuteSPQuery(_connection, "SP_CREATE_USER", userId, userName, outParam);
var actual = ds.Tables[0].Rows.Count;
Assert.AreEqual(expected, actual);
}
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 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 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)));
}
// 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 CreateDocument(string UserID, string DocumentID, string DocumentName, string ImageURL)
{
IDBParameter docId = _dal.InParameter("DOC_ID", DocumentID);
IDBParameter userId = _dal.InParameter("USER_ID", UserID);
IDBParameter docName = _dal.InParameter("DOCUMENT_NAME", DocumentName);
IDBParameter imgUrl = _dal.InParameter("IMAGE_URL", ImageURL);
IDBParameter outParam = _dal.OutParameter();
return(_dal.ExecuteSPQuery(_connection, "SP_CREATE_DOCUMNET", docId, userId, docName, imgUrl, outParam));
}
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)));
}
