public ManifestItemDefinition GetItemDefinition(uint itemHash)
{
int itemId = ConvertHashToTableId(itemHash);
string commandText = $"SELECT json FROM DestinyInventoryItemDefinition WHERE id = {itemId}";
string json = databaseAccessor.ExecuteCommand(commandText, config["Emissary:ManifestPath"]);
ManifestItemDefinition itemDefinition = JsonConvert.DeserializeObject <ManifestItemDefinition>(json);
return(itemDefinition);
}
private DestinyItem CreateDestinyItemFromGenericItem(DestinyGenericItem genericItem)
{
DestinyItem item = new DestinyItem();
item.ItemHash = genericItem.ItemHash;
item.ItemInstanceId = genericItem.ItemInstanceId;
ManifestItemDefinition manifestItemDefinition = manifestDao.GetItemDefinition(genericItem.ItemHash);
item.Name = manifestItemDefinition.DisplayName;
item.TierTypeName = manifestItemDefinition.TierTypeName;
item.CategoryHashes = manifestItemDefinition.ItemCategoryHashes;
item.Categories = item.CategoryHashes
.Select(hash => manifestDao.GetItemCategoryDefinition(hash).CategoryName)
.ToList();
return(item);
}
