public List <Detail> GetAllIoTDeviceByCompanyId(int companyId) { DBHelper._IoTDevice dbhelp_iotDevice = new DBHelper._IoTDevice(); DBHelper._Factory dbhelp_factory = new DBHelper._Factory(); List <int> factoryIdList = dbhelp_factory.GetAllByCompanyId(companyId).Select(s => s.Id).ToList <int>(); List <IoTDevice> iotDeviceList = new List <IoTDevice>(); foreach (int factoryId in factoryIdList) { iotDeviceList.AddRange(dbhelp_iotDevice.GetAllByFactory(factoryId)); } return(iotDeviceList.Select(s => new Detail() { IoTHubDeviceId = s.IoTHubDeviceID, IoTHubAlias = s.IoTHubAlias, IoTHubProtocol = s.IoTHubProtocol, FactoryId = s.FactoryID.ToString(), FactoryName = (s.Factory == null ? "" : s.Factory.Name), AuthenticationType = s.AuthenticationType, DeviceCertificateId = s.DeviceCertificateID.ToString(), DeviceCertificateName = (s.DeviceCertificate == null ? "" : s.DeviceCertificate.Name), DeviceTypeId = s.DeviceTypeId.ToString(), DeviceTypeName = (s.DeviceType == null ? "" : s.DeviceType.Name), DeviceVendor = s.DeviceVendor, DeviceModel = s.DeviceModel, DeviceConfigurationStatus = s.DeviceConfigurationStatus.ToString() }).ToList <Detail>()); }
public List <Detail_readonly> GetAllIoTDeviceByFactoryIdReadonly(int factoryId) { DBHelper._IoTDevice dbhelp_iotDevice = new DBHelper._IoTDevice(); return(dbhelp_iotDevice.GetAllByFactory(factoryId).Select(s => new Detail_readonly() { IoTHubDeviceId = s.IoTHubDeviceID, IoTHubProtocol = s.IoTHubProtocol, FactoryId = s.FactoryID.ToString(), FactoryName = s.Factory.Name, DeviceTypeId = s.DeviceTypeId.ToString(), DeviceTypeName = s.DeviceType.Name, DeviceVendor = s.DeviceVendor, DeviceModel = s.DeviceModel }).ToList <Detail_readonly>()); }
public List <Detail> GetAllIoTDeviceByFactoryId(int factoryId) { DBHelper._IoTDevice dbhelp_iotDevice = new DBHelper._IoTDevice(); return(dbhelp_iotDevice.GetAllByFactory(factoryId).Select(s => new Detail() { IoTHubDeviceId = s.IoTHubDeviceID, IoTHubAlias = s.IoTHubAlias, IoTHubProtocol = s.IoTHubProtocol, FactoryId = s.FactoryID.ToString(), FactoryName = (s.Factory == null ? "" : s.Factory.Name), AuthenticationType = s.AuthenticationType, DeviceCertificateId = s.DeviceCertificateID.ToString(), DeviceCertificateName = (s.DeviceCertificate == null ? "" : s.DeviceCertificate.Name), DeviceTypeId = s.DeviceTypeId.ToString(), DeviceTypeName = (s.DeviceType == null ? "" : s.DeviceType.Name), DeviceVendor = s.DeviceVendor, DeviceModel = s.DeviceModel, DeviceConfigurationStatus = s.DeviceConfigurationStatus.ToString() }).ToList <Detail>()); }
public List <Detail_readonly> GetAllIoTDeviceByCompanyIdReadonly(int companyId) { DBHelper._IoTDevice dbhelp_iotdevice = new DBHelper._IoTDevice(); DBHelper._Factory dbhelp_factory = new DBHelper._Factory(); List <IoTDevice> iotDeviceList = new List <IoTDevice>(); List <int> factoryIdList = dbhelp_factory.GetAllByCompanyId(companyId).Select(s => s.Id).ToList <int>(); foreach (int factoryId in factoryIdList) { iotDeviceList.AddRange(dbhelp_iotdevice.GetAllByFactory(factoryId)); } return(iotDeviceList.Select(s => new Detail_readonly() { IoTHubDeviceId = s.IoTHubDeviceID, IoTHubProtocol = s.IoTHubProtocol, FactoryId = s.FactoryID.ToString(), FactoryName = s.Factory.Name, DeviceTypeId = s.DeviceTypeId.ToString(), DeviceTypeName = s.DeviceType.Name, DeviceVendor = s.DeviceVendor, DeviceModel = s.DeviceModel }).ToList <Detail_readonly>()); }