/// <summary> /// Checks if a object is referenced before a delete /// </summary> /// <param name="id">Id</param> /// <returns>Empty string if no references exists, error string if references exists</returns> protected override async Task <string> CheckObjectReferences(string id) { List <AikaQuest> aikaQuests = await _aikaQuestDbAccess.GetQuestsObjectIsReferenced(id); if (aikaQuests.Count > 0) { string referencedInQuests = string.Join(", ", aikaQuests.Select(p => p.Name)); return(_localizer["CanNotDeleteSkillReferencedInAikaQuest", referencedInQuests].Value); } List <KirjaPage> kirjaPages = await _kirjaPageDbAccess.GetPagesBySkill(id); if (kirjaPages.Count > 0) { string mentionedInPages = string.Join(", ", kirjaPages.Select(p => p.Name)); return(_localizer["CanNotDeleteSkillMentionedInKirjaPage", mentionedInPages].Value); } List <TaleDialog> taleDialogs = await _taleDbAccess.GetDialogsObjectIsReferenced(id); if (taleDialogs.Count > 0) { List <KortistoNpc> npcs = await _kortistoNpcDbAccess.ResolveFlexFieldObjectNames(taleDialogs.Select(t => t.RelatedObjectId).ToList()); string referencedInDialogs = string.Join(", ", npcs.Select(n => n.Name)); return(_localizer["CanNotDeleteSkillReferencedInTaleDialog", referencedInDialogs].Value); } List <KortistoNpc> learnedNpcs = await _kortistoNpcDbAccess.GetNpcsByLearnedSkill(id); if (learnedNpcs.Count > 0) { string learnedByNpcsString = string.Join(", ", learnedNpcs.Select(n => n.Name)); return(_localizer["CanNotDeleteSkillLearnedByNpc", learnedByNpcsString].Value); } List <KortistoNpc> referencedInDailyRoutines = await _kortistoNpcDbAccess.GetNpcsObjectIsReferencedInDailyRoutine(id); if (referencedInDailyRoutines.Count > 0) { string usedInDailyRoutines = string.Join(", ", referencedInDailyRoutines.Select(m => m.Name)); return(_localizer["CanNotDeleteSkillUsedInDailyRoutine", usedInDailyRoutines].Value); } return(string.Empty); }
public async Task <IActionResult> GetPagesBySkill(string skillId) { List <KirjaPage> pages = await _pageDbAccess.GetPagesBySkill(skillId); return(Ok(pages)); }