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