/************** Site ************/ public bool SiteAdd(Site site) { try { iotContext db = new iotContext(); iotDomain targetDomain = (from d in db.Domains where site.Domain.Id == d.Id select d).First(); Location siteLocation = (from l in db.Locations where l.Id == site.siteLocation.Id select l).First(); Site nsite = new Site(); nsite.SiteName = site.SiteName; nsite.Domain = targetDomain; nsite.siteLocation = siteLocation; db.Sites.Add(nsite); db.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
/************** Type ************/ public ParameterType TypeForName(string name) { try { iotContext db = new iotContext(); List <ParameterType> types = (from d in db.ParamTypes where d.Name.Equals(name) select d).ToList(); if (types.Count == 0) { //add type ParameterType type = new ParameterType(); type.Name = name; ParameterType storedType = db.ParamTypes.Add(type); db.SaveChanges(); return(storedType); } else { return(types.First()); } } catch (Exception e) { return(new ParameterType()); } }
static public void ClearIotRepository() { iotContext dbContext = new iotContext(); var tableNames = dbContext.Database.SqlQuery <string>("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME NOT LIKE '%Migration%'").ToList(); foreach (var tableName in tableNames) { dbContext.Database.ExecuteSqlCommand(string.Format("DELETE FROM {0}", tableName)); } dbContext.SaveChanges(); }
/************** Action param ************/ public bool ActionParamAdd(ActionParameter param) { try { if (param != null) { iotContext db = new iotContext(); db.ActionParameters.Add(param); db.SaveChanges(); //TODO verify save } } catch (Exception e) { } return(true); }
/************** Mapper ************/ public bool MapperAdd(sconnActionResultMapper param) { try { if (param != null) { iotContext db = new iotContext(); db.ActionResultMappers.Add(param); db.SaveChanges(); //TODO verify save } } catch (Exception e) { } return(true); }
/************** Type ************/ public bool TypeAdd(DeviceType param) { try { if (param != null) { iotContext db = new iotContext(); db.Types.Add(param); db.SaveChanges(); //TODO verify save } } catch (Exception e) { } return(true); }
/************** Endpoint ************/ public bool EndpointAdd(EndpointInfo edp) { try { if (edp != null) { iotContext db = new iotContext(); db.Endpoints.Add(edp); db.SaveChanges(); //TODO verify save } } catch (Exception e) { } return(true); }
/************** Location ************/ public bool LocationAdd(Location loc) { try { if (loc != null) { iotContext db = new iotContext(); db.Locations.Add(loc); db.SaveChanges(); //TODO verify save } } catch (Exception e) { } return(true); }
/************** Property ************/ public bool PropertyAdd(DeviceProperty property) { try { if (property != null) { iotContext db = new iotContext(); db.Properties.Add(property); db.SaveChanges(); //TODO verify save } } catch (Exception e) { } return(true); }
/************** Action ************/ public bool ActionAdd(DeviceAction action) { try { if (action != null) { iotContext db = new iotContext(); db.Actions.Add(action); db.SaveChanges(); //TODO verify save } } catch (Exception e) { } return(true); }
/************** Device ************/ public bool DeviceAdd(Device device) { try { if (device != null) { iotContext db = new iotContext(); db.Devices.Add(device); db.SaveChanges(); //TODO verify save } } catch (Exception e) { } return(true); }
/**************************** Execute ****************************/ /************** Domain ************/ public bool DomainAdd(iotDomain domain) { try { if (domain != null) { iotContext db = new iotContext(); db.Domains.Add(domain); db.SaveChanges(); //TODO verify save } } catch (Exception e) { } return(true); }