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