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