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); }