public void GetCampgroundsForPark_ReturnsCorrectCampgrounds(string parkName, int expectedResult) { ICampgroundSqlDAO dao = new CampgroundSqlDAO(connectionString); Park testPark = new Park(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand($"SELECT * FROM park WHERE name = '{parkName}'", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { testPark.Park_ID = Convert.ToInt32(reader["park_id"]); testPark.Name = Convert.ToString(reader["name"]); testPark.Location = Convert.ToString(reader["location"]); testPark.Establish_date = Convert.ToDateTime(reader["establish_date"]); testPark.Area = Convert.ToInt32(reader["area"]); testPark.Visitors = Convert.ToInt32(reader["visitors"]); testPark.Description = Convert.ToString(reader["description"]); } } } catch (SqlException ex) { Console.WriteLine($"There was an error {ex.Message}."); } IList <Campground> campgroundList = dao.GetCampgroundsForPark(testPark); Assert.AreEqual(1, campgroundList.Count); }
public void GetTop5Sites_ReturnsSites(string parkName, int campgroundSelection, int expected) { ICampgroundSqlDAO campdao = new CampgroundSqlDAO(connectionString); ISiteSqlDAO sitedao = new SiteSqlDAO(connectionString); Park testPark = new Park(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand($"SELECT * FROM park WHERE name = '{parkName}'", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { testPark.Park_ID = Convert.ToInt32(reader["park_id"]); testPark.Name = Convert.ToString(reader["name"]); testPark.Location = Convert.ToString(reader["location"]); testPark.Establish_date = Convert.ToDateTime(reader["establish_date"]); testPark.Area = Convert.ToInt32(reader["area"]); testPark.Visitors = Convert.ToInt32(reader["visitors"]); testPark.Description = Convert.ToString(reader["description"]); } } } catch (SqlException ex) { Console.WriteLine($"There was an error {ex.Message}."); } IList <Campground> campgroundList = campdao.GetCampgroundsForPark(testPark); Campground campground = campgroundList.ElementAt(campgroundSelection - 1); IList <Site> siteList = sitedao.GetTop5SitesInCampground(campground, "06/19/2019", "06/20/2019"); Assert.AreEqual(expected, siteList.Count); }