public static List <JObject> getSupervisorDataForChart(string deptCode)
{
List <JObject> elements = new List <JObject>();
DataTable dtResult = GeoReportAccess.GetSupervisorByDeptCode(deptCode);
string sys_empidgeo = string.Empty;
foreach (DataRow dtr in dtResult.Rows)
{
sys_empidgeo = dtr["SYS_EMPIDGEO"].ToString();
}
if (!string.IsNullOrEmpty(sys_empidgeo))
{
DataTable geos = GeoReportAccess.GetSupervisorsBySysGeo(sys_empidgeo);
foreach (DataRow dtr in geos.Rows)
{
JObject subSupervisor = new JObject();
subSupervisor["id"] = dtr["SYS_EMPID"].ToString();
subSupervisor["pid"] = dtr["SYS_EMPIDGEO"].ToString();
subSupervisor["EMPID"] = dtr["EMPID"].ToString();
subSupervisor["EMPNAME"] = dtr["EMPNAME"].ToString();
subSupervisor["DEPTNAME"] = dtr["DEPTNAME"].ToString();
subSupervisor["POSITION"] = dtr["POSITION"].ToString();
subSupervisor["EMAIL"] = dtr["EMAIL"].ToString();
string imggPath = dtr["IMAGE"].ToString();
if (string.IsNullOrEmpty(imggPath))
{
imggPath = "/FileServer/Photos/default.jpg";
}
else if (!IsFileExists(imggPath))
{
imggPath = "/FileServer/Photos/default.jpg";
}
subSupervisor["IMAGE"] = imggPath;// dtr["IMAGE"].ToString();
elements.Add(subSupervisor);
}
//Get root.
EmployeeMaster root = bEmployeeMaster.getEmployeeBySysEmpid(sys_empidgeo);
JObject rootSupervisor = new JObject();
rootSupervisor["id"] = sys_empidgeo;
rootSupervisor["pid"] = "null";
rootSupervisor["EMPID"] = root.EMPID;
rootSupervisor["EMPNAME"] = root.EMPNAME;
rootSupervisor["DEPTNAME"] = root.DEPTNAME;
rootSupervisor["POSITION"] = root.POSITION;
rootSupervisor["EMAIL"] = root.EMAIL;
string imgPath = root.IMAGE;
if (string.IsNullOrEmpty(imgPath))
{
imgPath = "/FileServer/Photos/default.jpg";
}
else if (!IsFileExists(imgPath))
{
imgPath = "/FileServer/Photos/default.jpg";
}
rootSupervisor["IMAGE"] = imgPath;
elements.Add(rootSupervisor);
}
return(elements);
}
public static List <JObject> getSupervisorDataForChartV2(string deptCode)
{
List <JObject> elements = new List <JObject>();
DataTable dtResult = GeoReportAccess.GetSupervisorByDeptCode(deptCode);
List <string> sys_empidgeo = new List <string>();
string sys_parent = string.Empty;
if (dtResult.Rows.Count > 1)
{
DeptAccess deptAccess = new DeptAccess();
DataTable depResult = deptAccess.GetByDeptCodeIsActive(deptCode);
foreach (DataRow dtr in depResult.Rows)
{
JObject rootSupervisor = new JObject();
rootSupervisor["id"] = dtr["DEPTCODE"].ToString();
rootSupervisor["pid"] = "null";
rootSupervisor["EMPID"] = "";
rootSupervisor["EMPNAME"] = "";
rootSupervisor["DEPTNAME"] = dtr["DEPTNAME"].ToString();
rootSupervisor["POSITION"] = "";
rootSupervisor["EMAIL"] = "";
rootSupervisor["IMAGE"] = "/FileServer/Photos/default.jpg";
elements.Add(rootSupervisor);
sys_parent = dtr["DEPTCODE"].ToString();
break;
}
}
foreach (DataRow dtr in dtResult.Rows)
{
if (!sys_empidgeo.Contains(dtr["SYS_EMPIDGEO"].ToString()))
{
sys_empidgeo.Add(dtr["SYS_EMPIDGEO"].ToString());
}
}
if (sys_empidgeo != null && sys_empidgeo.Count() > 0)
{
foreach (var sys_geo in sys_empidgeo)
{
DataTable geos = GeoReportAccess.GetSupervisorsBySysGeo(sys_geo);
foreach (DataRow dtr in geos.Rows)
{
JObject subSupervisor = new JObject();
subSupervisor["id"] = dtr["SYS_EMPID"].ToString();
subSupervisor["pid"] = dtr["SYS_EMPIDGEO"].ToString();
subSupervisor["EMPID"] = dtr["EMPID"].ToString();
subSupervisor["EMPNAME"] = dtr["EMPNAME"].ToString();
subSupervisor["DEPTNAME"] = dtr["DEPTNAME"].ToString();
subSupervisor["POSITION"] = dtr["POSITION"].ToString();
subSupervisor["EMAIL"] = dtr["EMAIL"].ToString();
string imgsPath = dtr["IMAGE"].ToString();
if (string.IsNullOrEmpty(imgsPath))
{
imgsPath = "/FileServer/Photos/default.jpg";
}
else if (!IsFileExists(imgsPath))
{
imgsPath = "/FileServer/Photos/default.jpg";
}
subSupervisor["IMAGE"] = imgsPath;// dtr["IMAGE"].ToString();
elements.Add(subSupervisor);
}
//Get root.
EmployeeMaster root = bEmployeeMaster.getEmployeeBySysEmpid(sys_geo);
JObject rootSupervisor = new JObject();
rootSupervisor["id"] = sys_geo;
rootSupervisor["pid"] = sys_parent;
rootSupervisor["EMPID"] = root.EMPID;
rootSupervisor["EMPNAME"] = root.EMPNAME;
rootSupervisor["DEPTNAME"] = root.DEPTNAME;
rootSupervisor["POSITION"] = root.POSITION;
rootSupervisor["EMAIL"] = root.EMAIL;
string imgPath = root.IMAGE;
if (string.IsNullOrEmpty(imgPath))
{
imgPath = "/FileServer/Photos/default.jpg";
}
else if (!IsFileExists(imgPath))
{
imgPath = "/FileServer/Photos/default.jpg";
}
rootSupervisor["IMAGE"] = imgPath;
elements.Add(rootSupervisor);
}
}
if (elements.Count() == 0)
{
DeptAccess deptAccess = new DeptAccess();
DataTable depResult = deptAccess.GetByDeptCodeIsActive(deptCode);
foreach (DataRow dtr in depResult.Rows)
{
JObject rootSupervisor = new JObject();
rootSupervisor["id"] = dtr["DEPTCODE"].ToString();
rootSupervisor["pid"] = "null";
rootSupervisor["EMPID"] = "";
rootSupervisor["EMPNAME"] = "Doesn't have SUPERVISOR";
rootSupervisor["DEPTNAME"] = dtr["DEPTNAME"].ToString();
rootSupervisor["POSITION"] = "";
rootSupervisor["EMAIL"] = "";
rootSupervisor["IMAGE"] = "/FileServer/Photos/default.jpg";
elements.Add(rootSupervisor);
sys_parent = dtr["DEPTCODE"].ToString();
break;
}
}
return(elements);
}
