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