private void FindAvailableCampSites()
{
int campground_id = CLIHelper.GetInteger("Please Select Campground ID");
Console.WriteLine();
DateTime startDate = CLIHelper.GetDateTime("Please Select Start of Stay (yyyy-mm-dd)");
Console.WriteLine();
DateTime endDate = CLIHelper.GetDateTime("Please Select Date of Depature (yyyy-mm-dd)");
SiteDal dal = new SiteDal(connectionString);
List <Site> sites;
bool avail = dal.IsSiteAvailable(campground_id, startDate, endDate);
if (!avail)
{
Tools.ColorfulWriteLine("No availablity please try different dates or Campground", ConsoleColor.Red);
}
else if (avail)
{
sites = dal.GetTop5(campground_id, startDate, endDate);
foreach (Site s in sites)
{
Console.WriteLine();
Tools.ColorfulWriteLine($"National Site ID".PadRight(20) + "Campground Site Number".PadRight(30) + "Max Occupancy".PadRight(25) + "Total Days".PadRight(20) + "Total Cost", ConsoleColor.Yellow);
Console.WriteLine($"{s.site_id}".PadRight(20) + $"{s.site_number}".PadRight(30) + $"{s.max_occupancy}".PadRight(30) + $"{s.totalDays}".PadRight(20) + $"${s.totalCost}");
}
}
}
