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