Beispiel #1
0
        public void Test_DeleteReview()
        {
            LandmarkReviewSqlDAO testDAO = new LandmarkReviewSqlDAO(connectionString);
            int testReviewId             = AddTestLandmarkReview();

            Assert.AreEqual(true, testDAO.DeleteReview(testReviewId));
        }
Beispiel #2
0
        public void Test_GetAllReviews()
        {
            LandmarkReviewSqlDAO testDAO = new LandmarkReviewSqlDAO(connectionString);
            int testLandmarkId           = AddTestLandmark();
            int startingReviewCount      = testDAO.GetAllReviews(testLandmarkId).Count;

            AddTestLandmarkReview();

            Assert.AreEqual(startingReviewCount + 1, testDAO.GetAllReviews(testLandmarkId).Count);
        }
Beispiel #3
0
        public void Test_GetReview()
        {
            LandmarkReviewSqlDAO testDAO = new LandmarkReviewSqlDAO(connectionString);
            int testLandmarkId           = AddTestLandmark();
            int testUserId   = AddTestUser();
            int testReviewId = AddTestLandmarkReview();

            Review test = testDAO.GetReview(testReviewId);

            Assert.AreEqual((decimal)(1.5), testDAO.GetReview(testReviewId).Rating);
            Assert.AreEqual("test review title", testDAO.GetReview(testReviewId).Title);
            Assert.AreEqual("test review body", testDAO.GetReview(testReviewId).Detail);
            Assert.AreEqual(testLandmarkId, testDAO.GetReview(testReviewId).TypeId);
            Assert.AreEqual(testUserId, testDAO.GetReview(testReviewId).UserId);
        }
Beispiel #4
0
        public void Test_CreateReview()
        {
            LandmarkReviewSqlDAO testDAO = new LandmarkReviewSqlDAO(connectionString);
            Review testReview            = new Review();

            int testUserId     = AddTestUser();
            int testLandmarkId = AddTestLandmark();

            testReview.Rating   = 2;
            testReview.Title    = "anything";
            testReview.Detail   = "anything";
            testReview.UserName = "******";
            testReview.UserId   = testUserId;
            testReview.TypeId   = testLandmarkId;

            Assert.AreEqual(true, testDAO.CreateReview(testReview));
        }