private void AddPropertyForMapperAndDevice(sconnConfigMapper maper, Device edited, int DevNo) { try { iotRepository <DeviceProperty> proprepo = new iotRepository <DeviceProperty>(); DeviceProperty prop = new DeviceProperty(); prop.PropertyName = "Input" + maper.SeqNumber; //TODO read from name cfg prop.Device = edited; prop.LastUpdateTime = DateTime.Now; proprepo.Add(prop); List <DeviceProperty> storeprops = proprepo.GetAll().ToList(); DeviceProperty storedProp = (from s in storeprops where s.PropertyName == prop.PropertyName select s).First(); //create parameter and bind mapper to it iotRepository <DeviceParameter> paramrepo = new iotRepository <DeviceParameter>(); DeviceParameter param = new DeviceParameter(); param.Value = sconnConfigToStringVal(maper, site.siteCfg.deviceConfigs[DevNo]); param.Type = ParamTypeForSconnMapper(maper); param.Property = storedProp; paramrepo.Add(param); List <DeviceParameter> storeparams = paramrepo.GetAll().ToList(); DeviceParameter storedParam = (from p in storeparams where p.Property == param.Property select p).First(); maper.Parameter = storedParam; iotRepository <sconnConfigMapper> mapperRepo = new iotRepository <sconnConfigMapper>(); mapperRepo.Add(maper); } catch (Exception e) { } }
/**** LOAD ****/ public void TestEntityDbWriteLoad() { try { int ReadTestInterations = 5; int maxQueryTimeMs = 25; Stopwatch watch = new Stopwatch(); watch.Start(); for (int i = 0; i < ReadTestInterations; i++) { iotRepository <Location> locrepo = new iotRepository <Location>(); Location loc = new Location(); loc.LocationName = Guid.NewGuid().ToString(); loc.Lat = 0; loc.Lng = 0; locrepo.Add(loc); } watch.Stop(); double TimePerQueryMs = watch.ElapsedMilliseconds / ReadTestInterations; Assert.IsTrue(TimePerQueryMs < maxQueryTimeMs); } catch (Exception ex) { Assert.Fail(); } }
public void TestRepoUpdate() { iotRepository <Location> repo = new iotRepository <Location>(); //get List <Location> locs = repo.GetAll().ToList(); //add if required Location loc = new Location(); if (locs != null) { loc.LocationName = Guid.NewGuid().ToString(); loc.Lat = 0; loc.Lng = 0; repo.Add(loc); //update locs = repo.GetAll().ToList(); loc = locs.Where(l => { return(l.LocationName == loc.LocationName); }).First(); Location StoredBefore = repo.GetById(loc.Id); StoredBefore.Lat = 53.325241; repo.Update(StoredBefore); //verify Location stored = repo.GetById(loc.Id); Assert.IsTrue(loc.Lat == stored.Lat); } }
public void TestConnectorRepo() { iotRepository <iotDomain> repo = new iotRepository <iotDomain>(); List <iotDomain> domains = repo.GetAll().ToList(); Assert.IsTrue(domains != null); }
public void TestEntityDbReadLoad() { try { int ReadTestInterations = 250; int maxQueryTimeMs = 25; bool ReadSuccess = false; int FailCount = 0; TestRepoCreate(); Stopwatch watch = new Stopwatch(); iotRepository <iotDomain> repo = new iotRepository <iotDomain>(); List <iotDomain> domains = repo.GetAll().ToList(); iotDomain domain = domains.First(); watch.Start(); for (int i = 0; i < ReadTestInterations; i++) { ReadSuccess = TestRepoSingleRead(domain.Id); if (!ReadSuccess) { FailCount++; } } watch.Stop(); double TimePerQueryMs = watch.ElapsedMilliseconds / ReadTestInterations; Assert.IsTrue(TimePerQueryMs < maxQueryTimeMs); } catch (Exception ex) { Assert.Fail(); } }
public void TestRepoRead() { iotRepository <Location> repo = new iotRepository <Location>(); List <Location> locs = repo.GetAll().ToList(); Assert.IsTrue(locs != null); }
public List <Device> GetAllDevice() { try { iotRepository <Device> repo = new iotRepository <Device>(); return(repo.GetAll().ToList()); } catch (Exception ex) { throw new FaultException(ex.Message); } }
public EndpointInfo EndpointWithId(int id) { try { iotRepository <EndpointInfo> repo = new iotRepository <EndpointInfo>(); return(repo.GetById(id)); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(new EndpointInfo()); } }
public DeviceCredentials DeviceCredentialWithId(int id) { try { iotRepository <DeviceCredentials> repo = new iotRepository <DeviceCredentials>(); return(repo.GetById(id)); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(new DeviceCredentials()); } }
public ActionParameter ActionParamWithId(int id) { try { iotRepository <ActionParameter> repo = new iotRepository <ActionParameter>(); return(repo.GetById(id)); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(new ActionParameter()); } }
public iotDomain DomainWithId(int id) { try { iotRepository <iotDomain> repo = new iotRepository <iotDomain>(); return(repo.GetById(id)); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(new iotDomain()); } }
public int AddDevice(Device Device) { try { iotRepository <Device> repo = new iotRepository <Device>(); repo.Add(Device); return(Device.Id); } catch (Exception ex) { throw new FaultException(ex.Message); } }
public bool UpdateDevice(Device Device) { try { iotRepository <Device> repo = new iotRepository <Device>(); repo.Update(Device); return(true); } catch (Exception ex) { throw new FaultException(ex.Message); } }
public Device GetDevice(string id) { try { int DeviceId = Convert.ToInt32(id); iotRepository <Device> repo = new iotRepository <Device>(); return(repo.GetById(DeviceId)); } catch (Exception ex) { throw new FaultException(ex.Message); } }
public bool TestRepoSingleRead(int id) { try { iotRepository <Location> repo = new iotRepository <Location>(); Location locs = repo.GetById(id); return(locs != null); } catch (Exception ex) { return(false); } }
public void TestRepoCreate() { iotRepository <iotDomain> locrepo = new iotRepository <iotDomain>(); iotDomain dm = new iotDomain(); dm.DomainName = Guid.NewGuid().ToString(); dm.Sites = new List <Site>(); locrepo.Add(dm); List <iotDomain> locs = locrepo.GetAll().ToList(); Assert.IsTrue(locs.Contains(dm)); locrepo.Delete(dm); }
public DeviceType DeviceTypeWithId(int id) { try { iotRepository <DeviceType> repo = new iotRepository <DeviceType>(); return(repo.GetById(id)); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(new DeviceType()); } }
public bool SiteUpdate(Site domain) { try { iotRepository <Site> repo = new iotRepository <Site>(); repo.Update(domain); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }
public bool ActionUpdate(DeviceAction domain) { try { iotRepository <DeviceAction> repo = new iotRepository <DeviceAction>(); repo.Update(domain); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }
public bool ResParamUpdate(DeviceParameter domain) { try { iotRepository <DeviceParameter> repo = new iotRepository <DeviceParameter>(); repo.Update(domain); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }
/******************* Add ***********************/ public bool DeviceAdd(Device dev) { try { iotRepository <Device> repo = new iotRepository <Device>(); repo.Add(dev); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }
public bool PropertyRemove(DeviceProperty domain) { try { iotRepository <DeviceProperty> repo = new iotRepository <DeviceProperty>(); repo.Delete(domain); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }
public String GetSomeJson() { try { } catch (Exception ex) { _logger.ErrorException(ex.Message, ex); } iotRepository <Device> repo = new iotRepository <Device>(); Device dev = repo.GetById(52); return(JsonConvert.SerializeObject(dev)); }
public bool ReqParamRemove(ActionParameter domain) { try { iotRepository <ActionParameter> repo = new iotRepository <ActionParameter>(); repo.Delete(domain); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }
public bool LocationRemove(Location domain) { try { iotRepository <Location> repo = new iotRepository <Location>(); repo.Delete(domain); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }
public bool ActionAdd(DeviceAction action) { try { iotRepository <DeviceAction> repo = new iotRepository <DeviceAction>(); repo.Add(action); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }
public bool DeviceCredentialsRemove(DeviceCredentials creds) { try { iotRepository <DeviceCredentials> repo = new iotRepository <DeviceCredentials>(); repo.Delete(creds); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }
public bool DeviceTypeRemove(DeviceType type) { try { iotRepository <DeviceType> repo = new iotRepository <DeviceType>(); repo.Delete(type); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }
public bool EndpointRemove(EndpointInfo endp) { try { iotRepository <EndpointInfo> repo = new iotRepository <EndpointInfo>(); repo.Delete(endp); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }
public bool SiteAdd(Site site) { try { iotRepository <Site> repo = new iotRepository <Site>(); repo.Add(site); return(true); } catch (Exception e) { nlogger.ErrorException(e.Message, e); return(false); } }