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 }); }