public IList <EmployeeExt> GetEmployeeExt() { List <EmployeeExt> lst = new List <EmployeeExt>(); using (var context = (HRM_ROHTOEntities)Activator.CreateInstance(typeof(HRM_ROHTOEntities), _connectionStr)) { foreach (var item in context.TBL_EMPLOYEE) { TBL_DEPARTMENT department = context.TBL_DEPARTMENT.FirstOrDefault(x => x.DepartmentID == item.DepartmentID); TBL_POSITION position = context.TBL_POSITION.FirstOrDefault(x => x.PositionID == item.PositionID1); EmployeeExt ext = new EmployeeExt { EmployeeID = item.EmployeeID, EmployeeCode = item.EmployeeCode, FullName = item.FullName, ContractNo = item.ContractNo, CardNumber = item.CardNumber, DepartmentName = department != null ? department.DepartmentName : "", PositionName = position != null ? position.PositionName : "", IsLeaveOut = item.IsLeaveOut == true ? "Nghỉ việc" : "Đang làm" }; lst.Add(ext); } } lst.OrderBy(n => n.DepartmentName).ThenBy(n => n.EmployeeCode); return(lst); }
public ActionResult Edit(TBL_DEPARTMENT Item) { try { RepairToShow(Item.DepartmentID); if (Item.ParentID == 0) { Item.ParentID = null; Item.LevelID = 1; } else { int parentLevelID = DA_Department.Instance.GetLevelIDOfParent(Item.ParentID); Item.LevelID = parentLevelID + 1; } DA_Department.Instance.Update(Item); //Ghi log TBL_DEPARTMENT oldDepartment = DA_Department.Instance.GetById(Item.DepartmentID); WriteLog("Department", "Edit", oldDepartment, Item); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(TBL_DEPARTMENT Item) { try { RepairToShow(); if (Item.ParentID == 0) { Item.ParentID = null; Item.LevelID = 1; } else { int parentLevelID = DA_Department.Instance.GetLevelIDOfParent(Item.ParentID); Item.LevelID = parentLevelID + 1; } DA_Department.Instance.Insert(Item); //Ghi log WriteLog("Department", "Create", null, Item); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(string id) { int _id = int.Parse(id); TBL_DEPARTMENT obj = DA_Department.Instance.GetById(_id); if (obj == null) { return(HttpNotFound()); } RepairToShow(); return(View(obj)); }
//public int GetLevelID(long? ParentID) //{ // int lv = 0; // if (ParentID != null && ParentID > 0) // { // lv = DA_Department.Instance.GetLevelIDOfDepartment((long)ParentID); // } // return (lv + 1); //} public ActionResult Delete(string id) { int _id = int.Parse(id); DA_Department.Instance.DeleteAdvance(_id); //Ghi log TBL_DEPARTMENT oldDepartment = DA_Department.Instance.GetById(id); WriteLog("Department", "Delete", oldDepartment, null); return(RedirectToAction("Index")); }
public JsonResult AddOrUpdateEntity(TBL_DEPARTMENT item, bool isEdit) { if (!string.IsNullOrWhiteSpace(item.DepartmentName) && ((isEdit && item.DepartmentID > 0) || !isEdit)) { try { int result = isEdit ? DA_Department.Instance.Update(item) : DA_Department.Instance.Insert(item); return(Json(result > 0 ? 1 : 0)); } catch (Exception ex) { } } return(Json(0)); }
public ActionResult Create() { TBL_DEPARTMENT Item = new TBL_DEPARTMENT(); if (Request.QueryString["p"] != null) { int parent = 0; int.TryParse(Request.QueryString["p"].ToString(), out parent); Item.ParentID = parent; } RepairToShow(); return(View(Item)); }
public HttpResponseMessage DepartmentAdd(DepartmentModel _DepartmentModel) { try { bool conn = false; conn = db.Database.Exists(); if (!conn) { ConnectionTools.changeToLocalDB(db); conn = db.Database.Exists(); } if (conn) { if (_DepartmentModel.DEPARTMENT_ID == null || _DepartmentModel.DEPARTMENT_ID == 0) { TBL_DEPARTMENT gd = new TBL_DEPARTMENT(); gd.COMPANY_ID = _DepartmentModel.COMPANY_ID; gd.DEPARTMENT_NAME = _DepartmentModel.DEPARTMENT_NAME; gd.SORT_INDEX = _DepartmentModel.SORT_INDEX; gd.IS_DELETE = false; gd.STATUS = _DepartmentModel.STATUS; gd.CREATED_BY = _DepartmentModel.CREATED_BY; gd.CREATED_DATE = System.DateTime.Now; db.TBL_DEPARTMENT.Add(gd); db.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.OK, "ok")); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed)); } } catch (Exception ex) { throw; } finally { ConnectionTools.ChangeToRemoteDB(db); } }
public JsonResult delete() { try { //jQuery DataTables Param string id = (Request.Form.GetValues("id").FirstOrDefault() == null ? "" : Request.Form.GetValues("id").FirstOrDefault().ToString()); if (id.All(Char.IsDigit)) { TBL_DEPARTMENT department = DA_Department.Instance.GetById(Convert.ToInt32(id)); return(Json(department == null ? 0 : DA_Department.Instance.Delete(department))); } return(Json(0)); } catch (Exception ex) { return(Json(0)); } }