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