public void GetReservationsTest() { ReservationSqlDAL dal = new ReservationSqlDAL(ConnectionString); var reservations = dal.GetReservations(1, 1, 1); Assert.AreEqual(1, reservations.Count); }
/// <summary> /// Checks the entered requested date range against existing reservations for that selected site at the selected campground at the selected park /// </summary> /// <param name="parkId"></param> /// <param name="campgroundId"></param> /// <param name="siteNumber"></param> /// <param name="desiredReservationDates"></param> /// <returns>Reservation at the selected site at the selected campground at the selected park</returns> private Reservation CheckAvailableReservation(int parkId, int campgroundId, int siteId, int siteNumber, DateTime[] desiredReservationDates) { ReservationSqlDAL dal = new ReservationSqlDAL(DatabaseConnection); IList <Reservation> reservations = dal.GetReservations(parkId, campgroundId, siteNumber); Reservation successfulReservation = new Reservation(); bool isValidReservation = true; foreach (var reservation in reservations) { if ((desiredReservationDates[0] >= reservation.StartDate && desiredReservationDates[0] <= reservation.EndDate) || (desiredReservationDates[1] >= reservation.StartDate && desiredReservationDates[1] <= reservation.EndDate)) { isValidReservation = false; Console.WriteLine("Reservation already booked during all or part of this date range. Please select another date range."); break; } } if (isValidReservation) { Console.Write("Please Enter Reservation Name: "); string reservationName = Console.ReadLine(); successfulReservation = dal.AddReservation(siteId, reservationName, desiredReservationDates); } return(successfulReservation); }