/// <summary>
/// //execute order in db and update passed Store
/// </summary>
/// <param name="storeChoice"></param>
/// <param name="appOrder"></param>
/// <returns></returns>
public Library.Store FillOrderDb(Library.Store storeChoice, Library.Order appOrder)
{
using var context = new P0Context(_dbContextOptions);
List <bool> successList = storeChoice.FillOrder(appOrder);
int successListIndex = 0;
//go ahead and grab everything
var dbStore = context.Stores
.Include(s => s.Items)
.ThenInclude(i => i.Product)
.Include(s => s.Orders)
.ThenInclude(o => o.Customer)
.First(s => s.Id == storeChoice.Id);
//get store inventory
var dbItems = context.Items.Where(s => s.StoreId == storeChoice.Id);
//find all items in inventory matching product.Name appOrderId then decrement quantity and update appStore
foreach (var product in appOrder.Selections)
{
//find first item in dbItems that has the same name, and is an inventory
var dbInvItem = dbItems.FirstOrDefault(i => i.Product.Name == product.Name);
//update the db when fillOrder is successful
if (successList.ElementAt(successListIndex)) // == appOrder.OrderId &&
{
dbInvItem.Quantity -= product.Quantity;
context.Update(dbInvItem);
//storeChoice.Inventory.First(x=>x.Name == product.Name).Quantity = (int)dbInvItem.Quantity;
}
successListIndex++;
}
context.SaveChanges();
return(storeChoice);
}
