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 Delete(int PositionID) { // Ghi log TBL_POSITION oldPosition = DA_Position.Instance.GetById(PositionID); WriteLog("Position", "Edit", oldPosition, null); DA_Position.Instance.Delete(PositionID); return(RedirectToAction("Index")); }
public ActionResult Edit(int PositionID) { TBL_POSITION cus = DA_Position.Instance.GetById(PositionID); if (cus == null) { return(HttpNotFound()); } return(View(cus)); }
public ActionResult Create(TBL_POSITION item) { try { DA_Position.Instance.Insert(item); // Ghi log WriteLog("Position", "Create", null, item); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(TBL_POSITION item) { try { DA_Position.Instance.Update(item); // Ghi log TBL_POSITION oldPosition = DA_Position.Instance.GetById(item.PositionID); WriteLog("Position", "Edit", oldPosition, item); return(RedirectToAction("Index")); } catch { return(View()); } }