public void t_Site_Save_Insert()
{
Site site = new Site()
{
CodeName = "codename",
GeoCoordinate = new Business.DataTypes.Coordinate()
{
Latitude = new Business.DataTypes.Degree()
{
Value = 56.789M
},
Longitude = new Business.DataTypes.Degree()
{
Value = 67.281M
}
},
Id = TestHelper.TestGuid1,
Name = "Site Name"
};
SiteMapper.Insert(site);
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var siteQuery = from sites in iba.Site_ado select sites;
Assert.IsNotNull(siteQuery, "Query result is null");
Assert.AreEqual(1, siteQuery.Count(), "Wrong number of results in query");
Site_ado adoSite = siteQuery.First();
validateObjectEquality(site, adoSite);
}
}
private static void validateObjectEquality(Site site, Site_ado adoSite)
{
Assert.IsNotNull(adoSite, "There is not Site with the ID to test for");
Assert.AreEqual(site.CodeName, adoSite.CodeName, "CodeName");
Assert.AreEqual(site.GeoCoordinate.Latitude.Value, adoSite.Latitude, "Latitude");
Assert.AreEqual(site.GeoCoordinate.Longitude.Value, adoSite.Longitude, "Longitude");
Assert.AreEqual(site.Id, adoSite.LocationId, "Id");
Assert.AreEqual(site.Name, adoSite.LocationName, "Name");
}
private static void validateExtraLocations(List <Location_ado> extraList, IQueryable <Site_ado> siteQuery)
{
foreach (Location_ado adoLocation in extraSites(extraList))
{
Site_ado adoSite = siteQuery.First(x => x.LocationId == adoLocation.LocationId);
Assert.IsNotNull(adoSite, "There is no longer an object with id " + adoLocation.LocationId.ToString());
Assert.AreEqual(adoLocation.CodeName, adoSite.CodeName, "Extra " + adoSite.LocationId.ToString() + " CodeName mismatch");
Assert.AreEqual(adoLocation.Latitude, adoSite.Latitude, "Extra " + adoSite.LocationId.ToString() + " Latitude mismatch");
Assert.AreEqual(adoLocation.Longitude, adoSite.Longitude, "Extra " + adoSite.LocationId.ToString() + " Longitude mismatch");
Assert.AreEqual(adoSite.LocationName, adoSite.LocationName, "Extra " + adoSite.LocationId.ToString() + " Locationname mismatch");
}
}
public void t_Site_Save_Update()
{
Location_ado location = null;
// backdoor data setup
DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba)
{
location = Location_ado.CreateLocation_ado(TestHelper.TestGuid1,
"locationName", LookupConstants.LocationTypeSite);
location.CodeName = "abc";
location.Latitude = 89.3M;
location.Longitude = 90.10093M;
location.ParentLocationId = null;
iba.AddToLocation_ado(location);
});
List <Location_ado> extraList = DbTestHelper.LoadExtraneousLocations();
// Setup object to be saved. Change everything except the Id.
Site site = new Site()
{
CodeName = location.CodeName + "a",
GeoCoordinate = new Business.DataTypes.Coordinate()
{
Latitude = new Business.DataTypes.Degree()
{
Value = location.Latitude.Value + 1M
},
Longitude = new Business.DataTypes.Degree()
{
Value = location.Longitude.Value + 1M
}
},
Id = location.LocationId,
Name = location.LocationName + "asd"
};
// Execute the test
SiteMapper.Update(site);
// Validate results
using (IbaUnitTestEntities iba = new IbaUnitTestEntities())
{
var siteQuery = from sites in iba.Site_ado select sites;
Assert.IsNotNull(siteQuery, "Query result is null");
Assert.AreEqual(extraSites(extraList).Count() + 1, siteQuery.Count(), "Wrong number of results in query");
Site_ado adoSite = siteQuery.First(x => x.LocationId == TestHelper.TestGuid1);
validateObjectEquality(site, adoSite);
validateExtraLocations(extraList, siteQuery);
}
}
