public Meaning findById(int id)
{
try
{
Program.conn.Open(); // Open new connection
SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM meaning WHERE id = " + id, Program.conn);
SQLiteDataReader reader = cmd.ExecuteReader();
Meaning meaning = new Meaning();
IWordDAO wordDao = new WordDAO();
while (reader.Read())
{
meaning = new Meaning(reader.GetInt32(0), reader.GetString(2), wordDao.findById(reader.GetInt32(1)));
}
return(meaning);
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex);
return(null);
}
finally
{
Program.conn.Close(); // Close connection
}
}
public ObservableCollection <Meaning> getAll()
{
IWordDAO wordDao = new WordDAO();
ObservableCollection <Meaning> meanings = new ObservableCollection <Meaning>();
try
{
Program.conn.Open(); // Open new connection
SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM meaning", Program.conn);
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
meanings.Add(new Meaning(reader.GetInt32(0), reader.GetString(2), wordDao.findById(reader.GetInt32(1))));
}
return(meanings);
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex);
return(null);
}
finally
{
Program.conn.Close(); // Close connection
}
}