/// <summary> /// 删除 /// </summary> /// <param name="ID"></param> /// <returns></returns> public bool DeleteDepartment(int ID) { var departRepository = new DepartmentRepository(); return(departRepository.DeleteDepartment(ID)); }
public int DeleteDepartment(DepartmentModel department) { return(_departmentRepository.DeleteDepartment(department)); }
static void Main(string[] args) { //Authored by & stolen from James Nitz //For educational purposes only //Setting a new instance of the employee repository and dept repo to a variable. Remeber to use the using statement at the top! var repo = new EmployeeRepository(); var deptRepo = new DepartmentRepository(); //That both classes has method that gets all employees. Use it and store all them employees in a var. var employeeWithId2 = repo.GetEmployeeById(2); while (true) { var departments = deptRepo.GetAllDepartments(); var employees = repo.GetAllEmployeesWithDepartment(); Console.WriteLine("Welcome to muh Database!!"); Console.WriteLine("Press 1 for Departments"); Console.WriteLine("Press 2 for Employee"); Console.WriteLine("Press 3 for a full report"); Console.WriteLine("Press 4 to get outta here"); string option = Console.ReadLine(); if (option == "1") { Console.Clear(); Console.WriteLine("---DEPARTMENTS---"); Console.WriteLine("Press 1 to add a Department"); Console.WriteLine("Press 2 to add a Delete"); Console.WriteLine("Press 3 to return"); string deptOption = Console.ReadLine(); switch (Int32.Parse(deptOption)) { case 1: Console.Clear(); Console.WriteLine("Name of Department?"); var deptNameInput = Console.ReadLine(); Department newDepartment = new Department() { DeptName = deptNameInput }; deptRepo.AddDepartment(newDepartment); break; case 2: Console.Clear(); Console.WriteLine("Delete which Department?"); for (var i = 0; i < departments.Count; i++) { Console.WriteLine($"{departments[i].Id} {departments[i].DeptName}"); } var deleteDeptInput = Int32.Parse(Console.ReadLine()); try { deptRepo.DeleteDepartment(deleteDeptInput); break; } catch { Console.Clear(); Console.WriteLine("Cannot delete department with working employees."); Console.WriteLine("Please fire or transfer:"); Console.WriteLine(""); foreach (var employee in employees) { if (employee.DepartmentId == deleteDeptInput) { Console.WriteLine($"{employee.FirstName} {employee.LastName}"); } } Console.WriteLine("Press enter to return"); Console.ReadLine(); break; } case 3: break; default: break; } } else if (option == "2") { Console.Clear(); Console.WriteLine("---EMPLOYEES---"); Console.WriteLine("Press 1 to add an employee"); Console.WriteLine("Press 2 to Fire an Employee"); Console.WriteLine("Press 3 to update an employee"); Console.WriteLine("Press 4 to return"); string empOption = Console.ReadLine(); switch (Int32.Parse(empOption)) { case 1: Console.Clear(); Console.WriteLine("First name of Employee?"); var employeeFirstNameInput = Console.ReadLine(); Console.WriteLine("Last Name of Employee?"); var employeeLastNameInput = Console.ReadLine(); Console.WriteLine("Which Department do they work in?"); foreach (var dept in departments) { Console.WriteLine($"{dept.Id} {dept.DeptName}"); } var employeeDeptChoice = Console.ReadLine(); var selectedDept = departments.Where(dept => int.Parse(employeeDeptChoice) == dept.Id).FirstOrDefault(); Employee newEmployee = new Employee() { FirstName = employeeFirstNameInput, LastName = employeeLastNameInput, DepartmentId = selectedDept.Id }; repo.AddEmployee(newEmployee); break; case 2: Console.Clear(); Console.WriteLine("Fire which Employee?"); for (var i = 0; i < employees.Count; i++) { Console.WriteLine($"{employees[i].Id} {employees[i].FirstName} {employees[i].LastName}"); } var deleteEmployeeInput = Int32.Parse(Console.ReadLine()); repo.DeleteEmployee(deleteEmployeeInput); break; case 3: Console.Clear(); Console.WriteLine("Who you want to update?"); for (var i = 0; i < employees.Count; i++) { Console.WriteLine($"{employees[i].Id} {employees[i].FirstName} {employees[i].LastName}"); } var updateEmployeeInput = Int32.Parse(Console.ReadLine()); var selectedEmployee = repo.GetEmployeeById(updateEmployeeInput); Console.Clear(); Console.WriteLine($"{selectedEmployee.FirstName} {selectedEmployee.LastName} who works in {selectedEmployee.Department.DeptName}"); Console.WriteLine(""); Console.WriteLine("What would you like to update?"); Console.WriteLine("1. Name"); Console.WriteLine("2. Department"); var selectedUpdateInput = Console.ReadLine(); switch (Int32.Parse(selectedUpdateInput)) { case 1: Console.WriteLine("Enter in new first name?"); var newFirstName = Console.ReadLine(); Console.WriteLine("Enter in new last name?"); var newLastName = Console.ReadLine(); selectedEmployee.FirstName = newFirstName; selectedEmployee.LastName = newLastName; repo.UpdateEmployee(selectedEmployee.Id, selectedEmployee); break; case 2: Console.WriteLine("What department do they work in now?"); for (var i = 0; i < departments.Count; i++) { Console.WriteLine($"{departments[i].Id} {departments[i].DeptName}"); } var selectedDeptInput = Int32.Parse(Console.ReadLine()); var newDept = departments.FirstOrDefault(dept => dept.Id == selectedDeptInput); selectedEmployee.DepartmentId = newDept.Id; repo.UpdateEmployee(selectedEmployee.Id, selectedEmployee); break; default: break; } break; case 4: break; default: break; } } else if (option == "3") { Console.Clear(); Console.WriteLine("------------------"); foreach (var dept in departments) { Console.WriteLine($"{dept.DeptName} has the following employees:"); foreach (var employee in employees) { if (employee.DepartmentId == dept.Id) { Console.WriteLine($"{employee.FirstName} {employee.LastName}"); } } } Console.WriteLine("------------------"); } else { Console.WriteLine("See ya Later"); break; } } }
static void Main(string[] args) { //Department var departmentRepo = new DepartmentRepository(); var allDepartments = departmentRepo.GetAllDepartments(); Console.WriteLine("All Departments"); Console.WriteLine("---------------"); foreach (var dept in allDepartments) { Console.WriteLine(dept.DepartmentName); } var hardCodedId = 2; var departmentWithId = departmentRepo.GetDepartmentById(hardCodedId); Console.WriteLine("---------------"); Console.WriteLine($"Department with id {hardCodedId} is {departmentWithId.DepartmentName}"); Console.WriteLine("---------------"); //Employee List var employeeRepo = new EmployeeRepository(); var allEmployee = employeeRepo.GetAllEmployees(); Console.WriteLine("All Employees"); Console.WriteLine("---------------"); foreach (var employee in allEmployee) { Console.WriteLine($"{employee.FirstName} {employee.LastName}"); } var hardCodedEmployeeId = 2; var employeeWithId = employeeRepo.GetEmployeeById(hardCodedEmployeeId); Console.WriteLine("---------------"); Console.WriteLine($"Department with id {hardCodedEmployeeId} is {employeeWithId.FirstName} {employeeWithId.LastName}"); //Employee with Department var allEmployeeRepo = new EmployeeRepository(); var allEmployeeWithDepartment = allEmployeeRepo.GetAllEmployeesWithDepartment(); Console.WriteLine("All Employees"); Console.WriteLine("---------------"); foreach (var employee in allEmployeeWithDepartment) { Console.WriteLine($"{employee.FirstName} {employee.LastName} works in {employee.EmployeeDepartment}"); } Console.WriteLine("--------------------"); //Add Department var legal = new Department(); Console.WriteLine("What department do you like to add?"); legal.DepartmentName = Console.ReadLine(); departmentRepo.AddDepartment(legal); //Update Department Console.WriteLine("What Department (ID) would you like to update?"); var departmentToUpdate = Int32.Parse(Console.ReadLine()); Console.WriteLine("What should the new department name be called?"); var newDepartmentName = Console.ReadLine(); departmentRepo.UpdateDepartment(departmentToUpdate, new Department { DepartmentName = newDepartmentName }); //Delete Department Console.WriteLine("What department do you want to delete?"); var deleteDept = int.Parse(Console.ReadLine()); departmentRepo.DeleteDepartment(deleteDept); Console.WriteLine("--------------------"); //Add Employee var newEmployee = new Employee(); Console.WriteLine("What is your first name?"); newEmployee.FirstName = Console.ReadLine(); Console.WriteLine("What is your last name?"); newEmployee.LastName = Console.ReadLine(); Console.WriteLine("What department do you want to work?"); newEmployee.DepartmentId = Int32.Parse(Console.ReadLine()); employeeRepo.AddEmployee(newEmployee); //Update Employee Console.WriteLine("Which Employee (ID) would you like to update?"); var employeeToUpdate = Int32.Parse(Console.ReadLine()); var updateEmployee = new Employee(); Console.WriteLine("What is your first name?"); updateEmployee.FirstName = Console.ReadLine(); Console.WriteLine("What is your last name?"); updateEmployee.LastName = Console.ReadLine(); Console.WriteLine("What department do you want to work?"); updateEmployee.DepartmentId = Int32.Parse(Console.ReadLine()); employeeRepo.UpdateEmployee(employeeToUpdate, updateEmployee); //Delete Employee Console.WriteLine("Which employee do you want to delete?"); var deleteEmp = int.Parse(Console.ReadLine()); employeeRepo.DeleteEmployee(deleteEmp); }
public void DeleteDepartment(int DepartmentId) { repository.DeleteDepartment(DepartmentId); }