1 Commits

Author SHA1 Message Date
e0ca716162 teste 2025-07-30 18:15:43 +00:00

View File

@@ -20,34 +20,18 @@ namespace Workshop8.Data
public async Task<IEnumerable<Cliente>> GetAllClientsAsync()
{
// SELECT
var clientes = new List<Cliente>();
await using var conn = new SqliteConnection(_connectionString);
await conn.OpenAsync();
var cmd = conn.CreateCommand();
cmd.CommandText = "SELECT id, nome, email, CriadoEm FROM Clientes;";
await using var reader = await cmd.ExecuteReaderAsync();
while (await reader.ReadAsync())
{
var c = new Cliente
{
Id = reader.GetInt32(0),
Nome = reader.GetString(1),
Email = reader.GetString(2),
CriadoEm = reader.GetDateTime(3)
};
clientes.Add(c);
}
return clientes;
// TODO: implementar SELECT
return new List<Cliente>();
}
public async Task AddClientAsync(Cliente c)
{
// TODO: implementar INSERT
//teste
}
public async Task UpdateClientAsync(Cliente c)