/// <summary>
/// Calls database to return a list of Park View Models
/// </summary>
/// <returns></returns>
public List <ParksHomeViewModel> GetParks()
{
List <ParksHomeViewModel> parks = new List <ParksHomeViewModel>();
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select parkCode, parkName, parkDescription from park";
cmd.Connection = conn;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ParksHomeViewModel park = new ParksHomeViewModel()
{
ParkCode = (string)reader["parkCode"],
Name = (string)reader["parkName"],
Description = (string)reader["parkDescription"]
};
parks.Add(park);
}
}
return(parks);
}
public void GetParks()
{
IParksDAL dal = new ParksSqlDAL(connectionString);
List <ParksHomeViewModel> parks = dal.GetParks();
bool tag = false;
ParksHomeViewModel test = new ParksHomeViewModel();
foreach (var park in parks)
{
if (park.Name == "TEST")
{
test = park;
tag = true;
}
}
Assert.IsTrue(tag);
Assert.AreEqual("TEST", test.ParkCode, "Park code");
Assert.AreEqual("TEST", test.Description, "Description");
}
