private void CompleteReservation()
{
int selectedSiteId = CLIHelper.GetSiteInteger(" Which campsite would you like to reserve? ", connectionString, selectedCampgroundId, desiredStartDate, desiredEndDate);
Console.ForegroundColor = ConsoleColor.DarkGreen;
Console.Write("\n What name should the reservation be saved under? ");
Console.ForegroundColor = ConsoleColor.White;
string reservationName = Console.ReadLine();
Console.WriteLine();
ReservationSqlDAL reservationDal = new ReservationSqlDAL(connectionString);
reservationDal.MakeReservation(selectedSiteId, reservationName, desiredStartDate, desiredEndDate);
Reservation thisReservation = reservationDal.GetSpecificReservation(selectedSiteId, reservationName);
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine($" Thank You! Your reservation has been made! Your confirmation number is: {thisReservation.Reservation_Id}");
Console.ForegroundColor = ConsoleColor.White;
}
