TableModel in EJ 1 ASP.NET MVC DataManager

23 Aug 2017 / 9 minutes to read

The DataManager contains a default support to bind a TableModel to the element. You can make the data observable using the getTableModel method. The getTableModel method also accept extra properties or properties with computed value that can be added to the TableModel. In the view, you can create a simple view by using the bindings getTableModel

Then the model is bound with the element using the bindTo.

cshtml

<div class="datatable" style="padding:10px">
        <div class="row">
            <div class="col-md-7">
                <table id="table1" class="table table-striped table-bordered" style="width:700px">
                    <thead>
                        <tr>
                            <th>EmployeeID</th>
                            <th>Full Name</th>
                        </tr>
                    </thead>
                    <tbody id="tbody1">
                        <tr>
                            <td ej-observe="EmployeeID"></td>
                            <td ej-computed="FullName"></td>
                        </tr>
                    </tbody>
                </table>
            </div>
            <div class="col-md-5">
                <form class="form-horizontal" role="form">
                    <div class="form-group">
                        <label class="col-sm-4 control-label">EmployeeID</label>
                        <div class="col-sm-8">
                            <input type="text" class="form-control" id="employeeId">
                        </div>
                    </div>
                    <div class="form-group">
                        <label class="col-sm-4 control-label">FirstName</label>
                        <div class="col-sm-8">
                            <input type="text" class="form-control" id="first">
                        </div>
                    </div>
                    <div class="form-group">
                        <label class="col-sm-4 control-label">LastName</label>
                        <div class="col-sm-8">
                            <input type="text" class="form-control" id="last">
                        </div>
                    </div>
                    <div class="form-group">
                        <div class="col-sm-offset-4 col-sm-4">
                            <button type="button" id="formSubmit" class="btn btn-default">Change</button>
                        </div>
                    </div>
                </form>
            </div>  
        </div>
    </div>

    @(Html.EJ().DataManager("FlatData").Json((IEnumerable<object>)ViewBag.datasource).Adaptor(AdaptorType.JsonAdaptor))

    <script type="text/javascript">

        setTimeout(function () {
            window.employees = [];
            var query = ej.Query();
            var promise = window.FlatData.executeQuery(query);
            promise.done(function (e) {
                    employees = e.getTableModel({
                        FullName: {
                            value: function () {
                                return this.FirstName + ' ' + this.LastName;
                            },
                            deps: ["FirstName", "LastName"]
                        }
                });
                employees.bindTo($("#tbody1"));
            });
        }, 1000);
          
        $("#formSubmit").click(function (e) {
            var employeeId = parseInt($("#employeeId").val(), 10);
            var fName = $("#first").val();
            var lName = $("#last").val();
            employee = employees.get(employeeId - 1);
            employee.set("FirstName",fName);
            employee.set("LastName",lName);
        });

    </script>

The result for the above code example is illustrated as follows.