private void Check() { if (EqFailName.TextLength <= 10) { MessageBox.Show("Длина наименования операции должна быть не менее 10 символов", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); EqFailName.Focus(); this.DialogResult = DialogResult.None; return; } if (Fail.TextLength <= 10 && MainForm.id == 0) { MessageBox.Show("Длина причины отказа должна быть не менее 10 символов", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); Fail.Focus(); this.DialogResult = DialogResult.None; return; } if (FullEmployeeName.SelectedIndex == 0) { MessageBox.Show("Необходимо выбрать сотрудника", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); FullEmployeeName.Focus(); this.DialogResult = DialogResult.None; return; } if (EmployeePost.SelectedIndex == 0) { MessageBox.Show("Необходимо выбрать должность сотрудника", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); EmployeePost.Focus(); this.DialogResult = DialogResult.None; return; } }
public async Task <IActionResult> Put(int id, [FromBody] EmployeePost employee) { if (ModelState.IsValid) { var employeeFromRepo = await _empRepo.GetById(id); if (employeeFromRepo == null) { return(NotFound()); } employeeFromRepo.FirstName = employee.FirstName ?? employeeFromRepo.FirstName; employeeFromRepo.LastName = employee.LastName ?? employeeFromRepo.LastName; employeeFromRepo.PersonNr = employee.PersonNr ?? employeeFromRepo.PersonNr; try { var employeeUpdated = _empRepo.Update(employeeFromRepo.EmployeeId, employeeFromRepo); return(Ok(employeeUpdated)); } catch (Exception ex) { _logger.LogError($"Thrown exception when updating {ex}"); BadRequest("Something when wrong while updating"); } } return(BadRequest("Error occured")); }
/// <summary> /// Удаление сотрудника /// </summary> /// <param name="post">Объект сотрудника</param> public void DeleteEmployeePost(EmployeePost post) { logger.Trace("Попытка подключения к источнику данных."); logger.Trace("Подготовка к удалению должности."); try { var postToDelete = context.EmployeePost.FirstOrDefault(ep => ep.PostId == post.PostId); if (postToDelete != null) { context.EmployeePost.Remove(postToDelete); context.SaveChanges(); logger.Debug("Удаление успешно завершено."); } } catch (SqlException sqlEx) { logger.Error("Ошибка удаления записи должности."); logger.Error($"Ошибка SQL Server — {sqlEx.Number}."); logger.Error($"Сообщение об ошибке: {sqlEx.Message}."); } catch (Exception ex) { logger.Error("Ошибка удаления записи должности."); logger.Error($"Ошибка — {ex.Message}."); } }
/// <summary> /// Добавление новой должности сотрудников /// </summary> /// <param name="post">Объект новой должности</param> /// <returns>Возвращаем только что созданный объект</returns> public EmployeePost InsertEmployeePost(EmployeePost post) { logger.Trace("Попытка подключения к источнику данных."); logger.Trace("Подготовка к добавлению должности"); try { logger.Debug($"Добавляемая запись {post.ToString()}"); context.EmployeePost.Add(post); context.SaveChanges(); logger.Debug($"Новая запись успешно добавлена."); return(post); } catch (SqlException sqlEx) { logger.Error("Ошибка добавления должности."); logger.Error($"Ошибка SQL Server — {sqlEx.Number}."); logger.Error($"Сообщение об ошибке: {sqlEx.Message}."); return(null); } catch (Exception ex) { logger.Error("Ошибка добавления должности."); logger.Error($"Ошибка — {ex.Message}."); return(null); } }
/// <summary> /// Обновление должности /// </summary> /// <param name="post">Редактируемая должность</param> /// <returns>Возвращаем объект должности, с обновленными данными</returns> public EmployeePost UpdateEmployeePost(EmployeePost post) { logger.Trace("Попытка подключения к источнику данных."); logger.Trace("Подготовка к обновлению должности."); try { var postToUpdate = context.EmployeePost.FirstOrDefault(ep => ep.PostId == post.PostId); logger.Debug($"Текущая запись {postToUpdate.ToString()}"); postToUpdate.Name = post.Name; postToUpdate.Note = post.Note; postToUpdate.RegistrationAllow = post.RegistrationAllow; postToUpdate.EnrollAllow = post.EnrollAllow; postToUpdate.DictionaryAllow = post.DictionaryAllow; context.SaveChanges(); logger.Debug($"Новая запись {postToUpdate.ToString()}"); return(postToUpdate); } catch (SqlException sqlEx) { logger.Error("Ошибка редактирования должности."); logger.Error($"Ошибка SQL Server — {sqlEx.Number}."); logger.Error($"Сообщение об ошибке: {sqlEx.Message}."); return(null); } catch (Exception ex) { logger.Error("Ошибка редактирования должности."); logger.Error($"Ошибка — {ex.Message}."); return(null); } }
public bool CreateUpdateEmployee(EmployeePost employeePost) { try { DataTable EmployeeData = CreateEmployeeStructure(); FillEmployeeInformation(EmployeeData, employeePost); var parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@EmployeeData", SqlDbType.Structured) { TypeName = "dbo.EmployeeData", Value = EmployeeData }); const string storedProc = "dbo.uspEmployeeCreateUpdate"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand(storedProc, connection)) { // Add the parameters to the command - add command.Parameters.AddRange(parameters.ToArray()); // Create an adapter and fill our dataset, uncomment when we use a stored procedure command.CommandType = CommandType.StoredProcedure; command.ExecuteNonQuery(); } } return(true); } catch (Exception ex) { return(false); } }
private void FillEmployeeInformation(DataTable data, EmployeePost employeePost) { DataRow newRow = data.NewRow(); if (employeePost.EmployeeId != null) { newRow["EmployeeId"] = employeePost.EmployeeId; } newRow["Name"] = employeePost.Name; if (employeePost.Fax != null) { newRow["Fax"] = employeePost.Fax; } newRow["Email"] = employeePost.Email; newRow["Password"] = employeePost.Password; newRow["UserName"] = employeePost.UserName; newRow["Telephone"] = employeePost.Telephone; newRow["CompanyId"] = employeePost.CompanyId; newRow["PortalId"] = employeePost.PortalId; newRow["RoleId"] = employeePost.RoleId; newRow["StatusId"] = employeePost.StatusId; newRow["LastLogin"] = DateTime.Parse(employeePost.LastLogin); newRow["CreatedOn"] = DateTime.Parse(employeePost.CreatedOn); if (employeePost.UpdatedOn != null) { newRow["UpdateOn"] = DateTime.Parse(employeePost.UpdatedOn); } if (employeePost.DeleteOn != null) { newRow["DeletedOn"] = DateTime.Parse(employeePost.DeleteOn); } data.Rows.Add(newRow); }
public async Task <IActionResult> Post([FromForm] EmployeePost employeeDTO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var employee = new Employee { Name = employeeDTO.Name, DateOfJoining = employeeDTO.DateOfJoining, }; var employeeDepartment = (await _UnitOfWork.DepartmentRepository.GetAllDepartmentsAsync()).Where(dep => dep.Name == employeeDTO.DepartmentName).FirstOrDefault(); if (employeeDepartment != null) { employee.DepartmentId = employeeDepartment.Id; //employee.Department = employeeDepartment; } _UnitOfWork.EmployeeRepository.CreateEmployee(employee); await _UnitOfWork.SaveChangesAsync(); return(Ok(employee)); }
/// <summary> /// Resolves the employee group by the employee post /// </summary> /// <param name="post">Employee post</param> /// <returns>Resolved employee group</returns> public EmployeeGroup ResolveGroupByPost(EmployeePost post) { if (post == EmployeePost.JuniorNurse) return EmployeeGroup.JuniorStaff; return EmployeeGroup.MiddleStaffAndDoctors; }
public async Task <IActionResult> UpdateEmployee(EmployeePost employee, int id) { try { employee.EmployeeId = id; employeeService.CreateUpdateEmployee(employee); return(StatusCode(StatusCodes.Status200OK)); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, ex)); } }
public IActionResult AddEmployee([FromBody] EmployeePost emp) { if (emp.Name == null || emp.Sex == null || emp.Birthday == null) { return(NotFound("Fields can`t be empty")); } var user = _employeeContext.Employees.Add(new Employee() { Name = emp.Name, Sex = emp.Sex, Birthday = emp.Birthday }); _employeeContext.SaveChanges(); // return Json return(Json(user.Entity.Id)); }
/// <summary> /// Получение списка сотрудников, определенной должности /// </summary> /// <param name="post">Должность сотрудников</param> /// <returns>Список сотрудников</returns> public List <Employee> GetEmployees(EmployeePost post) { logger.Trace("Попытка подключения к источнику данных."); logger.Trace("Подготовка к поиску списка пользователей определенной должности."); try { var employees = context.Employee.AsNoTracking().Where(e => e.PostId == post.PostId).ToList(); logger.Debug($"Поиск окончен. Количество записей: {employees.Count}."); return(employees); } catch (SqlException sqlEx) { logger.Error("Ошибка получения списка пользователей."); logger.Error($"Ошибка SQL Server — {sqlEx.Number}."); logger.Error($"Сообщение об ошибке: {sqlEx.Message}."); return(null); } catch (Exception ex) { logger.Error("Ошибка получения списка пользователей."); logger.Error($"Ошибка — {ex.Message}."); return(null); } }
public async Task <IActionResult> Post([FromBody] EmployeePost employee) { if (ModelState.IsValid) { try { var newEmployee = new Employee { FirstName = employee.FirstName, LastName = employee.LastName, PersonNr = employee.PersonNr }; var addedEmployee = await _empRepo.Create(newEmployee); if (employee.knowledges == null && employee.newKnowledges != null) { foreach (var newKnowledge in employee.newKnowledges) { var AddedKnowledges = await _KnRepo.Create(new Knowledge { KnowledgeName = newKnowledge }); var addedAssignment = await _AcqRepo.Create(new AcquiredKnowledge { EmployeeId = addedEmployee.EmployeeId, KnowledgeId = AddedKnowledges.KnowledgeId }); } } else if (employee.knowledges != null && employee.newKnowledges == null) { foreach (var knowledge in employee.knowledges) { var addedAssignment = await _AcqRepo.Create(new AcquiredKnowledge { EmployeeId = addedEmployee.EmployeeId, KnowledgeId = knowledge.KnowledgeId }); } } else if (employee.knowledges != null && employee.newKnowledges != null) { foreach (var newKnowledge in employee.newKnowledges) { var AddedKnowledges = await _KnRepo.Create(new Knowledge { KnowledgeName = newKnowledge }); var addedAssignment = await _AcqRepo.Create(new AcquiredKnowledge { EmployeeId = addedEmployee.EmployeeId, KnowledgeId = AddedKnowledges.KnowledgeId }); } foreach (var knowledge in employee.knowledges) { var addedAssignment = await _AcqRepo.Create(new AcquiredKnowledge { EmployeeId = addedEmployee.EmployeeId, KnowledgeId = knowledge.KnowledgeId }); } } return(Ok(addedEmployee)); } catch (Exception ex) { _logger.LogError($"Exception thrown while adding employee: {ex.Message}"); return(BadRequest($"Error ocurred")); } } return(BadRequest("Failed to save changes to the database")); }
public bool CreateUpdateEmployee(EmployeePost employeePost) { return(employeeRepository.CreateUpdateEmployee(employeePost)); }
private void button1_Click(object sender, EventArgs e) { MainForm main = new MainForm(); string CmdText = ""; OleDbConnection conn = new OleDbConnection(MainForm.connectionstring); conn.Open(); if (MainForm.id == 0) { CmdText = "INSERT INTO EqFailHistory(EqListID, DateTimeFail, EqFailName, FailReason, EmployeePost, FullEmployeeName) Values ('" + ID + "' , '" + DateTime.Value + "' , '" + EqFailName.Text + "' , '" + Fail.Text + "' , '" + EmployeePost.Text + "' , '" + FullEmployeeName.Text + "')"; } if (MainForm.id != 0) { CmdText = "INSERT INTO EqTechHistory(EqListID, DateTimeTech, EqTechName, FullEmployeeName, EmployeePost) Values ('" + ID.ToString() + "' , '" + DateTime.Value + "' , '" + EqFailName.Text + "' , '" + FullEmployeeName.Text + "' , '" + EmployeePost.Text + "')"; } if (EqFailName.TextLength <= 10) { MessageBox.Show("Длина наименования операции должна быть не менее 10 символов", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); EqFailName.Focus(); this.DialogResult = DialogResult.None; return; } if (Fail.TextLength <= 10 && MainForm.id == 0) { MessageBox.Show("Длина причины отказа должна быть не менее 10 символов", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); Fail.Focus(); this.DialogResult = DialogResult.None; return; } if (FullEmployeeName.SelectedValue == "") { MessageBox.Show("Необходимо выбрать сотрудника", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); FullEmployeeName.Focus(); this.DialogResult = DialogResult.None; return; } if (EmployeePost.SelectedIndex == 0) { MessageBox.Show("Необходимо выбрать должность сотрудника", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); EmployeePost.Focus(); this.DialogResult = DialogResult.None; return; } OleDbCommand Cmd = new OleDbCommand(CmdText, conn); Cmd.ExecuteNonQuery(); conn.Close(); main.RefreshEqData(); main.RefreshDataRequest(MainForm.id); }