private void btnAddEmployeeFormSaveChanges_Click(object sender, EventArgs e) { employee.EmployeeFName = employeeFNameTextBox.Text; employee.EmployeeLName = employeeLNameTextBox.Text; employee.EmployeePhoneNum = employeePhoneNumTextBox.Text; employee.EmployeeAddress = employeeAddressTextBox.Text; employee.EmployeeCity = employeeCityTextBox.Text; employee.EmployeeState = employeeStateComboBox.SelectedValue.ToString(); employee.EmployeeZipCode = employeeZipCodeTextBox.Text; employee.EmployeeCurrentPay = Convert.ToDecimal(employeeCurrentPayTextBox.Text); AddEmpDb.Employees.Add(employee); AddEmpDb.SaveChanges(); EmployeesListForm = new EmployeesListForm(); EmployeesListForm.Show(); this.Close(); }
//Deletes Employee private void btnEmployeeFormDeleteEmp_Click(object sender, EventArgs e) { if (employeeIDTextBox.Text == "") { MessageBox.Show("No employee selected. Please select an employee to delete", "Delete Error"); } else { int currentEmp = Convert.ToInt32(employeeIDTextBox.Text); var editedEmp = (from employee in EmpDb.Employees where employee.EmployeeID == currentEmp select employee).Single(); DialogResult result = MessageBox.Show($"Delete {editedEmp.EmployeeFName} {editedEmp.EmployeeLName}?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { try { EmpDb.Employees.Remove(editedEmp); EmpDb.SaveChanges(); } catch (DbUpdateConcurrencyException) { this.Close(); if (EmpDb.Entry(editedEmp).State == EntityState.Detached) { MessageBox.Show("Another user has deleted that employee.", "Concurrency Error"); } else { MessageBox.Show("Another user has updated that employee.", "Concurrency Error"); } } catch (DbUpdateException) { this.Close(); MessageBox.Show("Unable to delete employee. The employee is labeled as an employee that worked on an invoice.", "Employee Not Deleted"); EmployeesListForm newForm = new EmployeesListForm(); newForm.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } } } }
private void btnAddEmployeeFormCancel_Click(object sender, EventArgs e) { EmployeesListForm = new EmployeesListForm(); EmployeesListForm.Show(); this.Close(); }