javascript - Jtable error while deleting -
ihis first attempt jtable
. , works fine,except delete option. giving error:
"error occurred while communicating server"
<script> $(document).ready(function () { $("#department_v").jtable({ title: 'department entry', selecting: true, //enable selecting multiselect: true, //allow multiple selecting selectingcheckboxes: true, //show checkboxes on first column paging: true, //enables paging pagesize: 10, //actually not needed since default value 10. sorting: true, //enables sorting defaultsorting: 'id asc', //optional. default sorting on first load. actions: { listaction: '/frmadmin.aspx/departmentlist', deleteaction: '/frmadmin.aspx/deletedepartment', createaction: '/frmadmin.aspx/createnewdepartment', updateaction: '/frmadmin.aspx/updatedepartment', }, fields: { id: { title: 'id', key: true, list: true, edit: false }, dept_name: { title: 'departmentname', width: '13%' }, }, formcreated: function (event, data) { data.form.find('input[name="dept_name"]').addclass('validate[required]'); data.form.validationengine(); }, formsubmitting: function (event, data) { return data.form.validationengine('validate'); }, formclosed: function (event, data) { data.form.validationengine('hide'); data.form.validationengine('detach'); } }); $('#department_v').jtable('load'); }); </script> [webmethod(enablesession = true)] public static object departmentlist(int jtstartindex, int jtpagesize, string jtsorting) { try { //get data database using (var db = new hrisdbentities()) { var departmentresult = (from departmentlist in db.tbl_department select departmentlist).tolist(); if (departmentresult.count != 0) return new { result = "ok", records = departmentresult }; else return 0; } } catch (exception ex) { return new { result = "error reading database", message = ex.message }; } } [webmethod(enablesession = true)] public static object createnewdepartment(department record) { try { using (var db = new hrisdbentities()) { var newtblmember = new tbl_department { dept_name = record.dept_name }; var newempadd = db.tbl_department.add(newtblmember); db.savechanges(); return new { result = "ok", records = newempadd }; } } catch (exception ex) { return new { result = "error", message = ex.message }; } } [webmethod(enablesession = true)] public static object deletedepartment(int record) { try { using (hrisdbentities db = new hrisdbentities()) { var deletedmember = db.tbl_department.first(e => e.id == record); db.tbl_department.remove(deletedmember); db.savechanges(); return new { result = "ok" }; } } catch (exception ex) { return new { result = "error", message = ex.message }; } } [webmethod(enablesession = true)] public static object updatedepartment(department record) { try { int memid = record.id; using (hrisdbentities db = new hrisdbentities()) { var updateuser = (from member in db.tbl_department (member.id == memid) select member).firstordefault(); updateuser.dept_name = record.dept_name; db.tbl_department.attach(updateuser); var entry = db.entry(updateuser); entry.property(e => e.dept_name).ismodified = true; db.savechanges(); return new { result = "ok", }; } } catch (exception ex) { return new { result = "error", message = ex.message }; } }
getting following error
i'm using entity framework 6.x
thanks!
in delete method need pass parameter id
updated code
[webmethod(enablesession = true)] public static object deletedepartment(int id) { try { using (hrisdbentities db = new hrisdbentities()) { var deletedmember = db.tbl_department.first(e => e.id == id); db.tbl_department.remove(deletedmember); db.savechanges(); return new { result = "ok" }; } } catch (exception ex) { return new { result = "error", message = ex.message }; } }
after delete option working fi9.
thanks. hope others.
Comments
Post a Comment