private void SearchReservations(Park userParkChoice)
{
ViewCampgrounds(userParkChoice);
int userChoiceCampgroundID = CLIHelper.GetInteger("Enter the desired campground ID: ");
DateTime userChoiceStartDate = CLIHelper.GetDateTime("Enter the desired start date: (YYYY/MM/DD) ");
DateTime userChoiceEndDate = CLIHelper.GetDateTime("Enter the desired end date: (YYYY/MM/DD) ");
ReservationSQLDAL dal = new ReservationSQLDAL(DatabaseConnection);
List <Site> availableSites = dal.SearchForAvailableReservations(userChoiceCampgroundID, userChoiceStartDate, userChoiceEndDate);
CampgroundSQLDAL cgDal = new CampgroundSQLDAL(userChoiceCampgroundID, DatabaseConnection);
decimal totalCampingCost = cgDal.GetCampgroundDailyRate();
int totalDays = Convert.ToInt32((userChoiceEndDate - userChoiceStartDate).TotalDays);
if (availableSites.Count > 0)
{
Console.WriteLine("Showing First Five Available Sites:");
Console.WriteLine("Site No. Max Occupancy Accessible? Max RV Length Utilites? Total Cost");
foreach (Site site in availableSites)
{
Console.WriteLine("#" + site.SiteNumber + " " + site.MaxOccupancy + " " + site.IsAccessible + " " + site.MaxRVLength + " " + site.HasUtilities + " " + (totalCampingCost * totalDays).ToString("C2"));
}
}
else
{
Console.WriteLine("**** NO RESULTS ****");
}
}
public void SearchForAvailableSitesTest()
{
ReservationSQLDAL dal = new ReservationSQLDAL(connectionString);
List <Site> validSites = dal.SearchForAvailableReservations(campgroundID, start, end);
Assert.IsNotNull(validSites);
Assert.IsTrue(validSites.Count > 0);
}