public bool AddWordToWordBook(String wordbookid,String word) { WordUnit wordunit = new WordUnit(word); wordunit.WordBookId = wordbookid; if (!IsWordInWordBook(wordbookid, wordunit.HeadWord)) { using (var statement = connection_.Prepare(SQL_INSERT)) { statement.Bind(1, wordunit.HeadWord); statement.Bind(2, wordunit.WordBookId); statement.Bind(3, wordunit.Phonetic); statement.Bind(4, wordunit.Definition); statement.Bind(5, wordunit.DeletedFlag ? 1 : 0); statement.Bind(6, wordunit.Note); statement.Step(); } return true; } else { return false; } }
public bool DeleteWord(WordUnit word) { bool result = true; //bool result = wordlistDB_.DeleteWordFromWordBook(WordBookName, word); if (result) { WordCount--; } return result; }
public bool AddWord(WordUnit word) { bool result = true; //bool result = wordlistDB_.AddWordToWordBook(WordBookName, word); if(result) { WordCount++; } return result; }
private bool IsWordInWordBook(String wordbookid,WordUnit word) { if(word==null) { return false; } return this.IsWordInWordBook(wordbookid, word.HeadWord); }
//should modify public bool UpdateWordInWordBook(String wordbookid,WordUnit word) { if (!IsWordInWordBook(wordbookid, word)) { using (var statement = connection_.Prepare(SQL_UPDAET_WORD_NOTE_IN_WORDBOOK)) { statement.Bind(1, word.Note); statement.Bind(2, word.HeadWord); statement.Bind(3, wordbookid); } return true; } else { return false; } }
public bool UpdateWordDefinitionInWordBook(String wordbookid, String word) { WordUnit wordunit = new WordUnit(word); wordunit.WordBookId = wordbookid; if (IsWordInWordBook(wordbookid, wordunit.HeadWord)) { using (var statement = connection_.Prepare(SQL_UPDAET_WORD_DEFINITION_IN_WORDBOOK)) { statement.Bind(1, wordunit.Definition); statement.Bind(2, wordunit.HeadWord); statement.Bind(3, wordunit.WordBookId); statement.Step(); } return true; } else { return false; } }