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