public void SetSelectedWord(WordProgressModel word) { selectedWord = word.word; WordCategoryModel categoryFound = db.WordCategories.Find( (cat) => cat.id == word.categoryId); Debug.Log(categoryFound); selectedWordCategory = categoryFound.categoryName; }
public void UpdateWordCategory(WordCategoryModel wordCategory) { IDbCommand cmd = GetDbCommand(); cmd.CommandText = $@"UPDATE {TABLE_NAME} SET {CATEGORY_NAME}={wordCategory.categoryName}, {STARS_COLLECTED}='{wordCategory.starsCollected}' WHERE id={wordCategory.id}"; cmd.ExecuteNonQuery(); }
public void Create(WordCategoryModel wordCategory) { IDbCommand cmd = GetDbCommand(); cmd.CommandText = $@"INSERT INTO {TABLE_NAME} ( {USER_ID}, {CATEGORY_NAME}, {STARS_COLLECTED} ) VALUES ( {wordCategory.userId}, '{wordCategory.categoryName}', {wordCategory.starsCollected} );"; cmd.ExecuteNonQuery(); }