public async Task <WowItem> GetOrCreateWowItemAsync(InciteDbContext dbContext, WowHeadItem wowHeadItem, Dictionary <int, WowItem> seenItems)
{
if (seenItems.ContainsKey(wowHeadItem.Id))
{
return(seenItems[wowHeadItem.Id]);
}
WowItem wowItem = await dbContext.WowItems
.FirstOrDefaultAsync(x => x.WowId == wowHeadItem.Id);
if (wowItem != null)
{
seenItems[wowHeadItem.Id] = wowItem;
return(wowItem);
}
WowItemSubclass wowItemSubclass = null;
WowItemClass wowItemClass = await dbContext.WowItemClasses
.Include(x => x.WowItemSubclasses)
.FirstOrDefaultAsync(x => x.WowId == wowHeadItem.ItemClass.Id);
if (wowItemClass == null)
{
wowItemClass = new WowItemClass()
{
WowId = wowHeadItem.ItemClass.Id,
Name = wowHeadItem.ItemClass.Name
};
wowItemSubclass = new WowItemSubclass()
{
WowId = wowHeadItem.ItemSubclass.Id,
Name = wowHeadItem.ItemSubclass.Name,
WowItemClass = wowItemClass,
};
dbContext.WowItemClasses.Add(wowItemClass);
dbContext.WowItemSubclasses.Add(wowItemSubclass);
}
else
{
wowItemSubclass = wowItemClass.WowItemSubclasses
.FirstOrDefault(x => x.WowId == wowHeadItem.ItemSubclass.Id);
if (wowItemSubclass == null)
{
wowItemSubclass = new WowItemSubclass()
{
WowId = wowHeadItem.ItemSubclass.Id,
Name = wowHeadItem.ItemSubclass.Name,
WowItemClass = wowItemClass,
};
dbContext.WowItemSubclasses.Add(wowItemSubclass);
}
}
wowItem = new WowItem()
{
WowId = wowHeadItem.Id,
Name = wowHeadItem.Name,
ItemQuality = (WowItemQuality)wowHeadItem.Quality,
WowHeadIcon = wowHeadItem.Icon,
WowItemClass = wowItemClass,
WowItemSubclass = wowItemSubclass,
};
seenItems[wowHeadItem.Id] = wowItem;
dbContext.Add(wowItem);
if (wowHeadItem.CreatedBy.Count > 0)
{
foreach (var wowHeadSpell in wowHeadItem.CreatedBy)
{
WowSpell wowSpell = await dbContext.WowSpells
.FirstOrDefaultAsync(x => x.WowId == wowHeadSpell.Id);
if (wowSpell == null)
{
wowSpell = new WowSpell()
{
WowId = wowHeadSpell.Id,
Name = wowHeadSpell.Name,
CreatedItem = wowItem,
};
dbContext.WowSpells.Add(wowSpell);
foreach (var reagent in wowHeadSpell.Reagents)
{
var wowReagent = new WowReagent()
{
Count = reagent.Count,
WowSpell = wowSpell,
WowItem = await GetOrCreateWowItemAsync(dbContext, reagent.Item, seenItems),
};
dbContext.WowReagents.Add(wowReagent);
}
}
wowItem.CreatedBy.Add(wowSpell);
}
}
await dbContext.SaveChangesAsync();
return(wowItem);
}
public Task <WowItem> GetOrCreateWowItemAsync(InciteDbContext dbContext, WowHeadItem wowHeadItem)
{
return(GetOrCreateWowItemAsync(dbContext, wowHeadItem, new Dictionary <int, WowItem>()));
}
