protected void btnSave_Click(object sender, EventArgs e) { try { InitBUS(); string message = checkInput(); if (message == "") { DepartmentDTO dpDTO = new DepartmentDTO(); dpDTO.Name = this.txtDepartment.Text; dpDTO.Description = this.txtDescription.Text; dpDTO.UserId = getUserLogin().UserId; // Mac dinh la 1, khong quan ly dpDTO.UserType = int.Parse(this.dropTypeUser.SelectedItem.Value.ToString()); ConnectionData.OpenMyConnection(); dpBUS.tblDepartment_insert(dpDTO); Visible(false); pnSuccess.Visible = true; lblSuccess.Text = "Bạn đã thêm thành công!"; LoadDepartmentList(); ConnectionData.CloseMyConnection(); } else { pnSuccess.Visible = false; pnError.Visible = true; lblError.Text = message; } } catch (Exception ex) { logs.Error(userLogin.Username + "-Client - btnSave_Click", ex); } }
public static Department MapFromDTO(DepartmentDTO dto) { Department Department = new Department(); Department.DepartmentID = dto.DepartmentID; Department.DepartmentName = dto.DepartmentName; Department.ParentDepartment = dto.ParentDepartmentId == null ? null : ManagerFactory.DepartmentManager.GetDepartment(dto.ParentDepartmentId); return Department; }
public static DepartmentDTO MapToDTO(Department model) { DepartmentDTO dto = new DepartmentDTO(); dto.DepartmentID = model.DepartmentID; dto.DepartmentName = model.DepartmentName; dto.ParentDepartmentId = model.ParentDepartment ==null?null:model.ParentDepartment.DepartmentID; dto.ParentDepartmentName = model.ParentDepartment==null?null:model.ParentDepartment.DepartmentName; return dto; }
public void tblDepartment_insert(DepartmentDTO dt) { string sql = "INSERT INTO tblDepartment(Name, Description, Role) "+ "VALUES(@Name, @Description, @Role)"; SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = dt.Name; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = dt.Description; cmd.Parameters.Add("@Role", SqlDbType.Int).Value = dt.Role; cmd.ExecuteNonQuery(); cmd.Dispose(); }
public void tblDepartment_Update(DepartmentDTO dt) { string sql = "UPDATE tblDepartment SET "+ "Name = @Name, " + "Description = @Description, "+ "Role = @Role WHERE ID = @ID"; SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@ID", SqlDbType.Int).Value = dt.ID; cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = dt.Name; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = dt.Description; cmd.Parameters.Add("@Role", SqlDbType.Int).Value = dt.Role; cmd.ExecuteNonQuery(); cmd.Dispose(); }
public ActionResult DepartMentEdit(string Id) { var departmentDomain = CommonSrv.LoadObjectById(typeof(Department), Id) as Gecko.Security.Domain.Department; DepartmentDTO departmentDTO = new DepartmentDTO(); departmentDTO.Id = departmentDomain.Id; departmentDTO.Name = departmentDomain.Name; departmentDTO.OrderId = departmentDomain.OrderId; departmentDTO.Phone = departmentDomain.Phone; departmentDTO.ExtNumber = departmentDomain.ExtNumber; departmentDTO.Fax = departmentDomain.Fax; departmentDTO.Remark = departmentDomain.Remark; departmentDTO.ParentDepartmentId = departmentDomain.ParentDepartment != null ? departmentDomain.ParentDepartment.Id : null; return(View("DepartMentInfo", departmentDTO)); }
public async Task <IActionResult> Edit(DepartmentDTO departmentDTO) { if (ModelState.IsValid) { var deparment = _mapper.Map <Department>(departmentDTO); await _departmentService.Update(deparment); return(RedirectToAction(nameof(Index))); } var data = await _instructorService.GetAll(); ViewBag.Instructors = data.Select(x => _mapper.Map <InstructorDTO>(x)).ToList(); return(View(departmentDTO)); }
/// <summary> /// 更新部门。 /// </summary> /// <param name="dto">待更新部门的信息。</param> public static void UpdateDepartment(DepartmentDTO dto) { Db.SessionFactory.EvictQueries("Department"); Department d = Db.Session.Load(typeof(Department), dto.Id) as Department; d.Name = dto.Name; d.Phone = dto.Phone; d.ExtNumber = dto.ExtNumber; d.Fax = dto.Fax; d.Remark = dto.Remark; d.OrderId = dto.OrderId; Db.TransUpdate(d); }
public async Task <IHttpActionResult> Update([FromBody] DepartmentDTO DepartmentDto) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var entity = await DepartmentService.FindOneAsync(DepartmentDto.Id); entity = DepartmentDto.ToEntity(entity); entity.LastUserId = User.Identity.GetUserId(); entity.LastTime = DateTime.Now; await DepartmentService.UpdateAsync(entity); return(Ok(entity.ToModel())); }
public IEnumerable <DepartmentDTO> GetDeptPlanOfUser() { List <DepartmentDTO> result = new List <DepartmentDTO>(); SessionManager.DoWork(session => { Staff staff = ControllerHelpers.GetCurrentStaff(session); if (staff.Department != null) { DepartmentDTO pd = staff.Department.Map <DepartmentDTO>(); result.Add(pd); } }); return(result); }
public async Task <XElement> GetDepartments(string sessionKey, long requestId) { #region Заглушка var hubConn = new HubConnection(Settings.Default.ResponseHubUrl); var hubProxy = hubConn.CreateHubProxy("ResponseHub"); await hubConn.Start(); var result = DepartmentDTO.ArrayToXElement(new DepartmentDTO[] { new DepartmentDTO() { Id = Guid.NewGuid(), Name = "ОП З-1", }, new DepartmentDTO() { Id = Guid.NewGuid(), Name = "ОП З-2", }, new DepartmentDTO() { Id = Guid.NewGuid(), Name = "Служба клиентского сервиса" }, new DepartmentDTO() { Id = Guid.NewGuid(), Name = "Закупки" }, new DepartmentDTO() { Id = Guid.NewGuid(), Name = "Бухгалтерия" }, new DepartmentDTO() { Id = Guid.NewGuid(), Name = "Юридический отдел" } }); result.Add(new XElement("rc", 0)); result.Add(new XElement("msg", "")); hubProxy.Invoke("OperationCallback", sessionKey, requestId, result); return(zapad.Model.API.ReturnCodes.BuildRcAnswer(0, "Успешно")); #endregion }
public IActionResult GetDepartments(Guid id) { List <DepartmentDTO> departmentsDTO = new List <DepartmentDTO>(); IEnumerable <Unit> departments = db.Units.Where(a => a.MailingGroupId == id).Where(t => t.Deleted == false); foreach (var d in departments) { DepartmentDTO departmentDTO = new DepartmentDTO(); departmentDTO.Id = d.Id; departmentDTO.FullTitle = GetFullOrgName(d.UnitEmployeeDbId); departmentDTO.UnitEmployeeDbId = d.UnitEmployeeDbId; departmentsDTO.Add(departmentDTO); } return(new ObjectResult(departmentsDTO)); }
public DepartmentDTO GetById(int departmentId) { try { DepartmentDTO Department = new DepartmentDTO(); Mapper.Map <Department, DepartmentDTO>(_repository .Query() .SelectQueryable() .Where(c => c.Id == departmentId).FirstOrDefault(), Department); return(Department); } catch (Exception ex) { throw ex; } }
public List <DepartmentDTO> getDataList() { string query = ("SELECT * FROM DEPARTMENT"); DataTable data = DataProvider.Instance.ExecuteQuery(query); List <DepartmentDTO> deptListResult = new List <DepartmentDTO>(); foreach (DataRow item in data.Rows) { DepartmentDTO deptDTO = new DepartmentDTO(item); deptListResult.Add(deptDTO); } return(deptListResult); }
public ActionResult DepartmentCreateClose(DepartmentDTO data) { try { DepartmentDTO resDeptDTO = new DepartmentDTO(); resDeptDTO = _departmentServices.InsertDepartment(data); ViewBag.Success = "New Deparment added"; ModelState.Clear(); return(View("Departments", _departmentServices.GetDepartmentlist())); } catch (Exception Ex) { ViewBag.error = Ex.Message; return(View(data)); } }
public async Task <IHttpActionResult> Post(DepartmentDTO departmentDTO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { var department = mapper.Map <Department>(departmentDTO); department = await departmentService.Insert(department); return(Ok(department)); } catch (Exception ex) { return(InternalServerError(ex)); } }
public IActionResult Details(int id) { var foundDepartments = _db.Departments.Find(id); if (foundDepartments == null) { return(NotFound()); } //map and return DTO DepartmentDTO departmentDTO = new DepartmentDTO(); departmentDTO.Description = foundDepartments.Description; return(Ok(departmentDTO)); }
public static Department Convert(this DepartmentDTO departmentDto) { return(new Department { ItemId = departmentDto.ItemId, IsDeleted = departmentDto.IsDeleted, Updated = departmentDto.Updated, CorrectorId = departmentDto.CorrectorId, ShortName = departmentDto.Name, FullName = departmentDto.FullName, Address = departmentDto.Address, Phone = departmentDto.Phone, Fax = departmentDto.Fax, Email = departmentDto.Email, Website = departmentDto.Website }); }
public async Task PostDepartment([FromBody] DepartmentDTO departmentDTO) { try { var dept = new Department { Name = departmentDTO.Name }; await _unitOfWork.Department.AddDepartmentAsync(dept); _unitOfWork.Department.Save(); } catch (Exception ex) { throw ex; } }
public DepartmentDTO CreateDepartment(DepartmentDTO department) { var newObj = new Departments { DepartmentId = department.DepartmentID, Name = department.Name, Budget = department.Budget, CreatedDate = department.CreatedDate }; Database.Departments.Add(newObj); Database.SaveChanges(); department.DepartmentID = newObj.DepartmentId; return(department); }
public ActionResult Create(DepartmentDTO dept) { if (ModelState.IsValid) { dept.CreatedBy = dept.ModifiedBy = this.User.Id; dept = this._IDepartmentService.Create(dept); var account = new AccountDTO(); account.CreatedBy = account.ModifiedBy = this.User.Id; account.Balance = 0m; account.DepartmentId = dept.Id; this._IAccountService.Create(account); return(RedirectToAction("Index")); } this.DataBind(); return(View()); }
// GET: Departments/Edit/5 public ActionResult Edit(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DepartmentDTO department = _dataAccess.GetDepartment(id.GetValueOrDefault()); if (department == null) { return(HttpNotFound()); } var model = Mapper.Map <DepartmentViewModel>(department); return(View(model)); }
public void _GetChildOfTree(ref DepartmentDTO node, List <DepartmentDTO> rawList) { long id = node.Id; var lstChild = rawList.Where(x => x.ParentId == id).ToList(); if (lstChild.Count > 0) { node.Child = new List <DepartmentDTO>(); node.Child.AddRange(lstChild); for (int i = 0; i < lstChild.Count; i++) { var item = node.Child[i]; _GetChildOfTree(ref item, rawList); node.Child[i] = item; } } }
public ActionResult Edit(int id, DepartmentViewModel departmentViewModel) { if (ModelState.IsValid) { var facultyId = _facultyManager.GetAll().Where(t => t.NameOfFaculty.Equals(departmentViewModel.Faculty)).ToList() .First().Id; var department = new DepartmentDTO { Id = departmentViewModel.Id, NameOfDepartment = departmentViewModel.NameOfDepartment, FacultyId = facultyId }; _departmentManager.Update(department); return(RedirectToAction(nameof(Index))); } return(View()); }
public ActionResult AddDepartment(DepartmentViewModel model) { var counter = departmentService.GetDepartments().Last(); var counterId = counter.DepartmentId + 1; DepartmentDTO newDep = new DepartmentDTO { DepartmentId = counterId, Name = model.Name, Description = model.Description }; departmentService.AddDepartment(newDep); return(RedirectToAction("Index", "Department")); }
public List <DepartmentDTO> getDepartment() { string sql = "SELECT * FROM BOPHAN"; DataTable data = ConnectionDB.getData(sql); List <DepartmentDTO> list = new List <DepartmentDTO>(); for (int i = 0; i < data.Rows.Count; i++) { DepartmentDTO department = new DepartmentDTO(); department.iMaBP = data.Rows[i]["MaBP"].ToString(); department.iTenBP = data.Rows[i]["TenBP"].ToString(); department.iGhiChu = data.Rows[i]["GhiChu"].ToString(); department.iActive = bool.Parse(data.Rows[i]["Active"].ToString()); list.Add(department); } return(list); }
public string GetChildren(Guid?partntId, List <DepartmentDTO> departmentList) { var department = new DepartmentDTO(); //var partnt = departmentList.Find(item => !item.ParentId.HasValue); var htmlString = new StringBuilder(); var partntItem = departmentList.Find(model => model.Id == partntId); if (partntItem != null) { htmlString.Append("<li>"); htmlString.Append(string.Format("<a id='{1}' >{0}</a>", partntItem.Name, partntItem.Id)); htmlString.Append("</li>"); } this.GetItems(partntId, departmentList, htmlString); return(htmlString.ToString()); }
//string connectionString = ConfigurationManager.ConnectionStrings["ConnectionTA"].ToString(); #endregion #region Department /// <summary> /// /// </summary> /// <param name="charge"></param> /// <param name="operation"></param> /// <returns></returns> public MessageDTO SaveDepartment(DepartmentDTO department, string operation) { DataTable dataTable = new DataTable(); IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString); MessageDTO message = new MessageDTO(); try { connector.BeginTransaction(); //Todos los registros object[] parameters = new object[] { department.DepartmentId, department.Company.CompanyId, department.SpendingCenter.SpendingCenterId, department.User.UserId, department.DepartmentDescription, department.DepartmentStatus, operation }; //connector.ExecuteNonQuery(CommandType.StoredProcedure, "SaveDepartment", parameters); dataTable = connector.ExecuteDataTable(CommandType.StoredProcedure, "SaveDepartment", parameters); foreach (DataRow row in dataTable.Rows) { message.ErrorCode = row["ERROR_NUMBER"].ToString(); message.ErrorMessage = row["ERROR_DESCRIPTION"].ToString(); } if (message.ErrorCode == "0") { connector.Commit(); } else { connector.RollBack(); } } catch (Exception exception) { message.ErrorCode = "-1"; message.ErrorMessage = exception.ToString(); connector.RollBack(); } finally { connector.Dispose(); } return(message); }
public DepartmentDTO InsertOrUpdateDepartment(DepartmentDTO departmentDTO) { if (departmentDTO.Id > 0) ///Update Department { ///Get Department entity from database by id var _Department = dbcontext.Departments.Find(departmentDTO.Id); if (_Department != null) ///if Exist { try { ///Mapp new values from DepartmentDTO to Department var mapped_Department = mapper.Map <DepartmentDTO, Department>(departmentDTO, _Department); dbcontext.Departments.Update(mapped_Department); dbcontext.SaveChanges(); // return true; return(departmentDTO); } catch (Exception x) { return(null); } } else { return(null); } } else { try { var mappedDepartment = mapper.Map <Department>(departmentDTO); dbcontext.Departments.Add(mappedDepartment); dbcontext.SaveChanges(); // return inserted object ; return(departmentDTO); } catch (Exception e) { return(null); //return false; } } }
public List <DepartmentDTO> GetDepartment() { using (UnitOfWork uow = new UnitOfWork()) { var departments = uow.Departments.List(); List <DepartmentDTO> departmentList = new List <DepartmentDTO>(); foreach (var item in departments) { DepartmentDTO department = Mapper.Map <Department, DepartmentDTO>(item); departmentList.Add(department); } return(departmentList); } }
public DepartmentDTO Add(DepartmentDTO itemDto) { var model = itemDto.ToModel(); model.Id = IdentityGenerator.NewSequentialGuid(); model.Created = DateTime.UtcNow; // 数据验证 this.ValidateModel(model); _Repository.Add(model); this.OperationLog(HrMessagesResources.Add_Department, model.ToDto(), null); //commit the unit of work _Repository.UnitOfWork.Commit(); return(model.ToDto()); }
public DepartmentDTO GetDepartmentByDptName(string department_name)//按科室名查找 { using (MyContext ctx = new MyContext()) { var s = ctx.Departments.SingleOrDefault(e => e.dept_name == department_name); if (s == null) { return(null); } DepartmentDTO dto = new DepartmentDTO(); dto.dept_name = s.dept_name; dto.dir_name = s.dir_name; dto.dir_ID = s.dir_ID; dto.room_ID = s.room_ID; dto.people_num = s.people_num; return(dto); } }
public async Task <ActionResult <DepartmentDTO> > GetDepartment(int id) { DepartmentDTO departmentDTO = new DepartmentDTO(); var department = await _context.Departments.FindAsync(id); if (department == null) { return(NotFound()); } departmentDTO.Id = department.Id; departmentDTO.DeptCode = department.DeptCode; departmentDTO.DeptName = department.DeptName; departmentDTO.CostCentreId = department.CostCentreId; return(departmentDTO); }
public DepartmentDTO Put(DepartmentDTO obj) { SessionManager.DoWork(session => { Staff st = session.Query <Staff>().SingleOrDefault(a => a.Id == obj.StaffId); StaffRole str = st.StaffRoles.SingleOrDefault(a => a.Id == obj.StaffRoleId); if (str != null) { st.StaffRoles.Remove(str); } st.StaffRoles.Add(new StaffRole() { Id = obj.StaffRoleId }); session.SaveOrUpdate(st); }); return(obj); }
public async Task <DepartmentDTO> GetDepartment(int id) { try { var deptFromDb = await _unitOfWork.Department.GetDepartmentAsync(id); var dept = new DepartmentDTO { Name = deptFromDb.Name, Id = deptFromDb.Id }; return(dept); } catch (Exception ex) { throw ex; } }
public void tblDepartment_Update(DepartmentDTO dt) { dpmDAO.tblDepartment_Update(dt); }
public void tblDepartment_insert(DepartmentDTO dt) { dpmDAO.tblDepartment_insert(dt); }
public void tblDepartment_insert(DepartmentDTO dt) { //string sql = "INSERT INTO tblDepartment(Name, Description, UserId,UserType) " + // "VALUES(@Name, @Description, @UserId,@UserType)"; //SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection); //cmd.CommandType = CommandType.Text; //cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = dt.Name; //cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = dt.Description; //cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = dt.UserId; //cmd.Parameters.Add("@UserType", SqlDbType.Int).Value = dt.UserType; //cmd.ExecuteNonQuery(); //cmd.Dispose(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "pro_add_tblDeparment"; cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = dt.Name; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = dt.Description; cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = dt.UserId; cmd.Parameters.Add("@UserType", SqlDbType.Int).Value = dt.UserType; cmd.Connection = ConnectionData._MyConnection; try { cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { //ConnectionData._MyConnection.Dispose(); } }