public async Task <IActionResult> GetSections(int id, int storeId, CancellationToken ct)
{
var sections = _sectionRepository.GetAllEntities(id, ct);
List <SectionAPP> sectionsAPP = new List <SectionAPP>();
foreach (SectionEntity sec in sections)
{
var shelves = _shelfRepository.GetAllEntities(sec.Id, ct);
sec.Shelves = shelves;
SectionAPP section = new SectionAPP()
{
Id = sec.Id,
AisleId = sec.AisleId,
Name = sec.Name,
ItemsPerShelf = sec.ItemsPerShelf,
Shelves = new List <ShelfAPP>()
};
foreach (ShelfEntity shelf in shelves)
{
var shelfSlots = _shelfSlotsRepository.GetAllEntities(shelf.Id, ct);
shelf.Slots = shelfSlots;
ShelfAPP shelfapp = new ShelfAPP
{
Id = shelf.Id,
SectionId = shelf.SectionId,
ShelfNumber = shelf.ShelfNumber,
Slots = new List <ShelfSlotAPP>()
};
foreach (var slot in shelfSlots)
{
var item = await _itemRepository.GetEntityAsync(slot.ItemId, ct);
var link = await _itemStoreLinkRepository.GetEntityAsync(item.Id, storeId, ct);
var department = await _departmentRepository.GetEntityAsync(link.DepartmentId, ct);
var lowerDepartment = await _lowerDepartmentRepository.GetEntityAsync(link.LowerDepartmentId, ct);
var aisle = await _aisleRepository.GetEntityAsync(link.AisleId, ct);
SpoonProductInformation spoonItem = GetSpoonItem(item.SpoonacularProductId);
Item itemapp = new Item
{
Id = item.Id,
LinkId = link.Id,
Image = "image.jpg",
Name = item.Name,
Price = link.Price,
InStock = link.InStock,
StockAmount = link.StockAmount,
DepartmentId = link.DepartmentId,
LowerDepartmentId = link.LowerDepartmentId,
AisleId = link.AisleId,
SectionId = link.SectionId,
ShelfId = link.ShelfId,
SlotId = link.SlotId,
LowerDepartment = lowerDepartment.Name,
Aisle = aisle.Name,
Section = sec.Name,
Shelf = shelf.ShelfNumber.ToString(),
Slot = slot.SlotOnShelf.ToString(),
Department = department.Name,
ProductInformation = spoonItem
};
if (spoonItem != null)
{
itemapp.Image = spoonItem.images.First();
}
ShelfSlotAPP slotApp = new ShelfSlotAPP
{
Id = slot.Id,
ItemId = slot.ItemId,
ShelfId = slot.ShelfId,
SlotOnShelf = slot.SlotOnShelf,
Item = itemapp
};
shelfapp.Slots.Add(slotApp);
}
section.Shelves.Add(shelfapp);
}
sectionsAPP.Add(section);
}
return(Ok(sectionsAPP));
}