public async Task <Note> UpsertNote(Note note) { var insertCallback = timelineDataService.Callback($"Created Note {note.name}", Constants.TimelineReferences.Note); var updateCallback = timelineDataService.Callback($"Edited Note {note.name}", Constants.TimelineReferences.Note); return(await Upsert(CreateNoteSql, UpdateNoteSql, GetNoteSql, note, insertCallback, updateCallback)); }
public async Task <Checklist> UpsertChecklist(Checklist checklist) { var instertSql = "insert into checklists(name, type, description, created_at, updated_at) values " + "(@name, @type, @description, current_timestamp, current_timestamp) returning id"; var updateSql = "update checklists set name=@name, type=@type, description=@description, " + "updated_at=current_timestamp where id=@id"; var selectSql = "select * from checklists where id=@id"; var insert = tds.Callback($"Created Checklist {checklist.name}", Constants.TimelineReferences.Checklist); var update = tds.Callback($"Edited Checklist {checklist.name}", Constants.TimelineReferences.Checklist); return(await Upsert(instertSql, updateSql, selectSql, checklist, insert, update)); }