public List<Marca> selectAll()
{
FbConnection conn = ConnectionFactory.getConnection();
FbCommand query = new FbCommand(SELECTALL, conn);
FbDataReader reader = null;
List<Marca> lista = null;
try
{
conn.Open();
reader = query.ExecuteReader();
while (reader.Read())
{
Marca marca = new Marca();
marca.setCodMarca(int.Parse(reader["codMarca"].ToString()));
marca.setDescricao(reader["descricao"].ToString());
lista.Add(marca);
}
}
catch (FbException ex)
{
ex.Message.ToString();
}
finally
{
ConnectionFactory.closeAll(conn, query, reader);
}
return lista;
}
public Marca selectById(Marca marca)
{
FbConnection conn = ConnectionFactory.getConnection();
FbCommand query = new FbCommand(SELECTBYID, conn);
FbDataReader reader = null;
try
{
query.Parameters.AddWithValue("@codMarca", marca.getCodMarca());
conn.Open();
reader = query.ExecuteReader();
if (reader.Read()) {
marca.setCodMarca(int.Parse(reader["codMarca"].ToString()));
marca.setDescricao(reader["descricao"].ToString());
}
}
catch (FbException ex)
{
ex.Message.ToString();
}
finally
{
ConnectionFactory.closeAll(conn, query, reader);
}
return marca;
}