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