public void TrueSearchReservationsTest() { ReservationSQLDAL reservation = new ReservationSQLDAL(connectionString); int trueResult = reservation.BookReservation(1, 1, new System.DateTime(1980, 7, 4), new System.DateTime(1980, 7, 11), "Terranova"); Assert.IsTrue(trueResult > 0); }
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 GetAllReservations() { List <Reservation> myReservationsTest = new List <Reservation>(); ReservationSQLDAL mySQLTest = new ReservationSQLDAL(connectionString); myReservationsTest = mySQLTest.GetAllReservations(); }
public void SearchForAvailableSitesTest() { ReservationSQLDAL dal = new ReservationSQLDAL(connectionString); List <Site> validSites = dal.SearchForAvailableReservations(campgroundID, start, end); Assert.IsNotNull(validSites); Assert.IsTrue(validSites.Count > 0); }
private void GetReservations() { ReservationSQLDAL dal = new ReservationSQLDAL(connectionString); List <Reservation> reservations = dal.GetAllReservations(); Console.WriteLine(); foreach (var reservation in reservations) { Console.WriteLine(); Console.WriteLine(reservation); } }
public void AddNewReservation() { Reservation myReservationTest = new Reservation(); myReservationTest.CampgroundId = 1; myReservationTest.FromDate = new DateTime(2017, 02, 20); myReservationTest.ToDate = new DateTime(2017, 03, 01); myReservationTest.SiteId = 9; myReservationTest.Name = "Test Johnson"; ReservationSQLDAL mySQLTest = new ReservationSQLDAL(connectionString); myReservationTest.ReservationId = mySQLTest.AddNewReservation(myReservationTest); }
public void DisplayCampsiteAndReservations(List <Campsite> campsites) { foreach (var campsite in campsites) { Console.WriteLine(campsite); } Console.WriteLine(); Console.WriteLine("Do you want to make a reservation?"); string userChoice = Console.ReadLine().ToUpper(); if (userChoice == "Y") { ReservationSQLDAL resDal = new ReservationSQLDAL(connectionString); Console.WriteLine("Please Enter the Campsite Id..."); newReservation.SiteId = int.Parse(Console.ReadLine()); Console.WriteLine("What is the last name for the reservation?"); newReservation.Name = Console.ReadLine(); if (newReservation.ToDate == DateTime.MinValue) { AskForTravelDates(); } resDal.AddNewReservation(newReservation); if (newReservation.ReservationId > 0) { Console.WriteLine(newReservation); } else { Console.WriteLine("Invalid Date Range."); } } else if (userChoice == "N") { //send them back to the main menu } else { Console.WriteLine("Invalid input."); } }
public void BookingMenu(int campgroundID, DateTime arrivalDate, DateTime departureDate) { int reservationID = 0; ReservationSQLDAL dal = new ReservationSQLDAL(DatabaseConnection); bool done = false; while (!done) { Console.WriteLine(); Console.WriteLine("Which Site Should be Reserved? (0 To Cancel)"); int siteNumber = int.Parse(Console.ReadLine()); if (siteNumber == 0) { done = true; break; } else if (!(CampsiteSQLDAL.GetAvailableCampsites(campgroundID, arrivalDate, departureDate, siteNumber))) { Console.WriteLine(); Console.WriteLine("Not a valid selection. Press enter to continue."); Console.WriteLine(); Console.ReadLine(); continue; } Console.WriteLine("What Name Should the Reservation be Made Under?"); string reservationName = Console.ReadLine(); reservationID = dal.BookReservation(siteNumber, campgroundID, arrivalDate, departureDate, reservationName); if (reservationID > 0) { Console.WriteLine(); Console.WriteLine($"The reservation has been made and the confirmation id is {reservationID}. Press enter to continue."); Console.ReadLine(); done = true; } else { Console.WriteLine("Error making reservation. Please try again."); } } }