Could not find property xxxx on type xxxx. Make sure you specify Key and Column.Bind correctly.

Title:

Hello,
read answers on similar problems, but with no luck. Any attempt to sort or group grid by any column - give error mentioned above.
 
View:
    @(Html.Awe().Grid(gridId)
            .Resizable()
            .Url(Url.Action("GridGetPrices", "prices"))
            .Parent("txtSearch", "search")
            .PageSize(10)
            //.Groupable(false).ShowGroupBar(false).ShowGroupedColumn(false)
            .Resizable()
            .Reorderable()
            .Attr("data-syncg", "price")
            .Nests(
                new Nest { Name = "editnst", GetFunc = "utils.loadNestPopup('Edit')" },
                new Nest { Name = "delnst", GetFunc = "utils.loadNestPopup('Delete')" }
            )
            .Columns(
                    new Column { Bind = "TariffType", ClientFormat = ".(TariffType)", Header = @Html.DisplayNameFor(x => x.ticketTariff.ticketTariffs_types.tariffType).ToString(), Width = 80 },
                    new Column { Bind = "Price", ClientFormat = ".(Price)", Header = @Html.DisplayNameFor(x => x.price1).ToString(), Width = 60 },
                    new Column { Bind = "Currency", ClientFormat = ".(Currency)", Header = @Html.DisplayNameFor(x => x.currency.currency1).ToString(), Width = 60 },
                    new Column { Bind = "Preference", ClientFormat = ".(Preference)", Header = @Html.DisplayNameFor(x => x.preference.preference1).ToString(), Width = 100 },
                    new Column { Bind = "Description", ClientFormat = ".(Description)", Header = @Html.DisplayNameFor(x => x.ticketTariff.forUser).ToString(), Width = 140 },
                    new Column { Bind = "Zone", ClientFormat = ".(Zone)", Header = @Html.DisplayNameFor(x => x.zone.description).ToString(), Width = 140 },
    
                    new Column { ClientFormat = editbutton, Width = 60 },
                    new Column { ClientFormat = deletebutton, Width = 60 }
            )
                .SingleColumnSort(true)
        .Sortable(true)
    )

Controller:
    public ActionResult GridGetPrices(GridParams g, string search)
    {
        search = (search ?? "").ToLower();
        var items = db.prices.Where(o => o.ticketTariff.forUser.ToLower().Contains(search) || o.preference.preference1.ToLower().Contains(search)).AsQueryable();

        var model = new GridModelBuilder<price>(items, g)
        {
            Key = "id", // needed for api select, update, tree, nesting, EF
            GetItem = () => db.prices.Find(Convert.ToInt32(g.Key)), // called by the grid.api.update
            Map = MapPrices
        }.Build();

        return Json(model);
    }

    private object MapPrices(price o)
    {
        return new
        {
            o.id,
            TariffID = o.tariffID,
            TariffType = o.ticketTariff.ticketTariffs_types.tariffType,
            Currency = o.currency.currency1,
            Price = o.price1,
            Preference = o.preference.preference1,
            Description = o.ticketTariff.forUser,
            Zone = o.zone.description
        };
    }

Thank You.

Vladimir Kerzhentsev

asked at 05 Sep 2019

Answers

`Column.Bind` is based on the model specified in `GridModelBuilder<ThisType>` seems to me that your `price` type doesn't contain the `TariffType` property you specify in `Bind` so in your case I think you need: Bind= "ticketTariff.ticketTariffs_types.tariffType" Bind= "currency.currency1" etc. https://www.aspnetawesome.com/learn/mvc/Grid#Data-binding
Omu

answered at 05 Sep 2019
- Thank you! Thi solved my problem.
  
  at 05 Sep 2019 Vladimir Kerzhentsev

please Sign In to leave an answer