public void NationalParkDALMethods()
{
NationalParkDAL _park = new NationalParkDAL(_connectionString);
//GetParks() and PopulateParkFromReader() - second method contained within first
List <Park> parkList = _park.GetParks();
Assert.IsNotNull(parkList);
//GetCampgroundsByPark() and PopulateCampgroundFromReader() - second method contained within first
List <Campground> campList = _park.GetCampgroundsByPark(parkList[0]);
Assert.IsNotNull(campList);
//GetSitesByCampground() and PopulateSiteFromReader() - second method contained within first
List <Site> siteList = _park.GetSitesByCampground(campList[0].Id);
Assert.IsNotNull(siteList);
//GetSitesForUser() and PopulateCustomItemFromReader() - second method contained within first
DateTime userArrDate = new DateTime(2018, 08, 01);
DateTime userDepDate = new DateTime(2018, 08, 30);
List <CustomItem> sitesForUser = _park.GetSitesForUser(campList[0].Id, userArrDate, userDepDate);
Assert.IsNotNull(sitesForUser);
//MakeReservation()
int confirmNum = _park.MakeReservation(siteList[0].SiteId, "TEST FAMILY NAME", userArrDate, userDepDate);
Assert.IsNotNull(confirmNum);
}
private void ViewParkDetails()
{
int parkToView = CLIHelper.GetInteger("What park would you like to view?");
Console.WriteLine();
NationalParkDAL npDAL = new NationalParkDAL(DatabaseConnection);
Park p = npDAL.GetParkInfo(parkToView);
if (p != null)
{
Console.WriteLine("Park ID: " + p.Id);
Console.WriteLine("Park Name: " + p.name);
Console.WriteLine("Location: " + p.location);
Console.WriteLine("Established: " + p.establishdate);
Console.WriteLine("Area: " + p.area);
Console.WriteLine("Visitors " + p.visitors);
Console.WriteLine(p.description);
ParkSubmenu(p.Id);
}
else
{
Console.WriteLine("NO RESULTS IN PARKLIST");
}
}
public void NationalParkDALMethods()
{
NationalParkDAL _park = new NationalParkDAL(_connectionString);
//GetParks() and PopulateParkFromReader()
List <Park> parkList = _park.GetParks();
Assert.IsNotNull(parkList);
//Campground Methods
//Site Methods
//Reservation Methods
//CustomItem Methods
}
private void ShowAllParks()
{
Console.WriteLine();
NationalParkDAL npDAL = new NationalParkDAL(DatabaseConnection);
List <Park> parkList = npDAL.ShowAllParks();
if (parkList.Count > 0)
{
foreach (Park p in parkList)
{
Console.Write(p.Id);
Console.Write(". ");
Console.WriteLine(p.name);
}
}
else
{
Console.WriteLine("NO RESULTS IN PARKLIST");
}
}
public NationalPark(string connectionString)
{
_db = new NationalParkDAL(connectionString);
}
