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); }