public override void Setup()
{
// Arrange
base.Setup();
dao = new ParkSqlDAO(ConnectionString);
//Add a test park
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
SqlCommand command = new SqlCommand(
"INSERT INTO park (name, location, establish_date, area, visitors, description) VALUES ('Acadia', 'Ohio', '2010-01-01', '120', '120', 'Park'); SELECT SCOPE_IDENTITY()",
connection);
connection.Open();
newParkId = Convert.ToInt32(command.ExecuteScalar());
}
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
SqlCommand command = new SqlCommand(
"INSERT INTO park (name, location, establish_date, area, visitors, description) VALUES ('Arches', 'Ohio', '2010-01-01', '120', '120', 'Park'); SELECT SCOPE_IDENTITY()",
connection);
connection.Open();
newParkId = Convert.ToInt32(command.ExecuteScalar());
}
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
SqlCommand command = new SqlCommand(
"INSERT INTO park (name, location, establish_date, area, visitors, description) VALUES ('Cuyahoga Valley', 'Ohio', '2010-01-01', '120', '120', 'Park'); SELECT SCOPE_IDENTITY()",
connection);
connection.Open();
newParkId = Convert.ToInt32(command.ExecuteScalar());
}
}
public void TestGetParks()
{
//Arrange
ParkSqlDAO dao = new ParkSqlDAO(connectionString);
//Act
IList <Park> parks = dao.GetAllParks();
int i = 0;
for (; i < parks.Count; i++)
{
if (parks[i].ParkId == newParkId)
{
break;
}
}
//Assert
Assert.AreEqual(2, parks.Count);
Assert.AreEqual("Mount Rushmore", parks[i].Name);
}
public override void Setup()
{
base.Setup();
dao = new ParkSqlDAO(ConnectionString);
}