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);
}
}
private void saveSurvey()
{
FiftyMeterPointSurvey survey = getCurrentPointSurvey();
DateTime newStartTime =
DateTime.Parse(this.UserState.SiteVisit.StartTimeStamp.Value.ToShortDateString() + " " + this.Time.Text);
survey.EndTimeStamp = newStartTime.AddMinutes(5);
survey.StartTimeStamp = newStartTime;
survey.NoiseCode = byte.Parse(this.NoiseCodeDropDown.SelectedValue);
PointSurveyMapper.Update(survey);
}
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");
}
}
protected void RetrieveIncomplete_Click(object sender, EventArgs e)
{
if (this.SiteVisitedInput.SelectedIndex > -1 && !string.IsNullOrEmpty(this.VisitDateInput.Text))
{
List <SiteVisit> visitList = SiteVisitMapper.SelectAllForSite(Guid.Parse(this.SiteVisitedInput.SelectedValue));
SiteVisit theVisit = visitList.Find(x => !x.IsDataEntryComplete
&&
x.StartTimeStamp.Value.ToShortDateString()
.Equals(
DateTime.Parse(this.VisitDateInput.Text).ToShortDateString()));
if (theVisit != null)
{
resetSession();
this.UserState.SiteVisit = theVisit;
this.UserState.SiteVisit.SupplementalObservations.AddRange(
SupplementalObservationMapper.SelectAllForEvent(theVisit.Id));
this.UserState.SiteVisit.PointSurveys.AddRange(PointSurveyMapper.SelectAllForSiteVisit(theVisit.Id));
this.UserState.SiteVisit.PointSurveys.ForEach(x =>
{
x.Observations.AddRange(ObservationMapper.SelectAllForEvent <PointCountBeyond50>(x.Id));
x.Observations.AddRange(ObservationMapper.SelectAllForEvent <PointCountWithin50>(x.Id));
});
List <SiteCondition> conditions = ConditionsMapper.Select_BySiteVisitId(theVisit.Id);
if (conditions != null && conditions.Count.Equals(2))
{
this.UserState.SiteVisit.StartConditions =
conditions.Single(x => x.Id.Equals(this.UserState.SiteVisit.StartConditions.Id));
this.UserState.SiteVisit.EndConditions =
conditions.Single(x => x.Id.Equals(this.UserState.SiteVisit.EndConditions.Id));
}
loadCurrentSiteVisit();
}
else
{
Master.SetErrorMessage(
"<p>No <i>incomplete</i> site visit entry has been started for this site and date.</p>");
}
}
else
{
Master.SetErrorMessage(
"<p>Both site and date must be filled in to retrieve an incomplete site visit.</p>");
}
}
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);
}
}
public void t_PointSurvey_Save_Insert()
{
FiftyMeterPointSurvey toInsert = new FiftyMeterPointSurvey()
{
Id = TestHelper.TestGuid1,
EndTimeStamp = DateTime.Now,
LocationId = TestHelper.TestGuid4,
NoiseCode = 0,
StartTimeStamp = DateTime.Now.AddHours(-2)
};
PointSurveyMapper.Insert(toInsert);
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var PointSurveyQuery = from PointSurveys in iba.PointSurvey_ado1 select PointSurveys;
Assert.IsNotNull(PointSurveyQuery, "Query result is null");
Assert.AreEqual(1, PointSurveyQuery.Count(), "Wrong number of results in query");
PointSurvey_ado adoPointSurvey = PointSurveyQuery.First();
validateObjectEquality(toInsert, adoPointSurvey);
}
}
public void t_PointSurvey_Select_ByGuid_Empty()
{
PointSurveyMapper.Select(Guid.Empty);
}
