<script type="text/javascript">
    var assetListVM;
    $(function () {
        assetListVM = {
            dt: null,

            init: function () {
                dt = $('#assets-data-table').DataTable({
                    "serverSide": true,
                    "processing": true,
                    "ajax": {
                        "url": "@Url.Action("Get", "tbl_Patient_Registration")",
                        "data": function (data) {



                        }
                    },
                    "columns": [

                        { "title": "MR No", "data": "MR_No", "searchable": true },
                        { "title": "CR No", "data": "CR_No", "searchable": true },
                        { "title": "Ptient Name", "data": "Ptient_Name", "searchable": true },
                        { "title": "Mobile No", "data": "Mobile_No", "searchable": true },
                        { "title": "CNIC/Passport No", "data": "CNIC_Passport_No", "searchable": true },
                        {
                            "title": "Reg Date", "data": "Reg_Date","type": "date", "dateFormat": "mm/dd/yyyy"  },


                         {
                             "render": function (data, type, full, meta)
                             { return '<a class="btn btn-info" href="/tbl_Patient_Registration/Edit/' + full.MR_No + '">Edit</a>'; }
                         }


                    ],
                    "lengthMenu": [[10, 25, 50, 100], [10, 25, 50, 100]],
                });
            },

            refresh: function () {
                dt.ajax.reload();
            }
        }


        // initialize the datatables
        assetListVM.init();

    });

</script>

// searching and sorting
        query = SearchAssets(requestModel, query);
        var filteredCount = query.Count();

        // Paging
        query = query.Skip(requestModel.Start).Take(requestModel.Length);


        var data = query.Select(s => new
        {
            MR_No =s.MR_No,
            CR_No = s.CR_No,
            Ptient_Name = s.Ptient_Name,
            Mobile_No = s.Mobile_No,
            Reg_Date = s.Reg_Date,
            CNIC_Passport_No = s.CNIC_Passport_No

        }).ToList();

        return Json(new DataTablesResponse(requestModel.Draw, data, filteredCount, totalCount), JsonRequestBehavior.AllowGet);

    }