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);
}
}
/// <summary>
/// Displays all campgrounds at the selected park.
/// </summary>
/// <param name="park"></param>
/// <returns></returns>
private List <Campground> DisplayCampgroundsList(Park park)
{
Console.Clear();
CampgroundSqlDAL cgDAL = new CampgroundSqlDAL(ConnectionString);
List <Campground> campgrounds = cgDAL.GetCampgroundsAtPark(park.Park_id);
campgrounds.Insert(0, null);
Console.WriteLine("".PadRight(5) + Campground.Header);
for (int i = 1; i < campgrounds.Count; i++)
{
Console.WriteLine($"#{i,-1} {campgrounds[i]}");
}
Console.WriteLine();
return(campgrounds);
}
/// <summary>
/// Gets date range from user, checks for available sites, and allows for reservations.
/// For searching an entire park.
/// </summary>
/// <param name="park"></param>
private void ManageAvailableSiteSearch(Park park)
{
List <Site> availableSites = new List <Site>();
DateTime arrivalDate = new DateTime();
DateTime departureDate = new DateTime();
while (availableSites.Count == 0)
{
Tuple <DateTime, DateTime> dateRange = GetDateRange();
if (dateRange == null)
{
return;
}
arrivalDate = dateRange.Item1;
departureDate = dateRange.Item2;
int numberOfNights = (int)(departureDate - arrivalDate).TotalDays;
Console.WriteLine();
CampgroundSqlDAL cgDAL = new CampgroundSqlDAL(ConnectionString);
List <Campground> campgrounds = cgDAL.GetCampgroundsAtPark(park.Park_id);
availableSites = SearchForAvailableSites(campgrounds, arrivalDate, departureDate);
if (IsClosed(campgrounds, arrivalDate, departureDate))
{
Console.WriteLine("One or more campgrounds are closed for part or all of your date range.");
}
if (availableSites.Count == 0)
{
string wantsAlternateRange = CLIHelper.GetString(
"No available sites. Would you like to enter an alternate date range? (yes or no): ");
if (wantsAlternateRange.ToLower() != "yes")
{
return;
}
}
}
ActOnAvailableSites(availableSites, arrivalDate, departureDate);
}