public static List <EmployeeMaster> getUserFunctionReports(string funccode) { List <EmployeeMaster> functionReports = new List <EmployeeMaster>(); FunctionReportAccess access = new FunctionReportAccess(); DataTable dtResult = access.GetUsersFunctionReports(funccode); foreach (DataRow dtr in dtResult.Rows) { EmployeeMaster item = new EmployeeMaster { SYS_EMPID = dtr["SYS_EMPID"].ToString(), EMPID = dtr["EMPID"].ToString(), EMPNAME = dtr["EMPNAME"].ToString(), POSITION = dtr["POSITION"].ToString(), SKILL = dtr["SKILL"].ToString() }; CategoryValueEntity position = bEmployeeMaster.getPositions().Where(p => p.Code == item.POSITION).FirstOrDefault(); CategoryValueEntity skill = bEmployeeMaster.getSkills().Where(p => p.Code == item.SKILL).FirstOrDefault(); if (position != null) { item.POSITION = position.CategoryValue; } if (skill != null) { item.SKILL = skill.CategoryValue; } functionReports.Add(item); } return(functionReports); }
public static List <EmployeeMaster> getUserInFunctReportByDeptCode(string functCode) { List <EmployeeMaster> functionReports = new List <EmployeeMaster>(); FunctionReportAccess access = new FunctionReportAccess(); DataTable dtResult = access.GetUsersFunctionReports(functCode); foreach (DataRow dtr in dtResult.Rows) { EmployeeMaster item = new EmployeeMaster { //FUNCPORTCD = dtr["FUNCPORTCD"].ToString(), EMPID = dtr["EMPID"].ToString(), EMPNAME = dtr["EMPNAME"].ToString() + "," + dtr["SYS_EMPID"].ToString(), SYS_EMPID = dtr["SYS_EMPID"].ToString() }; functionReports.Add(item); } return(functionReports); }