public void GetAvailableSitesParkwideTest()
{
// Arrange
Reservation reservation = new Reservation
{
Name = "Jeeyai Jhoe",
From_Date = DateTime.Now.AddDays(7),
To_Date = DateTime.Now.AddDays(12)
};
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
SqlCommand command = new SqlCommand(
@"SELECT park_id
FROM park
WHERE name = 'Casa de Jesse'",
connection);
connection.Open();
parkId = Convert.ToInt32(command.ExecuteScalar());
}
// Act and Assert
Assert.AreEqual(8, (dao.GetAvailableSitesParkwide(parkId, reservation).Count));
Assert.AreEqual(6, (dao.GetAvailableSitesParkwide(parkId, reservation)[1].Max_Occupancy));
}