public static List <eFunctReportItem> getFunctReportByFunctCode(string functCode)
{
List <eFunctReportItem> lstResult = new List <eFunctReportItem>();
DataTable dtResult = FunctionReportAccess.getFunctReportByFunctCode(functCode);
foreach (DataRow dtr in dtResult.Rows)
{
eFunctReportItem item = new eFunctReportItem();
item.FUNCREPORTCD = dtr["FUNCPORTCD"].ToString();
item.FUNCCODE = dtr["FUNCCODE"].ToString();
item.SYS_EMPID = dtr["SYS_EMPID"].ToString();
string strDate = dtr["APPLYDATE"].ToString();
item.APPLYDATE = DateTime.ParseExact(strDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture);
if (dtr["ISACTIVE"].ToString() == "0")
{
item.ISACTIVE = false;
}
else
{
item.ISACTIVE = true;
}
item.EMPNAME = dtr["EMPNAME"].ToString();
lstResult.Add(item);
}
return(lstResult);
}
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 <FunctionReport> getAllGeoReports()
{
List <FunctionReport> functionReports = new List <FunctionReport>();
FunctionReportAccess access = new FunctionReportAccess();
DataTable dtResult = access.GetFunctionReports();
foreach (DataRow dtr in dtResult.Rows)
{
FunctionReport item = new FunctionReport
{
FUNCPORTCD = dtr["FUNCPORTCD"].ToString(),
FUNCCODE = dtr["FUNCCODE"].ToString(),
SYS_EMPID = dtr["SYS_EMPID"].ToString(),
APPLYDATE = DateTime.Parse(string.IsNullOrEmpty(dtr["APPLYDATE"].ToString()) ? "1-1-1999" : dtr["APPLYDATE"].ToString()),
ISACTIVE = dtr["ISACTIVE"].ToString(),
POSITION = dtr["POSITION"].ToString(),
SKILL = dtr["SKILL"].ToString(),
REMARK = dtr["REMARK"].ToString(),
FUNCTREPORTLEVEL = dtr["FUNCTREPORTLEVEL"].ToString(),
CREATE_UID = dtr["CREATE_UID"].ToString(),
CREATE_DT = dtr["CREATE_DT"].ToString(),
UPDATE_UID = dtr["UPDATE_UID"].ToString(),
UPDATE_DT = dtr["UPDATE_DT"].ToString(),
};
functionReports.Add(item);
}
return(functionReports);
}
public ActionResult createFunctReporter([DataSourceRequest] DataSourceRequest request, eFunctReportItem _reporter, string deptcode)
{
//FormEntity formEntity = new FormEntity();
//formEntity.FormID = _form.FORM_CODE;
//formEntity.FormName = _form.FORM_NAME;
//formEntity.DictionaryID = "";
//formEntity.CREATE_UID = "hieuht";
//formEntity.FilePath = _form.FILE_PATH;
//formEntity.ModuleID = "";
//bool result = FormAccess.InsertForm(formEntity);
_reporter.FUNCCODE = deptcode;
string userId = Session["UserId"].ToString();
DataTable dtResult = FunctionReportAccess.insertNewGeoReport(_reporter, userId);
Session["functreport_tree"] = bFunctionReport.getTreeFunctionDepts();
dynamic res = string.Empty;
res = new
{
result = dtResult.Rows[0][0].ToString(),
message = dtResult.Rows[0][1].ToString()
};
return(Json(new[] { _reporter, res }.ToDataSourceResult(request, ModelState)));
//return Json("ok", JsonRequestBehavior.AllowGet);
}
public static List <FunctionReportViewModel> getTreeFunctionReports()
{
List <FunctionReportViewModel> functionReports = new List <FunctionReportViewModel>();
FunctionReportAccess access = new FunctionReportAccess();
DataTable dtResult = access.GetTreeFunctionReports();
foreach (DataRow dtr in dtResult.Rows)
{
FunctionReportViewModel item = new FunctionReportViewModel
{
FUNCPORTCD = dtr["FUNCPORTCD"].ToString(),
FUNCNAME = dtr["FUNCNAME"].ToString(),
FUNCCODE = dtr["FUNCCODE"].ToString(),
FUNCPARENT = dtr["FUNCPARENT"].ToString()
};
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);
}
public static List <JObject> getFunctionorDataForChart(string funcCode)
{
List <JObject> elements = new List <JObject>();
DataTable dtResult = FunctionReportAccess.GetFunctionorByFuncCode(funcCode);
string sys_empidFun = string.Empty;
foreach (DataRow dtr in dtResult.Rows)
{
sys_empidFun = dtr["SYS_EMPIDFUN"].ToString();
}
if (!string.IsNullOrEmpty(sys_empidFun))
{
DataTable geos = FunctionReportAccess.GetFunctionorsBySysFun(sys_empidFun);
foreach (DataRow dtr in geos.Rows)
{
JObject subSupervisor = new JObject();
subSupervisor["id"] = dtr["SYS_EMPID"].ToString();
subSupervisor["pid"] = dtr["SYS_EMPIDFUN"].ToString();
subSupervisor["EMPID"] = dtr["EMPID"].ToString();
subSupervisor["EMPNAME"] = dtr["EMPNAME"].ToString();
subSupervisor["FUNCNAME"] = dtr["FUNCNAME"].ToString();
subSupervisor["POSITION"] = dtr["POSITION"].ToString();
subSupervisor["EMAIL"] = dtr["EMAIL"].ToString();
subSupervisor["IMAGE"] = dtr["IMAGE"].ToString();
elements.Add(subSupervisor);
}
//Get root.
EmployeeMaster root = bEmployeeMaster.getEmployeeBySysEmpid(sys_empidFun);
JObject rootSupervisor = new JObject();
rootSupervisor["id"] = sys_empidFun;
rootSupervisor["pid"] = "null";
rootSupervisor["EMPID"] = root.EMPID;
rootSupervisor["EMPNAME"] = root.EMPNAME;
rootSupervisor["FUNCNAME"] = root.FUNCNAME;
rootSupervisor["POSITION"] = root.POSITION;
rootSupervisor["EMAIL"] = root.EMAIL;
rootSupervisor["IMAGE"] = root.IMAGE;
elements.Add(rootSupervisor);
}
return(elements);
}
public static void DeleteFunctReport(string functRortCd)
{
FunctionReportAccess access = new FunctionReportAccess();
access.DeleteFunctReport(functRortCd);
}
public static void DeleteFunctReportByFKey(string functCode, string sysEmpId)
{
FunctionReportAccess access = new FunctionReportAccess();
access.DeleteFunctReportByFKey(functCode, sysEmpId);
}
public static void InsertFunctReport(string functCode, string sysEmpId)
{
FunctionReportAccess access = new FunctionReportAccess();
access.InsertFunctReport(functCode, sysEmpId);
}
