public List <Buch> GetBuecher(int Autoren_id = 0)
{
VerbindungOeffnen();
string statement = "SELECT * " +
"FROM T_Buecher ";
if (Autoren_id > 0)
{
statement += "WHERE F_Autoren_id = " + Autoren_id;
}
FbCommand reader = new FbCommand(statement, Connection);
FbDataAdapter adapter = new FbDataAdapter(reader);
DataSet Data = new DataSet();
adapter.FillSchema(Data, SchemaType.Source);
adapter.Fill(Data);
List <Buch> buecher = new List <Buch>();
foreach (DataRow item in Data.Tables[0].Rows)
{
buecher.Add(new Buch(item["ISBN"].ToString(), item["Titel"].ToString()));
}
return(buecher);
}
public List <Autor> GetAutoren()
{
VerbindungOeffnen();
string statement = "SELECT * " +
"FROM T_Autoren";
FbCommand reader = new FbCommand(statement, Connection);
FbDataAdapter adapter = new FbDataAdapter(reader);
DataSet Data = new DataSet();
adapter.FillSchema(Data, SchemaType.Source);
adapter.Fill(Data);
List <Autor> autoren = new List <Autor>();
foreach (DataRow item in Data.Tables[0].Rows)
{
autoren.Add(new Autor((int)item["Autoren_id"], item["Name"].ToString()));
}
return(autoren);
}
