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); }