public void deleteIoTDeviceConfiguration(int id) { DBHelper._IoTDeviceCustomizedConfiguration dbhelp = new DBHelper._IoTDeviceCustomizedConfiguration(); IoTDeviceCustomizedConfiguration existingIoTDCC = dbhelp.GetByid(id); dbhelp.Delete(existingIoTDCC); }
public void updateCustomizedConfiguration(int id, Update iotDCC) { DBHelper._IoTDeviceCustomizedConfiguration dbhelp = new DBHelper._IoTDeviceCustomizedConfiguration(); IoTDeviceCustomizedConfiguration existingIoTDCC = dbhelp.GetByid(id); existingIoTDCC.Name = iotDCC.Name; existingIoTDCC.DataType = iotDCC.DataType; existingIoTDCC.Description = iotDCC.Description; existingIoTDCC.DefaultValue = iotDCC.DefaultValue; dbhelp.Update(existingIoTDCC); }
public List <Detail> GetAllCustomizedConfigurationByCompanyId(int companyId) { DBHelper._IoTDeviceCustomizedConfiguration dbhelp = new DBHelper._IoTDeviceCustomizedConfiguration(); return(dbhelp.GetAllByCompanyId(companyId).Select(s => new Detail() { Id = s.Id, Name = s.Name, DataType = s.DataType, Description = s.Description, DefaultValue = s.DefaultValue }).ToList <Detail>()); }
public Detail getCustomizedConfigurationById(int id) { DBHelper._IoTDeviceCustomizedConfiguration dbhelp = new DBHelper._IoTDeviceCustomizedConfiguration(); IoTDeviceCustomizedConfiguration iotDCC = dbhelp.GetByid(id); return(new Detail() { Id = iotDCC.Id, Name = iotDCC.Name, DataType = iotDCC.DataType, Description = iotDCC.Description, DefaultValue = iotDCC.DefaultValue }); }
public void addIoTDeviceConfiguration(Add iotDCC) { DBHelper._IoTDeviceCustomizedConfiguration dbhelp = new DBHelper._IoTDeviceCustomizedConfiguration(); var newIoTCustomizedConfiguration = new IoTDeviceCustomizedConfiguration() { CompanyId = iotDCC.CompanyId, Name = iotDCC.Name, DataType = iotDCC.DataType, Description = iotDCC.Description, DefaultValue = iotDCC.DefaultValue }; dbhelp.Add(newIoTCustomizedConfiguration); }
public List <Detail> GetAll(string deviceID) { DBHelper._IoTDevice dbhelp_iotDevice = new DBHelper._IoTDevice(); DBHelper._IoTDeviceConfiguration dbhelp_sysConfig = new DBHelper._IoTDeviceConfiguration(); DBHelper._IoTDeviceCustomizedConfiguration dbhelp_customizedConfig = new DBHelper._IoTDeviceCustomizedConfiguration(); List <Detail> returnConfigList = new List <Detail>(); IoTDevice iotDevice = dbhelp_iotDevice.GetByid(deviceID); int companyId = iotDevice.Factory.CompanyId; /***** retrieve existing desired config *****/ JObject desiredProperty = JObject.Parse(iotDevice.DeviceTwinsDesired); Dictionary <string, string> dic_existingSysDesiredConfig = new Dictionary <string, string>(); if (desiredProperty["SF_SystemConfig"] != null) { JObject systemConfig = JObject.Parse(desiredProperty["SF_SystemConfig"].ToString()); foreach (var obj in systemConfig) { string value = obj.Value.Value <string>(); if (value == "True" || value == "False") { value = value.ToLower(); } dic_existingSysDesiredConfig.Add(obj.Key, value); } } Dictionary <string, string> dic_existingCustomizedDesiredConfig = new Dictionary <string, string>(); if (desiredProperty["SF_CustomizedConfig"] != null) { JObject customizedConfig = JObject.Parse(desiredProperty["SF_CustomizedConfig"].ToString()); foreach (var obj in customizedConfig) { string value = obj.Value.Value <string>(); if (value == "True" || value == "False") { value = value.ToLower(); } dic_existingCustomizedDesiredConfig.Add(obj.Key, value); } } /***** retrieve existing reported config *****/ JObject reportedProperty = JObject.Parse(iotDevice.DeviceTwinsReported); Dictionary <string, string> dic_existingSysReportedConfig = new Dictionary <string, string>(); if (reportedProperty["SF_SystemConfig"] != null) { JObject systemConfig = JObject.Parse(reportedProperty["SF_SystemConfig"].ToString()); foreach (var obj in systemConfig) { dic_existingSysReportedConfig.Add(obj.Key, obj.Value.Value <string>()); } } Dictionary <string, string> dic_existingCustomizedReportedConfig = new Dictionary <string, string>(); if (reportedProperty["SF_CustomizedConfig"] != null) { JObject customizedConfig = JObject.Parse(reportedProperty["SF_CustomizedConfig"].ToString()); foreach (var obj in customizedConfig) { dic_existingCustomizedReportedConfig.Add(obj.Key, obj.Value.Value <string>()); } } /***** return System Configuration *****/ foreach (var config in dbhelp_sysConfig.GetAll()) { if (dic_existingSysDesiredConfig.ContainsKey(config.Name)) { returnConfigList.Add(new Detail() { IsSystem = true, Readonly = false, ConfigurationName = config.Name, ConfigurationDataTye = config.DataType, ConfigurationDescription = config.Description, DeviceValue = dic_existingSysReportedConfig.ContainsKey(config.Name) ? dic_existingSysReportedConfig[config.Name] : "", SettingValue = dic_existingSysDesiredConfig[config.Name], EnabledFlag = true }); } else { returnConfigList.Add(new Detail() { IsSystem = true, Readonly = false, ConfigurationName = config.Name, ConfigurationDataTye = config.DataType, ConfigurationDescription = config.Description, DeviceValue = "", SettingValue = config.DefaultValue, EnabledFlag = false }); } } /***** return Customized Configuration *****/ List <string> list_deviceCustomizedConfigName = new List <string>(); foreach (var config in dbhelp_customizedConfig.GetAllByCompanyId(companyId)) { if (dic_existingCustomizedDesiredConfig.ContainsKey(config.Name)) { returnConfigList.Add(new Detail() { IsSystem = false, Readonly = false, ConfigurationName = config.Name, ConfigurationDataTye = config.DataType, ConfigurationDescription = config.Description, DeviceValue = dic_existingCustomizedReportedConfig.ContainsKey(config.Name) ? dic_existingCustomizedReportedConfig[config.Name] : "", SettingValue = dic_existingCustomizedDesiredConfig[config.Name], EnabledFlag = true }); } else { returnConfigList.Add(new Detail() { IsSystem = false, Readonly = false, ConfigurationName = config.Name, ConfigurationDataTye = config.DataType, ConfigurationDescription = config.Description, DeviceValue = "", SettingValue = config.DefaultValue, EnabledFlag = false }); } list_deviceCustomizedConfigName.Add(config.Name); } /***** return Customized Configuration (readonly) *****/ foreach (var config in dic_existingCustomizedReportedConfig) { if (!list_deviceCustomizedConfigName.Contains(config.Key)) { returnConfigList.Add(new Detail() { IsSystem = false, Readonly = true, ConfigurationName = config.Key, ConfigurationDataTye = "", ConfigurationDescription = "", DeviceValue = config.Value, SettingValue = "", EnabledFlag = false }); } } return(returnConfigList); }