public void GetCampgroundsAtPark_InsertedCampgroundExists()
{
using (TransactionScope transaction = new TransactionScope())
{
CampgroundSqlDAL testClass = new CampgroundSqlDAL(connectionString);
Park tempPark = new Park();
tempPark.Area = 0;
tempPark.Description = "TEST DESCRIPTION";
tempPark.Establish_Date = new DateTime(2000, 1, 1).Date;
tempPark.Location = "TEST LOCATION";
tempPark.Name = "TEST PARK";
tempPark.Visitors = 0;
int tempPark_parkId = ParkSqlDALTests.InsertFakePark(tempPark);
Campground testCamp = new Campground();
testCamp.Daily_Fee = 5.00M;
testCamp.Name = "Slimy Valley";
testCamp.Open_From_MM = 5;
testCamp.Open_To_MM = 6;
testCamp.Park_Id = tempPark_parkId;
testCamp.Campground_Id = InsertFakeCampground(testCamp);
Campground insertedCampground = testClass.GetCampgroundsAtPark(tempPark_parkId).First();
Assert.IsNotNull(insertedCampground);
}
}
private void ManualInitialize()
{
// Put a temporary park into the database
tempPark.Area = 0;
tempPark.Description = "TEST DESCRIPTION";
tempPark.Establish_Date = new DateTime(2000, 1, 1).Date;
tempPark.Location = "TEST LOCATION";
tempPark.Name = "TEST PARK";
tempPark.Visitors = 0;
int tempPark_parkId = ParkSqlDALTests.InsertFakePark(tempPark);
// Put a temporary campground into the database
// Record the id into a class scope int variable
testCamp.Daily_Fee = 5.00M;
testCamp.Name = "Slimy Valley";
testCamp.Open_From_MM = 1;
testCamp.Open_To_MM = 12;
testCamp.Park_Id = tempPark_parkId;
// put a temporary site into the database
// Record the id into a class scope int variable
testCamp.Campground_Id = CampgroundSqlDALTests.InsertFakeCampground(testCamp);
testSite.Campground_Id = testCamp.Campground_Id;
testSite.Site_Number = 1;
siteId = SiteSqlDALTests.InsertFakeSite(testSite);
}
public void GetParkByParkName()
{
using (TransactionScope transaction = new TransactionScope())
{
int newParkId = ParkSqlDALTests.InsertFakePark(park);
ParkSqlDAL testClass = new ParkSqlDAL(connectionString);
ParkModel newPark = testClass.GetParkByParkName(park.Name);
Assert.AreEqual(newPark.ParkId, newParkId);
}
}
public void GetAllParks()
{
using (TransactionScope transaction = new TransactionScope())
{
int newParkId = ParkSqlDALTests.InsertFakePark(park);
ParkSqlDAL testClass = new ParkSqlDAL(connectionString);
List <ParkModel> parks = testClass.GetAllParks();
Assert.IsTrue(parks.Select(park => park.ParkId).Contains(newParkId));
}
}
public void GetTrailsByParkName()
{
using (TransactionScope transaction = new TransactionScope())
{
int newParkId = ParkSqlDALTests.InsertFakePark(park);
int newTrailId = TrailSqlDALTests.InsertFakeTrail(trail, newParkId);
TrailSqlDAL testClass = new TrailSqlDAL(connectionString);
List <TrailModel> newTrails = testClass.GetTrailsByParkName(park.Name);
Assert.IsTrue(newTrails.Select(trail => trail.TrailId).Contains(newTrailId));
}
}
public void GetTrailByTrailName()
{
using (TransactionScope transaction = new TransactionScope())
{
int newParkId = ParkSqlDALTests.InsertFakePark(park);
int newTrailId = TrailSqlDALTests.InsertFakeTrail(trail, newParkId);
TrailSqlDAL testClass = new TrailSqlDAL(connectionString);
TrailModel newTrail = testClass.GetTrailByTrailName(trail.Name);
Assert.AreEqual(newTrail.TrailId, newTrailId);
}
}
public void GetImageByParkId()
{
using (TransactionScope transaction = new TransactionScope())
{
int newParkId = ParkSqlDALTests.InsertFakePark(park);
int newParkImageId = ParkSqlDALTests.InsertFakeParkImage(parkImage, newParkId);
ParkSqlDAL testClass = new ParkSqlDAL(connectionString);
string newParkImageAddress = testClass.GetImageByParkId(newParkId);
Assert.AreEqual(parkImage.ImageAddress, newParkImageAddress);
}
}
public void GetPanoramicById()
{
using (TransactionScope transaction = new TransactionScope())
{
int newParkId = ParkSqlDALTests.InsertFakePark(park);
int newTrailId = TrailSqlDALTests.InsertFakeTrail(trail, newParkId);
int newPanoramicId = PanoramicSqlDALTests.InsertFakePanoramic(panoramicImage, newTrailId);
PanoramicSqlDAL testClass = new PanoramicSqlDAL(connectionString);
PanoramicModel newPanoramicImages = testClass.GetPanoramicById(newPanoramicId);
Assert.AreEqual(newPanoramicImages.PanoramicId, newPanoramicId);
}
}
public void GetAllPanoramics()
{
using (TransactionScope transaction = new TransactionScope())
{
int newParkId = ParkSqlDALTests.InsertFakePark(park);
int newTrailId = TrailSqlDALTests.InsertFakeTrail(trail, newParkId);
int newPanoramicId = PanoramicSqlDALTests.InsertFakePanoramic(panoramicImage, newTrailId);
PanoramicSqlDAL testClass = new PanoramicSqlDAL(connectionString);
List <PanoramicModel> newPanoramicImages = testClass.GetAllPanoramics();
Assert.IsTrue(newPanoramicImages.Select(panoramic => panoramic.PanoramicId).Contains(newPanoramicId));
}
}