public void TestParkNames()
{
TransactionScope testParkNames;
testParkNames = new TransactionScope();
ParkSqlDAL parkDAL = new ParkSqlDAL(connectionString);
List <Park> park = parkDAL.GetParks();
string park_1_Name = "Acadia";
string park_2_Name = "Arches";
string park_3_Name = "Cuyahoga Valley";
bool output_Name_Matches1 = park[0].name == park_1_Name;
Assert.IsTrue(output_Name_Matches1);
bool output_Name_Matches2 = park[1].name == park_2_Name;
Assert.IsTrue(output_Name_Matches2);
bool output_Name_Matches3 = park[2].name == park_3_Name;
Assert.IsTrue(output_Name_Matches3);
testParkNames.Dispose();
}
public void TestCampgroundList()
{
TransactionScope test = new TransactionScope();
ParkSqlDAL parkDAL = new ParkSqlDAL(connectionString);
List <Park> park = parkDAL.GetParks();
CampgroundSqlDAL campgroundDAL = new CampgroundSqlDAL(connectionString);
List <Campground> testNumberOfCampsAcadia = campgroundDAL.GetAllCampgroundFromPark(park[0]);
List <Campground> testNumberOfCampsArches = campgroundDAL.GetAllCampgroundFromPark(park[1]);
List <Campground> testNumberOfCampsCuyahogaValley = campgroundDAL.GetAllCampgroundFromPark(park[2]);
//assert
bool outputAcadia_doesCampCountNumberMatch = testNumberOfCampsAcadia.Count == 3;
Assert.IsTrue(outputAcadia_doesCampCountNumberMatch);
bool outputArches_doesCampCountNumberMatch = testNumberOfCampsArches.Count == 3;
Assert.IsTrue(outputArches_doesCampCountNumberMatch);
bool outputCuyahogaValley_doesCampCountNumberMatch = testNumberOfCampsCuyahogaValley.Count == 1;
Assert.IsTrue(outputCuyahogaValley_doesCampCountNumberMatch);
test.Dispose();
}
/// <summary>
/// Display the list of parks
/// </summary>
/// <returns>The park id selected by user</returns>
private int DisplayAllParks()
{
int parkSelection = 0;
while (true)
{
ParkSqlDAL dal = new ParkSqlDAL(DatabaseConnection);
IList <Park> parks = dal.GetParks();
if (parks.Count > 0)
{
Console.WriteLine("Please select the national park that you wish to visit.");
foreach (Park park in parks)
{
Console.WriteLine(park.ParkId.ToString().PadRight(10) + park.Name.PadRight(40));
}
Console.Write(">> ");
parkSelection = CLIHelper.GetInteger(Console.ReadLine());
if (parkSelection <= parks.Count && parkSelection > 0)
{
break;
}
Console.Clear();
}
else
{
Console.WriteLine("**** SOLD TO PRIVATE CORPORATION-TEDDY ROOSEVELT SPINNING IN GRAVE ****");
}
}
return(parkSelection);
}
// GET: Home
public ActionResult Index()
{
ParkSqlDAL parkDAL = new ParkSqlDAL(connectionString);
List <Park> parkList = parkDAL.GetParks();
return(View("Index", parkList));
}
// GET: Home
public ActionResult Home()
{
ParkSqlDAL dal = new ParkSqlDAL(connectionString);
List <Park> parks = dal.GetParks();
return(View(parks));
}
public void ParkSqlDalTests()
{
ParkSqlDAL parkDal = new ParkSqlDAL(connectionString);
List <Park> parks = parkDal.GetParks();
Assert.IsNotNull(parks);
}
public void GetParksTest()
{
ParkSqlDAL dal = new ParkSqlDAL(ConnectionString);
var park = dal.GetParks();
Assert.AreEqual(1, park.Count);
}
public void GetAllParksTest()
{
ParkSqlDAL testPark = new ParkSqlDAL(connectionString);
List <Park> testList = testPark.GetParks();
Assert.AreEqual(4, testList.Count);
Assert.AreEqual("test park", testList[3].ParkName);
Assert.AreEqual("ohio", testList[3].Location);
}
private void GetParks()
{
IParkDAL parkdal = new ParkSqlDAL(DatabaseConnectionString.DatabaseString);
IList <Park> parks = parkdal.GetParks();
for (int i = 0; i < parks.Count; i++)
{
Console.WriteLine($"{parks[i].ParkId}) {parks[i].Name}");
}
}
public void GetParksTest_ReturnAllParks()
{
// Arrange
ParkSqlDAL PSDal = new ParkSqlDAL(ConnectionString);
// Act
IList <Park> parks = PSDal.GetParks();
// Assert
Assert.AreEqual(1, parks.Count);
}
public void GetParkDetailTest()
{
//Arrange
IParkDAL pDetailDAL = new ParkSqlDAL(connectionString);
//Act
IList <ParkModel> details = pDetailDAL.GetParks("YNP");
//Assert
Assert.IsNotNull(details);
Assert.AreEqual("Yellowstone National Park", details[0].ParkName);
}
public void GetParksTest()
{
//Arrange
ParkSqlDAL parkSqlDal = new ParkSqlDAL(connectionString);
//Act
List <Park> parks = parkSqlDal.GetParks();
//Assert
Assert.IsNotNull(parks);
Assert.AreEqual(numberOfParks, parks.Count);
}
public void TestParkList()
{
TransactionScope testParkList;
testParkList = new TransactionScope();
ParkSqlDAL parkDAL = new ParkSqlDAL(connectionString);
List <Park> park = parkDAL.GetParks();
bool output = park.Count > 0;
Assert.IsTrue(output);
testParkList.Dispose();
}
private void PrintMenu()
{
Console.WriteLine("Select a Park for Further Details");
IParkDAL parkDal = new ParkSqlDAL(DatabaseConnection);
IList <Park> parks = parkDal.GetParks();
foreach (Park park in parks)
{
Console.WriteLine($"{park.ParkId}) {park.Name}");
}
Console.WriteLine("Q) Quit");
}
public void GetParksTest()
{
// Arrange
IParkDAL pDAL = new ParkSqlDAL(connectionString);
//Act
IList <ParkModel> park = pDAL.GetParks();
//Assert
int parkTotal = park.Count;
Assert.IsNotNull(park);
Assert.AreEqual(4, parkTotal);
}
public void DisplayMainMenu()
{
ParkSqlDAL parkDal = new ParkSqlDAL(_dbConnectionString);
List <Park> parks = parkDal.GetParks();
Console.Clear();
Console.WriteLine();
Console.WriteLine(" View Parks ");
Console.WriteLine();
bool exit = false;
while (!exit)
{
for (int index = 0; index < parks.Count; index++)
{
Console.WriteLine(" " + (index + 1) + ") " + parks[index].ParkName);
}
Console.WriteLine(" Q - Quit");
Console.WriteLine();
Console.Write(" Select a park... ");
string command = Console.ReadLine();
int selection;
if (command == "q" || command == "Q")
{
DisplayQuitApplication();
exit = true;
}
else if (int.TryParse(command, out selection))
{
if (selection > 0 && selection <= parks.Count)
{
DisplayParkInfoMenu(parks[selection - 1]);
}
}
else
{
DisplayInvalidRequest();
}
Console.ReadKey();
Console.Clear();
}
}
/// <summary>
/// Get all Parks calls the GetParks method from the ParkSqlDAL Class and creates a list
/// then that list is called into an if statement and if the count of the items in the list is > 0
/// then it will print out all the parks contained in the park table in the database
/// else no results will be printed out.
/// </summary>
private void GetAllParks()
{
ParkSqlDAL dal = new ParkSqlDAL(DatabaseConnection);
List <Park> parks = dal.GetParks();
if (parks.Count > 0)
{ //I used a lambda expression in the foreach loop. Just a different way to write the foreach loop
//But does exactly the same thing if written out the longer way.
parks.ForEach(item =>
{
Console.WriteLine(item + "\n");
});
}
else
{
Console.WriteLine("NO RESULTS");
}
}
private void DisplayParkNames()
{
ParkSqlDAL pIO = new ParkSqlDAL(DatabaseConnection);
List <Park> parks = pIO.GetParks();
numParks = parks.Count;
if (parks.Count > 0)
{
for (int i = 0; i < parks.Count; i++)
{
Console.WriteLine((i + 1) + ") " + parks[i].Name);
}
}
else
{
Console.WriteLine("**** NO RESULTS FOUND ****");
}
}
// this method connects to the DAL class to store (in a list) and display all parks for the user //
private List <Park> ListAllParks()
{
ParkSqlDAL dal = new ParkSqlDAL(connectionString);
List <Park> parks = dal.GetParks();
if (parks.Count > 0)
{
foreach (Park park in parks)
{
Console.WriteLine("{0, -3}{1, -20}", $"{park.park_id.ToString()})", $"{park.name}");
}
}
else
{
Console.WriteLine("**** NO RESULTS ****");
}
Console.WriteLine("{0, -3}{1, -20}", $"Q)", $"quit");
return(parks);
}
// this method connects to the DAL class to store (in a list) and display the info on the selected park //
private List <Park> DisplayParkInfo()
{
ParkSqlDAL dal = new ParkSqlDAL(connectionString);
List <Park> parks = dal.GetParks();
Console.WriteLine("---------------------------------------------");
Console.WriteLine(" PARK INFORMATION");
Console.WriteLine("---------------------------------------------");
Console.WriteLine("{0, -20}{1, 25}", $"Name: ", $"{parks[customerSelection].name.ToString().ToUpper()}");
Console.WriteLine("---------------------------------------------");
Console.WriteLine("{0, -20}{1, 25}", $"Location:", $"{parks[customerSelection].location}");
Console.WriteLine("{0, -20}{1, 25}", $"Established:", $"{parks[customerSelection].establish_date.ToString()}");
Console.WriteLine("{0, -20}{1, 25}", $"Area: ", $"{parks[customerSelection].area.ToString()}");
Console.WriteLine("{0, -20}{1, 25}", $"Annual Visitors:", $"{parks[customerSelection].visitors.ToString()}");
Console.WriteLine("---------------------------------------------");
Console.WriteLine();
Console.WriteLine(parks[customerSelection].description);
return(parks);
}
public void TestListSiteDAL()
{
testScope = new TransactionScope();
DateTime startTime = new DateTime(2016, 08, 01);
DateTime endTime = new DateTime(2016, 08, 03);
ParkSqlDAL parkDAL = new ParkSqlDAL(connectionString);
List <Park> park = parkDAL.GetParks();
CampgroundSqlDAL campgroundDAL = new CampgroundSqlDAL(connectionString);
List <Campground> testNumberOfCampsAcadia = campgroundDAL.GetAllCampgroundFromPark(park[0]);
SiteSqlDAL siteDal = new SiteSqlDAL(connectionString);
List <Site> availableSites = siteDal.GetAvailableSites(testNumberOfCampsAcadia[0], startTime, endTime);
Assert.IsNotNull(availableSites);
Assert.IsTrue(availableSites.Count > 0);
testScope.Dispose();
}
public void DisplayMenu()
{
ParkSqlDAL parkDal = new ParkSqlDAL(_dbConnectionString);
List <Park> parks = parkDal.GetParks();
menus.MenuTitle("National Parks Reservation System");
bool exit = false;
while (!exit)
{
menus.MainMenu(parks);
string command = Console.ReadLine();
int selection;
if (command == "q" || command == "Q")
{
menus.QuitMenu();
exit = true;
}
else if (int.TryParse(command, out selection))
{
if (selection > 0 && selection <= parks.Count)
{
DisplayParkInfo(parks[selection - 1]);
}
}
else
{
menus.InvalidEntry();
}
Console.ReadKey();
Console.Clear();
}
}
public void TestCampgroundName()
{
TransactionScope testNames = new TransactionScope();
ParkSqlDAL parkDAL = new ParkSqlDAL(connectionString);
List <Park> park = parkDAL.GetParks();
CampgroundSqlDAL campgroundDAL = new CampgroundSqlDAL(connectionString);
List <Campground> testNamesOfCampsAcadia = campgroundDAL.GetAllCampgroundFromPark(park[0]);
List <Campground> testNamesOfCampsArches = campgroundDAL.GetAllCampgroundFromPark(park[1]);
List <Campground> testNamesOfCampsCuyahoga = campgroundDAL.GetAllCampgroundFromPark(park[2]);
//assert
bool outputArcadia_isCampNameCorrect1 = testNamesOfCampsAcadia[0].name == "Blackwoods";
Assert.IsTrue(outputArcadia_isCampNameCorrect1);
bool outputArcadia_isCampNameCorrect2 = testNamesOfCampsAcadia[2].name == "Schoodic Woods";
Assert.IsTrue(outputArcadia_isCampNameCorrect2);
bool outputArches_isCampNameCorrect1 = testNamesOfCampsAcadia[0].name == "Devil's Garden";
Assert.IsTrue(outputArches_isCampNameCorrect1);
bool outputArches_isCampNameCorrect2 = testNamesOfCampsAcadia[2].name == "Juniper Group Site";
Assert.IsTrue(outputArches_isCampNameCorrect2);
bool outputCuyahogaValley_isCampNameCorrect1 = testNamesOfCampsAcadia[2].name == "The Unnamed Primitive Campsites";
Assert.IsTrue(outputCuyahogaValley_isCampNameCorrect1);
testNames.Dispose();
}
