public string SaveDepartmentData(DeptViewModel objDeptView) { try { Department objEnDept = new Department(); if (objDeptView != null) { objEnDept.DeptName = objDeptView.DeptName; if (objDeptView.DeptId == 0) { empDb.Entry(objEnDept).State = EntityState.Added; } else { objEnDept.DeptId = objDeptView.DeptId; empDb.Entry(objEnDept).State = EntityState.Modified; empDb.Entry(objEnDept).Property(x => x.IsDelete).IsModified = false; } empDb.SaveChanges(); return("SavedSuccessfully"); } else { return("SomethingWrong"); } } catch (Exception ex) { throw ex; } }
//*************************************************** //부서 및 학과 업데이트 result 1 이상 성공 0 실패 //*************************************************** public int UpdateDept(DeptViewModel data, string admin) { string sql = "update SASU_DEPT set dept_name = @name, datasys1 = now(),datasys2 = 'U',datasys3=@admin where DEPT_id = @id"; int result = 0; try { connectionOpen(); cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("@name", data.DeptName); cmd.Parameters.AddWithValue("@admin", admin); cmd.Parameters.AddWithValue("@id", data.DeptId); Console.WriteLine(cmd.CommandText); result = cmd.ExecuteNonQuery(); Console.WriteLine("-------------성공"); } catch (Exception e) { Console.WriteLine(e.ToString()); Console.WriteLine("-------------a-a"); result = 0; } finally { cmd = null; conn.Close(); } return(result); }
//*************************************************** //관리자 정보 삭제 //*************************************************** #endregion #region 부서 및 학과 //*************************************************** //부서 및 학과 생성 result 1 이상 성공 0 실패 //*************************************************** public int InsertDept(DeptViewModel data, string admin) { string sql = "insert into SASU_DEPT values(@id,@name,now(),'A',@admin)"; int result = 0; try { connectionOpen(); cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("@id", data.DeptId); cmd.Parameters.AddWithValue("@name", data.DeptName); cmd.Parameters.AddWithValue("@admin", admin); result = cmd.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine(e.ToString()); result = 0; } finally { cmd = null; conn.Close(); } return(result); }
public static List <DeptViewModel> getActivedDepts() { List <DeptViewModel> dtDept = new List <DeptViewModel>(); DeptAccess access = new DeptAccess(); DataTable dtResult = access.GetActivedDepartments(); foreach (DataRow dtr in dtResult.Rows) { DeptViewModel item = new DeptViewModel { DEPTCODE = dtr["DEPTCODE"].ToString(), DEPTNAME = dtr["DEPTNAME"].ToString(), DEPTPARENT = dtr["DEPTPARENT"].ToString(), DEPTLEVEL = dtr["DEPTLEVEL"].ToString(), ORDERINDEX = dtr["ORDERINDEX"].ToString(), ISACTIVE = dtr["ISACTIVE"].ToString(), REMARK = dtr["REMARK"].ToString(), DEPTCODEOLD = dtr["DEPTCODEOLD"].ToString(), COMPCODE = dtr["COMPCODE"].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() }; dtDept.Add(item); } return(dtDept); }
/// <summary> /// 修改部门,若失败返回false /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Edit(DeptViewModel model) { bool result = false; var modelDept = model.Department; try { var dept = context.Departments.Find(modelDept.Id); if (modelDept.DeptCode != dept.DeptCode) { var depts = context.Departments.FirstOrDefault(dept => dept.DeptCode == modelDept.DeptCode); if (depts != null) { return(result); } dept.DeptCode = modelDept.DeptCode; } dept.Subordinate = modelDept.Subordinate.Split(',')[0].Trim(','); dept.DeptName = modelDept.DeptName; dept.Description = modelDept.Description; context.Departments.Update(dept); context.SaveChanges(); logger.LogWarning("修改部门信息{LogType}{CustomProperty}", "Operate", JsonConvert.SerializeObject(modelDept)); result = true; return(result); } catch (Exception ex) { logger.LogError("修改部门信息失败{LogType}{CustomProperty}", "Operate", JsonConvert.SerializeObject(modelDept)); throw ex; } }
public ActionResult Index() { var dvm = new DeptViewModel(); dvm.DNames = empService.GetNames(); return(View(dvm)); }
public ActionResult Edit(int id) { department dept = _deptRep.GetModelById(id); DeptViewModel viewModel = new DeptViewModel(); Mapper.Map(dept, viewModel); return(View(viewModel)); }
public IActionResult Create(DeptViewModel model) { if (ModelState.IsValid) { deptManager.Create(model); } return(RedirectToAction(nameof(Index))); }
public ActionResult EditSave(DeptViewModel deptViewModel) { ResultModel result = new ResultModel(); department dept = _deptRep.GetModelById(deptViewModel.Id); Mapper.Map(deptViewModel, dept); result.IsSuccess = _deptRep.Update(dept) > 0; return(Json(result)); }
public ActionResult AddNew(DeptViewModel deptViewModel) { ResultModel result = new ResultModel(); department dept = new department(); Mapper.Map(deptViewModel, dept); result.IsSuccess = _deptRep.Add(dept) > 0; return(Json(result)); }
public DeptViewModel Index(Department errorModel = null) { var model = new DeptViewModel(); model.Departments = Departments.ToList(); GetSubordinates(model); logger.LogWarning("读取部门信息{LogType}", "Operate"); return(model); }
/// <summary> /// 赋值VM中部门list /// </summary> /// <param name="model">部门的ViewModel</param> private static void GetSubordinates(DeptViewModel model) { var deptcodes = model.Departments.Select(dept => new { dept.DeptCode, dept.DeptName }); model.Subordinates.Add("0,顶层部门"); foreach (var deptcode in deptcodes) { model.Subordinates.Add($"{deptcode.DeptCode},{deptcode.DeptName}"); } }
public IActionResult Edit(DeptViewModel model) { var result = deptManager.Edit(model); if (!result) { return(RedirectToAction(nameof(Index), model.Department)); } return(RedirectToAction(nameof(Index))); }
public IActionResult Index() { var dEntity = _DepartmentRepo.GetAll(); var dvm = new DeptViewModel { Dept = dEntity }; ViewBag.Dept = dvm; return(View()); }
public void EditShouldBe_OK() { var model = new DeptViewModel(); model.Department.Id = 20; model.Department.DeptCode = "112"; model.Department.DeptName = "测试部"; model.Department.Subordinate = "404,技术部"; model.Department.Description = "测试部门"; bool result = deptManager.Edit(model); Assert.True(result); }
public async Task <IActionResult> Index() { ViewData["Title"] = $"{_appSettings.Value.AppTitle}-{Subtitle.DepartmentList}"; var NoOfRowsSelItemLst = ExternalUtility.GetNoOfSelectItemList(_appSettings.Value.NoOfRowsOptions, _appSettings.Value.DefaultOptionRowSel); var deptVM = new DeptViewModel() { Department1 = "", SelState = _appSettings.Value.DefaultSelState, States = await _stateSerice.GetStateSelectList(), NoOfRows = NoOfRowsSelItemLst }; return(View(deptVM)); }
protected override void OnStartup(StartupEventArgs e) { base.OnStartup(e); Window win = new MainWindow(); Window win2 = new DetailsWindow(); DeptModel DM = new DeptModel(); DeptViewModel dmw = new DeptViewModel(DM); win.DataContext = dmw; win2.DataContext = dmw; win.Show(); win2.Show(); }
public DataTable InsertDepartments(DeptViewModel deptViewModel) { OracleParameter[] param = new OracleParameter[9]; param[0] = new OracleParameter("pDEPTCODE", (object)deptViewModel.DEPTCODE ?? DBNull.Value); param[1] = new OracleParameter("pDEPTNAME", (object)deptViewModel.DEPTNAME ?? DBNull.Value); param[2] = new OracleParameter("pDEPTPARENT", (object)deptViewModel.DEPTPARENT ?? DBNull.Value); param[3] = new OracleParameter("pDEPTLEVEL", (object)deptViewModel.DEPTLEVEL ?? DBNull.Value); param[4] = new OracleParameter("pORDERINDEX", (object)deptViewModel.ORDERINDEX ?? DBNull.Value); param[5] = new OracleParameter("pISACTIVE", (object)deptViewModel.ISACTIVE ?? DBNull.Value); param[6] = new OracleParameter("pREMARK", (object)deptViewModel.REMARK ?? DBNull.Value); param[7] = new OracleParameter("pCREATE_UID", (object)deptViewModel.CREATE_UID ?? DBNull.Value); param[8] = new OracleParameter("pUPDATE_UID", (object)deptViewModel.UPDATE_UID ?? DBNull.Value); return(DBHelper.getDataTable_SP("HR_DEPARTMENT.SP_INSERT_NEW_T_HR_DEPT", param)); }
public ActionResult Dept() { var vm = new DeptViewModel(); vm.Department = new DeptRepository().GetAll(); vm.DeptList = new List <SelectListItem>(); vm.Department.ForEach(x => vm.DeptList.Add(new SelectListItem() { Text = x.Name, Value = x.Id.ToString() })); var m = new DeptRepository().GetAllDeptWithSubDept(); return(View(vm)); }
public async Task <IActionResult> QueryFAQ() { QueryFaqExtdViewModel faqVM = new QueryFaqExtdViewModel(); faqVM.FAQVMList = null; List <DeptViewModel> depts = await api.PopulateDeptDropDown(); DeptViewModel dvm = new DeptViewModel(); dvm.DeptId = 0; dvm.DeptName = "Select Department"; depts.Insert(0, dvm); ViewData["DeptId"] = new SelectList(depts, "DeptId", "DeptName", dvm.DeptName); return(View(faqVM)); }
public static DeptViewModel Recursive(DeptViewModel dept, List <DeptViewModel> deptList) { if (deptList.Where(c => c.DEPTPARENT == dept.DEPTCODE).Count() < 1) { return(dept); } else { List <DeptViewModel> newList = new List <DeptViewModel>(); foreach (DeptViewModel ca in deptList.Where(c => c.DEPTPARENT == dept.DEPTCODE)) { newList.Add(Recursive(ca, deptList)); } dept.DeptViewModels = newList; return(dept); } }
public IHttpActionResult Put(DeptViewModel dept) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (var ctx = new EMSEntities()) { try { var existingDept = ctx.DEPTs.Where(s => s.TRNNO == dept.TRNNO) .FirstOrDefault <DEPT>(); if (existingDept != null) { existingDept.ABR = dept.ABR; existingDept.DESCRIP = dept.DESCRIP; existingDept.STATUS = dept.STATUS; ctx.SaveChanges(); } else { return(NotFound()); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } return(Ok()); }
//********************************************* // 체크 버튼 클릭 //********************************************* private void CheckButton_Click(object sender, RoutedEventArgs e) { DeptViewModel Data = (DeptViewModel)DeptInfo.DataContext; //입력 if (Btn_state == 0) { DeptViewModel Temp = new DeptViewModel { DeptCode = "A", DeptId = Data.DeptId, DeptName = Data.DeptName, DeptCreateAt = Data.DeptCreateAt }; myViewModel.Insert(myViewModel.Count, Temp); sql.InsertDept(Temp, AdminId); } //수정 if (Btn_state == 1) { //데이터가 변경된 경우 Console.WriteLine("----------------------"); Console.WriteLine(Data.DeptId); Console.WriteLine(Data.DeptName); if (selectArray[1] != Data.DeptName) { //입력 구분값 변경 if (Data.DeptCode == "S") { Data.DeptCode = "U"; } Console.WriteLine(sql.UpdateDept(Data, AdminId)); } Console.WriteLine("----------------------"); } if (Btn_state == 2) { sql.DeleteDept(Data); } //바인딩 해제 DefaultState(); sql.SelectDept(myViewModel, string.Empty); selectArray = new string[2]; resetText(); }
public void Create(DeptViewModel model) { var dept = model.Department; try { dept.Subordinate = dept.Subordinate.Split(',')[0].Trim(','); dept.DeptCode = model.ConfirmDeptCode; context.Departments.Add(dept); context.SaveChanges(); logger.LogWarning("添加部门{LogType}{CustomProperty}", "Operate", JsonConvert.SerializeObject(dept)); } catch (Exception ex) { logger.LogWarning("添加部门失败{LogType}{CustomProperty}", "Operate", JsonConvert.SerializeObject(dept)); throw ex; } }
public HttpResponseMessage SaveDeptData(DeptViewModel objDeptView) { try { if (objDeptView != null) { return(Request.CreateErrorResponse(HttpStatusCode.OK, _departmentService.SaveDepartmentData(objDeptView))); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Saved")); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public DataTable UpdateDepartments(DeptViewModel deptViewModel) { OracleParameter[] param = new OracleParameter[10]; param[0] = new OracleParameter("pDEPTCODE", (object)deptViewModel.DEPTCODE ?? DBNull.Value); param[1] = new OracleParameter("pDEPTNAME", (object)deptViewModel.DEPTNAME ?? DBNull.Value); param[2] = new OracleParameter("pDEPTPARENT", (object)deptViewModel.DEPTPARENT ?? DBNull.Value); param[3] = new OracleParameter("pDEPTLEVEL", (object)deptViewModel.DEPTLEVEL ?? DBNull.Value); param[4] = new OracleParameter("pORDERINDEX", (object)deptViewModel.ORDERINDEX ?? DBNull.Value); param[5] = new OracleParameter("pISACTIVE", (object)deptViewModel.ISACTIVE ?? DBNull.Value); param[6] = new OracleParameter("pREMARK", (object)deptViewModel.REMARK ?? DBNull.Value); param[7] = new OracleParameter("pDEPTCODEOLD", (object)deptViewModel.DEPTCODEOLD ?? DBNull.Value); //param[8] = new OracleParameter("pCOMPCODE", (object)deptViewModel.COMPCODE ?? DBNull.Value); param[8] = new OracleParameter("pUPDATE_UID", (object)deptViewModel.UPDATE_UID ?? DBNull.Value); param[9] = new OracleParameter("T_TABLE", OracleDbType.RefCursor) { Direction = ParameterDirection.Output }; return(DBHelper.getDataTable_SP("HR_DEPARTMENT.SP_UPDATE_T_HR_DEPT", param)); }
public IActionResult OnGet(int? id) { DepartmentVM = new DeptViewModel() { Faculty = _facultyRepo.GetFacultyListOfDropDown(), Department = new Department() }; if (id != null) { var deptFromDb = _deptRepo.GetFisrtOrDefault(m => m.Id == id); if (deptFromDb == null) { return NotFound(); } DepartmentVM.Department = deptFromDb; } return Page(); }
public async Task <JsonResult> UpdateDepartment(DeptViewModel deptViewModel) { try { if (!ModelState.IsValid) { string message = "Please enter required data."; TempData.Put("notify", new StatusResult() { Status = StatusText.Error.ToString(), StatusDetail = message }); ModelState.AddModelError("", message); return(Json(new { datas = "", tcount = 0, rcount = 0, status = "Error", message = "Error" })); } else { var dept = new Department() { Id = 0, DeptBelongsTo = deptViewModel.SelState, Deptartment = deptViewModel.Department1, CreatedBy = _session.GetString("UserId"), CreationDate = DateTime.Now }; var result = await _deptService.SaveNewDepartment(dept); if (result.Status == StatusText.Successful.ToString()) { return(Json(new { datas = "", tcount = 0, rcount = 0, status = "Successful", message = result.StatusDetail })); } else { return(Json(new { datas = "", tcount = 0, rcount = 0, status = "Error", message = result.StatusDetail })); } } } catch (Exception ex) { Log.Logger.Error(ex.Message); return(Json(new { datas = "", status = "Error", error = ex.Message })); } }
public IHttpActionResult PostNewBp(DeptViewModel dept) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } using (var ctx = new EMSEntities()) { int totalConunt = ctx.DEPTs.Count <DEPT>(); dept.TRNNO = totalConunt + 1; ctx.DEPTs.Add(new DEPT() { TRNNO = (dept.TRNNO), ABR = dept.ABR, DESCRIP = dept.DESCRIP, STATUS = dept.STATUS }); try { ctx.SaveChanges(); } catch (DbEntityValidationException ex) { // Retrieve the error messages as a list of strings. var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); // Throw a new DbEntityValidationException with the improved exception message. throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); } } return(Ok()); }
public ActionResult UpdateGeoOrganization(string deptCode, string deptParent, string deptName, bool active, string orderIndex) { DeptViewModel geoOrganization = new DeptViewModel(); geoOrganization.DEPTCODE = deptCode; geoOrganization.DEPTPARENT = deptParent; geoOrganization.DEPTNAME = deptName; geoOrganization.DEPTLEVEL = deptCode.Substring(0, 1); if (active) { geoOrganization.ISACTIVE = "1"; } else { geoOrganization.ISACTIVE = "0"; } geoOrganization.ORDERINDEX = orderIndex; bDept.UpdateGeoOrganization(geoOrganization); Session["geoorganization_tree"] = bDept.getDepts(); Session["geoorganizationreport_tree"] = bGeoReport.getTreeGeoDepts(); return(PartialView("GeoOrganizationInforPartial")); }