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