public bool DeleteWordBook(WordBookUnit wordbookname) { if(IsContainWordBook(wordbookname)) { using (var statement = connection_.Prepare(SQL_DELETE)) { statement.Bind(1, wordbookname.WordBookName); statement.Step(); } //delete all word in this wordbookname //to do return true; } else { return false; } }
public bool AddWordBook(WordBookUnit wordbookname) { if (!IsContainWordBook(wordbookname)) { using (var statement = connection_.Prepare(SQL_INSERT)) { statement.Bind(1, wordbookname.WordBookName); statement.Bind(2, wordbookname.WordCount); statement.Bind(3, wordbookname.DeletedFlag ? 1 : 0); statement.Bind(4, wordbookname.IsReadOnly ? 1 : 0); statement.Step(); } //add a new blank wordbook return true; } else { return false; } }
public bool IsContainWordBook(WordBookUnit wordbookname) { using (var statement = connection_.Prepare(SQL_QUERY_BY_WORDBOOK_NAME)) { statement.Bind(1, wordbookname.WordBookName); SQLiteResult result = statement.Step(); return SQLiteResult.ROW == result; } }
public void ImportWordBook(WordBookUnit wordbookname) { //to do }