public void Create(CpuMetricModel item)
{
using var connection = new SQLiteConnection(_provider.GetConnectionString());
connection.Execute("INSERT INTO cpumetrics(value, time) VALUES(@value, @time)",
new
{
value = item.Value,
time = item.Time.ToUnixTimeSeconds()
});
}
public void Update(CpuMetricModel item)
{
using var connection = new SQLiteConnection(_provider.GetConnectionString());
connection.Execute("UPDATE cpumetrics SET value = @value, time = @time WHERE id = @id",
new
{
value = item.Value,
time = item.Time,
id = item.Id
});
}
public void Create(CpuMetricModel item)
{
using var connection = new SQLiteConnection(_connection);
connection.Execute("INSERT INTO cpumetrics(idagent, value, time) VALUES(@idagent, @value, @time)",
new
{
idagent = item.IdAgent,
value = item.Value,
time = item.Time
});
}
public void Update(CpuMetricModel item)
{
using var connection = new SQLiteConnection(_connection);
connection.Execute("UPDATE cpumetrics SET value = @value, time = @time, idagent = @idagent WHERE id = @id",
new
{
value = item.Value,
time = item.Time,
idagent = item.IdAgent,
id = item.Id
});
}
public IActionResult Create([FromBody] CpuMetricModel item)
{
_repository.Create(item);
return(Ok());
}
