public OperadorEntity busca(string nome)
{
this.connection.openConnection();
MySqlCommand cmd = new MySqlCommand(SELECT_NOME, this.connection.conn);
cmd.Parameters.Add(new MySqlParameter("0", nome));
MySqlDataReader rdr = cmd.ExecuteReader();
OperadorEntity entity = new OperadorEntity();
while (rdr.Read())
{
entity.id = rdr.GetInt32(rdr.GetOrdinal("ID"));
entity.nome = rdr.GetString(rdr.GetOrdinal("NOME"));
entity.senha = rdr.GetString(rdr.GetOrdinal("SENHA"));
}
this.connection.closeConnection();
return(entity);
}
public List <OperadorEntity> busca()
{
this.connection.openConnection();
List <OperadorEntity> operadorList = new List <OperadorEntity>();
MySqlCommand cmd = new MySqlCommand(SELECT_ALL, this.connection.conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
OperadorEntity entity = new OperadorEntity();
entity.id = rdr.GetInt32(rdr.GetOrdinal("ID"));
entity.nome = rdr.GetString(rdr.GetOrdinal("NOME"));
entity.senha = rdr.GetString(rdr.GetOrdinal("SENHA"));
operadorList.Add(entity);
}
this.connection.closeConnection();
return(operadorList);
}
