public void Test_GetUnapprovedLandmarks() { LandmarkSqlDAO testDAO = new LandmarkSqlDAO(connectionString); int startingCount = testDAO.GetUnapprovedLandmarks().Count; int unapprovedLandmarkId = AddTestLandmark(); Assert.AreEqual(startingCount + 1, testDAO.GetUnapprovedLandmarks().Count); }
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); }
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); }
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)); }
public void Test_AddLandmark() { LandmarkSqlDAO testDAO = new LandmarkSqlDAO(connectionString); Landmark testLandmark = new Landmark(); testLandmark.LongName = "Anything"; testLandmark.ShortName = "Anything"; testLandmark.Latitude = 10; testLandmark.Longitude = -20; testLandmark.City = "Here"; testLandmark.State = "Ohio"; testLandmark.StateCode = "OH"; testLandmark.Details = "details"; testLandmark.StreetNumber = 1; testLandmark.StreetName = "Street"; testLandmark.IsApproved = true; Assert.AreEqual(true, testDAO.AddLandmark(testLandmark)); }