public void t_Conditions_Save_Insert()
{
SiteCondition Conditions = new SiteCondition()
{
Id = TestHelper.TestGuid1,
SiteVisitId = TestHelper.TestParentGuid,
Sky = 3,
Temperature = new Business.DataTypes.Temperature()
{
Value = 54, Units = "C"
},
Wind = 0
};
ConditionsMapper.Insert(Conditions);
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var ConditionsQuery = from Conditionss in iba.SiteCondition_ado select Conditionss;
Assert.IsNotNull(ConditionsQuery, "Query result is null");
Assert.AreEqual(1, ConditionsQuery.Count(), "Wrong number of results in query");
SiteCondition_ado adoConditions = ConditionsQuery.First();
validateObjectEquality(Conditions, adoConditions);
}
}
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_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_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_Delete()
{
Guid eventId = DbTestHelper.TestGuid1;
Guid speciesId1 = new Guid(DbTestHelper.SPECIES_1_ID);
Guid speciesId2 = new Guid(DbTestHelper.SPECIES_2_ID);
string speciesCode2 = DbTestHelper.SPECIES_2_CODE;
string comments1 = string.Empty;
string comments2 = "comments 2";
multiBackdoorSetup(eventId, speciesId1, speciesId2, comments1, comments2);
// TODO: fix this
FiftyMeterDataEntryMapper.Delete(new FiftyMeterDataEntry()
{
Comments = comments2,
SpeciesCode = speciesCode2,
PointSurveyId = eventId,
CountBeyond50 = 2,
CountWithin50 = 1
}, new Business.Entities.FiftyMeterPointSurvey());
// There should be one object left for species 1
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var observationQuery = from observations in iba.Observation_ado select observations;
Assert.IsNotNull(observationQuery, "observationQuery is null");
Assert.AreEqual(1, observationQuery.Count(), "observationQuery has wrong count");
Assert.IsTrue(observationQuery.First().SpeciesId.Equals(speciesId1), "the remaining observation isn't for Species 1");
}
}
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_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_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_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_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_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_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");
}
}
}
/// <summary>
/// Clears the table.
/// </summary>
/// <param name="tableName">Name of the table.</param>
public static void ClearTable(string tableName)
{
string sql = "DELETE FROM dbo." + tableName;
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
iba.ExecuteStoreCommand(sql);
}
}
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_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_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 static void LoadAdoObjects(LoadAdoMethod method)
{
try
{
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
method(iba);
iba.SaveChanges();
}
}
catch (Exception ex)
{
string message = (ex.InnerException == null) ? ex.Message : ex.InnerException.Message;
Assert.Fail(message);
}
}
public void t_SiteVisit_Save_Insert()
{
SiteVisit toInsert = new SiteVisit()
{
Id = TestHelper.TestGuid1,
EndConditions = new SiteCondition()
{
Id = TestHelper.TestGuid1,
SiteVisitId = TestHelper.TestGuid1,
Sky = 0,
Temperature = new Business.DataTypes.Temperature()
{
Units = "C", Value = 20
},
Wind = 2
},
EndTimeStamp = DateTime.Now,
IsDataEntryComplete = true,
LocationId = TestHelper.TestGuid4,
ObserverId = TestHelper.TestGuid3,
RecorderId = TestHelper.TestGuid2,
StartConditions = new SiteCondition()
{
Id = TestHelper.TestGuid2,
SiteVisitId = TestHelper.TestGuid1,
Sky = 1,
Temperature = new Business.DataTypes.Temperature()
{
Units = "C", Value = 23
},
Wind = 2
},
StartTimeStamp = DateTime.Now.AddHours(-2),
Comments = "asdf asdfa sdf asdfasdfasdf"
};
SiteVisitMapper.Insert(toInsert);
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var SiteVisitQuery = from SiteVisits in iba.SiteVisit_ado1 select SiteVisits;
Assert.IsNotNull(SiteVisitQuery, "Query result is null");
Assert.AreEqual(1, SiteVisitQuery.Count(), "Wrong number of results in query");
SiteVisit_ado adoSiteVisit = SiteVisitQuery.First();
validateObjectEquality(toInsert, adoSiteVisit);
}
}
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_PointCountLess50_Save_Insert()
{
//loadSiteVisit(TestHelper.TestGuid1);
PointCountWithin50 supplemental = new PointCountWithin50()
{
Comments = "asdfasdf asdf adsfa dsfads fasdf adsfasd fadsf awefr34fr34r34 ",
SpeciesCode = TestHelper.SPECIES_1_CODE,
EventId = TestHelper.TestGuid1
};
ObservationMapper.Insert(supplemental);
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var PointCountLess50Query = from PointCountLess50s in iba.Observation_ado select PointCountLess50s;
Assert.IsNotNull(PointCountLess50Query, "Query result is null");
Assert.AreEqual(1, PointCountLess50Query.Count(), "Wrong number of results in query");
Observation_ado adoPointCountLess50 = PointCountLess50Query.First();
validateObjectEquality(supplemental, adoPointCountLess50, iba);
}
}
public void t_SupplementalObservation_Save_Insert()
{
//loadSiteVisit(TestHelper.TestGuid1);
SupplementalObservation supplemental = new SupplementalObservation()
{
Comments = "asdfasdf asdf adsfa dsfads fasdf adsfasd fadsf awefr34fr34r34 ",
SpeciesCode = TestHelper.SPECIES_1_CODE,
EventId = TestHelper.TestGuid1
};
ObservationMapper.Insert(supplemental);
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var SupplementalObservationQuery = from SupplementalObservations in iba.Observation_ado select SupplementalObservations;
Assert.IsNotNull(SupplementalObservationQuery, "Query result is null");
Assert.AreEqual(1, SupplementalObservationQuery.Count(), "Wrong number of results in query");
Observation_ado adoSupplementalObservation = SupplementalObservationQuery.First();
validateObjectEquality(supplemental, adoSupplementalObservation, iba);
}
}
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 t_PointSurvey_Save_Insert()
{
FiftyMeterPointSurvey toInsert = new FiftyMeterPointSurvey()
{
Id = TestHelper.TestGuid1,
EndTimeStamp = DateTime.Now,
LocationId = TestHelper.TestGuid4,
NoiseCode = 0,
StartTimeStamp = DateTime.Now.AddHours(-2)
};
PointSurveyMapper.Insert(toInsert);
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var PointSurveyQuery = from PointSurveys in iba.PointSurvey_ado1 select PointSurveys;
Assert.IsNotNull(PointSurveyQuery, "Query result is null");
Assert.AreEqual(1, PointSurveyQuery.Count(), "Wrong number of results in query");
PointSurvey_ado adoPointSurvey = PointSurveyQuery.First();
validateObjectEquality(toInsert, adoPointSurvey);
}
}
public void t_Species_Save_Update()
{
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();
// Setup object to be saved. Change everything except the Id.
Species testObject = new Species()
{
AlphaCode = setupObject.AlphaCode + "a",
CommonName = setupObject.CommonName + "b",
ScientificName = setupObject.ScientificName + "c",
WarningCount = setupObject.WarningCount - 1,
Id = setupObject.SpeciesId
};
// Execute the test
SpeciesMapper.Update(testObject);
// 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(extraList.Count() + 1, SpeciesQuery.Count(), "Wrong number of results in query");
Species_ado adoSpecies = SpeciesQuery.First(x => x.SpeciesId == TestHelper.TestGuid1);
validateObjectEquality(testObject, adoSpecies);
validateExtrapersonAdos(extraList, SpeciesQuery);
}
}
public void t_Insert()
{
FiftyMeterDataEntry entry = new FiftyMeterDataEntry()
{
Comments = "comments",
CountBeyond50 = 1,
CountWithin50 = 2,
PointSurveyId = DbTestHelper.TestGuid4,
SpeciesCode = DbTestHelper.SPECIES_2_CODE
};
// Todo: fix this
FiftyMeterDataEntryFacade.Insert(entry);
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var observationQuery = from observations in iba.Observation_ado select observations;
Assert.IsNotNull(observationQuery, "observationQuery is null");
Assert.AreEqual(3, observationQuery.Count(), "observationQuery has wrong count");
Observation_ado beyond50 = observationQuery.First(x => x.ObservationTypeId.Equals(PointCountBeyond50.ObservationTypeGuid));
Assert.IsNotNull(beyond50, "no object added for Beyond 50 count");
Assert.AreEqual(entry.Comments, beyond50.Comments, "comments beyond");
Assert.AreEqual(entry.PointSurveyId, beyond50.EventId, "event id beyond");
Assert.AreEqual(new Guid(DbTestHelper.SPECIES_2_ID), beyond50.SpeciesId, "species ID beyond");
List<Observation_ado> withinList = observationQuery.Where(x => x.ObservationTypeId.Equals(PointCountWithin50.ObservationTypeGuid)).ToList();
Assert.IsNotNull(withinList, "withinList is null");
Assert.AreEqual(entry.Comments, withinList[0].Comments, "within 1 comments");
Assert.AreEqual(entry.PointSurveyId, withinList[0].EventId, "within 1 event id");
Assert.AreEqual(new Guid(DbTestHelper.SPECIES_2_ID), withinList[0].SpeciesId, "within 1 species id");
Assert.AreEqual(entry.Comments, withinList[1].Comments, "within 2 comments");
Assert.AreEqual(entry.PointSurveyId, withinList[1].EventId, "within 2 event id");
Assert.AreEqual(new Guid(DbTestHelper.SPECIES_2_ID), withinList[1].SpeciesId, "within 2 species id");
}
}
public void t_Species_Save_Insert()
{
Species Species = new Species()
{
Id = TestHelper.TestGuid1,
AlphaCode = "Alpha",
CommonName = "Alpha One Two Three",
ScientificName = "Sillius maximum",
WarningCount = 12
};
SpeciesMapper.Insert(Species);
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var SpeciesQuery = from Speciess in iba.Species_ado select Speciess;
Assert.IsNotNull(SpeciesQuery, "Query result is null");
Assert.AreEqual(1, SpeciesQuery.Count(), "Wrong number of results in query");
Species_ado adoSpecies = SpeciesQuery.First();
validateObjectEquality(Species, adoSpecies);
}
}
public void t_Person_Save_Insert()
{
Person Person = new Person()
{
Id = TestHelper.TestGuid1,
FirstName = "First Name",
LastName = "Last Name",
EmailAddress = "asdf@adfasd",
PhoneNumber = "(651) 646-8007"
};
PersonMapper.Insert(Person);
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var PersonQuery = from Persons in iba.Person_ado select Persons;
Assert.IsNotNull(PersonQuery, "Query result is null");
Assert.AreEqual(1, PersonQuery.Count(), "Wrong number of results in query");
Person_ado adoPerson = PersonQuery.First();
validateObjectEquality(Person, adoPerson);
}
}
private static void validateObjectEquality(PointCountWithin50 supplemental, Observation_ado adoPointCountLess50, IbaUnitTestEntities iba)
{
Assert.IsNotNull(adoPointCountLess50, "There is no PointCountLess50 with the ID to test for");
Assert.IsNotNull(adoPointCountLess50.Comments, "ADO Comments are null");
Assert.AreEqual(supplemental.Comments, adoPointCountLess50.Comments, "Comments");
Assert.AreEqual(supplemental.EventId, adoPointCountLess50.EventId, "EventId");
// ID is now an identity field
//Assert.AreEqual(supplemental.Id, adoPointCountLess50.ObservationId, "ObservationId");
Assert.AreEqual(supplemental.ObservationTypeId, adoPointCountLess50.ObservationTypeId, "ObservationTypeId");
var speciesQuery = from specieses in iba.Species_ado where specieses.AlphaCode == supplemental.SpeciesCode select specieses.SpeciesId;
Assert.AreEqual(speciesQuery.First().ToString(), adoPointCountLess50.SpeciesId.ToString(), "SpeciesId");
}
