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