// 社員追加 public void addEmployee(EmployeeAddInput employee) { try { using (sys_employeeEntities db = new sys_employeeEntities()) { if (DataBaseCommon.isDuplicateEmployee(employee.Id, db)) { throw new Exception("社員Idが重複発生です"); } if (DataBaseCommon.isDuplicateUsername(employee.UserName, db)) { throw new Exception("社員Usernameが重複発生です"); } var path = ""; var avatarFile = employee.AvatarFile; if (avatarFile != null && avatarFile.ContentLength > 0) { path = HelperCommon.saveAvatarFile(avatarFile, employee.Id); } employee employeeEntity = new employee(); employeeEntity.employeeId = employee.Id; employeeEntity.managerId = employee.ManagerId; employeeEntity.userName = employee.UserName; employeeEntity.passWord = HelperCommon.hashPassword(employee.PassWord); employeeEntity.authorityId = employee.AuthorityId; employeeEntity.dateOfBirth = DateTime.Parse(employee.DateOfBirth); employeeEntity.address = employee.Address; employeeEntity.personalNumber = employee.PersonalNumber; employeeEntity.name = employee.Name; employeeEntity.kataName = employee.KataName; employeeEntity.telephoneNumber = employee.TelephoneNumber; employeeEntity.mailAddress = employee.MailAddress; employeeEntity.customerId = employee.CustomerId; employeeEntity.accountBankInfo = employee.AccountBankInfo; employeeEntity.avatarFilePath = path; employeeEntity.depentdentFamily = employee.DepentdentFamily; employeeEntity.entryDate = employee.EntryDate; employeeEntity.description = employee.Description; db.employee.Add(employeeEntity); db.SaveChanges(); } } catch (Exception e) { throw e; } }
// 社員情報編集 public EmployeeUpdateInput updateEmployee(EmployeeUpdateInput employeeUpdateInput) { try { using (sys_employeeEntities db = new sys_employeeEntities()) { var path = ""; var avatarFile = employeeUpdateInput.AvatarFile; if (avatarFile != null && avatarFile.ContentLength > 0) { path = HelperCommon.saveAvatarFile(employeeUpdateInput.AvatarFile, employeeUpdateInput.Id); } var query = (from e in db.employee where e.employeeId == employeeUpdateInput.Id select e).First(); if (!query.userName.Equals(employeeUpdateInput.UserName)) { if (DataBaseCommon.isDuplicateUsername(employeeUpdateInput.UserName, db)) { throw new Exception("社員Usernameが存在です"); } } employee employeeUpdate = (employee)query; employeeUpdate.employeeId = employeeUpdateInput.Id; employeeUpdate.name = employeeUpdateInput.Name; employeeUpdate.kataName = employeeUpdateInput.KataName; employeeUpdate.authorityId = employeeUpdateInput.AuthorityId; employeeUpdate.telephoneNumber = employeeUpdateInput.TelephoneNumber; employeeUpdate.dateOfBirth = DateTime.Parse(employeeUpdateInput.DateOfBirth); employeeUpdate.address = employeeUpdateInput.Address; employeeUpdate.mailAddress = employeeUpdateInput.MailAddress; employeeUpdate.customerId = employeeUpdateInput.CustomerId; employeeUpdate.managerId = employeeUpdateInput.ManagerId; employeeUpdate.personalNumber = employeeUpdateInput.PersonalNumber; employeeUpdate.accountBankInfo = employeeUpdateInput.AccountBankInfo; employeeUpdate.entryDate = employeeUpdateInput.EntryDate; employeeUpdate.leavingDate = employeeUpdateInput.LeavingDate; employeeUpdate.depentdentFamily = employeeUpdateInput.DepentdentFamily; employeeUpdate.userName = employeeUpdateInput.UserName; if (!employeeUpdate.passWord.Equals(employeeUpdateInput.PassWord)) { employeeUpdate.passWord = HelperCommon.hashPassword(employeeUpdateInput.PassWord); } employeeUpdate.description = employeeUpdateInput.Description; if (!path.Equals("")) { employeeUpdate.avatarFilePath = path; } db.SaveChanges(); } } catch (Exception e) { throw e; } return(employeeUpdateInput); }