public void Get_Campgrounds()
{
int one;
string campgroundName;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (SqlCommand commandFive = new SqlCommand(@"(SELECT park_id FROM park WHERE name = 'Franklin')", connection))
{
one = (int)commandFive.ExecuteScalar();
}
using (SqlCommand commandSix = new SqlCommand(@"(SELECT name FROM campground WHERE name = 'Blackwoods')", connection))
{
campgroundName = (string)commandSix.ExecuteScalar();
}
}
IList <Campground> blackwoodsCamp = daoC.GetCampgrounds(one);
// Assert
Assert.AreEqual(1, blackwoodsCamp.Count);
Assert.AreEqual(campgroundName, blackwoodsCamp[0].Name);
Assert.AreEqual(one, blackwoodsCamp[0].Park_Id);
}
public void GetCampgrounds_ShouldReturn_List_Of_CampgroundModels_Based_On_Park()
{
CampgroundSqlDAO dao = new CampgroundSqlDAO(base.ConnectionString);
IList <CampgroundModel> campgrounds = dao.GetCampgrounds(base.ParkId);
Assert.AreEqual(base.CampgroundCount, campgrounds.Count);
}
public void GetAllCampgroundsTest_ShouldReturnZero_When_ParkId_IsNot_Valid()
{
CampgroundSqlDAO dao = new CampgroundSqlDAO(ConnectionString);
IList <Campground> campgrounds = dao.GetCampgrounds(9999999999);
Assert.AreEqual(0, campgrounds.Count);
}
public void GetAllCampgroundsTest_ShouldReturnAllCampgrounds()
{
CampgroundSqlDAO dao = new CampgroundSqlDAO(ConnectionString);
IList <Campground> campgrounds = dao.GetCampgrounds(ParkId);
Assert.AreEqual(1, campgrounds.Count);
}
public void easy_campground_default_values_test()
{
IList <Campground> actualCampgrounds = dao.GetCampgrounds("1");
Assert.AreEqual("Test Name", actualCampgrounds[0].Name);
Assert.AreEqual("January", actualCampgrounds[0].OpenFromMm);
Assert.AreEqual("December", actualCampgrounds[0].OpenToMm);
Assert.AreEqual(30, actualCampgrounds[0].DailyFee);
}
public void GetCampgroundsTest()
{
//Arrange
CampgroundSqlDAO dao = new CampgroundSqlDAO(ConnectionString);
//Act
IList <Campground> campGrounds = dao.GetCampgrounds();
//Assert
Assert.AreEqual(3, campGrounds.Count);
}
public void GetCampgroundsTest()
{
// Arrange
CampgroundSqlDAO dao = new CampgroundSqlDAO(connectionString);
// Act
IList <Campground> actual = dao.GetCampgrounds(lastParkId);
// Assert
Assert.AreEqual(1, actual.Count);
}
public void GetCampgroundTest()
{
// Arrange
int parkId;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
SqlCommand command = new SqlCommand(
"SELECT park_id FROM campground",
connection);
connection.Open();
parkId = Convert.ToInt32(command.ExecuteScalar());
}
// Act and Assert
Assert.AreEqual(2, (dao.GetCampgrounds(parkId).Count));
Assert.AreEqual("January", (dao.GetCampgrounds(parkId)[0].Open_From_MM));
Assert.AreEqual("April", (dao.GetCampgrounds(parkId)[1].Open_From_MM));
}
public void ConstructsCampgroundProperly()
{
//assign
CampgroundSqlDAO campgroundSqlDAO = new CampgroundSqlDAO(ConnectionString);
IList <Campground> campgrounds = campgroundSqlDAO.GetCampgrounds();
//assert
Assert.AreEqual(TwinPeaksParkId, campgrounds[0].Park_Id);
Assert.AreEqual("Black Lodge", campgrounds[0].Name);
Assert.AreEqual(01, campgrounds[0].Open_From);
Assert.AreEqual(09, campgrounds[0].Open_To);
Assert.AreEqual(420.00M, campgrounds[0].Daily_fee);
}
public void TestGetCampgrounds()
{
// arrange
CampgroundSqlDAO dao = new CampgroundSqlDAO(connectionString);
// act
IList <Campground> actualResult = dao.GetCampgrounds(parkId);
// assert
Assert.AreEqual(1, actualResult.Count);
Assert.AreEqual("Camp Brandon", actualResult[0].Name);
Assert.AreEqual(3, actualResult[0].OpenMonth);
Assert.AreEqual(9, actualResult[0].CloseMonth);
Assert.AreEqual(1000000, actualResult[0].DailyFee);
}
public void GetCampgrounds()
{
IList <Campground> campgrounds = dao.GetCampgrounds(1);
Assert.AreEqual(1, campgrounds.Count);
}
