//Ausgabe aller Kunden mit Kundendetails
public Person[] getGesamt()
{
List <Person> liste = new List <Person>();
MySqlCommand comm = new MySqlCommand("select persnr, name, vorname, sprache, grad from person inner join sprachen using (persnr)", conn);
MySqlDataReader msdr = comm.ExecuteReader();
while (msdr.Read())
{
Person suche = liste.Find(p => p.persNr == msdr["persnr"].ToString());
if (suche != null)
{
Sprachen s = new Sprachen();
s.sprache = msdr["sprache"].ToString();
s.grad = Convert.ToInt32(msdr["grad"].ToString());
suche.sprachen.Add(s);
}
else
{
suche = new Person();
suche.name = msdr["name"].ToString();
suche.vorname = msdr["vorname"].ToString();
suche.persNr = msdr["persnr"].ToString();
suche.sprachen = new List <Sprachen>();
Sprachen s = new Sprachen();
s.sprache = msdr["sprache"].ToString();
s.grad = Convert.ToInt32(msdr["grad"].ToString());
suche.sprachen.Add(s);
liste.Add(suche);
}
}
msdr.Close();
return(liste.ToArray());
}
public List <Sprachen> getSprachen(String nummer)
{
List <Sprachen> liste = new List <Sprachen>();
MySqlCommand sec = new MySqlCommand("select sprache, grad from sprachen where persnr = '" + nummer + "'", conn);
MySqlDataReader data = sec.ExecuteReader();
while (data.Read())
{
Sprachen s = new Sprachen();
s.sprache = data["sprache"].ToString();
s.grad = Convert.ToInt32(data["grad"].ToString());
liste.Add(s);
}
data.Close();
return(liste);
}