public void t_PointCountBeyond50_DeleteTopX() { Guid eventId = TestHelper.TestGuid1; Guid speciesId = new Guid(TestHelper.SPECIES_2_ID); string speciesCode = TestHelper.SPECIES_2_CODE; Guid observationTypeId1 = LookupConstants.ObservationTypePointLess50m; Guid observationTypeId2 = LookupConstants.ObservationTypeSupplemental; DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { Observation_ado obs1 = Observation_ado.CreateObservation_ado(0, eventId, speciesId, observationTypeId1); iba.AddToObservation_ado(obs1); Observation_ado ob2 = Observation_ado.CreateObservation_ado(0, eventId, speciesId, observationTypeId1); iba.AddToObservation_ado(ob2); Observation_ado obs3 = Observation_ado.CreateObservation_ado(0, eventId, speciesId, observationTypeId1); iba.AddToObservation_ado(obs3); Observation_ado obs4 = Observation_ado.CreateObservation_ado(0, eventId, speciesId, observationTypeId2); iba.AddToObservation_ado(obs4); }); ObservationMapper.DeleteTopX(eventId, observationTypeId1, speciesCode, 2); using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var observationQuery = from observations in iba.Observation_ado select observations; Assert.IsNotNull(observationQuery, "observationQuery is null"); Assert.AreEqual(2, observationQuery.Count(), "observationQuery has wrong count"); Assert.AreEqual(1, observationQuery.Count(x => x.ObservationTypeId.Equals(observationTypeId1)), "wrong count for type 1"); Assert.AreEqual(1, observationQuery.Count(x => x.ObservationTypeId.Equals(observationTypeId2)), "wrong count for type 2"); } }
public void t_Site_Delete() { Location_ado location = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { location = Location_ado.CreateLocation_ado(new Guid("87606168-3ac7-402a-8ae6-4f6905555581"), "locationName", LookupConstants.LocationTypeSite); location.CodeName = "abc"; location.Latitude = 89.3M; location.Longitude = 90.10093M; location.ParentLocationId = null; iba.AddToLocation_ado(location); }); List <Location_ado> locationlist = DbTestHelper.LoadExtraneousLocations(); SiteMapper.Delete(new Site() { Id = location.LocationId }); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var siteQuery = from sites in iba.Site_ado select sites; Assert.IsNotNull(siteQuery, "Query result is null"); Assert.AreEqual(extraSites(locationlist).Count(), siteQuery.Count(), "Wrong number of results in query"); validateExtraLocations(locationlist, siteQuery); } }
public void t_PointCountLess50_Delete() { Observation_ado setupObject = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = new Observation_ado() { Comments = "asdfasdf asdf adsfa dsfads fasdf adsfasd fadsf awefr34fr34r34 ", SpeciesId = new Guid(TestHelper.SPECIES_1_ID), EventId = TestHelper.TestGuid1, ObservationTypeId = _PointCountLess50TypeId }; iba.AddToObservation_ado(setupObject); }); List <Observation_ado> Observationlist = DbTestHelper.LoadExtraneousObservations(TestHelper.TestGuid3); ObservationMapper.Delete(new PointCountWithin50() { Id = setupObject.ObservationId }); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var PointCountLess50Query = from PointCountLess50s in iba.Observation_ado select PointCountLess50s; Assert.IsNotNull(PointCountLess50Query, "Query result is null"); Assert.AreEqual(Observationlist.Count(), PointCountLess50Query.Count(), "Wrong number of results in query"); validateExtraObservations(Observationlist, PointCountLess50Query); } }
public void t_Species_Delete() { Species_ado setupObject = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = Species_ado.CreateSpecies_ado(TestHelper.TestGuid1, "a1", 1, true); setupObject.CommonName = "asdf@adfasd"; setupObject.ScientificName = "(651) 646-8007"; iba.AddToSpecies_ado(setupObject); }); List <Species_ado> personAdolist = DbTestHelper.LoadExtraneousSpecies(); SpeciesMapper.Delete(new Species() { Id = setupObject.SpeciesId }); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var SpeciesQuery = from Speciess in iba.Species_ado select Speciess; Assert.IsNotNull(SpeciesQuery, "Query result is null"); Assert.AreEqual(personAdolist.Count(), SpeciesQuery.Count(), "Wrong number of results in query"); validateExtrapersonAdos(personAdolist, SpeciesQuery); } }
public void t_PointCountLess50_Select_ByEventId() { Guid pointSurveyId = TestHelper.TestGuid2; DbTestHelper.LoadSinglePointSurvey(pointSurveyId, TestHelper.TestGuid2, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1)); Observation_ado setupObject = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = new Observation_ado() { Comments = "asdfasdf asdf adsfa dsfads fasdf adsfasd fadsf awefr34fr34r34 ", SpeciesId = new Guid(TestHelper.SPECIES_1_ID), EventId = pointSurveyId, ObservationTypeId = _PointCountLess50TypeId }; iba.AddToObservation_ado(setupObject); }); DbTestHelper.LoadExtraneousObservations(TestHelper.TestGuid3); // Exercise the test List <PointCountWithin50> selectList = ObservationMapper.SelectAllForEvent <PointCountWithin50>(setupObject.EventId); Assert.AreEqual(1, selectList.Count(), "Does not contain just one object"); PointCountWithin50 result = selectList[0]; using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { validateObjectEquality(result, setupObject, iba); } }
public void t_Conditions_Select_BySiteVisitId() { SiteCondition_ado conditionAdo = SiteCondition_ado.CreateSiteCondition_ado(TestHelper.TestGuid1, 32, "F", 2, 3, TestHelper.TestParentGuid); // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { iba.AddToSiteCondition_ado(conditionAdo); }); SiteCondition_ado conditionAdo2 = SiteCondition_ado.CreateSiteCondition_ado(TestHelper.TestGuid2, 32, "F", 2, 3, TestHelper.TestParentGuid); DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { iba.AddToSiteCondition_ado(conditionAdo2); }); // Exercise the test List <SiteCondition> conditions = ConditionsMapper.Select_BySiteVisitId(TestHelper.TestParentGuid); SiteCondition cond = conditions.First(x => x.Id == conditionAdo.ConditionId); validateResults(conditionAdo, cond); cond = conditions.First(x => x.Id == conditionAdo2.ConditionId); validateResults(conditionAdo2, cond); }
public void t_PointSurvey_Delete() { PointSurvey_ado setupObject = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = PointSurvey_ado.CreatePointSurvey_ado(TestHelper.TestGuid3, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddMinutes(5)); setupObject.NoiseCode = 0; setupObject.SiteVisitId = TestHelper.TestGuid1; iba.AddToPointSurvey_ado1(setupObject); }); List <PointSurvey_ado> PointSurveyAdolist = DbTestHelper.LoadExtraneousPointSurveys(); PointSurveyMapper.Delete(new FiftyMeterPointSurvey() { Id = setupObject.EventId }); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var PointSurveyQuery = from PointSurveys in iba.PointSurvey_ado1 select PointSurveys; Assert.IsNotNull(PointSurveyQuery, "Query result is null"); Assert.AreEqual(PointSurveyAdolist.Count(), PointSurveyQuery.Count(), "Wrong number of results in query"); validateExtraPointSurveyAdos(PointSurveyAdolist, PointSurveyQuery); } }
public void t_SiteVisit_Delete() { SiteVisit_ado setupObject = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = SiteVisit_ado.CreateSiteVisit_ado(TestHelper.TestGuid1, true, TestHelper.TestGuid2, DateTime.Now, DateTime.Now.AddHours(2), TestHelper.TestGuid3); setupObject.ObserverId = TestHelper.TestGuid4; setupObject.RecorderId = TestHelper.TestGuid3; setupObject.Comments = "asdf asdfasdf"; iba.AddToSiteVisit_ado1(setupObject); }); List <SiteVisit_ado> SiteVisitAdolist = DbTestHelper.LoadExtraneousSiteVisits(); SiteVisitMapper.Delete(new SiteVisit() { Id = setupObject.EventId }); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var SiteVisitQuery = from SiteVisits in iba.SiteVisit_ado1 select SiteVisits; Assert.IsNotNull(SiteVisitQuery, "Query result is null"); Assert.AreEqual(SiteVisitAdolist.Count(), SiteVisitQuery.Count(), "Wrong number of results in query"); validateExtraSiteVisitAdos(SiteVisitAdolist, SiteVisitQuery); } }
public void t_GetBoundaries_WrongSite() { List <Location_ado> extraList = DbTestHelper.LoadExtraneousLocations(); SiteBoundary boundary1 = new SiteBoundary() { SiteId = extraList[0].LocationId, Latitude = 1.02m, Longitude = 3.456m, VertexSequence = 1 }; SiteBoundary boundary2 = new SiteBoundary() { SiteId = extraList[1].LocationId, Latitude = -7.8m, Longitude = 90.12m, VertexSequence = 2 }; DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { iba.AddToSiteBoundaries(boundary2); iba.AddToSiteBoundaries(boundary1); }); // using site 1 Site results = new Site() { Id = extraList[0].LocationId }; SiteMapper.GetBoundaries(results); Assert.IsNotNull(results.Boundaries, "results are null"); Assert.AreEqual(1, results.Boundaries.Count(), "wrong count"); Coordinate coord = results.Boundaries.Dequeue(); Assert.AreEqual(boundary1.Latitude, coord.Latitude.Value, "lat 1"); Assert.AreEqual(boundary1.Longitude, coord.Longitude.Value, "long 1"); }
public void t_PointCountLess50_Select_ByGuid() { Observation_ado setupObject = null; // backdoor data setup Guid pointSurveyId = TestHelper.TestGuid3; DbTestHelper.LoadSinglePointSurvey(pointSurveyId, TestHelper.TestGuid2, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1)); DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = new Observation_ado() { Comments = "asdfasdf asdf adsfa dsfads fasdf adsfasd fadsf awefr34fr34r34 ", SpeciesId = new Guid(TestHelper.SPECIES_1_ID), EventId = pointSurveyId, ObservationTypeId = _PointCountLess50TypeId }; iba.AddToObservation_ado(setupObject); }); DbTestHelper.LoadExtraneousObservations(TestHelper.TestGuid3); // Exercise the test PointCountWithin50 PointCountLess50 = ObservationMapper.Select <PointCountWithin50>(setupObject.ObservationId); using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { validateObjectEquality(PointCountLess50, setupObject, iba); } }
public void t_Person_Delete() { Person_ado personAdo = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { personAdo = Person_ado.CreatePerson_ado(TestHelper.TestGuid1, "First Name", "Last Name", 1, 2, true, true); personAdo.EmailAddress = "asdf@adfasd"; personAdo.PhoneNumber = "(651) 646-8007"; iba.AddToPerson_ado(personAdo); }); List <Person_ado> personAdolist = DbTestHelper.LoadExtraneousPersons(); PersonMapper.Delete(new Person() { Id = personAdo.PersonId }); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var PersonQuery = from Persons in iba.Person_ado select Persons; Assert.IsNotNull(PersonQuery, "Query result is null"); Assert.AreEqual(personAdolist.Count(), PersonQuery.Count(), "Wrong number of results in query"); validateExtrapersonAdos(personAdolist, PersonQuery); } }
public void t_Person_Select_ByGuid() { Person_ado personAdo = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { personAdo = Person_ado.CreatePerson_ado(TestHelper.TestGuid1, "First Name", "Last Name", 1, 2, true, true); personAdo.EmailAddress = "asdf@adfasd"; personAdo.PhoneNumber = "(651) 646-8007"; personAdo.Address1 = "address1"; personAdo.Address2 = "asddress 2"; personAdo.City = "city"; personAdo.Country = "cou "; personAdo.HasBeenTrained = true; personAdo.HasClipboard = true; personAdo.OpenId = "httP;//www.googl.ecom/asdf.adsfae"; personAdo.PersonRole = 1; personAdo.PersonStatus = 2; personAdo.State = "TX"; personAdo.ZipCode = "55555"; iba.AddToPerson_ado(personAdo); }); List <Person_ado> extraList = DbTestHelper.LoadExtraneousPersons(); // Exercise the test Person Person = PersonMapper.Select(personAdo.PersonId); validateResults(personAdo, Person); }
private static void loadObservations(List <Observation_ado> obsList) { DbTestHelper.LoadAdoObjects((IbaUnitTestEntities iba) => { obsList.ForEach(x => iba.AddToObservation_ado(x)); iba.SaveChanges(); }); }
private void loadASite() { DbTestHelper.LoadAdoObjects((IbaUnitTestEntities iba) => { Location_ado site = Location_ado.CreateLocation_ado(TestHelper.TestParentGuid, "Parent", LookupConstants.LocationTypeSite); iba.AddToLocation_ado(site); }); }
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_Site_Save_Update() { Location_ado location = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { location = Location_ado.CreateLocation_ado(TestHelper.TestGuid1, "locationName", LookupConstants.LocationTypeSite); location.CodeName = "abc"; location.Latitude = 89.3M; location.Longitude = 90.10093M; location.ParentLocationId = null; iba.AddToLocation_ado(location); }); List <Location_ado> extraList = DbTestHelper.LoadExtraneousLocations(); // Setup object to be saved. Change everything except the Id. Site site = new Site() { CodeName = location.CodeName + "a", 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" }; // Execute the test SiteMapper.Update(site); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var siteQuery = from sites in iba.Site_ado select sites; Assert.IsNotNull(siteQuery, "Query result is null"); Assert.AreEqual(extraSites(extraList).Count() + 1, siteQuery.Count(), "Wrong number of results in query"); Site_ado adoSite = siteQuery.First(x => x.LocationId == TestHelper.TestGuid1); validateObjectEquality(site, adoSite); validateExtraLocations(extraList, siteQuery); } }
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_Conditions_Save_Update() { SiteCondition_ado conditionAdo = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { conditionAdo = SiteCondition_ado.CreateSiteCondition_ado(TestHelper.TestGuid1, 32, "F", 2, 3, TestHelper.TestParentGuid); }); List <SiteCondition_ado> extraList = DbTestHelper.LoadExtraneousConditions(); // Setup object to be saved. Change everything except the Id. SiteCondition conditions = new SiteCondition() { Id = TestHelper.TestGuid1, SiteVisitId = TestHelper.TestGuid1, Sky = 2, Temperature = new Business.DataTypes.Temperature() { Value = 45, Units = "F" }, Wind = 2 }; // Execute the test ConditionsMapper.Update(conditions); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var ConditionsQuery = from Conditionss in iba.SiteCondition_ado select Conditionss; Assert.IsNotNull(ConditionsQuery, "Query result is null"); Assert.AreEqual(extraList.Count() + 1, ConditionsQuery.Count(), "Wrong number of results in query"); SiteCondition_ado adoConditions = ConditionsQuery.First(x => x.ConditionId == TestHelper.TestGuid1); validateObjectEquality(conditions, adoConditions); // double check the other objects as well, must make sure they remain unchanged. foreach (SiteCondition_ado cond in extraList) { SiteCondition_ado posttest = ConditionsQuery.First(x => x.ConditionId == cond.ConditionId); Assert.IsNotNull(posttest, cond.ConditionId.ToString() + " is missing from results"); Assert.AreEqual(cond.Scale, posttest.Scale, cond.ConditionId.ToString() + " different scale"); Assert.AreEqual(cond.SiteVisitId, posttest.SiteVisitId, cond.ConditionId.ToString() + " different SiteVisitId"); Assert.AreEqual(cond.Sky, posttest.Sky, cond.ConditionId.ToString() + " different sky"); Assert.AreEqual(cond.Temperature, posttest.Temperature, cond.ConditionId.ToString() + " different temperature"); Assert.AreEqual(cond.Wind, posttest.Wind, cond.ConditionId.ToString() + " different wind"); } } }
public void t_Conditions_Select_ByGuid() { SiteCondition_ado conditionAdo = SiteCondition_ado.CreateSiteCondition_ado(TestHelper.TestGuid1, 32, "F", 2, 3, TestHelper.TestParentGuid); // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { iba.AddToSiteCondition_ado(conditionAdo); }); DbTestHelper.LoadExtraneousConditions(); // Exercise the test SiteCondition Conditions = ConditionsMapper.Select(conditionAdo.ConditionId); validateResults(conditionAdo, Conditions); }
public void t_SiteVisit_Save_Update() { SiteVisit_ado setupObject = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = SiteVisit_ado.CreateSiteVisit_ado(TestHelper.TestGuid1, true, TestHelper.TestGuid2, DateTime.Now, DateTime.Now.AddHours(2), TestHelper.TestGuid3); setupObject.ObserverId = TestHelper.TestGuid4; setupObject.RecorderId = TestHelper.TestGuid3; setupObject.Comments = "asdf asdfasdf"; iba.AddToSiteVisit_ado1(setupObject); }); List <SiteVisit_ado> extraList = DbTestHelper.LoadExtraneousSiteVisits(); // Setup object to be saved. Change everything except the Id. SiteVisit toSave = new SiteVisit() { Id = setupObject.EventId, EndTimeStamp = setupObject.EndTime.AddHours(1), IsDataEntryComplete = false, LocationId = TestHelper.TestGuid4, ObserverId = TestHelper.TestGuid3, RecorderId = TestHelper.TestGuid2, StartTimeStamp = setupObject.StartTime.AddHours(0.5), Comments = "asdf asdfa sdf asdfasdfasdf" }; // Execute the test SiteVisitMapper.Update(toSave); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var SiteVisitQuery = from SiteVisits in iba.SiteVisit_ado1 select SiteVisits; Assert.IsNotNull(SiteVisitQuery, "Query result is null"); Assert.AreEqual(extraList.Count() + 1, SiteVisitQuery.Count(), "Wrong number of results in query"); SiteVisit_ado adoSiteVisit = SiteVisitQuery.First(x => x.EventId == TestHelper.TestGuid1); validateObjectEquality(toSave, adoSiteVisit); validateExtraSiteVisitAdos(extraList, SiteVisitQuery); } }
public void t_PointCountLess50_Save_Update() { //loadSiteVisit(TestHelper.TestGuid1); Observation_ado setupObject = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = new Observation_ado() { Comments = "asdfasdf asdf adsfa dsfads fasdf adsfasd fadsf awefr34fr34r34 ", SpeciesId = new Guid(TestHelper.SPECIES_1_ID), EventId = TestHelper.TestGuid1, ObservationTypeId = _PointCountLess50TypeId }; iba.AddToObservation_ado(setupObject); }); List <Observation_ado> extraList = DbTestHelper.LoadExtraneousObservations(TestHelper.TestGuid3); // Setup object to be saved. Change everything except the Id. PointCountWithin50 testObject = new PointCountWithin50() { Comments = "hurdy gurdy", SpeciesCode = TestHelper.SPECIES_2_CODE, EventId = setupObject.EventId, Id = setupObject.ObservationId }; // Execute the test ObservationMapper.Update(testObject); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var PointCountLess50Query = from PointCountLess50s in iba.Observation_ado select PointCountLess50s; Assert.IsNotNull(PointCountLess50Query, "Query result is null"); Assert.AreEqual(extraList.Count() + 1, PointCountLess50Query.Count(), "Wrong number of results in query"); Observation_ado adoPointCountLess50 = PointCountLess50Query.First(x => x.ObservationId == setupObject.ObservationId); validateObjectEquality(testObject, adoPointCountLess50, iba); validateExtraObservations(extraList, PointCountLess50Query); } }
public void t_Species_Select() { Species_ado setupObject = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = Species_ado.CreateSpecies_ado(TestHelper.TestGuid1, "a1", 1, true); setupObject.CommonName = "asdf@adfasd"; setupObject.ScientificName = "(651) 646-8007"; iba.AddToSpecies_ado(setupObject); }); List <Species_ado> extraList = DbTestHelper.LoadExtraneousSpecies(); // Exercise the test Species testObject = SpeciesMapper.Select(setupObject.SpeciesId); validateObjectEquality(testObject, setupObject); }
private void setupOakwood() { Location_ado site = Location_ado.CreateLocation_ado(TestHelper.TestGuid1, OAKWOOD, LookupConstants.LocationTypeSite); Location_ado point = Location_ado.CreateLocation_ado(TestHelper.TestGuid2, "Point", LookupConstants.LocationTypePoint); point.ParentLocationId = site.LocationId; SiteVisit_ado visit = DbTestHelper.LoadSingleSiteVisit(TestHelper.TestGuid1, site.LocationId, DateTime.Now.AddHours(-7)); PointSurvey_ado survey = PointSurvey_ado.CreatePointSurvey_ado(TestHelper.TestGuid2, point.LocationId, DateTime.Now.AddHours(-7), DateTime.Now.AddHours(-6)); survey.SiteVisitId = visit.EventId; DbTestHelper.LoadAdoObjects((IbaUnitTestEntities iba) => { iba.AddToPointSurvey_ado1(survey); iba.AddToLocation_ado(site); iba.AddToLocation_ado(point); iba.SaveChanges(); }); List <Observation_ado> obsList = new List <Observation_ado>(); addABunchOfObservations(obsList, 35, List[0].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 26, List[1].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 21, List[2].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 16, List[3].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 11, List[4].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 6, List[5].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 5, List[6].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 3, List[7].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 3, List[8].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 3, List[9].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 3, List[10].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 3, List[11].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 2, List[12].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 2, List[13].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 2, List[14].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 1, List[15].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 1, List[16].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 1, List[17].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 1, List[18].SpeciesId, survey.EventId); addABunchOfObservations(obsList, 25, List[19].SpeciesId, survey.EventId); loadObservations(obsList); }
public void t_SelectAllForEvent_SiteVisit() { Guid siteVisitid = DbTestHelper.TestGuid3; DbTestHelper.LoadSingleSiteVisit(siteVisitid); Guid eventId = DbTestHelper.TestGuid1; Guid eventId2 = DbTestHelper.TestGuid2; Guid speciesId1 = new Guid(DbTestHelper.SPECIES_1_ID); Guid speciesId2 = new Guid(DbTestHelper.SPECIES_2_ID); string speciesCode1 = DbTestHelper.SPECIES_1_CODE; string speciesCode2 = DbTestHelper.SPECIES_2_CODE; string comments1 = string.Empty; string comments2 = "comments 2"; DbTestHelper.LoadAdoObjects((IbaUnitTestEntities iba) => { PointSurvey_ado survey1 = PointSurvey_ado.CreatePointSurvey_ado(eventId, true, DbTestHelper.TestGuid2, DateTime.Now, DateTime.Now.AddHours(2)); survey1.SiteVisitId = siteVisitid; iba.AddToPointSurvey_ado1(survey1); PointSurvey_ado survey2 = PointSurvey_ado.CreatePointSurvey_ado(eventId2, true, DbTestHelper.TestGuid2, DateTime.Now, DateTime.Now.AddHours(2)); survey2.SiteVisitId = siteVisitid; iba.AddToPointSurvey_ado1(survey2); }); multiBackdoorSetup(eventId, speciesId1, speciesId2, comments1, comments2); multiBackdoorSetup(eventId2, speciesId1, speciesId2, comments1, comments2); // Run the system List<FiftyMeterDataEntry> entryList = FiftyMeterDataEntryMapper.SelectAllForEvent(siteVisitid); // Validate results Assert.IsNotNull(entryList, "entrylist is null"); Assert.AreEqual(4, entryList.Count(), "entrylist does not contain 4 objects"); // TODO: need to make sure the grouping handles different PointSurveyId values, separating them appropriately. ValidateFiftyMeterDataEntryObject(eventId, comments1, entryList, "1", 0, 1, speciesCode1); ValidateFiftyMeterDataEntryObject(eventId, comments2, entryList, "2", 2, 1, speciesCode2); ValidateFiftyMeterDataEntryObject(eventId2, comments1, entryList, "1", 0, 1, speciesCode1); ValidateFiftyMeterDataEntryObject(eventId2, comments2, entryList, "2", 2, 1, speciesCode2); }
public void t_PointSurvey_Select_ByGuid() { PointSurvey_ado setupObject = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = PointSurvey_ado.CreatePointSurvey_ado(TestHelper.TestGuid3, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddMinutes(5)); setupObject.NoiseCode = 0; setupObject.SiteVisitId = TestHelper.TestGuid1; iba.AddToPointSurvey_ado1(setupObject); }); List <PointSurvey_ado> extraList = DbTestHelper.LoadExtraneousPointSurveys(); // Exercise the test FiftyMeterPointSurvey resultObject = PointSurveyMapper.Select(setupObject.EventId); validateObjectEquality(resultObject, setupObject); }
public void t_SiteVisit_Select_ByGuid() { SiteVisit_ado setupObject = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = SiteVisit_ado.CreateSiteVisit_ado(TestHelper.TestGuid1, true, TestHelper.TestGuid2, DateTime.Now, DateTime.Now.AddHours(2), TestHelper.TestGuid3); setupObject.ObserverId = TestHelper.TestGuid4; setupObject.RecorderId = TestHelper.TestGuid3; setupObject.Comments = "asdf asdfasdf"; iba.AddToSiteVisit_ado1(setupObject); }); List <SiteVisit_ado> extraList = DbTestHelper.LoadExtraneousSiteVisits(); // Exercise the test SiteVisit resultObject = SiteVisitMapper.Select(setupObject.EventId); validateObjectEquality(resultObject, setupObject); }
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); }
private static void multiBackdoorSetup(Guid eventId, Guid speciesId1, Guid speciesId2, string comments1, string comments2) { DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { Observation_ado obsSpecies1 = Observation_ado.CreateObservation_ado(0, eventId, speciesId1, PointCountWithin50.ObservationTypeGuid); obsSpecies1.Comments = comments1; iba.AddToObservation_ado(obsSpecies1); Observation_ado obsSpecies2 = Observation_ado.CreateObservation_ado(0, eventId, speciesId2, PointCountWithin50.ObservationTypeGuid); obsSpecies2.Comments = comments2; iba.AddToObservation_ado(obsSpecies2); Observation_ado obsSpecies3 = Observation_ado.CreateObservation_ado(0, eventId, speciesId2, PointCountBeyond50.ObservationTypeGuid); obsSpecies3.Comments = comments2; iba.AddToObservation_ado(obsSpecies3); Observation_ado obsSpecies4 = Observation_ado.CreateObservation_ado(0, eventId, speciesId2, PointCountBeyond50.ObservationTypeGuid); obsSpecies4.Comments = comments2; iba.AddToObservation_ado(obsSpecies4); }); }
public void t_PointSurvey_Save_Update() { PointSurvey_ado setupObject = null; // backdoor data setup DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba) { setupObject = PointSurvey_ado.CreatePointSurvey_ado(TestHelper.TestGuid3, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddMinutes(5)); setupObject.NoiseCode = 0; setupObject.SiteVisitId = TestHelper.TestGuid1; iba.AddToPointSurvey_ado1(setupObject); }); List <PointSurvey_ado> extraList = DbTestHelper.LoadExtraneousPointSurveys(); // Setup object to be saved. Change everything except the Id. FiftyMeterPointSurvey toSave = new FiftyMeterPointSurvey() { Id = setupObject.EventId, EndTimeStamp = setupObject.EndTime.AddHours(1), LocationId = TestHelper.TestGuid4, NoiseCode = 0, StartTimeStamp = setupObject.StartTime.AddHours(0.5) }; // Execute the test PointSurveyMapper.Update(toSave); // Validate results using (IbaUnitTestEntities iba = new IbaUnitTestEntities()) { var PointSurveyQuery = from PointSurveys in iba.PointSurvey_ado1 select PointSurveys; Assert.IsNotNull(PointSurveyQuery, "Query result is null"); Assert.AreEqual(extraList.Count() + 1, PointSurveyQuery.Count(), "Wrong number of results in query"); PointSurvey_ado adoPointSurvey = PointSurveyQuery.First(x => x.EventId == setupObject.EventId); validateObjectEquality(toSave, adoPointSurvey); validateExtraPointSurveyAdos(extraList, PointSurveyQuery); } }
public void tGetSiteBySpecies_Supplemental() { Guid siteVisitId1 = TestHelper.TestGuid1; Guid surveyId1 = TestHelper.TestGuid4; DbTestHelper.LoadSingleSiteVisit(siteVisitId1, _siteList[0].LocationId, DateTime.Parse("2010-01-01")); DbTestHelper.LoadSamplingPoint(surveyId1, _siteList[0].LocationId); DbTestHelper.LoadSinglePointSurvey(surveyId1, siteVisitId1, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1)); DbTestHelper.LoadAdoObjects((IbaUnitTestEntities iba) => { // Just 1 in week 1 site 1 iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, siteVisitId1, new Guid(TestHelper.SPECIES_1_ID), SupplementalObservation.ObservationTypeGuid)); }); // Finally, can exercise the system under test using (IDataReader reader = iba.Data.Mappers.ResultsMapper.GetSiteBySpecies(new Guid(TestHelper.SPECIES_1_ID), 2010)) { Assert.IsFalse(reader.Read()); } }