|
<ej-grid [allowPaging]="true" id="Grid" [allowSorting]="true" [allowFiltering]="true" (resizeEnd) ="onResizeEnd($event)" (actionComplete)="onactionComplete($event)" [allowGrouping]="true" [allowResizing]="true" [allowReordering]="true" [dataSource]="gridData">
. . .
. . .
</ej-grid>
//Server end
public string Query(string gridObj)
{
con.Open();
var time = DateTime.Now.TimeOfDay.ToString();
//Inserting Grid object into StateStore Table with respective time
//States and CurrentTime are two columns in table
//States have the corresponding object whereas the CurrentTime as time
SqlCommand insert = new SqlCommand("INSERT INTO SaveModel (States,CurrentTime ) VALUES('" + gridObj + "','" + time + "')", con);
insert.ExecuteNonQuery();
con.Close();
return time;//can be saved in ejDropDownList
}
export class GridComponent {
public gridData: any;
onactionComplete(e) {
var gridObj = $("#Grid").ejGrid("instance")
this.stateChanges(e, gridObj);
};
onResizeEnd(e) {
var gridObj = $("#Grid").ejGrid("instance")
this.stateChanges(e, gridObj);
}
public stateChanges(args, proxy) {
if (args.requestType != "refresh") {
var columns = proxy.model.columns.slice();
if (args.type == "resizeEnd") {
. . .
. . .
columns[inx].width = args.newWidth;
}
var state = {
cols: columns,
groupedCol: proxy.model.groupSettings.groupedColumns.slice(),
sortedCol: proxy.model.sortSettings.sortedColumns.slice(),
filteredCol: proxy.model.filterSettings.filteredColumns.slice()
}
var object = JSON.stringify(state);//converting object to string
$.ajax({
type: "POST",
url: "http://localhost:50498/Home/Query",
data: { "gridObj": object },//posting the grid object as string
success: function (data, status, xhr) {
//On Success save the data which is the time
. . . .
},
});
}
}
}
| 
