$(document).ready(function() {
$('#jpgCustomers').jqGrid({//url from wich data should be requestedurl: '@Url.Action("Customers")',//type of datadatatype: 'json',//urlaccessmethod typemtype: 'POST',
serializeRowData:function(postData) {
$.blockUI({message: ("#working")});returnpostData;
},//columns model//columns namescolNames: ['No.', 'Name', 'FullName', 'Description', 'Enabled', 'Email Address', 'Phone', 'Pager', 'Fax', 'Comments', ' '],
colModel: [//displayed Columns{ name: 'Number', index: 'Number', align: 'center', width: 40, editable:false, search:false},
{ name:'LogonName', index: 'LogonName', align: 'left', width: 80, editable:true, search:true, stype: 'text', editrules: { required:true} },
{ name:'FullName', index: 'FullName', align: 'left', width: 200, editable:true, search:true, stype: 'text', editrules: { required:true} },
{ name:'Description', index: 'Description', align: 'left', width: 300, editable:true, search:true, stype: 'text'},
{ name:'Enabled', index: 'Enabled', align: 'center', width: 80, editable:true, formatter: SFTPEnabledFormatter, unformat: SFTPEnabledUnformatter, edittype: 'select', editoptions: { value: '-2:Inherited;0:Disabled;1:Enabled' }, search:true, stype: 'select', searchoptions: { value: "-1:All;-2:Inherited;1:Enabled;0:Disabled"} },//Hidden Columns{ width: 60, name: 'Email', index: 'Email', hidden:true, editable:true, editrules: { required:true, edithidden:true}, editype: 'email'},
{ width:60, name: 'Phone', index: 'Phone', hidden:true, editable:true, editrules: { required:false, edithidden:true, number:true, minValue: 0 }, editype: 'text'},
{ width:60, name: 'Pager', index: 'Pager', hidden:true, editable:true, editrules: { required:false, edithidden:true, number:true, minValue: 0 }, editype: 'text'},
{ width:60, name: 'Fax', index: 'Fax', hidden:true, editable:true, editrules: { required:false, edithidden:true, number:true, minValue: 0 }, editype: 'text'},
{ width:120, name: 'Comments', index: 'Comments', align: 'left', hidden:true, editable:true, editrules: { required:false, edithidden:true}, edittype: 'textarea', editoptions: { rows: '3', cols: '60'} },//Action column{
name:'myac',
width:80,
fixed:true,
sortable:false,
resize:false,
editable:false,
search:false,
formatter:'actions',
formatoptions: {
onSuccess:function(response) {debugger;
$.unblockUI();varjsonResponse =$.parseJSON(response.responseText);if(jsonResponse.State != 'Success') {return[false, jsonResponse.ResponseMessage];
}else{return[true];
} },
onError :function(rowid, response, textStatus) {debugger;
$.unblockUI();
},
keys:true,
delOptions: {
url: encodeURI('@Url.Action("DeleteCustomer")'),
onclickSubmit:function(params, posdata) {
$.blockUI({message: ("#working")});
},
afterSubmit:function(response, postData) {
$.unblockUI();varjsonResponse =$.parseJSON(response.responseText);if(jsonResponse.State != 'Success') {return[false, jsonResponse.ResponseMessage];
}else{return[true];
}
},
beforeShowForm:function(form) {vardlgDiv = $("#delmod" +jpgCustomers.id);
CenterDialog(dlgDiv);varsel_id = $("#DelData>td:nth-child(1)").text();
$("td.delmsg", form).html("Delete User <b>" + $("#jpgCustomers").jqGrid('getCell', sel_id, 'LogonName') + "</b>?");
}
}
}
}
],
reloadAfterSubmit:true,//pager for gridpager: $('#jpgpCustomers'),//number of rows per pagerowNum: @(Model.RowsInCustomerGrid),//initial sorting columnsortname: 'FullName',//initial sorting directionsortorder: 'asc',//we want to display total records countviewrecords:true,//grid heightheight: '100%',//where to go on submit of edit/addediturl: encodeURI('@Url.Action("EditCustomer")'),//subgrid});
});