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());
}
}
public void tGetSpeciesCount_Supplemental()
{
Guid siteVisitId1 = TestHelper.TestGuid1;
Guid surveyId1 = TestHelper.TestGuid4;
DbTestHelper.LoadSingleSiteVisit(siteVisitId1, _siteList[0].LocationId, DateTime.Now);
DbTestHelper.LoadSamplingPoint(surveyId1, _siteList[0].LocationId);
DbTestHelper.LoadSinglePointSurvey(surveyId1, siteVisitId1, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1));
DbTestHelper.LoadAdoObjects((IbaUnitTestEntities iba) =>
{
// Load species 1 into the database
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, siteVisitId1,
new Guid(TestHelper.SPECIES_1_ID), SupplementalObservation.ObservationTypeGuid));
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId1,
new Guid(TestHelper.SPECIES_1_ID), PointCountBeyond50.ObservationTypeGuid));
});
// Finally, can exercise the system under test
DataSet set = ResultsMapper.GetSpeciesCount(DateTime.Now.Year);
Assert.IsNotNull(set, "DataSet is null");
Assert.AreEqual(1, set.Tables.Count, "There is not 1 table in the DataSet");
DataTable table = set.Tables[0];
Assert.AreEqual(1, table.Rows.Count, "There are not three rows in the results");
// Results are supposed to be sorted by common name. That means order of Species1, Species3, Species2.
DataRow species1 = table.Rows[0];
Assert.AreEqual(TestHelper.SPECIES_1_COMMON, species1["CommonName"], "CommonName wrong row 1");
Assert.AreEqual(TestHelper.SPECIES_1_SCIENTIFIC, species1["ScientificName"], "ScientificName wrong row 1");
Assert.AreEqual("1", species1["SpeciesCount"].ToString(), "SpeciesCount wrong row 1");
Assert.AreEqual(TestHelper.SPECIES_1_ID, species1["SpeciesId"].ToString(), "SpeciesId wrong row 1");
}
public void tGetSpeciesCount_NoData()
{
Guid siteVisitId1 = TestHelper.TestGuid1;
Guid siteVisitId2 = TestHelper.TestGuid2;
Guid siteVisitId3 = TestHelper.TestGuid3;
Guid surveyId1 = TestHelper.TestGuid4;
Guid surveyId2 = TestHelper.TestGuid5;
Guid surveyId3 = TestHelper.TestGuid6;
DbTestHelper.LoadSingleSiteVisit(siteVisitId1, _siteList[0].LocationId, DateTime.Now);
DbTestHelper.LoadSingleSiteVisit(siteVisitId2, _siteList[1].LocationId, DateTime.Now);
DbTestHelper.LoadSingleSiteVisit(siteVisitId3, _siteList[2].LocationId, DateTime.Now);
DbTestHelper.LoadSamplingPoint(surveyId1, _siteList[0].LocationId);
DbTestHelper.LoadSamplingPoint(surveyId2, _siteList[1].LocationId);
DbTestHelper.LoadSamplingPoint(surveyId3, _siteList[2].LocationId);
DbTestHelper.LoadSinglePointSurvey(surveyId1, siteVisitId1, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1));
DbTestHelper.LoadSinglePointSurvey(surveyId2, siteVisitId2, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1));
DbTestHelper.LoadSinglePointSurvey(surveyId3, siteVisitId3, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1));
// No species loaded
// Finally, can exercise the system under test
DataSet set = ResultsMapper.GetSpeciesCount(DateTime.Now.Year);
Assert.IsNotNull(set, "DataSet is null");
Assert.AreEqual(1, set.Tables.Count, "There is not 1 table in the DataSet");
DataTable table = set.Tables[0];
Assert.IsTrue(table.Columns.Contains("CommonName"), "Does not contain CommonName column");
Assert.IsTrue(table.Columns.Contains("ScientificName"), "Does not contain ScientificName column");
Assert.IsTrue(table.Columns.Contains("SpeciesCount"), "Does not contain SpeciesCount column");
Assert.IsTrue(table.Columns.Contains("SpeciesId"), "Does not contain SpeciesId column");
Assert.AreEqual(0, table.Rows.Count, "There are not zero rows in the results");
}
public void tGetSpeciesCount_Full()
{
Guid siteVisitId1 = TestHelper.TestGuid1;
Guid siteVisitId2 = TestHelper.TestGuid2;
Guid siteVisitId3 = TestHelper.TestGuid3;
Guid surveyId1 = TestHelper.TestGuid4;
Guid surveyId2 = TestHelper.TestGuid5;
Guid surveyId3 = TestHelper.TestGuid6;
DbTestHelper.LoadSingleSiteVisit(siteVisitId1, _siteList[0].LocationId, DateTime.Now);
DbTestHelper.LoadSingleSiteVisit(siteVisitId2, _siteList[1].LocationId, DateTime.Now);
DbTestHelper.LoadSingleSiteVisit(siteVisitId3, _siteList[2].LocationId, DateTime.Now);
DbTestHelper.LoadSingleSiteVisit(surveyId1, _siteList[2].LocationId, DateTime.Now.AddYears(-1)); // extra
DbTestHelper.LoadSamplingPoint(surveyId1, _siteList[0].LocationId);
DbTestHelper.LoadSamplingPoint(surveyId2, _siteList[1].LocationId);
DbTestHelper.LoadSamplingPoint(surveyId3, _siteList[2].LocationId);
DbTestHelper.LoadSinglePointSurvey(surveyId1, siteVisitId1, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1));
DbTestHelper.LoadSinglePointSurvey(surveyId2, siteVisitId2, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1));
DbTestHelper.LoadSinglePointSurvey(surveyId3, siteVisitId3, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1));
DbTestHelper.LoadSinglePointSurvey(siteVisitId1, surveyId1, TestHelper.TestGuid1, DateTime.Now.AddYears(-1), DateTime.Now.AddYears(-1).AddHours(1)); // extra
DbTestHelper.LoadAdoObjects((IbaUnitTestEntities iba) =>
{
// Load species 1 into the database
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId1,
new Guid(TestHelper.SPECIES_1_ID), PointCountWithin50.ObservationTypeGuid));
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId1,
new Guid(TestHelper.SPECIES_1_ID), PointCountBeyond50.ObservationTypeGuid));
// species 2
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId1,
new Guid(TestHelper.SPECIES_2_ID), PointCountBeyond50.ObservationTypeGuid));
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId1,
new Guid(TestHelper.SPECIES_2_ID), PointCountBeyond50.ObservationTypeGuid));
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId1,
new Guid(TestHelper.SPECIES_2_ID), PointCountBeyond50.ObservationTypeGuid));
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId1,
new Guid(TestHelper.SPECIES_2_ID), PointCountWithin50.ObservationTypeGuid));
// species 3
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId1,
new Guid(TestHelper.SPECIES_3_ID), PointCountWithin50.ObservationTypeGuid));
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId2,
new Guid(TestHelper.SPECIES_3_ID), PointCountWithin50.ObservationTypeGuid));
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId3,
new Guid(TestHelper.SPECIES_3_ID), PointCountWithin50.ObservationTypeGuid));
// extra
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, siteVisitId1,
new Guid(TestHelper.SPECIES_1_ID), PointCountBeyond50.ObservationTypeGuid));
});
// Finally, can exercise the system under test
DataSet set = ResultsMapper.GetSpeciesCount(DateTime.Now.Year);
Assert.IsNotNull(set, "DataSet is null");
Assert.AreEqual(1, set.Tables.Count, "There is not 1 table in the DataSet");
DataTable table = set.Tables[0];
Assert.IsTrue(table.Columns.Contains("CommonName"), "Does not contain CommonName column");
Assert.IsTrue(table.Columns.Contains("ScientificName"), "Does not contain ScientificName column");
Assert.IsTrue(table.Columns.Contains("SpeciesCount"), "Does not contain SpeciesCount column");
Assert.IsTrue(table.Columns.Contains("SpeciesId"), "Does not contain SpeciesId column");
Assert.AreEqual(3, table.Rows.Count, "There are not three rows in the results");
// Results are supposed to be sorted by common name. That means order of Species1, Species3, Species2.
DataRow species1 = table.Rows[0];
Assert.AreEqual(TestHelper.SPECIES_1_COMMON, species1["CommonName"], "CommonName wrong row 1");
Assert.AreEqual(TestHelper.SPECIES_1_SCIENTIFIC, species1["ScientificName"], "ScientificName wrong row 1");
Assert.AreEqual("2", species1["SpeciesCount"].ToString(), "SpeciesCount wrong row 1");
Assert.AreEqual(TestHelper.SPECIES_1_ID, species1["SpeciesId"].ToString(), "SpeciesId wrong row 1");
species1 = table.Rows[1];
Assert.AreEqual(TestHelper.SPECIES_3_COMMON, species1["CommonName"], "CommonName wrong row 2");
Assert.AreEqual(TestHelper.SPECIES_3_SCIENTIFIC, species1["ScientificName"], "ScientificName wrong row 2");
Assert.AreEqual("3", species1["SpeciesCount"].ToString(), "SpeciesCount wrong row 2");
Assert.AreEqual(TestHelper.SPECIES_3_ID, species1["SpeciesId"].ToString(), "SpeciesId wrong row 2");
species1 = table.Rows[2];
Assert.AreEqual(TestHelper.SPECIES_2_COMMON, species1["CommonName"], "CommonName wrong row 3");
Assert.AreEqual(TestHelper.SPECIES_2_SCIENTIFIC, species1["ScientificName"], "ScientificName wrong row 3");
Assert.AreEqual("4", species1["SpeciesCount"].ToString(), "SpeciesCount wrong row 3");
Assert.AreEqual(TestHelper.SPECIES_2_ID, species1["SpeciesId"].ToString(), "SpeciesId wrong row 3");
}
public void tGetSiteBySpecies_Full()
{
Guid siteVisitId1 = TestHelper.TestGuid1;
Guid siteVisitId2 = TestHelper.TestGuid2;
Guid siteVisitId3 = TestHelper.TestGuid3;
Guid surveyId1 = TestHelper.TestGuid4;
Guid surveyId2 = TestHelper.TestGuid5;
Guid surveyId3 = TestHelper.TestGuid6;
// Week 1 site 1, visit 1
DbTestHelper.LoadSingleSiteVisit(siteVisitId1, _siteList[0].LocationId, DateTime.Parse("2010-01-01"));
// Week 2 site 1, visit 2
DbTestHelper.LoadSingleSiteVisit(siteVisitId2, _siteList[0].LocationId, DateTime.Parse("2010-01-09"));
// Week 2 site 2, visit 1
DbTestHelper.LoadSingleSiteVisit(siteVisitId3, _siteList[1].LocationId, DateTime.Parse("2010-01-08"));
DbTestHelper.LoadSamplingPoint(surveyId1, _siteList[0].LocationId);
DbTestHelper.LoadSamplingPoint(surveyId2, _siteList[0].LocationId);
DbTestHelper.LoadSamplingPoint(surveyId3, _siteList[1].LocationId);
DbTestHelper.LoadSinglePointSurvey(surveyId1, siteVisitId1, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1));
DbTestHelper.LoadSinglePointSurvey(surveyId2, siteVisitId2, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1));
DbTestHelper.LoadSinglePointSurvey(surveyId3, siteVisitId3, TestHelper.TestGuid1, DateTime.Now, DateTime.Now.AddHours(1));
// Different year
DbTestHelper.LoadSingleSiteVisit(surveyId1, _siteList[0].LocationId, DateTime.Parse("2009-06-06"));
DbTestHelper.LoadSinglePointSurvey(siteVisitId1, surveyId1, TestHelper.TestGuid4, DateTime.Parse("2009-06-06 11:00 AM"), DateTime.Parse("2009-06-06 11:05 AM"));
DbTestHelper.LoadAdoObjects((IbaUnitTestEntities iba) =>
{
// Just 1 in week 1 site 1
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId1,
new Guid(TestHelper.SPECIES_1_ID), PointCountWithin50.ObservationTypeGuid));
// Two in week 2 site 1
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId2,
new Guid(TestHelper.SPECIES_1_ID), PointCountBeyond50.ObservationTypeGuid));
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId2,
new Guid(TestHelper.SPECIES_1_ID), PointCountWithin50.ObservationTypeGuid));
// One beyond 50 in week 2 site 2
iba.AddToObservation_ado(Observation_ado.CreateObservation_ado(0, surveyId3,
new Guid(TestHelper.SPECIES_1_ID), PointCountBeyond50.ObservationTypeGuid));
});
// Finally, can exercise the system under test
using (IDataReader reader = iba.Data.Mappers.ResultsMapper.GetSiteBySpecies(new Guid(TestHelper.SPECIES_1_ID), 2010))
{
// Results are supposed to be sorted by location name.
Assert.IsTrue(reader.Read(), "missing row 1");
Assert.AreEqual("Location 1", reader.GetString(reader.GetOrdinal("LocationName")), "LocationName wrong row 1");
Assert.AreEqual("1", reader.GetValue(reader.GetOrdinal("Week")).ToString(), "Week wrong row 1");
Assert.AreEqual("1", reader.GetValue(reader.GetOrdinal("SpeciesCount")).ToString(), "SpeciesCount wrong row 1");
Assert.IsTrue(reader.Read(), "missing row 2");
Assert.AreEqual("Location 1", reader.GetString(reader.GetOrdinal("LocationName")), "LocationName wrong row 2");
Assert.AreEqual("2", reader.GetValue(reader.GetOrdinal("Week")).ToString(), "Week wrong row 2");
Assert.AreEqual("2", reader.GetValue(reader.GetOrdinal("SpeciesCount")).ToString(), "SpeciesCount wrong row 2");
Assert.IsTrue(reader.Read(), "missing row 3");
Assert.AreEqual("Location 2", reader.GetString(reader.GetOrdinal("LocationName")), "LocationName wrong row 3");
Assert.AreEqual("2", reader.GetValue(reader.GetOrdinal("Week")).ToString(), "Week wrong row 3");
Assert.AreEqual("1", reader.GetValue(reader.GetOrdinal("SpeciesCount")).ToString(), "SpeciesCount wrong row 3");
}
}
