public void deleteIoTDeviceConfiguration(int id)
{
DBHelper._IoTDeviceConfiguration dbhelp = new DBHelper._IoTDeviceConfiguration();
IoTDeviceSystemConfiguration existingIoTDC = dbhelp.GetByid(id);
dbhelp.Delete(existingIoTDC);
}
public void updateIoTDeviceConfiguration(int id, Edit iotDC)
{
DBHelper._IoTDeviceConfiguration dbhelp = new DBHelper._IoTDeviceConfiguration();
IoTDeviceSystemConfiguration existingIoTDC = dbhelp.GetByid(id);
existingIoTDC.Name = iotDC.Name;
existingIoTDC.DataType = iotDC.DataType;
existingIoTDC.Description = iotDC.Description;
existingIoTDC.DefaultValue = iotDC.DefaultValue;
dbhelp.Update(existingIoTDC);
}
public void addIoTDeviceConfiguration(Edit iotDC)
{
DBHelper._IoTDeviceConfiguration dbhelp = new DBHelper._IoTDeviceConfiguration();
var newIoTDeviceConfiguration = new IoTDeviceSystemConfiguration()
{
Name = iotDC.Name,
DataType = iotDC.DataType,
Description = iotDC.Description,
DefaultValue = iotDC.DefaultValue
};
dbhelp.Add(newIoTDeviceConfiguration);
}
public Detail getIoTDeviceConfigurationById(int id)
{
DBHelper._IoTDeviceConfiguration dbhelp = new DBHelper._IoTDeviceConfiguration();
IoTDeviceSystemConfiguration iotDC = dbhelp.GetByid(id);
return(new Detail()
{
Id = iotDC.Id,
Name = iotDC.Name,
DataType = iotDC.DataType,
Description = iotDC.Description,
DefaultValue = iotDC.DefaultValue
});
}
public void DeleteById(int id)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
IoTDeviceSystemConfiguration existingData = dbEntity.IoTDeviceSystemConfiguration.Find(id);
if (existingData == null)
{
throw new CDSException(10701);
}
dbEntity.IoTDeviceSystemConfiguration.Remove(existingData);
dbEntity.SaveChanges();
}
}
public int Create(Format_Create parseData)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
IoTDeviceSystemConfiguration newData = new IoTDeviceSystemConfiguration();
newData.Name = parseData.Name;
newData.DataType = parseData.DataType;
newData.Description = parseData.Description ?? "";
newData.DefaultValue = parseData.DefaultValue ?? "";
dbEntity.IoTDeviceSystemConfiguration.Add(newData);
dbEntity.SaveChanges();
return(newData.Id);
}
}
public Format_Detail GetById(int id)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
IoTDeviceSystemConfiguration existingData = (from c in dbEntity.IoTDeviceSystemConfiguration.AsNoTracking()
where c.Id == id
select c).SingleOrDefault <IoTDeviceSystemConfiguration>();
if (existingData == null)
{
throw new CDSException(10701);
}
return(new Format_Detail()
{
Id = existingData.Id,
Name = existingData.Name,
DataType = existingData.DataType,
Description = existingData.Description,
DefaultValue = existingData.DefaultValue
});
}
}
