public void PrintAvailableCampsites(int campgroundID, DateTime arrivalDate, DateTime departureDate) { CampsiteSQLDAL dal = new CampsiteSQLDAL(DatabaseConnection); List <Campsite> campsites = CampsiteSQLDAL.SearchCampsites(campgroundID, arrivalDate, departureDate); if (campsites.Count > 0) { Console.WriteLine(); Console.WriteLine("Results Matching Your Search Criteria"); Console.WriteLine(); Console.WriteLine("Site No.".PadRight(10) + "Max Occupancy".PadRight(15) + "Accessible?".PadRight(15) + "Max RV Length".PadRight(15) + "Utility".PadRight(15) + "Cost"); Console.WriteLine(new String('=', 77)); foreach (Campsite campsite in campsites) { decimal totalFee = CLIHelper.GetTotalFee(campsite.DailyFee, arrivalDate, departureDate); Console.Write(campsite.SiteNumber.ToString().PadRight(10)); Console.Write(campsite.MaxOccupancy.ToString().PadRight(15)); Console.Write((campsite.Accessible == true ? "YES" : "NO").PadRight(15)); Console.Write((campsite.MaxRVLength != 0 ? campsite.MaxRVLength.ToString() : "N/A").PadRight(15)); Console.Write((campsite.Utilities == true ? "YES" : "N/A").PadRight(15)); Console.WriteLine(totalFee.ToString("C2")); } Console.WriteLine(); BookingMenu(campgroundID, arrivalDate, departureDate); } else { Console.WriteLine("No available sites. Would you like to enter an alternate date range?"); Console.WriteLine(); } }
public void GetCampsiteTest() { CampsiteSQLDAL reservation = new CampsiteSQLDAL(connectionString); List <Campsite> campsites = CampsiteSQLDAL.SearchCampsites(1, new System.DateTime(2019, 01, 01), new System.DateTime(2019, 02, 01)); Assert.IsNotNull(campsites); }
public void GetAvailableCampsitesTest() { CampsiteSQLDAL campsite = new CampsiteSQLDAL(connectionString); bool result = CampsiteSQLDAL.GetAvailableCampsites(1, new System.DateTime(1970, 1, 1), new System.DateTime(1970, 2, 1), 1); Assert.IsTrue(result); }
public void OfferDateRangeByParkID() { CampsiteSQLDAL dal = new CampsiteSQLDAL(connectionString, false); List <Campsite> campsites = new List <Campsite>(); Console.WriteLine("Do you want to choose a date range? (Y/N)"); string dateChoice = Console.ReadLine().ToUpper(); if (dateChoice == "N") { campsites = dal.GetCampsitesByParkId(newCampsite.ParkId); DisplayCampsiteAndReservations(campsites); } else if (dateChoice == "Y") { AskForTravelDates(); campsites = dal.GetCampsitesByParkIdAndAvailableDates(newCampsite.ParkId, newReservation.FromDate, newReservation.ToDate); DisplayCampsiteAndReservations(campsites); } else { Console.WriteLine("Invalid Input..."); } }
public void DisplayParkforParkIDAndDate() { GetAllParksShortDisplay(); Console.WriteLine(); Console.WriteLine("Please Enter the Park Id..."); newCampsite.ParkId = int.Parse(Console.ReadLine()); Console.WriteLine("Do you wish to search the whole (p)ark or a specific (c)ampground? "); string userChoice = Console.ReadLine(); CampsiteSQLDAL dal = new CampsiteSQLDAL(connectionString, false); List <Campsite> campsites = new List <Campsite>(); if (userChoice == "p") { campsites = dal.GetCampsitesByParkIdAndAvailableDates(newCampsite.ParkId, newReservation.FromDate, newReservation.ToDate); DisplayCampsiteAndReservations(campsites); } else if (userChoice == "c") { DisplayCampgrounds(true); Console.WriteLine("Please enter a choice for campground..."); newCampsite.CampgroundId = int.Parse(Console.ReadLine()); campsites = dal.GetCampsitesByParkIdAndCampgroundId(newCampsite.ParkId, newCampsite.CampgroundId); DisplayCampsiteAndReservations(campsites); } else { Console.WriteLine("Invalid Input. Please Start Again..."); } }
public void GetCampsitesByParkAndCampground() { List <Campsite> myListOfReturnedCampsites = new List <Campsite>(); CampsiteSQLDAL mySQLTest = new CampsiteSQLDAL(connectionString, false); myListOfReturnedCampsites = mySQLTest.GetCampsitesByParkIdAndCampgroundId(1, 3); }
private void DisplayParkforParkID() { GetAllParksShortDisplay(); Console.WriteLine(); Console.WriteLine("Please Enter the Park Id..."); newCampsite.ParkId = int.Parse(Console.ReadLine()); Console.WriteLine("Do you wish to search the whole (p)ark or a specific (c)ampground? "); string userChoice = Console.ReadLine(); CampsiteSQLDAL dal = new CampsiteSQLDAL(connectionString, false); List <Campsite> campsites = new List <Campsite>(); if (userChoice == "p") { OfferDateRangeByParkID(); } else if (userChoice == "c") { DisplayCampgrounds(false); Console.WriteLine("Please enter a choice for campground..."); newCampsite.CampgroundId = int.Parse(Console.ReadLine()); Console.WriteLine("Do you want to choose a date range? (Y/N)"); string dateChoice = Console.ReadLine().ToUpper(); if (dateChoice == "N") { campsites = dal.GetCampsitesByParkIdAndCampgroundId(newCampsite.ParkId, newCampsite.CampgroundId); } else if (dateChoice == "Y") { AskForTravelDates(); campsites = dal.GetCampsitesByParkCampgroundAndAvailableDates(newCampsite.ParkId, newCampsite.CampgroundId, newReservation.FromDate, newReservation.ToDate); } DisplayCampsiteAndReservations(campsites); } else { Console.WriteLine("Invalid Input. Please Start Again..."); } }
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."); } } }
public void GetReservationDates() { CampsiteSQLDAL dal = new CampsiteSQLDAL(connectionString, false); List <Campsite> campsites = new List <Campsite>(); AskForTravelDates(); Console.WriteLine("Do you wish to display campsites by (a)ll parks or a (s)pecific park?"); string userChoice = Console.ReadLine().ToUpper(); if (userChoice == "A") { campsites = dal.GetCampsitesByAvailableDates(newReservation.FromDate, newReservation.ToDate); DisplayCampsiteAndReservations(campsites); } else if (userChoice == "S") { DisplayParkforParkIDAndDate(); } else { Console.WriteLine("Invalid Input. Please Start Again..."); } }