Client validation for grid inline editing

@{
    var grid2Id = "DinnersGrid2";
    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">
    <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)
        .BatchEdit(Url.Action("BatchSave", "GridInlineBatchEditing")))
    .Url(Url.Action("GridGetData", "GridInlineBatchEditing"))
    .Height(350)
    .Groupable(false)
    .Resizable()
    .Attr("data-syncg", "dinner")
    .Columns(
    new Column { Bind = "Id", Width = 75 }        
    .InlHiddenId()                
    .InlVldSummary(),

    new Column { Bind = "Name" }
    .InlString(),

    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, Grow = 2 }
    .InlMultiselect(new MultiselectOpt
    {
        Name = "MealsIds",
        Url = Url.Action("GetMealsImg", "Data")
    }
    .ImgItem()),

    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)))

@*grid client validation (for MVC5 call to BindOvld must be placed in a cshtml with @model DinnerInput)*@

@(Html.BindOVldForId<DinnerInput>(grid2Id, b =>
    {
        b.Prop("Name", "noAsdf", "Name can't contain asdf");

        b.Prop("Name", "organicNameMinLen", "Name length can't be less than 5 when Organic = yes");
        b.Relate("Organic", "Name"); // when checking Organic Name will also be updated
    }))

<script>
    function noAsdf(o) {
        return o.v.indexOf('asdf') !== -1;
    }

    function organicNameMinLen(o) {
        var row = o.inp.closest('.awe-row');
        var org = row.find('[name="Organic"]');
        var name = row.find('[name="Name"]');

        if (org.val() === 'true') {
            return (name.val().length < 5);
        }
    }
</script>
@section scripts {
    @*used by InlVldSummary()*@
    <script src="~/js/inlVldSummary.js"></script>        
}

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 });
    }
}