|
<div id = "ControlRegion">
@* create form *@
<form id="frmFilters" method="post">
<div class="row">
<input type="submit" class="btn btn-primary" />
</div>
</form>
@Html.EJ().Pivot().PivotGrid("PivotGrid1").EnableGroupingBar(true).ClientSideEvents(clientSideEvents => clientSideEvents.Load("onLoad")).DataSource(dataSource => dataSource.Rows(rows => { rows.FieldName("Country").FieldCaption("Country").Add(); rows.FieldName("State").FieldCaption("State").Add(); }).Columns(columns => { columns.FieldName("Product").FieldCaption("Product").Add(); }).Values(values => { values.FieldName("Amount").Add(); values.FieldName("Quantity").Add(); }).Filters(filters => { filters.FieldName("Date").FieldCaption("Date").Add(); }))
</div>
<script type="text/javascript">
$(document).ready(function () {
var pivot_dataset = [];
$("#frmFilters").submit(function (e) {
var form = $(this);
var url = '@(Url.Action("GetData", "PivotGrid"))';
$.ajax({
type: "POST",
dataType: "json",
contentType: "application/json; charset=utf-8",
url: url,
success: function (result) {
var pivot = $("#PivotGrid1").ejPivotGrid("instance");
pivot.model.dataSource.data = result;
pivot._load();
},
error: function (jqXHR, textStatus, errorThrown) {
alert("KO");
console.log(textStatus + ' ' + errorThrown);
}
});
e.preventDefault();//To privent page reload
});
})
</script> | 
