private void ViewCampgrounds(Park selectedPark) { CampgroundSqlDAL campgroundDAL = new CampgroundSqlDAL(connectionString); List <Campground> campgrounds = campgroundDAL.GetCampgrounds(selectedPark); Console.WriteLine($"#:".PadRight(8) + "Campground Name".PadRight(41) + "Open From:".PadRight(16) + "Open To:".PadRight(16) + "Daily Fee".PadRight(5)); foreach (Campground campground in campgrounds) { Console.WriteLine(campground.ToString()); } Console.WriteLine("Select A Command"); Console.WriteLine("1) Search for Available Reservation"); Console.WriteLine("2) Return To Previous Screen"); string campgroundMenuInput = Console.ReadLine(); switch (campgroundMenuInput) { case "1": input = "4"; break; case "2": input = "2"; break; default: Console.WriteLine("Please select a valid input. Press enter to try again."); Console.ReadLine(); break; } }
private IList <Campground> GetCampgrounds(int parkId) { ICampgroundDAL campdal = new CampgroundSqlDAL(DatabaseConnectionString.DatabaseString); IList <Campground> campgrounds = campdal.GetCampgrounds(parkId); return(campgrounds); }
public void GetCampgroundsTest() { CampgroundSqlDAL campgroundSqlDAL = new CampgroundSqlDAL(); string name = "Acadia"; List <Campground> test = campgroundSqlDAL.GetCampgrounds(name); Assert.IsNotNull(test); }
public void GetCampgroundsTest() { CampgroundSqlDAL dal = new CampgroundSqlDAL(ConnectionString); var campground = dal.GetCampgrounds(1); Assert.AreEqual(1, campground.Count); }
public void GetAllCampgroundsTest() { CampgroundSqlDAL dal = new CampgroundSqlDAL(connectionString); List <Campground> testList = dal.GetCampgrounds(1); Assert.AreEqual(1, testList[0].ParkId); Assert.AreEqual(4, testList.Count); Assert.IsNotNull(testList); }
private void ViewCampgrounds(Park selectedPark) { CampgroundSqlDAL campgroundDAL = new CampgroundSqlDAL(connectionString); List <Campground> campgrounds = campgroundDAL.GetCampgrounds(selectedPark); foreach (Campground campground in campgrounds) { Console.WriteLine(campground.ToString()); } }
public void GetCampgrounds_GetsCampgrounds() { // Arrange CampgroundSqlDAL CSDal = new CampgroundSqlDAL(ConnectionString); // Act IList <Campground> campgrounds = CSDal.GetCampgrounds(1); // Assert Assert.AreEqual(1, campgrounds.Count); }
public void ViewCampgroundsMenu(string park) { CampgroundSqlDAL campgroundSqlDAL = new CampgroundSqlDAL(); List <Campground> campgrounds = campgroundSqlDAL.GetCampgrounds(park); Console.WriteLine(); PrintTitleScreen(park + " Campgrounds"); Console.WriteLine("".PadRight(4) + "Name".PadRight(32) + "Open".PadRight(9) + "Close".PadRight(11) + "Daily fee"); for (int i = 0; i < campgrounds.Count; i++) { Console.WriteLine(i + 1 + ")".PadRight(3) + campgrounds[i].Name.PadRight(32) + ReturnMonthName(campgrounds[i].OpenMonth).PadRight(9) + ReturnMonthName(campgrounds[i].ClosingMonth).PadRight(11) + campgrounds[i].DailyFee.ToString("C2")); } int campgroundSelection = 0; bool validinput = false; do { Console.Write("\nWhich campground (enter 0 to cancel): "); string userInput = Console.ReadLine(); if (int.TryParse(userInput, out campgroundSelection)) { if (campgroundSelection >= 0 && campgroundSelection <= campgrounds.Count) { validinput = true; } } if (validinput == false) { Console.WriteLine("Not a valid input. Please try again."); } } while (validinput == false); if (campgroundSelection == 0) { return; } else { SearchCampgroundReservations(park, campgrounds[campgroundSelection - 1].Name); } }
public bool CampGroundReservation(int intInput) { DisplayCampgrounds(intInput); CampgroundSqlDAL dal = new CampgroundSqlDAL(connectionString); List <Campground> camps = dal.GetCampgrounds(intInput); DateTime arrivalResult = DateTime.MinValue; DateTime departureResult = DateTime.MinValue; DateTime TodayDate = DateTime.Today; Console.WriteLine(); int campgroundID = CLIHelper.GetInteger("Which campground? (enter 0 to cancel)"); if (campgroundID == 0) { Console.WriteLine("Hope to have you stay next time!"); return(false); } else if (campgroundID < 0 && campgroundID > camps.Count) { Console.WriteLine("Please select valid campground"); Console.WriteLine(); return(true); } string arrivalDate = CLIHelper.GetString("What is the arrival date? (mm/dd/yyyy)"); if (!DateTime.TryParse(arrivalDate, out arrivalResult) || arrivalResult < TodayDate) { Console.WriteLine("Please provide a valid date of arrival for the reservation."); Console.ReadLine(); return(true); } string departureDate = CLIHelper.GetString("What is the departure date? (mm/dd/yyyy)"); if (!DateTime.TryParse(departureDate, out departureResult) || departureResult <= arrivalResult) { Console.WriteLine("Please provide a valid date of depature for the reservation."); Console.ReadLine(); return(true); } else if (departureResult < arrivalResult) { Console.WriteLine(); Console.WriteLine("Departure date cannot be before the arrival date. Pleases try again with a valid date of departure."); return(true); } AvailableSitesToReserve(campgroundID, arrivalDate, departureDate); return(true); }
public void ReturnSelectedParkCampgroundsTest() { CampgroundSqlDAL dal = new CampgroundSqlDAL(connectionString); List <Campground> testList = dal.GetCampgrounds(4); foreach (Campground camps in testList) { Assert.AreEqual(2, camps.ParkId); Assert.AreEqual("Devil's Garden", camps.Name); Assert.AreEqual("Jan", camps.OpenMonth); Assert.AreEqual("Dec", camps.CloseMonth); Assert.AreEqual(25.00, camps.DailyFee); } }
public void InsertNewCampgroundsIntoCampgroundsTest() { CampgroundSqlDAL dal = new CampgroundSqlDAL(connectionString); List <Campground> testList = dal.GetCampgrounds(8); foreach (Campground camps in testList) { Assert.AreEqual(2, camps.ParkId); Assert.AreEqual("test campground", camps.Name); Assert.AreEqual("Feb", camps.OpenMonth); Assert.AreEqual("Dec", camps.CloseMonth); Assert.AreEqual(27.00, camps.DailyFee); } }
void DisplayCampgrounds(int intInput) { CampgroundSqlDAL dal = new CampgroundSqlDAL(connectionString); List <Campground> camps = dal.GetCampgrounds(intInput); DateTimeFormatInfo dateTimeInfo = new DateTimeFormatInfo(); Console.WriteLine(); Console.WriteLine("National Park Campgrounds"); Console.WriteLine(); Console.WriteLine(" Name Open Close Daily Fee"); foreach (Campground camp in camps) { Console.WriteLine("#" + camp.CampgroundId.ToString().PadRight(3) + camp.Name.ToString().PadRight(35) + dateTimeInfo.GetAbbreviatedMonthName(camp.OpenMonth).PadRight(6) + dateTimeInfo.GetAbbreviatedMonthName(camp.CloseMonth).PadRight(7) + string.Format("{0:C}", camp.DailyFee)); } }
/// <summary> /// GetAllCampgrounds calls the GetCampgrounds method from the campgroundSqlDAL it creates a list and calls that list /// into a if statement. it uses the cli helper to take in user input like a readline would /// it the GetCampgrounds method takes in a parameter of type int parkID so we created myParkID /// which is the number the user enters and then put that into the list. /// If the count in the list is > 0 it prints out all the campground information to the console screen /// we added a console writeline for formatting purposes so the user new what each column represented. /// </summary> private void GetAllCampgrounds() { int myParkid = CLIHelper.GetInteger("Please enter the Park ID (1 (Acadia) , 2 (Arches) or 3 (Cuyahoga National Valley Park): "); CampgroundSqlDAL dal = new CampgroundSqlDAL(DatabaseConnection); List <Campground> campgrounds = dal.GetCampgrounds(myParkid); if (campgrounds.Count > 0) { Console.WriteLine("".PadRight(10) + "Name".PadRight(35) + "Open".PadRight(20) + "Close".PadRight(20) + "Daily Fee".PadRight(20)); campgrounds.ForEach(thing => { Console.WriteLine(thing); }); } else { Console.WriteLine("NO RESULTS"); } }
/// <summary> /// Displays list of available campgrounds for selected park /// </summary> /// <param name="parkId"></param> /// <returns>The list of campgrounds available</returns> private IList <Campground> DisplayCampgroundInfo(int parkId) { CampgroundSqlDAL dal = new CampgroundSqlDAL(DatabaseConnection); IList <Campground> campgrounds = dal.GetCampgrounds(parkId); Console.Clear(); if (campgrounds.Count > 0) { Console.WriteLine("CAMPGROUNDS"); Console.WriteLine("ID".PadRight(10) + "Name".PadRight(40) + "Open".ToString().PadRight(10) + "Close".ToString().PadRight(10) + "Daily Fee".ToString().PadRight(10)); foreach (Campground campground in campgrounds) { Console.WriteLine((Convert.ToInt32(campground.CampgroundId)).ToString().PadRight(10) + campground.Name.PadRight(40) + campground.OpenMonth.ToString().PadRight(10) + campground.CloseMonth.ToString().PadRight(10) + campground.DailyFee.ToString("C2").PadRight(10)); } } else { Console.WriteLine("**** NO CAMPGROUNDS TO SHOW ****"); } return(campgrounds); }
private void SearchForReservationMenu(Park selectedPark) { SiteSqlDAL siteSqlDAL = new SiteSqlDAL(connectionString); CampgroundSqlDAL campgroundDAL = new CampgroundSqlDAL(connectionString); List <Campground> campgrounds = campgroundDAL.GetCampgrounds(selectedPark); Console.WriteLine($"#:".PadRight(8) + "Campground Name".PadRight(41) + "Open From:".PadRight(16) + "Open To:".PadRight(16) + "Daily Fee".PadRight(5)); foreach (Campground campground in campgrounds) { Console.WriteLine(campground.ToString()); } Console.Write("Which campground? (enter 0 to cancel)"); result[0] = Console.ReadLine(); if (result[0] == "0") { input = "3"; return; } Console.Write("What is the arrival date? (MM/DD/YYYY)"); result[1] = Console.ReadLine(); Console.Write("What is the departure date? (MM/DD/YYYY)"); result[2] = Console.ReadLine(); bool validCampgroundId = int.TryParse(result[0], out int campground_id); bool validFromDate = DateTime.TryParse(result[1], out DateTime from_date); bool validToDate = DateTime.TryParse(result[2], out DateTime to_date); if (DateTime.Compare(from_date, to_date) >= 0) { Console.WriteLine("Invalid Input, departure date is before arrival date. Press Enter to try again."); Console.ReadLine(); return; } if (!validCampgroundId || !validFromDate || !validToDate) { Console.WriteLine("Invalid Input, Check Campground ID or Date Formats. Press Enter to try again."); Console.ReadLine(); return; } bool containsId = false; foreach (Campground campground in campgrounds) { if (campground.Campground_id == campground_id) { containsId = true; } } if (containsId) { reservation.Reservation_from_date = from_date; reservation.Reservation_to_date = to_date; input = "5"; } //else //{ // Console.Clear(); // Console.WriteLine("Invalid Input, Check Campground ID or Date Formats."); // Console.WriteLine(); // input = "4"; // Console.Clear(); //} }