public EmpresasType select() { EmpresasType types = new EmpresasType(); return types; }
public EmpresasType selectByAssociacao(AssociacaoType associacao) { EmpresasType types = new EmpresasType(); MySqlConnection con = new MySqlConnection(Dados.StringConexao); string SQL = "SELECT * FROM empresa " + "WHERE id_associacao = @id"; MySqlCommand cmd = new MySqlCommand(SQL, con); cmd.Parameters.AddWithValue("@id", associacao.IdAssociacao); con.Open(); MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { types.Add(execReader(dr)); } return types; }
public EmpresasType select() { EmpresasType types = new EmpresasType(); return(types); }