// GET: /Staffs/GetStaffData?staffID=0&staffroleId=0 public JsonResult GetStaffData(int staffID, int staffroleId) { // รับค่าราคา StaffData st = new StaffData(); DataTable dt = new DataTable(); List <Staffs> staffList = new List <Staffs>(); try { dt = st.GetStaffRolePermissionSale(staffID, staffroleId); if (dt.Rows.Count > 0) { staffList = dt.AsEnumerable().Select(dr => new Staffs() { StaffID = dr.Field <int>("StaffID"), StaffCode = dr.Field <string>("StaffCode"), StaffTitleName = dr.Field <string>("StaffTitleName"), StaffFirstName = dr.Field <string>("StaffFirstName"), StaffLastName = dr.Field <string>("StaffLastName"), StaffRoleID = dr.Field <int>("StaffRoleID"), StaffRoleName = dr.Field <string>("StaffRoleName"), StaffName = dr.Field <string>("StaffTitleName") + dr.Field <string>("StaffFirstName") + " " + dr.Field <string>("StaffLastName"), Activated = dr.Field <int>("Activated"), Deleted = dr.Field <int>("Deleted"), }).ToList(); } return(Json(new { data = staffList, success = true }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { data = ex.Message, success = false }, JsonRequestBehavior.AllowGet)); } }