public static List <GeoReport> getAllGeoReports() { List <GeoReport> geoReports = new List <GeoReport>(); GeoReportAccess access = new GeoReportAccess(); DataTable dtResult = access.GetGeoReports(); foreach (DataRow dtr in dtResult.Rows) { GeoReport item = new GeoReport { GEOREPORTCD = dtr["GEOREPORTCD"].ToString(), DEPTCODE = dtr["DEPTCODE"].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(), GEOREPORTLEVEL = dtr["GEOREPORTLEVEL"].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(), }; geoReports.Add(item); } return(geoReports); }
//public ActionResult getGeoReportByDept([DataSourceRequest]DataSourceRequest request, string deptcode) //{ // List<eGeoReportItem> result = new List<eGeoReportItem>(); // result = bGeoReport.getGeoReportByDepartment(deptcode); // return Json(result.ToDataSourceResult(request)); //} public ActionResult getGeoReportByDept([DataSourceRequest] DataSourceRequest request, string deptcode) { List <eGeoReportItem> result = new List <eGeoReportItem>(); result = bGeoReport.getGeoReportByDepartment(deptcode); DataTable dtResult = GeoReportAccess.getReportByDepartment(deptcode); string jsonString = JsonConvert.SerializeObject(dtResult); JsonResult jsResult = new JsonResult(); jsResult = Json(dtResult.ToDataSourceResult(request)); DataTable dtTest = (DataTable)JsonConvert.DeserializeObject(jsonString, (typeof(DataTable))); //return jsResult; //return jsonResult; /* * DataRow dtr = dtResult.Rows[0]; * eGeoReportItem item = new eGeoReportItem(); * foreach(DataColumn cl in dtr.Table.Columns) * { * PropertyInfo prop = item.GetType().GetProperty(cl.ColumnName); * FieldInfo fld = item.GetType().GetField(cl.ColumnName); * } */ return(Json(dtTest.ToDataSourceResult(request))); }
public ActionResult createGeoReporter([DataSourceRequest] DataSourceRequest request, eGeoReportItem _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.DEPTCODE = deptcode; string userId = Session["UserId"].ToString(); DataTable dtResult = GeoReportAccess.insertNewGeoReport(_reporter, userId); Session["geoorganizationreport_tree"] = bGeoReport.getTreeGeoDepts(); 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 <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); }
//Version 2.0 for improving performance. public static List <GeoDeptViewModel> getGeoDeptReportsRegistered() { List <GeoDeptViewModel> geoReports = new List <GeoDeptViewModel>(); GeoReportAccess access = new GeoReportAccess(); DataTable dtResult = access.GetTreeGeoReportsRegistered(); foreach (DataRow dtr in dtResult.Rows) { GeoDeptViewModel item = new GeoDeptViewModel { GEOREPORTCD = dtr["GEOREPORTCD"].ToString(), DEPTNAME = dtr["DEPTNAME"].ToString(), DEPTCODE = dtr["DEPTCODE"].ToString(), DEPTPARENT = dtr["DEPTPARENT"].ToString() }; geoReports.Add(item); } return(geoReports); }
public static List <EmployeeMaster> getUserInGeoReportByDeptCode(string deptCode, string empid) { List <EmployeeMaster> userList = new List <EmployeeMaster>(); GeoReportAccess access = new GeoReportAccess(); DataTable dtResult = access.GetUserGeoReports(deptCode, empid); foreach (DataRow dtr in dtResult.Rows) { EmployeeMaster item = new EmployeeMaster { SYS_EMPID = dtr["SYS_EMPID"].ToString(), EMPNAME = dtr["EMPNAME"].ToString(), //+ "," + dtr["SYS_EMPID"].ToString(), DEPTCODE = dtr["DEPTCODE"].ToString(), EMPID = dtr["EMPID"].ToString() }; userList.Add(item); } return(userList); }
public static List <OriganizationUsersViewModel> getUsersGeoDeptReports() { List <OriganizationUsersViewModel> geoReports = new List <OriganizationUsersViewModel>(); GeoReportAccess access = new GeoReportAccess(); DataTable dtResult = access.GetTreeGeoReports(); foreach (DataRow dtr in dtResult.Rows) { OriganizationUsersViewModel item = new OriganizationUsersViewModel { Display = dtr["DEPTNAME"].ToString(), Key = dtr["REPORTCD"].ToString(), Flag = 0, GEOREPORTCD = dtr["REPORTCD"].ToString(), SYS_EMPID = dtr["SYS_EMPID"].ToString(), DEPTNAME = dtr["DEPTNAME"].ToString(), DEPTCODE = dtr["DEPTCODE"].ToString(), DEPTPARENT = dtr["DEPTPARENT"].ToString() }; geoReports.Add(item); } return(geoReports); }
public static List <eGeoReportItem> getGeoReportByDepartment(string deptcode) { List <eGeoReportItem> lstResult = new List <eGeoReportItem>(); DataTable dtResult = GeoReportAccess.getReportByDepartment(deptcode); /* * foreach (DataRow dtr in dtResult.Rows) * { * eGeoReportItem item = new eGeoReportItem(); * item.GEOREPORTCD = dtr["GEOREPORTCD"].ToString(); * item.DEPTCODE = dtr["DEPTCODE"].ToString(); * item.SYS_EMPID = dtr["SYS_EMPID"].ToString(); * string strDate = dtr["APPLYDATE"].ToString(); * item.APPLYDATE = DateTime.ParseExact(strDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture); * item.ISACTIVE = dtr["ISACTIVE"].ToString(); * item.EMPNAME = dtr["EMPNAME"].ToString(); * lstResult.Add(item); * } */ foreach (DataRow dtr in dtResult.Rows) { eGeoReportItem item = new eGeoReportItem(); item.GEOREPORTCD = dtr["GEOREPORTCD"].ToString(); item.DEPTCODE = dtr["DEPTCODE"].ToString(); item.SYS_EMPID = dtr["SYS_EMPID"].ToString(); string strDate = dtr["APPLYDATE"].ToString(); item.APPLYDATE = DateTime.ParseExact(strDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture); int nActive = 0; int.TryParse(dtr["ISACTIVE"].ToString(), out nActive); item.ISACTIVE = Convert.ToBoolean(nActive); item.EMPNAME = dtr["EMPNAME"].ToString(); lstResult.Add(item); } return(lstResult); }
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); }