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_Species_Select_All()
{
// Backdoor setup
List <Species_ado> list = DbTestHelper.LoadExtraneousSpecies();
// Exercise the test
List <Species> speciesList = SpeciesMapper.SelectAll();
// Validate results
Assert.AreEqual(list.Count(), speciesList.Count, "Wrong number of objects in the result list");
foreach (Species_ado ado in list)
{
// just check to make sure the object is there; leave specific value check for the Select_ByGuid test
Assert.IsTrue(speciesList.Exists(x => x.Id.Equals(ado.SpeciesId)), "Species_ado " + ado.SpeciesId.ToString() + " is not in the results");
}
}
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);
}
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);
}
}
