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 static string[] GetSpeciesList(string prefixText, int count)
{
IEnumerable <Species> list =
SpeciesMapper.SelectAll()
.Where(x => x.AlphaCode.StartsWith(prefixText))
.OrderBy(x => x.AlphaCode)
.Take(count);
List <string> arrayList = new List <string>();
foreach (Species s in list)
{
arrayList.Add(s.AlphaCode + " (" + s.CommonName + ")");
}
return(arrayList.ToArray <string>());
}
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);
}
}
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_Species_Select_ByGuid_Empty()
{
SpeciesMapper.Select(Guid.Empty);
}
