Example #1
0
        public void Test_GetLandmark()
        {
            LandmarkSqlDAO testDAO = new LandmarkSqlDAO(connectionString);
            int            testId  = AddTestLandmark();

            Assert.AreEqual("testLongName", testDAO.GetLandmark(testId).LongName);
            Assert.AreEqual("Main St", testDAO.GetLandmark(testId).StreetName);
            Assert.AreEqual(30, testDAO.GetLandmark(testId).Latitude);
            Assert.AreEqual(-80, testDAO.GetLandmark(testId).Longitude);
        }
Example #2
0
        public void Test_GetApprovedLandmarks()
        {
            LandmarkSqlDAO testDAO = new LandmarkSqlDAO(connectionString);

            int startingCount        = testDAO.GetApprovedLandmarks().Count;
            int unapprovedLandmarkId = AddTestLandmark();

            Landmark unapprovedLandmark = testDAO.GetLandmark(unapprovedLandmarkId);

            Assert.AreEqual(startingCount, testDAO.GetApprovedLandmarks().Count);

            unapprovedLandmark.IsApproved = true;
            testDAO.UpdateLandmark(unapprovedLandmark);
            Assert.AreEqual(startingCount + 1, testDAO.GetApprovedLandmarks().Count);
        }
Example #3
0
        public void Test_UpdateItinerary()
        {
            ItinerarySqlDAO testDAO         = new ItinerarySqlDAO(connectionString);
            LandmarkSqlDAO  testLandmarkDAO = new LandmarkSqlDAO(connectionString);
            Itinerary       itinerary       = new Itinerary();
            int             landmarkId      = AddTestLandmark();
            Landmark        landmark        = testLandmarkDAO.GetLandmark(landmarkId);

            itinerary.Name     = "anything";
            itinerary.StartLng = 98;
            itinerary.StartLat = -83;
            itinerary.OwnerID  = 1;
            itinerary.Landmarks.Add(landmark);
            itinerary.LandmarkIDs = new int[] { landmarkId };


            Assert.AreEqual(true, testDAO.UpdateItinerary(itinerary));
        }