or
{"data":[{"Key":"Azure Getting Started","HasSubgroups":false,"Items":[{"Name":"Azure Getting Started","Price":540.00,"Self":"api/books/3","Id":3},{"Name":"Azure Getting Started","Price":150.00,"Self":"api/books/5","Id":5}],"Aggregates":{"Price":{"Sum":690.00,"Min":150.00,"Max":540.00},"Name":{"Count":2}},"Subgroups":[]},{"Key":"Entity FrameWork","HasSubgroups":false,"Items":[{"Name":"Entity FrameWork","Price":350.00,"Self":"api/books/2","Id":2}],"Aggregates":{"Price":{"Sum":350.00,"Min":350.00,"Max":350.00},"Name":{"Count":1}},"Subgroups":[]}],"total":5,"aggregates":{"Price":{"Sum":1810.00,"Min":150.00,"Max":550.00},"Name":{"Count":5}}}var grid = $("#ordersGrid").kendoGrid({ // specify the columns on the grid toolbar: ["create"], columns: [ { field: "Name", title: "Name", width: "100px" }, { field: "Price", title: "Price", width: "100px", aggregates: ["Min", "Max", "Sum"], footerTemplate: "Sum:#=Sum# Min:#=Min# Max:#=Max#", groupFooterTemplate: "Sum: " }, { command: ["edit", "destroy"], title: " ", width: "210px" } ], // the datasource for the grid dataSource: new kendo.data.DataSource({ // the transport tells the datasource what endpoints // to use for CRUD actions transport: { read: { url: "/apibook/readget", type: "POST" }, update: { url: "/apibook/update", type: "POST" }, destroy: { url: "/apibook/destroy", type: "POST" }, create: { url: "/apibook/create", type: "POST" }, parameterMap: function (options, operation) { if (operation != "read") { var result = {}; for (var i = 0; i < options.models.length; i++) { var book = options.models[i]; debugger; for (var member in book) { result["books[" + i + "]." + member] = book[member]; } } return result; } if (operation == "read") { var result = {}; result["take"] = options.take; result["skip"] = options.skip; result["page"] = options.page; if (options.sort != null) { for (var i = 0; i < options.sort.length; i++) { result["sort[" + i + "]." + "dir"] = options.sort[i].dir; result["sort[" + i + "]." + "field"] = options.sort[i].field; } } if (options.aggregate != null) { var aggregates = ""; debugger; for (var i = 0; i < options.aggregate.length; i++) { if (aggregates == "") { aggregates = options.aggregate[i].field + "-" + options.aggregate[i].aggregate; } else aggregates += "~" + options.aggregate[i].field + "-" + options.aggregate[i].aggregate; } result["aggregates"] = aggregates; //for (var i = 0; i < options.aggregate.length; i++) { // result["aggregate[" + i + "]." + "aggregate"] = options.aggregate[i].aggregate; // result["aggregate[" + i + "]." + "field"] = options.aggregate[i].field; //} } result["groupBy"] = "Name-asc"; if (options.filter != null) { var filter = options.filter; if (filter.filters != null) { for (var i = 0; i < filter.filters.length; i++) { result["filter[" + i + "].field"] = filter.filters[i].field; result["filter[" + i + "].op"] = filter.filters[i].operator; result["filter[" + i + "].value"] = filter.filters[i].value; } } } return result; } } }, group: { field: "Name", aggregates: [ { field: "Price", aggregate: "sum" }, { field: "Price", aggregate: "min" }, { field: "Price", aggregate: "max" }, ] }, aggregate: [ { field: "Price", aggregate: "sum" }, { field: "Price", aggregate: "min" }, { field: "Price", aggregate: "max" }, { field: "Name", aggregate: "count" }], // the schema defines the schema of the JSON coming // back from the server so the datasource can parse it schema: { // the array of repeating data elements (employees) data: function (response) { debugger; //return response.Data.Items; return response.data; }, groups: function (response) { debugger; //return response.Data.Items; return response.data; }, aggregates: function (response) { if (response.aggregates != null) return response.aggregates; else return {}; }, model: { id: "Id", fields: { // specify all the model fields, along with validation rules and whether or // not they can be edited or nulled out. Id: { editable: false, nullable: true }, Name: { editable: true }, Price: { editable: true, nullable: false, validation: { required: true } }, } }, // the total count of records in the whole dataset. used // for paging. total: "Count", }, // the number of records to show per page pageSize: 3, // do paging on the server serverPaging: true, // do sorting on the server serverSorting: true, serverAggregates: true, serverGrouping:true, batch: true }), // paging is enabled in the grid pageable: true, // editing happens inline, one row at a time. editable: "popup", selectable: true, // sort by multiple columns sortable: { mode: "multiple" }, change: function (e) { // get the current item selected in the grid var employee = this.dataSource.getByUid(this.select().data("uid")); // write out the employee id console.log(employee.id); } }).data("kendoGrid");<link rel="shortcut icon" href="@Url.Content("~/Content/images/favicon.gif")" type="image/x-icon" /> <link href="@Url.Content("~/Content/Site.css")" rel="stylesheet" type="text/css" /> <link href="@Url.Content("~/Content/css/global.css")" rel="stylesheet" type="text/css" /> <link href="@Url.Content("~/Content/kendo.dataviz.min.css")" rel="stylesheet" type="text/css" /> <link href="@Url.Content("~/Content/kendo.common.min.css")" rel="stylesheet" type="text/css" /> <link href="@Url.Content("~/Content/kendo.default.min.css")" rel="stylesheet" type="text/css" /> <script src="@Url.Content("~/Scripts/jquery.min.js")" type="text/javascript"></script> <script src="@Url.Content("~/Scripts/kendo.dataviz.min.js")"></script> <script src="@Url.Content("~/Scripts/kendo.web.min.js")" type="text/javascript"></script> <script src="@Url.Content("~/Scripts/kendo.aspnetmvc.min.js")" type="text/javascript"></script> <script src="@Url.Content("~/Scripts/corners.js")" type="text/javascript"></script> <script src="@Url.Content("~/Scripts/menu.js")" type="text/javascript"></script> <script src="@Url.Content("~/Scripts/jquery.validate.min.js")" type="text/javascript"></script> <script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")" type="text/javascript"></script>@(Html.Kendo().Grid<WANDA.ViewLookupStaffTag>() .Name("StaffTagGrid") .BindTo((IEnumerable<WANDA.ViewLookupStaffTag>)ViewBag.StaffTag) .Columns(columns => { columns.Bound(p => p.StaffTagDesc).Title("Description"); columns.Bound(p => p.StaffTagCategoryDesc).GroupHeaderTemplate( @<text> Tag Category : @item.Key </text>); columns.Bound(p => p.StaffTagStatus).EditorTemplateName("StaffTagStatusDDL").Width(140).Title("Status"); columns.Command(command => { command.Edit(); }).Width(200); }) .ToolBar(toolbar => toolbar.Create()) .Editable(editable => editable.Mode(Kendo.Mvc.UI.GridEditMode.InLine)) .DataSource(dataSource => dataSource .Server() .Group(groups => groups.Add(p => p.StaffTagCategoryDesc)) .Sort(sort => sort.Add(p=>p.StaffTagDesc)) .Model(model => model.Id(p => p.StaffTagID)) .Create(create => create.Action("StaffTag_Create", "Setup")) .Read(read => read.Action("StaffTag", "Setup")) .Update(update => update.Action("StaffTag_Update", "Setup")) .Destroy(delete => delete.Action("StaffTag_Destroy", "Setup"))) .RowAction( row => { if (row.DataItem.StaffTagStatus == "Inactive") { row.HtmlAttributes["class"] = "inactive-status"; } }) .Pageable(pager => pager.PageSizes(true)) .Sortable() .Filterable() .DataSource(data => data.Server().PageSize(100)))<!DOCTYPE html><html><head> <title></title> <script src="Scripts/jquery.min.js" type="text/javascript"></script> <script src="Scripts/kendo.web.min.js" type="text/javascript"></script> <link href="Content/kendo.common.min.css" rel="stylesheet" type="text/css" /> <link href="Content/kendo.blueopal.min.css" rel="stylesheet" type="text/css" /></head><body> <input id="datetimepicker" value="10/10/2011 12:00 AM" style="width:200px;" /> <script> $(document).ready(function () { // create DateTimePicker from input HTML element $("#datetimepicker").kendoDateTimePicker(); }); </script></body></html><div id="workshopsTableContainer"> <table id="workshopsTable" class="table table-hover table-bordered"> <thead> <tr> <th>Site</th> <th>Date/Time</th> <th>Evaluation Code</th> <th></th> </tr> </thead> <tbody data-template="workshopsTableRowTemplate" data-bind="source: workshops"></tbody> </table></div><script id="workshopsTableRowTemplate" type="text/x-kendo-tmpl"><tr> <td data-bind="text: site_id"></td> <td data-bind="text: workshop_date"></td> <td data-bind="text: evaluation_code"></td> <td><a class="btn btn-primary">Edit</a></td></tr></script>$(function(){ workshopViewModel = kendo.observable({ workshops: new kendo.data.DataSource({ transport: { read: { url: "/applications/wms/components/API.cfc?method=read", dataType: "json", data: {objType: "workshop", organization_id: 944}, type: "POST", cache: false }, parameterMap: function(options, operation) { if (operation !== "read" && options.models) { return {models: kendo.stringify(options.models)}; } return options; } }, schema: { data: "data", total: "recordcount", type: "json", model: Workshop }, batch: false }) }); kendo.bind($("#workshopsTableContainer"), workshopViewModel);})var Workshop = kendo.data.Model.define( { id: "workshop_id", fields: { "workshop_id": { type: "number", editable: true, nullable: false }, "site_id": { type: "number", editable: true, nullable: false }, "workshop_date": { type: "string", editable: true, nullable: false }, "evaluation_code": { type: "string", editable: true, nullable: false } }});{"message":"","success":true,"recordcount":5,"data":[{"organization_date_created":"November, 03 2010 20:17:26","organizer_approved":1,"organizer_extension":132.0,"organizer_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","site_county_id":39,"organization_oap":"<\/string><\/var><\/string><\/var><\/string><\/var>200<\/string><\/var>1,2,3,12,13,17,18<\/string><\/var><\/struct><\/data><\/wddxPacket>","organizer_role":"Organizer","approved":0,"manager_full_name":"Angelique Adams","site_id":865,"site_zip_code":95330.0,"pb_notes":"","site_site_type":"College Campus","manager_deleted":0,"start_date_time":"February, 03 2010 18:00:00","site_organization_id":944,"manager_extension":132.0,"site_deleted":0,"query_date":"October, 01 2012 09:45:26","organizer_region_ids":"","manager_first_name":"Angelique ","organization_id":944,"manager_role":"Organizer","site_address":"16916 S Harlan Rd","site_date_created":"November, 03 2010 20:25:40","manager_date_created":"November, 03 2010 20:17:26","organizer_organization_id":944,"organization_pa":1,"organization_zip_code":95330.0,"manager_organization_id":944,"organizer_last_name":"Adams","organizer_full_name":"Angelique Adams","start_time":"6:00 PM","organizer_phone":"209-858-0077","manager_password":"angel1031","site_site":"ITT Technical Institute","pb_survey_count":0,"organizer_organization3_id":0,"manager_id":95599,"pb_shipped_date":"","organizer_email":"ajadams@itt-tech.edu","organizer_organization2_id":0,"manager_title":"Director of Finance","date_created":"November, 03 2010 20:25:40","organization_organization":"ITT Technical Institute","site_computers":"10 to 20","organization_approved":1,"workshop_date":"2\/3\/2010","organization_city":"Lathrop","organizer_date_created":"November, 03 2010 20:17:26","organizer_organization_id2":"","manager_organization3_id":0,"organizer_first_name":"Angelique ","evaluation_code":"6ztee","organizer_organization_id3":"","organizer_id":95599,"manager_last_name":"Adams","manager_email":"ajadams@itt-tech.edu","organization_logged_in":1,"site_city":"Lathrop","manager_organization_id2":"","manager_phone":"209-858-0077","manager_organization2_id":0,"workshop_id":2120,"manager_organization_id3":"","organizer_title":"Director of Finance","manager_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","deleted":0,"organization_deleted":0,"manager_region_ids":"","organizer_deleted":0,"pb_survey_count_status":"Uninitiated","manager_approved":1,"organization_county_id":39,"organizer_password":"angel1031","end_date_time":"February, 03 2010 19:00:00","organization_address":"16916 S Harlan Rd","end_time":"7:00 PM"},{"organization_date_created":"November, 03 2010 20:17:26","organizer_approved":1,"organizer_extension":132.0,"organizer_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","site_county_id":39,"organization_oap":"<\/string><\/var><\/string><\/var><\/string><\/var>200<\/string><\/var>1,2,3,12,13,17,18<\/string><\/var><\/struct><\/data><\/wddxPacket>","organizer_role":"Organizer","approved":1,"manager_full_name":"Angelique Adams","site_id":865,"site_zip_code":95330.0,"pb_notes":"","site_site_type":"College Campus","manager_deleted":0,"start_date_time":"February, 26 2011 11:00:00","site_organization_id":944,"manager_extension":132.0,"site_deleted":0,"query_date":"October, 01 2012 09:45:26","organizer_region_ids":"","manager_first_name":"Angelique ","organization_id":944,"manager_role":"Organizer","site_address":"16916 S Harlan Rd","site_date_created":"November, 03 2010 20:25:40","manager_date_created":"November, 03 2010 20:17:26","organizer_organization_id":944,"organization_pa":1,"organization_zip_code":95330.0,"manager_organization_id":944,"organizer_last_name":"Adams","organizer_full_name":"Angelique Adams","start_time":"11:00 AM","organizer_phone":"209-858-0077","manager_password":"angel1031","site_site":"ITT Technical Institute","pb_survey_count":0,"organizer_organization3_id":0,"manager_id":95599,"pb_shipped_date":"","organizer_email":"ajadams@itt-tech.edu","organizer_organization2_id":0,"manager_title":"Director of Finance","date_created":"January, 18 2011 09:21:32","organization_organization":"ITT Technical Institute","site_computers":"10 to 20","organization_approved":1,"workshop_date":"2\/26\/2011","organization_city":"Lathrop","organizer_date_created":"November, 03 2010 20:17:26","organizer_organization_id2":"","manager_organization3_id":0,"organizer_first_name":"Angelique ","evaluation_code":"icr9w","organizer_organization_id3":"","organizer_id":95599,"manager_last_name":"Adams","manager_email":"ajadams@itt-tech.edu","organization_logged_in":1,"site_city":"Lathrop","manager_organization_id2":"","manager_phone":"209-858-0077","manager_organization2_id":0,"workshop_id":2688,"manager_organization_id3":"","organizer_title":"Director of Finance","manager_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","deleted":0,"organization_deleted":0,"manager_region_ids":"","organizer_deleted":0,"pb_survey_count_status":"Uninitiated","manager_approved":1,"organization_county_id":39,"organizer_password":"angel1031","end_date_time":"February, 26 2011 13:00:00","organization_address":"16916 S Harlan Rd","end_time":"1:00 PM"},{"organization_date_created":"November, 03 2010 20:17:26","organizer_approved":1,"organizer_extension":132.0,"organizer_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","site_county_id":39,"organization_oap":"<\/string><\/var><\/string><\/var><\/string><\/var>200<\/string><\/var>1,2,3,12,13,17,18<\/string><\/var><\/struct><\/data><\/wddxPacket>","organizer_role":"Organizer","approved":1,"manager_full_name":"Angelique Adams","site_id":865,"site_zip_code":95330.0,"pb_notes":"","site_site_type":"College Campus","manager_deleted":0,"start_date_time":"February, 03 2011 18:00:00","site_organization_id":944,"manager_extension":132.0,"site_deleted":0,"query_date":"October, 01 2012 09:45:26","organizer_region_ids":"","manager_first_name":"Angelique ","organization_id":944,"manager_role":"Organizer","site_address":"16916 S Harlan Rd","site_date_created":"November, 03 2010 20:25:40","manager_date_created":"November, 03 2010 20:17:26","organizer_organization_id":944,"organization_pa":1,"organization_zip_code":95330.0,"manager_organization_id":944,"organizer_last_name":"Adams","organizer_full_name":"Angelique Adams","start_time":"6:00 PM","organizer_phone":"209-858-0077","manager_password":"angel1031","site_site":"ITT Technical Institute","pb_survey_count":0,"organizer_organization3_id":0,"manager_id":95599,"pb_shipped_date":"","organizer_email":"ajadams@itt-tech.edu","organizer_organization2_id":0,"manager_title":"Director of Finance","date_created":"January, 18 2011 09:22:27","organization_organization":"ITT Technical Institute","site_computers":"10 to 20","organization_approved":1,"workshop_date":"2\/3\/2011","organization_city":"Lathrop","organizer_date_created":"November, 03 2010 20:17:26","organizer_organization_id2":"","manager_organization3_id":0,"organizer_first_name":"Angelique ","evaluation_code":"xz8us","organizer_organization_id3":"","organizer_id":95599,"manager_last_name":"Adams","manager_email":"ajadams@itt-tech.edu","organization_logged_in":1,"site_city":"Lathrop","manager_organization_id2":"","manager_phone":"209-858-0077","manager_organization2_id":0,"workshop_id":2689,"manager_organization_id3":"","organizer_title":"Director of Finance","manager_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","deleted":0,"organization_deleted":0,"manager_region_ids":"","organizer_deleted":0,"pb_survey_count_status":"Uninitiated","manager_approved":1,"organization_county_id":39,"organizer_password":"angel1031","end_date_time":"February, 03 2011 20:00:00","organization_address":"16916 S Harlan Rd","end_time":"8:00 PM"},{"organization_date_created":"November, 03 2010 20:17:26","organizer_approved":1,"organizer_extension":132.0,"organizer_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","site_county_id":39,"organization_oap":"<\/string><\/var><\/string><\/var><\/string><\/var>200<\/string><\/var>1,2,3,12,13,17,18<\/string><\/var><\/struct><\/data><\/wddxPacket>","organizer_role":"Organizer","approved":0,"manager_full_name":"Angelique Adams","site_id":865,"site_zip_code":95330.0,"pb_notes":"","site_site_type":"College Campus","manager_deleted":0,"start_date_time":"January, 07 2013 17:00:00","site_organization_id":944,"manager_extension":132.0,"site_deleted":0,"query_date":"October, 01 2012 09:45:26","organizer_region_ids":"","manager_first_name":"Angelique ","organization_id":944,"manager_role":"Organizer","site_address":"16916 S Harlan Rd","site_date_created":"November, 03 2010 20:25:40","manager_date_created":"November, 03 2010 20:17:26","organizer_organization_id":944,"organization_pa":1,"organization_zip_code":95330.0,"manager_organization_id":944,"organizer_last_name":"Adams","organizer_full_name":"Angelique Adams","start_time":"5:00 PM","organizer_phone":"209-858-0077","manager_password":"angel1031","site_site":"ITT Technical Institute","pb_survey_count":0,"organizer_organization3_id":0,"manager_id":95599,"pb_shipped_date":"","organizer_email":"ajadams@itt-tech.edu","organizer_organization2_id":0,"manager_title":"Director of Finance","date_created":"September, 22 2012 12:43:38","organization_organization":"ITT Technical Institute","site_computers":"10 to 20","organization_approved":1,"workshop_date":"1\/7\/2013","organization_city":"Lathrop","organizer_date_created":"November, 03 2010 20:17:26","organizer_organization_id2":"","manager_organization3_id":0,"organizer_first_name":"Angelique ","evaluation_code":"uhc3a","organizer_organization_id3":"","organizer_id":95599,"manager_last_name":"Adams","manager_email":"ajadams@itt-tech.edu","organization_logged_in":1,"site_city":"Lathrop","manager_organization_id2":"","manager_phone":"209-858-0077","manager_organization2_id":0,"workshop_id":3520,"manager_organization_id3":"","organizer_title":"Director of Finance","manager_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","deleted":0,"organization_deleted":0,"manager_region_ids":"","organizer_deleted":0,"pb_survey_count_status":"Uninitiated","manager_approved":1,"organization_county_id":39,"organizer_password":"angel1031","end_date_time":"January, 07 2013 19:00:00","organization_address":"16916 S Harlan Rd","end_time":"7:00 PM"},{"organization_date_created":"November, 03 2010 20:17:26","organizer_approved":1,"organizer_extension":132.0,"organizer_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","site_county_id":39,"organization_oap":"<\/string><\/var><\/string><\/var><\/string><\/var>200<\/string><\/var>1,2,3,12,13,17,18<\/string><\/var><\/struct><\/data><\/wddxPacket>","organizer_role":"Organizer","approved":0,"manager_full_name":"Angelique Adams","site_id":865,"site_zip_code":95330.0,"pb_notes":"","site_site_type":"College Campus","manager_deleted":0,"start_date_time":"February, 07 2013 17:00:00","site_organization_id":944,"manager_extension":132.0,"site_deleted":0,"query_date":"October, 01 2012 09:45:26","organizer_region_ids":"","manager_first_name":"Angelique ","organization_id":944,"manager_role":"Organizer","site_address":"16916 S Harlan Rd","site_date_created":"November, 03 2010 20:25:40","manager_date_created":"November, 03 2010 20:17:26","organizer_organization_id":944,"organization_pa":1,"organization_zip_code":95330.0,"manager_organization_id":944,"organizer_last_name":"Adams","organizer_full_name":"Angelique Adams","start_time":"5:00 PM","organizer_phone":"209-858-0077","manager_password":"angel1031","site_site":"ITT Technical Institute","pb_survey_count":0,"organizer_organization3_id":0,"manager_id":95599,"pb_shipped_date":"","organizer_email":"ajadams@itt-tech.edu","organizer_organization2_id":0,"manager_title":"Director of Finance","date_created":"September, 22 2012 12:44:08","organization_organization":"ITT Technical Institute","site_computers":"10 to 20","organization_approved":1,"workshop_date":"2\/7\/2013","organization_city":"Lathrop","organizer_date_created":"November, 03 2010 20:17:26","organizer_organization_id2":"","manager_organization3_id":0,"organizer_first_name":"Angelique ","evaluation_code":"ib96k","organizer_organization_id3":"","organizer_id":95599,"manager_last_name":"Adams","manager_email":"ajadams@itt-tech.edu","organization_logged_in":1,"site_city":"Lathrop","manager_organization_id2":"","manager_phone":"209-858-0077","manager_organization2_id":0,"workshop_id":3521,"manager_organization_id3":"","organizer_title":"Director of Finance","manager_login_token":"9D31858C-9448-AA47-F48C02E67A5733BF","deleted":0,"organization_deleted":0,"manager_region_ids":"","organizer_deleted":0,"pb_survey_count_status":"Uninitiated","manager_approved":1,"organization_county_id":39,"organizer_password":"angel1031","end_date_time":"February, 07 2013 20:00:00","organization_address":"16916 S Harlan Rd","end_time":"8:00 PM"}]}