Example #1
0
        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);
        }
Example #2
0
        // 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);
        }