public void t_SamplingPointMapper_Save_Insert() { loadASite(); SamplingPoint site = new SamplingPoint() { GeoCoordinate = new Business.DataTypes.Coordinate() { Latitude = new Business.DataTypes.Degree() { Value = 56.789M }, Longitude = new Business.DataTypes.Degree() { Value = 67.281M } }, Id = TestHelper.TestGuid1, Name = "Site Name", SiteId = TestHelper.TestParentGuid }; SamplingPointMapper.Insert(site); using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var siteQuery = from sites in iba.SamplingPoint_ado select sites; Assert.IsNotNull(siteQuery, "Query result is null"); Assert.AreEqual(1, siteQuery.Count(), "Wrong number of results in query"); SamplingPoint_ado adoSite = siteQuery.First(); validateObjectEquality(site, adoSite); } }
public void t_SamplingPointMapper_Save_Update() { Location_ado location = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { location = Location_ado.CreateLocation_ado(TestHelper.TestGuid1, "locationName", LookupConstants.LocationTypePoint); location.CodeName = "abc"; location.Latitude = 89.3M; location.Longitude = 90.10093M; location.ParentLocationId = TestHelper.TestParentGuid; iba.AddToLocation_ado(location); }); List <Location_ado> extraList = DbTestHelper.LoadExtraneousLocations(); // Setup object to be saved. Change everything except the Id. SamplingPoint site = new SamplingPoint() { GeoCoordinate = new Business.DataTypes.Coordinate() { Latitude = new Business.DataTypes.Degree() { Value = location.Latitude.Value + 1M }, Longitude = new Business.DataTypes.Degree() { Value = location.Longitude.Value + 1M } }, Id = location.LocationId, Name = location.LocationName + "asd", SiteId = TestHelper.TestParentGuid }; // Execute the test SamplingPointMapper.Update(site); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var siteQuery = from sites in iba.SamplingPoint_ado select sites; Assert.IsNotNull(siteQuery, "Query result is null"); Assert.AreEqual(extraSamplingPoints(extraList).Count() + 1, siteQuery.Count(), "Wrong number of results in query"); SamplingPoint_ado adoSite = siteQuery.First(x => x.LocationId == TestHelper.TestGuid1); validateObjectEquality(site, adoSite); // double check the other objects as well, must make sure they remain unchanged. foreach (Location_ado adoLocation in extraSamplingPoints(extraList)) { adoSite = siteQuery.First(x => x.LocationId == adoLocation.LocationId); Assert.IsNotNull(adoSite, "There is no longer an object with id " + adoLocation.LocationId.ToString()); Assert.AreEqual(adoLocation.Latitude, adoSite.Latitude, "Extra " + adoSite.LocationId.ToString() + " Latitude mismatch"); Assert.AreEqual(adoLocation.Longitude, adoSite.Longitude, "Extra " + adoSite.LocationId.ToString() + " Longitude mismatch"); Assert.AreEqual(adoSite.LocationName, adoSite.LocationName, "Extra " + adoSite.LocationId.ToString() + " Locationname mismatch"); } } }
public void t_SamplingPointMapper_Delete() { Location_ado location = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { location = Location_ado.CreateLocation_ado(TestHelper.TestParentGuid, "locationName", LookupConstants.LocationTypeSite); location.CodeName = "abc"; location.Latitude = 89.3M; location.Longitude = 90.10093M; location.ParentLocationId = null; iba.AddToLocation_ado(location); }); Location_ado pointAdo = null; DbTestHelper.LoadAdoObjects((IbaUnitTestEntities iba) => { pointAdo = Location_ado.CreateLocation_ado(TestHelper.TestGuid1, "pointName", LookupConstants.LocationTypePoint); location.ParentLocationId = TestHelper.TestParentGuid; iba.AddToLocation_ado(pointAdo); }); List <Location_ado> extraList = DbTestHelper.LoadExtraneousLocations(); SamplingPoint point = new SamplingPoint() { Id = TestHelper.TestGuid1, SiteId = TestHelper.TestParentGuid }; // Exercise the system under test SamplingPointMapper.Delete(point); // Validate that the one record was deleted but none others were using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var pointQuery = from points in iba.Location_ado select points; Assert.IsNotNull(pointQuery, "Query result is null"); Assert.AreEqual(0, pointQuery.Count(x => x.LocationId == point.Id), "Point wasn't deleted"); // Check to see if extra points and locations are still in the database foreach (Location_ado extra in extraList) { Assert.AreEqual(1, pointQuery.Count(x => x.LocationId == extra.LocationId), "Location " + extra.LocationId.ToString() + " is no longer in the database."); } Assert.AreEqual(1, pointQuery.Count(x => x.LocationId == location.LocationId), "Parent was deleted"); } }
public void t_SamplingPointMapper_Select_All() { // Backdoor setup List <Location_ado> list = DbTestHelper.LoadExtraneousLocations(); List <Location_ado> siteAdoList = extraSamplingPoints(list); // Exercise the test List <SamplingPoint> siteList = SamplingPointMapper.SelectAll(); // Validate results Assert.AreEqual(siteAdoList.Count(), siteList.Count, "Wrong number of objects in the result list"); foreach (Location_ado ado in siteAdoList) { // just check to make sure the object is there; leave specific value check for the Select_ByGuid test Assert.IsTrue(siteList.Exists(x => x.Id.Equals(ado.LocationId)), "Location " + ado.LocationId.ToString() + " is not in the results"); } }
public void t_SamplingPointMapper_Select_ByGuid() { Location_ado location = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { location = Location_ado.CreateLocation_ado(TestHelper.TestGuid1, "locationName", LookupConstants.LocationTypePoint); location.Latitude = 89.3M; location.Longitude = 90.10093M; location.ParentLocationId = TestHelper.TestParentGuid; iba.AddToLocation_ado(location); }); DbTestHelper.LoadExtraneousLocations(); // Exercise the test SamplingPoint site = SamplingPointMapper.Select(location.LocationId); validateResults(location, site); }