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();
}
