public Task <int> InsertGlossaryItem(GlossaryItemModel item) { string sql = @$ "INSERT INTO glossary (term, definition) SELECT @Term, @Definition WHERE NOT EXISTS ( SELECT term FROM glossary WHERE term = @Term );"; return(_db.SaveData(sql, item)); }
public Task <int> InsertReference(ReferenceModel reference) { string sql = @$ "INSERT INTO reference (title, link, description, category) SELECT @Title, @Link, @Description, @Category ;"; return(_db.SaveData(sql, reference)); }