public static List <EmployeeMasterReport> GetEmployeeReports()
{
List <EmployeeMasterReport> dtEmployees = new List <EmployeeMasterReport>();
EmployeeMasterReportAccess access = new EmployeeMasterReportAccess();
DataTable dtResult = access.GetEmployeeReports();
foreach (DataRow dtr in dtResult.Rows)
{
EmployeeMasterReport item = new EmployeeMasterReport
{
REPORTCD = dtr["REPORTCD"].ToString(),
SYS_EMPID = dtr["SYS_EMPID"].ToString(),
DEPTCODEGEO = dtr["DEPTCODEGEO"].ToString(),
SYS_EMPIDGEO = dtr["SYS_EMPIDGEO"].ToString(),
DEPTCODEFUN = dtr["DEPTCODEFUN"].ToString(),
SYS_EMPIDFUN = dtr["SYS_EMPIDFUN"].ToString(),
APPLYDATE = dtr["APPLYDATE"].ToString(),
ISACTIVE = dtr["ISACTIVE"].ToString(),
POSITION = dtr["POSITION"].ToString(),
SKILL = dtr["SKILL"].ToString(),
REMARK = dtr["REMARK"].ToString(),
LEVELGEO = dtr["LEVELGEO"].ToString(),
LEVELFUN = dtr["LEVELFUN"].ToString(),
CREATE_UID = dtr["CREATE_UID"].ToString(),
UPDATE_UID = dtr["UPDATE_UID"].ToString(),
};
dtEmployees.Add(item);
}
return(dtEmployees);
}
public DataTable UpdateEmployeeReport(EmployeeMasterReport employeeMaster)
{
OracleParameter[] param = new OracleParameter[14];
param[0] = new OracleParameter("pREPORTCD", (object)employeeMaster.REPORTCD ?? DBNull.Value);
param[1] = new OracleParameter("pSYS_EMPID", (object)employeeMaster.SYS_EMPID ?? DBNull.Value);
param[2] = new OracleParameter("pDEPTCODEGEO", (object)employeeMaster.DEPTCODEGEO ?? DBNull.Value);
param[3] = new OracleParameter("pSYS_EMPIDGEO", (object)employeeMaster.SYS_EMPIDGEO ?? DBNull.Value);
param[4] = new OracleParameter("pDEPTCODEFUN", (object)employeeMaster.DEPTCODEFUN ?? DBNull.Value);
param[5] = new OracleParameter("pSYS_EMPIDFUN", (object)employeeMaster.SYS_EMPIDFUN ?? DBNull.Value);
param[6] = new OracleParameter("pAPPLYDATE", (object)employeeMaster.APPLYDATE ?? DBNull.Value);
param[7] = new OracleParameter("pISACTIVE", (object)employeeMaster.ISACTIVE ?? DBNull.Value);
param[8] = new OracleParameter("pPOSITION", (object)employeeMaster.POSITION ?? DBNull.Value);
param[9] = new OracleParameter("pSKILL", (object)employeeMaster.SKILL ?? DBNull.Value);
param[10] = new OracleParameter("pREMARK", (object)employeeMaster.REMARK ?? DBNull.Value);
param[11] = new OracleParameter("pLEVELGEO", (object)employeeMaster.LEVELGEO ?? DBNull.Value);
param[12] = new OracleParameter("pLEVELFUN", (object)employeeMaster.LEVELFUN ?? DBNull.Value);
param[13] = new OracleParameter("pUPDATE_UID", (object)employeeMaster.UPDATE_UID ?? DBNull.Value);
return(DBHelper.getDataTable_SP("HR_EMP_REPORT.SP_UPDATE_EMP_REPORT", param));
}
public ActionResult SaveEmployee(EmployeeMaster employeeMaster)
{
ViewBag.isMode = 1;
bool isValid = true;
//New
//string DATEJOIN = employeeMaster.DATEJOIN.ToString("dd-MM-yyyy");
//employeeMaster.DATEJOIN = DateTime.Parse(DATEJOIN);
if (string.IsNullOrEmpty(employeeMaster.SYS_EMPID))
{
employeeMaster.SYS_EMPID = bEmployeeMaster.getSysEmpId();
employeeMaster.EMPID = "00000000";
if (ModelState.IsValid)
{
employeeMaster.EMPID = bEmployeeMaster.getEmpId(employeeMaster.DEPTCODE, employeeMaster.DATEJOIN);
employeeMaster.IMAGE = "default.jpg";
//string image = uploadImage(null, employeeMaster.EMPID);
//employeeMaster.IMAGE = image;
bEmployeeMaster.insertEmployee(employeeMaster);
if (!string.IsNullOrEmpty(employeeMaster.GEOGRAPHICALORG) || !string.IsNullOrEmpty(employeeMaster.FUNCTIONALORG))
{
EmployeeMasterReport employeeMasterGeReport = new EmployeeMasterReport();
//insert employeereport is georeport.
if (!string.IsNullOrEmpty(employeeMaster.GEOGRAPHICALORG))
{
employeeMasterGeReport.DEPTCODEGEO = employeeMaster.GEOGRAPHICALORG;
if (!string.IsNullOrEmpty(employeeMaster.GEODIRECTREPORT))
{
employeeMasterGeReport.SYS_EMPIDGEO = employeeMaster.GEODIRECTREPORT;
}
}
//insert employeereport is functionreport.
if (!string.IsNullOrEmpty(employeeMaster.FUNCTIONALORG))
{
employeeMasterGeReport.DEPTCODEFUN = employeeMaster.FUNCTIONALORG;
if (!string.IsNullOrEmpty(employeeMaster.FUNCDIRECTREPORT))
{
employeeMasterGeReport.SYS_EMPIDFUN = employeeMaster.FUNCDIRECTREPORT;
}
}
employeeMasterGeReport.REPORTCD = bEmployeeMasterReport.getReportCDID();
employeeMasterGeReport.SYS_EMPID = employeeMaster.SYS_EMPID;
bEmployeeMasterReport.InsertEmployeeReport(employeeMasterGeReport);
}
}
else
{
isValid = false;
employeeMaster.SYS_EMPID = null;
employeeMaster.EMPID = null;
}
}
else//Update
{
if (ModelState.IsValid)
{
//string image = uploadImage(null, employeeMaster.EMPID);
//employeeMaster.IMAGE = image;
if (employeeMaster.IMAGE.Contains("default.jpg"))
{
employeeMaster.IMAGE = "default.jpg";
}
else
{
employeeMaster.IMAGE = employeeMaster.EMPID + ".jpg";
}
bEmployeeMaster.UpdateEmployee(employeeMaster);
List <EmployeeMasterReport> employeeMasterReport = bEmployeeMasterReport.getEmployeeReportBySysEmpID(employeeMaster.SYS_EMPID);
if (employeeMasterReport.Count > 0)
{
employeeMasterReport[0].DEPTCODEGEO = employeeMaster.GEOGRAPHICALORG;
employeeMasterReport[0].SYS_EMPIDGEO = employeeMaster.GEODIRECTREPORT;
employeeMasterReport[0].DEPTCODEFUN = employeeMaster.FUNCTIONALORG;
employeeMasterReport[0].SYS_EMPIDFUN = employeeMaster.FUNCDIRECTREPORT;
bEmployeeMasterReport.UpdateEmployeeReport(employeeMasterReport[0]);
}
else
{
if (!string.IsNullOrEmpty(employeeMaster.GEOGRAPHICALORG) || !string.IsNullOrEmpty(employeeMaster.FUNCTIONALORG))
{
EmployeeMasterReport employeeMasterGeReport = new EmployeeMasterReport();
//insert employeereport is georeport.
if (!string.IsNullOrEmpty(employeeMaster.GEOGRAPHICALORG))
{
employeeMasterGeReport.DEPTCODEGEO = employeeMaster.GEOGRAPHICALORG;
if (!string.IsNullOrEmpty(employeeMaster.GEODIRECTREPORT))
{
employeeMasterGeReport.SYS_EMPIDGEO = employeeMaster.GEODIRECTREPORT;
}
}
//insert employeereport is functionreport.
if (!string.IsNullOrEmpty(employeeMaster.FUNCTIONALORG))
{
employeeMasterGeReport.DEPTCODEFUN = employeeMaster.FUNCTIONALORG;
if (!string.IsNullOrEmpty(employeeMaster.FUNCDIRECTREPORT))
{
employeeMasterGeReport.SYS_EMPIDFUN = employeeMaster.FUNCDIRECTREPORT;
}
}
employeeMasterGeReport.REPORTCD = bEmployeeMasterReport.getReportCDID();
employeeMasterGeReport.SYS_EMPID = employeeMaster.SYS_EMPID;
bEmployeeMasterReport.InsertEmployeeReport(employeeMasterGeReport);
}
}
}
else
{
isValid = false;
}
}
ViewBag.Countries = SelectListCountries(employeeMaster.NATIONALITY);
ViewBag.Gender = SelectListGender(employeeMaster.GENDER);
ViewBag.Academics = SelectListAcademicLevels(employeeMaster.ACADEMIC);
ViewBag.Positions = SelectListPositions(employeeMaster.POSITION);
ViewBag.Skills = SelectListSkills(employeeMaster.SKILL);
//if (Session["geoorganizationreport_tree"] == null)
// Session["geoorganizationreport_tree"] = bGeoReport.getTreeGeoDepts();
//if (Session["functreport_tree"] == null)
// Session["functreport_tree"] = bFunctionReport.getTreeFunctionDepts();
ViewBag.geoInline = getGeOrganizations_Default_Inline_Data();
ViewBag.functInline = getFunctReports_Default_Inline_Data();
if (!string.IsNullOrEmpty(employeeMaster.EMPID))
{
employeeMaster = bEmployeeMaster.getEmployeeByEmpId(employeeMaster.EMPID);
}
if (isValid == false)
{
ViewBag.isMode = 0;
ModelState.Clear();
return(View("Index", employeeMaster));
}
ModelState.Clear();
return(View("Index", employeeMaster));
//return View("Edit", employeeMaster);
}
//END GEO
//Version 2.0
public static List <EmployeeDiagramViewModel> getDiagram(EmployeeMaster e)
{
if (e == null)
{
return(null);
}
List <EmployeeMasterReport> employeeMasterReport = bEmployeeMasterReport.getEmployeeReportBySysEmpID(e.SYS_EMPID);
List <EmployeeMaster> employeeMaster = bEmployeeMaster.getAllEmployees();
List <EmployeeMasterReport> allEmployeeReport = bEmployeeMasterReport.GetEmployeeReports();
List <EmployeeMasterReport> result = new List <EmployeeMasterReport>();
EmployeeMasterReport iterate = new EmployeeMasterReport();
iterate.SYS_EMPID = e.SYS_EMPID;
iterate.SYS_EMPIDFUN = e.FUNCDIRECTREPORT;
iterate.SYS_EMPIDGEO = e.GEODIRECTREPORT;
while (iterate != null)
{
if (result.Where(i => i.SYS_EMPID == iterate.SYS_EMPID).FirstOrDefault() == null)
{
result.Add(iterate);
}
iterate = allEmployeeReport.Where(erp => erp.SYS_EMPID == iterate.SYS_EMPIDFUN).FirstOrDefault();
}
result.Reverse();
if (result.Count == 0)
{
return(null);
}
List <EmployeeDiagramViewModel> data = new List <EmployeeDiagramViewModel>();
if (result.Count == 1)
{
if (!string.IsNullOrEmpty(e.FUNCDIRECTREPORT))
{
EmployeeDiagramViewModel parent = new EmployeeDiagramViewModel();
EmployeeMaster eOldParent = employeeMaster.Where(emp => emp.SYS_EMPID == e.FUNCDIRECTREPORT).FirstOrDefault();
parent.EMPNAME = eOldParent.EMPNAME;
parent.EMPID = eOldParent.EMPID;
parent.SYS_EMPID = eOldParent.SYS_EMPID;
parent.SYS_EMPIDGEO = e.GEODIRECTREPORT;
parent.SYS_EMPIDFUN = e.FUNCDIRECTREPORT;
if (string.IsNullOrEmpty(eOldParent.IMAGE))
{
parent.Image = "default.jpg" + "?" + (new Random()).Next(0, 100);
}
else
{
parent.Image = eOldParent.IMAGE + "?" + (new Random()).Next(0, 100);
}
parent.ColorScheme = "#1696d3";
EmployeeDiagramViewModel current = new EmployeeDiagramViewModel();
EmployeeMaster eCurrent = employeeMaster.Where(emp => emp.SYS_EMPID == result[0].SYS_EMPID).FirstOrDefault();
current.EMPNAME = eCurrent.EMPNAME;
current.EMPID = eCurrent.EMPID;
current.SYS_EMPID = eCurrent.SYS_EMPID;
current.SYS_EMPIDGEO = e.GEODIRECTREPORT;
current.SYS_EMPIDFUN = e.FUNCDIRECTREPORT;
if (string.IsNullOrEmpty(eCurrent.IMAGE))
{
current.Image = "default.jpg" + "?" + (new Random()).Next(0, 100);
}
else
{
current.Image = eCurrent.IMAGE + "?" + (new Random()).Next(0, 100);
}
current.ColorScheme = "#ee587b";
parent.Items = new List <EmployeeDiagramViewModel>();
parent.Items.Add(current);
data.Add(parent);
return(data);
}
else
{
EmployeeDiagramViewModel current = new EmployeeDiagramViewModel();
EmployeeMaster eCurrent = employeeMaster.Where(emp => emp.SYS_EMPID == result[0].SYS_EMPID).FirstOrDefault();
if (eCurrent != null)
{
current.EMPNAME = eCurrent.EMPNAME;
current.EMPID = eCurrent.EMPID;
current.SYS_EMPID = eCurrent.SYS_EMPID;
current.SYS_EMPIDGEO = e.GEODIRECTREPORT;
current.SYS_EMPIDFUN = e.FUNCDIRECTREPORT;
if (string.IsNullOrEmpty(eCurrent.IMAGE))
{
current.Image = "default.jpg" + "?" + (new Random()).Next(0, 100);
}
else
{
current.Image = eCurrent.IMAGE + "?" + (new Random()).Next(0, 100);
}
current.ColorScheme = "#ee587b";
data.Add(current);
}
return(data);
}
}
else
{
EmployeeDiagramViewModel parent = new EmployeeDiagramViewModel();
EmployeeMaster eOldParent = employeeMaster.Where(emp => emp.SYS_EMPID == result[0].SYS_EMPID).FirstOrDefault();
parent.EMPNAME = eOldParent.EMPNAME;
parent.EMPID = eOldParent.EMPID;
parent.SYS_EMPID = eOldParent.SYS_EMPID;
parent.SYS_EMPIDGEO = result[0].SYS_EMPIDGEO;
parent.SYS_EMPIDFUN = result[0].SYS_EMPIDFUN;
if (string.IsNullOrEmpty(eOldParent.IMAGE))
{
parent.Image = "default.jpg" + "?" + (new Random()).Next(0, 100);
}
else
{
parent.Image = eOldParent.IMAGE + "?" + (new Random()).Next(0, 100);
}
parent.ColorScheme = "#1696d3";
EmployeeDiagramViewModel firtChild = Recursive(parent, e.SYS_EMPID, result);
EmployeeDiagramViewModel child = null;
if (firtChild != null && !string.IsNullOrEmpty(firtChild.SYS_EMPIDFUN))
{
child = new EmployeeDiagramViewModel();
EmployeeMaster echild = employeeMaster.Where(emp => emp.SYS_EMPID == firtChild.SYS_EMPIDFUN).FirstOrDefault();
child.EMPNAME = echild.EMPNAME;
child.EMPID = echild.EMPID;
child.SYS_EMPID = echild.SYS_EMPID;
//child.SYS_EMPIDGEO = ca.SYS_EMPIDGEO;
//child.SYS_EMPIDFUN = ca.SYS_EMPIDFUN;
if (string.IsNullOrEmpty(echild.IMAGE))
{
child.Image = "default.jpg" + "?" + (new Random()).Next(0, 100);
}
else
{
child.Image = echild.IMAGE + "?" + (new Random()).Next(0, 100);
}
child.ColorScheme = "#1696d3";
child.Items = new List <EmployeeDiagramViewModel>();
child.Items.Add(firtChild);
//node.Items = new List<EmployeeDiagramViewModel>();
//node.Items.Add(child);
}
if (child != null)
{
data.Add(child);
}
else
{
data.Add(firtChild);
}
}
return(data);
}
public static void UpdateEmployeeReport(EmployeeMasterReport employeeMaster)
{
EmployeeMasterReportAccess access = new EmployeeMasterReportAccess();
access.UpdateEmployeeReport(employeeMaster);
}
public static void InsertEmployeeReport(EmployeeMasterReport employeeMaster)
{
EmployeeMasterReportAccess access = new EmployeeMasterReportAccess();
access.InsertEmployeeReport(employeeMaster);
}
