Grid inline batch editing

@{
    var grid2Id = "BatchSaveGrid";
    var initObj = new
    {
        Name = DemoUtils.RndName(),
        Date = DateTime.Now.ToShortDateString(),
        ChefId = DemoCache.Chefs.First().Id,
        MealsIds = DemoCache.Meals.Take(2).Select(o => o.Id).ToArray()
    };
}
<div class="bar">
    <div style="float: right;">
        @Html.Awe().TextBox("txtSearch2").Placeholder("search...").CssClass("searchtxt")
    </div>
    <button type="button" onclick="$('#@grid2Id').data('api').inlineCreate()" class="awe-btn">Create</button>
    @Html.InlineCreateButtonForGrid(grid2Id, initObj, "Create with predefined values")
    <button type="button" onclick="$('#@grid2Id').data('api').batchSave()" class="awe-btn">Save All</button>
    <button type="button" onclick="$('#@grid2Id').data('api').inlineCancelAll()" class="awe-btn">Cancel All</button>
</div>

@Html.InitDeletePopupForGrid(grid2Id, "GridInlineEditDemo")

@(Html.Awe().Grid(grid2Id)
    .Mod(o => o.Main(false))
    .Url(Url.Action("GridGetData", "GridInlineBatchEditing"))
    .InlEdit(new InlEditOpt
    {
        SaveUrl = Url.Action("BatchSave", "GridInlineBatchEditing"),
        Batch = true
    })
    .CssClass("noalt")
    .Parent("txtSearch2", "search")
    .Height(350)
    .Resizable()
    .Reorderable()
    .Attr("data-syncg", "dinner")
    .Columns(
        new Column { Bind = "Id", Width = 75 }
        .InlId(),

        new Column { Bind = "Name" }
        .InlString(),
        //.Inl(Html.Awe().TextBox("Name")),

        new Column { Bind = "Date", Width = 160 }
        .InlDate(),

        new Column { Bind = "Chef.FirstName,Chef.LastName", Prop = "ChefName", Header = "Chef", MinWidth = 170 }
        .InlDropdownList(new DropdownListOpt { Name = "ChefId", Url = Url.Action("GetChefs", "Data") }),

        new Column { Prop = "Meals", Header = "Meals", MinWidth = 250 }
        .Inl(Html.Awe().Multiselect(new MultiselectOpt { Name = "MealsIds", Url = Url.Action("GetMealsImg", "Data") })),

        new Column { Bind = "BonusMeal.Name", Prop = "BonusMeal", Header = "Bonus Meal" }
        .InlDropdownList(new DropdownListOpt
        {
            Name = "BonusMealId",
            Url = Url.Action("GetMealsImg", "Data")
        }
        .ImgItem()),

        new Column { Bind = "Organic", Width = 90, Prop = "DispOrganic" }
        .Inl(Html.Awe().Toggle(new ToggleOpt { Name = "Organic" })),

        Html.InlEditColumn(),
        Html.InlDeleteColumn(grid2Id)))

@*name of each inline helper/editor is matching the names of DinnerInput properties, and the names of row model properties set in MapToGridModel*@

@*optional grid client instant validation (for MVC5 must be placed in a cshtml with @model DinnerInput)*@
@(Html.BindOVldForId<DinnerInput>(grid2Id))

public class GridInlineBatchEditingController : Controller
{
    private readonly MyContext mcx = new MyContext();// mock EF Db context

    public GridInlineBatchEditingController()
    {
        
    }

    public IActionResult Index()
    {
        return View();
    }

    private object MapToGridModel(Dinner o)
    {
        return new
        {
            o.Id,
            o.Name,
            Date = o.Date.ToShortDateString(),
            ChefName = o.Chef.FullName,
            Meals = string.Join(", ", o.Meals.Select(m => m.Name)),
            BonusMeal = o.BonusMeal.Name,
            o.Organic,
            DispOrganic = o.Organic ? "Yes" : "No",

            // below properties used for inline editing only
            MealsIds = o.Meals.Select(m => m.Id.ToString()).ToArray(), // value for meals multiselect
            ChefId = o.Chef.Id, // value for chef dropdown
            BonusMealId = o.BonusMeal.Id // value for bonus meal dropdown
        };
    }

    public async Task<IActionResult> GridGetData(GridParams g, string search = "")
    {            
        var query = mcx.Dinners
            .Include(o => o.Chef)
            .Include(o => o.Meals)
            .Include(o => o.Country)
            .Include(o => o.BonusMeal)
        .Where(o => o.Name.Contains(search)).AsQueryable();

        var model = new GridModelBuilder<Dinner>(query, g)
        {
            KeyProp = o => o.Id, // needed for api select, update, tree, nesting, EF                
            Map = MapToGridModel,
        };

        return Json(await model.EFBuildAsync());
    }

    [HttpPost]
    public async Task<IActionResult> BatchSave(DinnerInput[] inputs)
    {
        var res = new List<object>();            

        foreach (var input in inputs)
        {
            var vldState = ModelUtil.Validate(input);

            // custom validation example
            if (input.Name != null && input.Name.Contains("aaa"))
            {
                vldState.Add("Name", "Name can't contain aaa");
            }

            if (vldState.IsValid())
            {
                try
                {
                    var isCreate = !input.Id.HasValue;
                    
                    var ent = isCreate ? new Dinner() : 
                        await mcx.Dinners
                            .Include(o => o.Meals)
                            .FirstAsync(o => o.Id == input.Id);

                    ent.Name = input.Name;
                    ent.Date = input.Date.Value;
                    ent.Chef = await mcx.FindAsync<Chef>(input.ChefId);
            
                    // ToList req for EF
                    ent.Meals = await mcx.Meals
                        .Where(o => input.MealsIds.Contains(o.Id)).ToListAsync();
            
                    ent.BonusMeal = await mcx.FindAsync<Meal>(input.BonusMealId);
                    ent.Organic = input.Organic ?? false;

                    if (isCreate)                
                    {
                        mcx.Add(ent);
                    }

                    res.Add(ent);
                }
                catch (Exception ex)
                {
                    vldState.Add("Name", ex.Message);
                }
            }

            if (!vldState.IsValid())
            {
                res.Add(vldState.ToInlineErrors());
            }
        }

        await mcx.SaveChangesAsync();
        var jres = res.Select(o => o is Dinner ? new { Item = MapToGridModel((Dinner)o)} : o );
        return Json(jres);
    }

    public async Task<IActionResult> Delete(int id)
    {
        var dinner = await mcx.FindAsync<Dinner>(id);

        return PartialView(new DeleteConfirmInput
        {
            Id = id,
            Type = "dinner",
            Name = dinner.Name
        });
    }

    [HttpPost]
    public async Task<IActionResult> Delete(DeleteConfirmInput input)
    {
        mcx.Remove(await mcx.FindAsync<Dinner>(input.Id));

        await mcx.SaveChangesAsync();

        // the PopupForm's success function aweUtils.itemDeleted expects an obj with "Id" property
        return Json(new { input.Id });
    }
}