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);
}
}
public void t_GetBoundaries_WrongSite()
{
List <Location_ado> extraList = DbTestHelper.LoadExtraneousLocations();
SiteBoundary boundary1 = new SiteBoundary()
{
SiteId = extraList[0].LocationId, Latitude = 1.02m, Longitude = 3.456m, VertexSequence = 1
};
SiteBoundary boundary2 = new SiteBoundary()
{
SiteId = extraList[1].LocationId, Latitude = -7.8m, Longitude = 90.12m, VertexSequence = 2
};
DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba)
{
iba.AddToSiteBoundaries(boundary2);
iba.AddToSiteBoundaries(boundary1);
});
// using site 1
Site results = new Site()
{
Id = extraList[0].LocationId
};
SiteMapper.GetBoundaries(results);
Assert.IsNotNull(results.Boundaries, "results are null");
Assert.AreEqual(1, results.Boundaries.Count(), "wrong count");
Coordinate coord = results.Boundaries.Dequeue();
Assert.AreEqual(boundary1.Latitude, coord.Latitude.Value, "lat 1");
Assert.AreEqual(boundary1.Longitude, coord.Longitude.Value, "long 1");
}
public void t_Site_Delete()
{
Location_ado location = null;
// backdoor data setup
DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba)
{
location = Location_ado.CreateLocation_ado(new Guid("87606168-3ac7-402a-8ae6-4f6905555581"),
"locationName", LookupConstants.LocationTypeSite);
location.CodeName = "abc";
location.Latitude = 89.3M;
location.Longitude = 90.10093M;
location.ParentLocationId = null;
iba.AddToLocation_ado(location);
});
List <Location_ado> locationlist = DbTestHelper.LoadExtraneousLocations();
SiteMapper.Delete(new Site()
{
Id = location.LocationId
});
// 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(locationlist).Count(), siteQuery.Count(), "Wrong number of results in query");
validateExtraLocations(locationlist, siteQuery);
}
}
public IEnumerable <SiteModel> GetSites()
{
_context.Database.ExecuteSqlCommand("PRAGMA foreign_keys = ON");
var sites = _siteRepo.GetAll().ToList();
var mapper = new SiteMapper();
return(mapper.Map(sites));
}
public void AddSite(SiteModel site)
{
var repository = new Repository <SiteEntity>(_context);
var mapper = new SiteMapper();
var entity = mapper.Map(site);
_siteRepo.Add(entity);
_siteRepo.Save();
}
public void DeleteSite(SiteModel site)
{
var mapper = new SiteMapper();
var entity = mapper.Map(site);
var entityToDelete = _siteRepo.Get(entity.SiteId);
_context.Entry(entityToDelete).Collection(y => y.Customers).Load();
_context.Entry(entityToDelete).Collection(y => y.Supervisors).Load();
_siteRepo.Delete(entityToDelete);
_siteRepo.Save();
}
public void t_GetBoundaries_None()
{
List <Location_ado> extraList = DbTestHelper.LoadExtraneousLocations();
Site results = new Site()
{
Id = extraList[0].LocationId
};
SiteMapper.GetBoundaries(results);
Assert.IsNotNull(results.Boundaries, "results are null");
Assert.AreEqual(0, results.Boundaries.Count(), "wrong count");
}
public GridViewModel GetSearchResult(SearchRequest request)
{
var model = SiteMapper.CreateGridViewModel();
var pageResult = QueryListHelper.SortResults(GetAllSites(), request);
var serviceRows = pageResult
.Where(p => string.IsNullOrEmpty(request.SearchText) || p.Name.StartsWith(request.SearchText, StringComparison.CurrentCultureIgnoreCase))
.Select(SiteMapper.BindGridData);
model.Rows = serviceRows.ToPagedList(request.Page ?? 1, request.PageSize);
return(model);
}
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);
}
}
public void t_Site_Select_All()
{
// Backdoor setup
List <Location_ado> list = DbTestHelper.LoadExtraneousLocations();
List <Location_ado> siteAdoList = extraSites(list);
// Exercise the test
List <Site> siteList = SiteMapper.SelectAll();
// Validate results
Assert.AreEqual(siteAdoList.Count(), siteList.Count, "Wrong number of objects in the result list");
foreach (Location_ado ado in siteAdoList)
{
// just check to make sure the object is there; leave specific value check for the Select_ByGuid test
Assert.IsTrue(siteList.Exists(x => x.Id.Equals(ado.LocationId)), "Location " + ado.LocationId.ToString() + " is not in the results");
}
}
public void t_Site_Select_ByCodeName()
{
Location_ado location = null;
// backdoor data setup
DbTestHelper.LoadAdoObjects(delegate(IbaUnitTestEntities iba)
{
location = Location_ado.CreateLocation_ado(new Guid("87606168-3ac7-402a-8ae6-4f6905555581"),
"locationName", LookupConstants.LocationTypeSite);
location.CodeName = "abc";
location.Latitude = 89.3M;
location.Longitude = 90.10093M;
location.ParentLocationId = null;
iba.AddToLocation_ado(location);
});
DbTestHelper.LoadExtraneousLocations();
// Exercise the test
Site site = SiteMapper.Select_ByCodeName(location.CodeName);
validateResults(location, site);
}
public void t_Site_Select_ByCodeName_Long()
{
// Exercise the test
Site site = SiteMapper.Select_ByCodeName("01234567890");
}
public void t_Site_Select_ByCodeName_EmptyString()
{
// Exercise the test
Site site = SiteMapper.Select_ByCodeName(string.Empty);
}
public void t_Site_Select_ByCodeName_Null()
{
// Exercise the test
Site site = SiteMapper.Select_ByCodeName(null);
}
public void t_Site_Select_ByGuid_Empty()
{
SiteMapper.Select(Guid.Empty);
}
