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_SiteVisit_SelectAllForSite() { // Backdoor setup List <SiteVisit_ado> list = DbTestHelper.LoadExtraneousSiteVisits(); // Exercise the test List <SiteVisit> resultList = SiteVisitMapper.SelectAllForSite(list[0].LocationId); // Validate results Assert.AreEqual(resultList.Count(), 1, "Wrong number of objects in the result list"); foreach (SiteVisit_ado ado in list.FindAll(x => x.LocationId.Equals(list[0].LocationId))) { // just check to make sure the object is there; leave specific value check for the Select_ByGuid test Assert.IsTrue(resultList.Exists(x => x.Id.Equals(ado.EventId)), "SiteVisitAdo " + ado.EventId.ToString() + " is not in the results"); } }
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_SiteVisit_Select_ByGuid() { 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(); // Exercise the test SiteVisit resultObject = SiteVisitMapper.Select(setupObject.EventId); validateObjectEquality(resultObject, setupObject); }