// GET: api/Sensors/5 (sensor_id)
public IHttpActionResult GetSensorById(int id)
{
List <SensorParameter> sensors = new List <SensorParameter>();
SensorParameter sensor = null;
try
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM SensorsParameters WHERE Sensor_Id=@id;";
cmd.Parameters.AddWithValue("@id", id);
cmd.Connection = conn;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
sensor = new SensorParameter
(
(int)reader["Read_Id"],
(int)reader["Sensor_Id"],
(string)reader["Parameter"],
(int)reader["Read_Value"],
(string)reader["Location"],
(DateTime)reader["DateTime"]
);
sensors.Add(sensor);
}
reader.Close();
conn.Close();
}
catch (Exception ex)
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
throw ex;
}
if (sensor == null)
{
return(NotFound());
}
else
{
return(Ok(sensors));
}
}
// GET: api/Sensors
public IEnumerable <SensorParameter> GetAllSensors()
{
List <SensorParameter> lista = new List <SensorParameter>();
SensorParameter sensor = null;
try
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM SensorsParameters;";
cmd.Connection = conn;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
sensor = new SensorParameter
(
(int)reader["Read_Id"],
(int)reader["Sensor_Id"],
(string)reader["Parameter"],
(int)reader["Read_Value"],
(string)reader["Location"],
(DateTime)reader["DateTime"]
);
lista.Add(sensor);
}
reader.Close();
conn.Close();
}
catch (Exception ex)
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
throw ex;
}
return(lista);
}
public void AddParameter(SensorParameter parameter)
{
}
public void AddParameter(SensorParameter parameter)
{
_parameters.Add(parameter);
}
public override void Execute(object parameter)
{
//Добавление датчиков в шаблон
if (_templateDeviceViewModel != null)
{
if (_templateDeviceViewModel.SelectedSensor == null ||
_templateDeviceViewModel.SelectedParameter == null ||
_templateDeviceViewModel.CodeParameter == null || _templateDeviceViewModel.CodeParameter == "")
{
MessageBox.Show("Заполните все поля!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
string url = "http://h92761ae.beget.tech/add_sensor_of_device.php?id_temp_device=" + _templateDeviceViewModel.SelectedTemplate.Id +
"&id_sensor=" + _templateDeviceViewModel.SelectedSensor.Id +
"&id_parameter=" + _templateDeviceViewModel.SelectedParameter.IdParameter +
"&code_parameter=" + _templateDeviceViewModel.CodeParameter +
"&id_in_device=" + _templateDeviceViewModel.IdInDevice;
if (!BackClient.SendRequest(url))
{
return;
}
SensorsOfDevice sensorsOfDevice = new SensorsOfDevice
{
NameSensor = _templateDeviceViewModel.SelectedSensor.Name,
NameParameter = _templateDeviceViewModel.SelectedParameter.NameParameter,
CodeParameter = _templateDeviceViewModel.CodeParameter,
IdInDevice = _templateDeviceViewModel.IdInDevice,
IdSensor = _templateDeviceViewModel.SelectedSensor.Id,
IdParameter = _templateDeviceViewModel.SelectedParameter.IdParameter,
IdTemplateDevice = _templateDeviceViewModel.SelectedTemplate.Id
};
_templateDeviceViewModel.SelectedTemplate.SensorsOfDevices.Add(sensorsOfDevice);
}
//Добавление параметров датчику
if (_sensorViewModel != null)
{
if (_sensorViewModel.SelectedSensor == null ||
_sensorViewModel.SelectedParameterType == null)
{
MessageBox.Show("Заполните все поля!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
string url = "http://h92761ae.beget.tech/add_sensor_parameter.php?id_parameter=" + _sensorViewModel.SelectedParameter.Id +
"&id_sensor=" + _sensorViewModel.SelectedSensor.Id +
"&id_type_parameter=" + _sensorViewModel.SelectedParameterType.Id;
if (!BackClient.SendRequest(url))
{
return;
}
SensorParameter sensorParameter = new SensorParameter
{
NameParameter = _sensorViewModel.SelectedParameter.Name,
NameTypeParameter = _sensorViewModel.SelectedParameterType.Name,
IdParameter = _sensorViewModel.SelectedParameter.Id,
IdTypeParameter = _sensorViewModel.SelectedParameterType.Id,
IdSensor = _sensorViewModel.SelectedSensor.Id
};
_sensorViewModel.SelectedSensor.SensorParameters.Add(sensorParameter);
}
//Добавление параметров
if (_parameterViewModel != null)
{
if (string.IsNullOrEmpty(_parameterViewModel.Name) || string.IsNullOrEmpty(_parameterViewModel.Description))
{
MessageBox.Show("Заполните все поля!", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
string url = "http://h92761ae.beget.tech/add_parameter.php?name=" + _parameterViewModel.Name +
"&description=" + _parameterViewModel.Description;
if (!BackClient.SendRequest(url))
{
return;
}
Parameter param = new Parameter
{
Name = _parameterViewModel.Name,
Description = _parameterViewModel.Description
};
_parameterViewModel.Parameters.Add(param);
}
}
