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 StringBuilder getMeaningByID(int id) { IWordDAO wordDao = new WordDAO(); StringBuilder strb = new StringBuilder(); try { Program.conn.Open(); // Open new connection SQLiteCommand cmd = new SQLiteCommand("select * from meaning where word = " + id, Program.conn); SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { strb.Append("- ").Append(reader.GetString(2) + "\r\n"); } return(strb); } 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 } }