namespace JeansFull.Models
{
    public class EFPurchGoodRepository : IPurchGoodsRepository
    {
        private Point4Context db;
        public EFPurchGoodRepository(Point4Context dbc)
        {
         db = dbc;
        }
        public IQueryable<PurchGoods> PurchGoods => db.PurchGoods
            .Include(c => c.GoodsStocks)
            .Where(c => c.GoodsStocks.Stock > 0)
            .Include(c => c.Nomencl)
             .ThenInclude(c => c.Articul)
              .ThenInclude(c => c.Model)
            .Include(c => c.Nomencl)
             .ThenInclude(c => c.Articul)
              .ThenInclude(c => c.Type)
            .Include(c => c.Nomencl)
             .ThenInclude(c => c.Articul)
              .ThenInclude(c => c.Manufacturer)
            .Include(c => c.Nomencl)
             .ThenInclude(c => c.Articul)
              .ThenInclude(c => c.ArticulImages)
            ;
    }

@model IEnumerable<PurchGoods>

@{
    foreach (var g in Model)
    {
    <div>
        <h2>ProductID: @g.GoodId</h2>
        <p><h2>NomenclID: @g.NomenclId</h2></p>
        <p><h2>Stock: @g.Nomencl.Stock</h2></p>
        <p><h2>Articul: @g.Nomencl.Articul.Articul</h2></p>
        <p><h2>Articul: @g.Nomencl.Articul.Model.ModelName</h2></p>
        <p><h2>Articul: @g.Nomencl.Articul.Type.Type</h2></p>
        <p><h2>Articul: @g.Nomencl.Articul.Manufacturer.ManufName</h2></p>
        <p><h2>Articul: @g.Nomencl.Articul.ArticulImages</h2></p>
    </div>
    }
}