// 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));
}
}
