$.ajax({
        url: "api/Lookups",
        data: { lookupName: "Employees" },
        dataType: "json",
        contentType: "application/json; charset=utf-8",
        async: false,
        success: function (data) {
            employees = data;

        },
        error: function (XMLHttpRequest, textStatus, errorThrown) {
            console.log(XMLHttpRequest.responseText);
        }
    });

    $.ajax({
        url: "api/Lookups",
        data: { lookupName: "Trucs" },
        dataType: "json",
        contentType: "application/json; charset=utf-8",
        async: false,
        success: function (data) {
            trucs = data;
        },
        error: function (XMLHttpRequest, textStatus, errorThrown) {
            console.log(XMLHttpRequest.responseText);
        }
    });

    $("#gridCheckList").kendoGrid({
        columns: [
            { template: '<a href="\\#!/Checklist/#=Id#">Review</a>', field: "Id", title: "#", width: 80, sortable: false },
            { field: "CheckDate", title: "Date", template: "#=  kendo.toString(kendo.parseDate(CheckDate, 'yyyy-MM-dd'), 'MM/dd/yyyy') #", width: 90 },
            { field: "TruckUnit", title: "Truck", values: trucs, width: 60 },
            { field: "PCCode", title: "Party Chief", values: employees },
            { field: "OdometerReading", title: "Odometer KM" },
            { field: "TotalQuestion", title: "Questions" },
            { field: "AnsweredQuestion", title: "Answered" },
            { field: "NoQuestion", title: "No Aswers" },
            {
                field: "Completed", title: "Completed",
                template:
                "# if (Completed) { #" +
                "<span class='glyphicon glyphicon-star' aria-hidden='true'></span>" +
                "# }" +
                "#" +
                "# if (!Completed) { #" +
                "<span class='glyphicon glyphicon-star-empty' aria-hidden='true'></span>" +
                "# }" +
                "#"

            }
        ],
        autoBind: false,
        pageable: {
            refresh: true,
            pageSizes: true,
            info: true,
            numeric: true,
            previousNext: true
        },
        resizable: true,
        dataSource: {
            type: "webapi",
            transport: {
                idField: "Id",
                read: {
                    url: "api/VehicleCheckLists",
                    dataType: "json"
                }
            },
            pageSize: 10,
            schema: {
                data: "Data",
                total: "Total",
                model: {
                    id: "Id",
                    fields: {
                        Id: { type: "number" },
                        CheckDate: { type: "date" },
                        TruckUnit: { type: "string" },
                        PCCode: { type: "string" },
                        CheckedBy: { type: "string" },
                        OdometerReading: { type: "number" },
                        ASSTCode: { type: "string" },
                        TotalQuestion: { type: "number" },
                        AnsweredQuestion: { type: "number" },
                        NoQuestion: { type: "number" },
                        Completed: { type: "boolean" }
                    }
                }
            },
            error: function (XMLHttpRequest, textStatus, errorThrown) {
                var data = eval("(" + XMLHttpRequest.xhr.responseText + ")");
                toastr.error("Something went wrong (" + data.ExceptionMessage + ")");
                console.log(data.ExceptionMessage);
            }
        },
        editable: false,
        sortable: true,
        filterable: true
    });

var products = [{
    ProductID : 1,
    ProductName : "Chai",
    SupplierID : 1,
    CategoryID : 1,
    QuantityPerUnit : "10 boxes x 20 bags",
    UnitPrice : 18.0000,
    UnitsInStock : 39,
    UnitsOnOrder : 0,
    ReorderLevel : 10,
    Discontinued : false,
    Category : {
        CategoryID : 1,
        CategoryName : "Beverages",
        Description : "Soft drinks, coffees, teas, beers, and ales"
    }
}, {
    ProductID : 2,
    ProductName : "Chang",
    SupplierID : 1,
    CategoryID : 1,
    QuantityPerUnit : "24 - 12 oz bottles",
    UnitPrice : 19.0000,
    UnitsInStock : 17,
    UnitsOnOrder : 40,
    ReorderLevel : 25,
    Discontinued : false,
    Category : {
        CategoryID : 1,
        CategoryName : "Beverages",
        Description : "Soft drinks, coffees, teas, beers, and ales"
    }
},


$("#grid").kendoGrid({
                        dataSource: dataSource,
                        pageable: true,
                        height: 550,
                        toolbar: ["create"],
                        columns: [
                            { field:"ProductName",title:"Product Name" },
                            { field: "Category", title: "Category", width: "180px", editor: categoryDropDownEditor, template: "#=Category.CategoryName#" },
                            { field: "UnitPrice", title:"Unit Price", format: "{0:c}", width: "130px" },
                            { command: "destroy", title: " ", width: "150px" }],
                        editable: true
                    });
                });

                function categoryDropDownEditor(container, options) {
                    $('<input required name="' + options.field + '"/>')
                        .appendTo(container)
                        .kendoDropDownList({
                            autoBind: false,
                            dataTextField: "CategoryName",
                            dataValueField: "CategoryID",
                            dataSource: {
                                type: "odata",
                                transport: {
                                    read: "https://demos.telerik.com/kendo-ui/service/Northwind.svc/Categories"
                                }
                            }
                        });
                }