public void Create(HddMetricModel item)
{
using var connection = new SQLiteConnection(_provider.GetConnectionString());
connection.Execute("INSERT INTO hddmetrics (freesize, time) VALUES(@freesize, @time)",
new
{
freesize = item.FreeSize,
time = item.Time.ToUnixTimeSeconds()
});
}
public void Update(HddMetricModel item)
{
using var connection = new SQLiteConnection(_provider.GetConnectionString());
connection.Execute("UPDATE hddmetrics SET value = @value, time = @time WHERE id = @id",
new
{
value = item.Value,
time = item.Time,
id = item.Id
});
}
public void Create(HddMetricModel item)
{
using var connection = new SQLiteConnection(_provider.GetConnectionString());
connection.Execute("INSERT INTO hddmetrics (value, time, idagent) VALUES(@value, @time, @idagent)",
new
{
value = item.Value,
time = item.Time.ToUnixTimeSeconds(),
idagent = item.IdAgent
});
}
public void Create(HddMetricModel item)
{
using var connection = new SQLiteConnection(_connection);
connection.Execute("INSERT INTO hddmetrics(idagent, value, time) VALUES(@idagent, @value, @time)",
new
{
idagent = item.IdAgent,
value = item.Value,
time = item.Time
});
}
public void Update(HddMetricModel item)
{
using var connection = new SQLiteConnection(_connection);
connection.Execute("UPDATE hddmetrics SET value = @value, time = @time, idagent = @idagent WHERE id = @id",
new
{
value = item.Value,
time = item.Time,
idagent = item.IdAgent,
id = item.Id
});
}
