public class EnzoViewModel
    {
        public Product Product { get; set; }
        public IngList IngList { get; set; }
        public IEnumerable<Ingredient> Ingredient { get; set; } 
    }

        public ActionResult IngList()
        {
            ViewBag.IngId = new SelectList(db.Ingredients, "Id", "Name");
            ViewBag.ProdId = new SelectList(db.Products, "Id", "Name");
            var viewModel =
                (from il in db.IngLists
                 join p in db.Products on il.ProdId equals p.Id
                 join ing in db.Ingredients on il.IngId equals ing.Id
                 where (il.ProdId == p.Id) && (il.IngId == ing.Id)
                 select new IngListModel { ProdName = p.Name, IngName = ing.Name, Amount = il.Amount }).ToList();
            return View(viewModel);
        }

        [HttpPost]
        public ActionResult IngList(IngList inglist)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    db.IngLists.Add(inglist);
                    db.SaveChanges();
                    return RedirectToAction("IngList");
                }
            }
            catch (Exception ex)
            {
                ModelState.AddModelError(String.Empty, ex);
            }
            return View(inglist);
        }

@model EnzoApp.Models.IngListModel

@{
    ViewBag.Title = "IngList";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2>IngList</h2>

@using (Html.BeginForm()) {
    @Html.ValidationSummary(true)

    <fieldset>
        <legend>Добавить новый заказ</legend>
        <br>
        <div class="editor-label">
            <b>Клиент</b>
        </div>
        <div class="editor-field">
            @Html.DropDownList("ProdId", (IEnumerable<SelectListItem>) ViewBag.ProdId, "--Выберите рецептуру--")
            @Html.ValidationMessageFor(model => model.ProdName)
        </div>

        <div class="editor-label">
            <b>Дата отгрузки</b>
        </div>
        <div class="editor-field">
            @Html.DropDownList("IngId", (IEnumerable<SelectListItem>) ViewBag.IngId, "--Выберите ингредиент--")
            @Html.ValidationMessageFor(model => model.IngName)
        </div>

        <div class="editor-label">
            <b>Артикул</b>
        </div>
        <div class="editor-field">
            @Html.EditorFor(model => model.Amount)
            @Html.ValidationMessageFor(model => model.Amount)
        </div>

        <p>
            <input type="submit" value="Добавить" />
        </p>
    </fieldset>
}

@{
    var grid = new WebGrid(
        Model,rowsPerPage:10,
        defaultSort:"ProdName",
        columnNames:new [] {"ProdName", "IngName", "Amount"}
        );
}

@grid.GetHtml(

fillEmptyRows:false,
mode:WebGridPagerModes.All,

columns:grid.Columns
(
grid.Column("ProdName", header:"Наименование", format: @<text>@Html.ActionLink((string)item.Name, "IngredientDetails", new { id = item.Id }, new { @class = "btn btn-success" })</text>),
grid.Column("IngName", header:"Ингредиент"),
grid.Column("Amount", header:"Кг")
)
)


<div>
    @Html.ActionLink("Назад", "Orders")
</div>

    public class IngListModel
    {
        public string ProdName { get; set; }
        public string IngName { get; set; }
        public int Amount { get; set; }
    }

    class ModelList
    {
        public int Id { get; set; }
        public string ClientName { get; set; }
        public string ShipDate { get; set; }
        public string Article { get; set; }
    }

        public ActionResult Orders()
        {
            var viewModel =
                (from pd in db.Orders
                 join p in db.Clients on pd.ClientId equals p.Id
                 where pd.ClientId == p.Id
                 select new ModelList { Id = pd.Id, ClientName = p.Name, ShipDate = pd.ShipDate, Article = pd.Article }).ToList();
            return View(viewModel);
        }

@{
    var grid = new WebGrid(
        Model,rowsPerPage:10,
        defaultSort:"ClientName",
        columnNames:new [] {"ClientName", "ShipDate", "Article"}
        );
}

@grid.GetHtml(

fillEmptyRows:false,
mode:WebGridPagerModes.All,

columns:grid.Columns
(
grid.Column("ClientName", header:"Клиент", format: @<text>@Html.ActionLink((string)item.ClientName, "OrderDetails", new { id = item.Id }, new { @class = "btn btn-success" })</text>),
grid.Column("ShipDate", header:"Дата"),
grid.Column("Article", header:"Артикул")
)
)