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