public static List <FunctViewModel> getFunctions()
{
List <FunctViewModel> dtFunct = new List <FunctViewModel>();
FunctAccess access = new FunctAccess();
DataTable dtResult = access.GetFunctions();
foreach (DataRow dtr in dtResult.Rows)
{
FunctViewModel item = new FunctViewModel
{
FUNCCODE = dtr["FUNCCODE"].ToString(),
FUNCNAME = dtr["FUNCNAME"].ToString(),
FUNCPARENT = dtr["FUNCPARENT"].ToString(),
FUNCLEVEL = dtr["FUNCLEVEL"].ToString(),
ORDERINDEX = dtr["ORDERINDEX"].ToString(),
ISACTIVE = dtr["ISACTIVE"].ToString(),
REMARK = dtr["REMARK"].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()
};
dtFunct.Add(item);
}
return(dtFunct);
}
public static string getNewFunctCode(string functCode)
{
FunctAccess access = new FunctAccess();
DataTable result = access.GetNewFunctCode(functCode);
if (result.Columns.Contains("'ERROR'"))
{
if (result.Rows[0].ItemArray[1].ToString() == "Not exist T_HR_DEPT")
{
return("-1");
}
}
return(result.Rows[0]["NEWFUNCCODE"].ToString());
}
public static KeyValuePair <JObject, List <JObject> > getDataForFuncChart(string funccode)
{
List <FunctViewModel> functs = new List <FunctViewModel>();
//DUNG DE DUYET LUA CHON NODE HIEN THI.
List <ElementViewModel> result = new List <ElementViewModel>();
#region "TAO TAT CA CAC GROUPS"
JObject groupElements = new JObject();
FunctAccess access = new FunctAccess();
DataTable dtResult = access.GetChildsByFunccodeIsActive(funccode);
foreach (DataRow dtr in dtResult.Rows)
{
JObject group = new JObject();
group["group"] = true;
group["groupName"] = dtr["FUNCNAME"].ToString();
group["groupState"] = "";
group["template"] = "group_grey";
string key = "A" + dtr["FUNCCODE"].ToString();
FunctViewModel item = new FunctViewModel
{
FUNCCODE = dtr["FUNCCODE"].ToString(),
FUNCNAME = dtr["FUNCNAME"].ToString(),
FUNCPARENT = dtr["FUNCPARENT"].ToString(),
FUNCLEVEL = dtr["FUNCLEVEL"].ToString(),
ORDERINDEX = dtr["ORDERINDEX"].ToString(),
ISACTIVE = dtr["ISACTIVE"].ToString()
};
functs.Add(item);
ElementViewModel g = new ElementViewModel
{
display = true,
id = dtr["FUNCCODE"].ToString(),
pid = dtr["FUNCPARENT"].ToString()
};
result.Add(g);
groupElements[key] = group;
}
//LAY VE NODE TUONG UNG DEPTCODE TUYEN VAO.
if (funccode != "-1")
{
#region "NODE ROOT NEU FUNCCODE !=-1 (LAY TAT CA)"
dtResult = access.GetByFuncCodeIsActive(funccode);
foreach (DataRow dtr in dtResult.Rows)
{
int oLevel;
int.TryParse(dtr["FUNCLEVEL"].ToString(), out oLevel);
JObject group = new JObject();
group["group"] = true;
group["groupName"] = dtr["FUNCNAME"].ToString();
group["groupState"] = "";
group["template"] = "group_grey";
string key = "A" + dtr["FUNCCODE"].ToString();
FunctViewModel item = new FunctViewModel
{
FUNCCODE = dtr["FUNCCODE"].ToString(),
FUNCNAME = dtr["FUNCNAME"].ToString(),
FUNCPARENT = dtr["FUNCPARENT"].ToString(),
FUNCLEVEL = dtr["FUNCLEVEL"].ToString(),
ORDERINDEX = dtr["ORDERINDEX"].ToString(),
ISACTIVE = dtr["ISACTIVE"].ToString()
};
functs.Add(item);
ElementViewModel g = new ElementViewModel
{
display = true,
id = dtr["FUNCCODE"].ToString(),
pid = dtr["FUNCPARENT"].ToString()
};
result.Add(g);
groupElements[key] = group;
}
#endregion
}
#region "TAO GROUP EMPTY"
JObject egroup = new JObject();
egroup["group"] = false;
egroup["groupName"] = "";
egroup["groupState"] = "";
egroup["template"] = "empty";
groupElements["empty"] = egroup;
#endregion
#endregion
#region "TAO CAC NODES EMPTY"
List <JObject> nodeElements = new List <JObject>();
#region "TAO CAC FUNCTIONER"
var empReporter = bEmployeeMasterReport.GeFunctioners();
Dictionary <string, string> funcCodeDeptParents = new Dictionary <string, string>();
//LAY CAC GEO SUPERVISOR
foreach (var geo in empReporter)
{
var dept = result.Where(d => d.id == geo.DEPTCODEFUN).FirstOrDefault();
if (dept == null)
{
continue;
}
//DANH DAU KO HIEN THI
dept.display = false;
var list = result.Where(d => d.pid == dept.id);
//TAO MOT NODE SUPERVISOR.
JObject group = new JObject();
//CAP NHAT LAI PID TRO VAO GEO SUPERVISOR
foreach (var g in list)
{
g.pid = geo.SYS_EMPID;
}
group["id"] = geo.SYS_EMPID;
var efunc = result.Where(d => d.pid == dept.pid && d.display == false).FirstOrDefault();
if (efunc != null)
{
var el = empReporter.Where(em => em.DEPTCODEFUN == dept.pid).FirstOrDefault();
if (el != null)
{
group["pid"] = el.SYS_EMPID;
}
else
{
group["pid"] = dept.pid;
}
}
group["tags"] = "[" + "'A" + geo.DEPTCODEFUN + "']";
group["EMPNAME"] = geo.EMPNAME;
group["EMPID"] = geo.EMPID;
group["EMAIL"] = geo.EMAIL;
group["POSITION"] = geo.POSITION;
group["IMAGE"] = geo.IMAGE;
nodeElements.Add(group);
}
#endregion
//KIEM TRA ROOT CO GEO FUNCTIONER.
if (funccode != "-1")
{
ElementViewModel e = result.Where(d => d.id == funccode && d.display == true).FirstOrDefault();
if (e != null)
{
JObject rgroup = new JObject();
rgroup["id"] = e.id;
rgroup["pid"] = e.pid;
rgroup["tags"] = "[" + "'empty','A" + funccode + "']";
rgroup["EMPNAME"] = "";
rgroup["EMPID"] = "";
rgroup["EMAIL"] = "";
rgroup["POSITION"] = "";
rgroup["IMAGE"] = "";
nodeElements.Add(rgroup);
}
}
foreach (var d in functs)
{
ElementViewModel node = result.Where(dp => dp.id == d.FUNCCODE && dp.display == true).FirstOrDefault();
if (node != null)
{
JObject group = new JObject();
group["id"] = node.id;
group["pid"] = node.pid;
group["tags"] = "[" + "'empty','A" + d.FUNCCODE + "']";
group["EMPNAME"] = "";
group["EMPID"] = "";
group["EMAIL"] = "";
group["POSITION"] = "";
group["IMAGE"] = "";
nodeElements.Add(group);
}
}
#endregion
KeyValuePair <JObject, List <JObject> > data = new KeyValuePair <JObject, List <JObject> >(groupElements, nodeElements);
return(data);
}
public static void UpdateFunction(FunctViewModel functViewModel)
{
FunctAccess access = new FunctAccess();
access.UpdateFunctions(functViewModel);
}
public static void insertFunction(FunctViewModel functViewModel)
{
FunctAccess access = new FunctAccess();
access.InsertFunctions(functViewModel);
}
