public void t_PointSurvey_Delete()
{
PointSurvey_ado setupObject = null;
// backdoor data setup
DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba)
{
setupObject = PointSurvey_ado.CreatePointSurvey_ado(TestHelper.TestGuid3, TestHelper.TestGuid1,
DateTime.Now, DateTime.Now.AddMinutes(5));
setupObject.NoiseCode = 0;
setupObject.SiteVisitId = TestHelper.TestGuid1;
iba.AddToPointSurvey_ado1(setupObject);
});
List <PointSurvey_ado> PointSurveyAdolist = DbTestHelper.LoadExtraneousPointSurveys();
PointSurveyMapper.Delete(new FiftyMeterPointSurvey()
{
Id = setupObject.EventId
});
// Validate results
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var PointSurveyQuery = from PointSurveys in iba.PointSurvey_ado1 select PointSurveys;
Assert.IsNotNull(PointSurveyQuery, "Query result is null");
Assert.AreEqual(PointSurveyAdolist.Count(), PointSurveyQuery.Count(), "Wrong number of results in query");
validateExtraPointSurveyAdos(PointSurveyAdolist, PointSurveyQuery);
}
}
public void t_PointSurvey_SelectAllForSiteVisit()
{
// Backdoor setup -- both have same SameVisitId
List <PointSurvey_ado> list = DbTestHelper.LoadExtraneousPointSurveys();
// Exercise the test
List <FiftyMeterPointSurvey> resultList = PointSurveyMapper.SelectAllForSiteVisit(list[0].SiteVisitId.Value);
// Validate results
Assert.AreEqual(resultList.Count(), list.Count(), "Wrong number of objects in the result list");
foreach (PointSurvey_ado ado in list)
{
// 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)), "PointSurvey_ado " + ado.EventId.ToString() + " is not in the results");
}
}
public void t_PointSurvey_Select_ByGuid()
{
PointSurvey_ado setupObject = null;
// backdoor data setup
DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba)
{
setupObject = PointSurvey_ado.CreatePointSurvey_ado(TestHelper.TestGuid3, TestHelper.TestGuid1,
DateTime.Now, DateTime.Now.AddMinutes(5));
setupObject.NoiseCode = 0;
setupObject.SiteVisitId = TestHelper.TestGuid1;
iba.AddToPointSurvey_ado1(setupObject);
});
List <PointSurvey_ado> extraList = DbTestHelper.LoadExtraneousPointSurveys();
// Exercise the test
FiftyMeterPointSurvey resultObject = PointSurveyMapper.Select(setupObject.EventId);
validateObjectEquality(resultObject, setupObject);
}
public void t_PointSurvey_Save_Update()
{
PointSurvey_ado setupObject = null;
// backdoor data setup
DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba)
{
setupObject = PointSurvey_ado.CreatePointSurvey_ado(TestHelper.TestGuid3, TestHelper.TestGuid1,
DateTime.Now, DateTime.Now.AddMinutes(5));
setupObject.NoiseCode = 0;
setupObject.SiteVisitId = TestHelper.TestGuid1;
iba.AddToPointSurvey_ado1(setupObject);
});
List <PointSurvey_ado> extraList = DbTestHelper.LoadExtraneousPointSurveys();
// Setup object to be saved. Change everything except the Id.
FiftyMeterPointSurvey toSave = new FiftyMeterPointSurvey()
{
Id = setupObject.EventId,
EndTimeStamp = setupObject.EndTime.AddHours(1),
LocationId = TestHelper.TestGuid4,
NoiseCode = 0,
StartTimeStamp = setupObject.StartTime.AddHours(0.5)
};
// Execute the test
PointSurveyMapper.Update(toSave);
// Validate results
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var PointSurveyQuery = from PointSurveys in iba.PointSurvey_ado1 select PointSurveys;
Assert.IsNotNull(PointSurveyQuery, "Query result is null");
Assert.AreEqual(extraList.Count() + 1, PointSurveyQuery.Count(), "Wrong number of results in query");
PointSurvey_ado adoPointSurvey = PointSurveyQuery.First(x => x.EventId == setupObject.EventId);
validateObjectEquality(toSave, adoPointSurvey);
validateExtraPointSurveyAdos(extraList, PointSurveyQuery);
}
}
