public async Task <Result <Label> > GetLabelAsync(Guid id) { await _initTask; const string sql = "SELECT * FROM labels WHERE id == @id"; var parameter = new List <KeyValuePair <string, string> > { new KeyValuePair <string, string>("@id", id.ToString()) }; var command = new SqlCommand(sql, parameter); Label label; try { label = await _sqliteStorage.ExecuteReaderAsync(command, _toLabelConverter); } catch (Exception e) { return(Result.Fail(new NotFoundError().CausedBy(e))); } return(Result.Ok(label)); }
public async Task <IEnumerable <Guid> > GetLabelIdsForPageId(Guid pageId) { await _initTask; const string sql = "SELECT label_id FROM page_labels WHERE page_id = @pageId"; var parameter = new List <KeyValuePair <string, string> > { new KeyValuePair <string, string>("@pageId", pageId.ToString()) }; var command = new SqlCommand(sql, parameter); var result = await _sqliteStorage.ExecuteReaderAsync(command, _toLabelsIdConverter); return(result); }