コード例 #1
0
        static void Main(string[] args)
        {
            DepartmentRepository departmentRepo = new DepartmentRepository();

            Console.WriteLine("Getting All Departments:");
            Console.WriteLine();

            List <Department> allDepartments = departmentRepo.GetAllDepartments();

            foreach (Department dept in allDepartments)
            {
                Console.WriteLine($"{dept.Id} {dept.DeptName}");
            }

            Console.WriteLine("----------------------------");
            Console.WriteLine("Getting Department with Id 1");

            Department singleDepartment = departmentRepo.GetDepartmentById(1);

            Console.WriteLine($"{singleDepartment.Id} {singleDepartment.DeptName}");



            Department legalDept = new Department
            {
                DeptName = "Legal"
            };

            departmentRepo.AddDepartment(legalDept);

            Console.WriteLine("-------------------------------");
            Console.WriteLine("Added the new Legal Department!");

            departmentRepo.UpdateDepartment(1, new Department()
            {
                DeptName = "New Department"
            });

            Console.WriteLine("Here's your updated department:");
            Console.WriteLine(departmentRepo.GetDepartmentById(1).DeptName);

            Console.WriteLine("Now let's delete a department.");
            departmentRepo.DeleteDepartment(4);
            List <Department> newDeps = departmentRepo.GetAllDepartments();

            foreach (Department dep in newDeps)
            {
                Console.WriteLine(dep.DeptName);
            }

            Console.ReadLine();
        }
コード例 #2
0
        public static void CollectInput()
        {
            Console.Clear();

            while (true)
            {
                Console.WriteLine("Please enter the id of the department you wish to update");
                Console.Write("> ");

                string response = Console.ReadLine();
                int    id       = Int32.Parse(response);

                DepartmentRepository departments = new DepartmentRepository();

                var foundDepartment = departments.GetDepartmentById(id);

                Console.Clear();

                Console.WriteLine($"{foundDepartment.Id}: {foundDepartment.DeptName}");

                Console.WriteLine();

                Console.WriteLine("Please enter a new name for the department");
                Console.Write(" >");

                string deptName = Console.ReadLine();

                Department newDepartment = new Department
                {
                    DeptName = deptName
                };

                departments.UpdateDepartment(id, newDepartment);

                var updatedDepartment = departments.GetDepartmentById(id);

                Console.Clear();

                Console.WriteLine("Updated department:");
                Console.WriteLine($"{updatedDepartment.Id}: {updatedDepartment.DeptName}");

                Console.WriteLine($"Press any key to return to the previous menu");
                Console.ReadLine();
                Console.Clear();
                break;
            }
        }
コード例 #3
0
        static void Main(string[] args)
        {
            // Get All Departments
            var departmentRepo = new DepartmentRepository();
            var allDepartments = departmentRepo.GetAllDepartments();

            Console.WriteLine("All Departments");
            Console.WriteLine("---------------");
            foreach (var dept in allDepartments)
            {
                Console.WriteLine(dept.DepartmentName);
            }
            // Get Department by Id
            var hardCodedId       = 3;
            var departmentWithId3 = departmentRepo.GetDepartmentById(hardCodedId);

            Console.WriteLine("---------------");
            Console.WriteLine($"Department with id {hardCodedId} is {departmentWithId3.DepartmentName}");

            // Get all Employees
            var employeeRepo = new EmployeeRepository();
            var allEmployees = employeeRepo.GetAllEmployees();

            Console.WriteLine("All Employees");
            Console.WriteLine("-------------");
            foreach (var employee in allEmployees)
            {
                Console.WriteLine(employee.FirstName);
                Console.WriteLine(employee.LastName);
            }

            // Get Employee by Id
            var emHardCodedId   = 4;
            var employeeWithId4 = employeeRepo.GetEmployeeById(emHardCodedId);

            Console.WriteLine("-------------");
            Console.WriteLine($"{employeeWithId4.FirstName}{employeeWithId4.LastName}");

            Console.WriteLine();
            Console.WriteLine();
            Console.WriteLine();
            Console.WriteLine();

            // Adding new department
            var legal = new Department();

            Console.WriteLine("What department would you lke to add?");
            legal.DepartmentName = Console.ReadLine();
            departmentRepo.AddDepartment(legal);

            // Updating a department
            Console.WriteLine("What department 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
            });


            // Deleting a department
            departmentRepo.DeleteDepartment(7);
            departmentRepo.DeleteDepartment(8);
            departmentRepo.DeleteDepartment(9);
        }
コード例 #4
0
        static void Main(string[] args)
        {
            DepartmentRepository departmentRepo = new DepartmentRepository();
            EmployeeRepository   employeeRepo   = new EmployeeRepository();

            Console.WriteLine("Getting All Departments:");
            Console.WriteLine();

            List <Department> allDepartments = departmentRepo.GetAllDepartments();
            List <Employee>   allEmployees   = employeeRepo.GetAllEmployees();

            foreach (Department dept in allDepartments)
            {
                Console.WriteLine($"{dept.Id}.) {dept.DeptName}");
            }

            Console.WriteLine("----------------------------");
            Console.WriteLine("Getting Department with Id 1");

            Department singleDepartment = departmentRepo.GetDepartmentById(1);

            Console.WriteLine($"{singleDepartment.Id}.) {singleDepartment.DeptName}");

            Console.WriteLine("CREATE");
            Console.WriteLine("What's the name of the new Department?");
            var newDeptName = Console.ReadLine();

            Department newDept = new Department
            {
                DeptName = newDeptName
            };

            departmentRepo.AddDepartment(newDept);

            Console.WriteLine("-------------------------------");
            Console.WriteLine($"Added the new {newDept.DeptName} Department!");

            Console.WriteLine("----------------------------");
            Console.WriteLine("UPDATE");
            Console.WriteLine("which Department (use number)?");
            var updatedDepartments = departmentRepo.GetAllDepartments();

            foreach (Department dept in updatedDepartments)
            {
                Console.WriteLine($"{dept.Id}.) {dept.DeptName}");
            }
            var        updatedDepartmentId = int.Parse(Console.ReadLine());
            Department departmentToUpdate  = departmentRepo.GetDepartmentById(updatedDepartmentId);

            Console.WriteLine($"Update {departmentToUpdate.DeptName} department Name.");
            departmentToUpdate.DeptName = Console.ReadLine();


            departmentRepo.UpdateDepartment(updatedDepartmentId, departmentToUpdate);

            Console.WriteLine("----------------------------");
            Console.WriteLine("DELETE");
            Console.WriteLine("which Department (use number)?");
            foreach (Department dept in updatedDepartments)
            {
                Console.WriteLine($"{dept.Id}.) {dept.DeptName}");
            }
            var        deleteDepartmentId = int.Parse(Console.ReadLine());
            Department departmentToDelete = departmentRepo.GetDepartmentById(deleteDepartmentId);

            Console.WriteLine($"Deleting {departmentToDelete.DeptName}");
            departmentRepo.DeleteDepartment(deleteDepartmentId);

            Console.WriteLine("Getting all Employees");
            foreach (Employee emp in allEmployees)
            {
                Console.WriteLine($"{emp.Id}.) {emp.FirstName} {emp.LastName}");
            }

            Console.WriteLine("CREATE");
            Console.WriteLine("What is their First Name?");
            var newEmployeeFirstName = Console.ReadLine();

            Console.WriteLine("what is their Last Name?");

            var newEmployeeLastName = Console.ReadLine();

            Console.WriteLine("Which department do they work in?");
            foreach (Department dept in allDepartments)
            {
                Console.WriteLine($"{dept.Id}.) {dept.DeptName}");
            }
            var newEmployeeDepartmentId = int.Parse(Console.ReadLine());

            Employee newEmployee = new Employee
            {
                FirstName    = newEmployeeFirstName,
                LastName     = newEmployeeLastName,
                DepartmentId = newEmployeeDepartmentId
            };

            employeeRepo.AddEmployee(newEmployee);

            Console.WriteLine("----------------------------");
            Console.WriteLine("UPDATE");
            Console.WriteLine("which Employee (use number)?");
            foreach (Employee emp in allEmployees)
            {
                Console.WriteLine($"{emp.Id}.) {emp.FirstName} {emp.LastName}");
            }
            var      updatedEmployeeId = int.Parse(Console.ReadLine());
            Employee employeeToUpdate  = employeeRepo.GetEmployeeById(updatedEmployeeId);

            Console.WriteLine($"Update {employeeToUpdate.FirstName} {employeeToUpdate.LastName} first name.");
            employeeToUpdate.FirstName = Console.ReadLine();
            Console.WriteLine($"Update {employeeToUpdate.FirstName} {employeeToUpdate.LastName} last name.");
            employeeToUpdate.LastName = Console.ReadLine();
            Console.WriteLine($"Update {employeeToUpdate.FirstName} {employeeToUpdate.LastName}'s department.");
            employeeToUpdate.DepartmentId = int.Parse(Console.ReadLine());

            employeeRepo.UpdateEmployee(updatedEmployeeId, employeeToUpdate);

            Console.WriteLine("DELETE");
            Console.WriteLine("which employee (use number)?");

            List <Employee> updatedAllEmployees = employeeRepo.GetAllEmployees();

            foreach (Employee emp in updatedAllEmployees)
            {
                Console.WriteLine($"{emp.Id}.) {emp.FirstName} {emp.LastName}");
            }
            var      deleteEmployeeId = int.Parse(Console.ReadLine());
            Employee employeeToDelete = employeeRepo.GetEmployeeById(deleteEmployeeId);

            Console.WriteLine($"Deleting {employeeToDelete.FirstName} {employeeToDelete.LastName}");
            employeeRepo.DeleteEmployee(deleteEmployeeId);
        }
コード例 #5
0
        static void Main(string[] args)
        {
            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       = 3;
            var departmentWithId3 = departmentRepo.GetDepartmentById(hardCodedId);

            Console.WriteLine("-----------");
            Console.WriteLine($"Department with id {hardCodedId} is {departmentWithId3.DepartmentName}");

            /// heres a break-------------------------------------------------------------------------------
            /// ---------------------------------------------------------------------------------------------

            var employeeRepo = new EmployeeRepository();
            var allEmployees = employeeRepo.GetAllEmployees();

            Console.WriteLine("All Employees");
            Console.WriteLine("---------------");

            foreach (var employee in allEmployees)
            {
                Console.WriteLine(employee.FirstName);
            }

            var hardCodedEmployeeId = 2;

            var employeeWithId3 = employeeRepo.GetEmployeeById(hardCodedEmployeeId);

            Console.WriteLine("-----------");
            Console.WriteLine($"Employee with id {hardCodedEmployeeId} is {employeeWithId3.FirstName}");

            Console.WriteLine();
            Console.WriteLine();
            Console.WriteLine();
            Console.WriteLine();

            var legal = new Department();

            Console.WriteLine("What department would you like to add?");
            legal.DepartmentName = Console.ReadLine();
            departmentRepo.AddDepartment(legal);

            Console.WriteLine("What Department (ID) would you like to update?");
            var departmentToUpdate = Int32.Parse(Console.ReadLine());

            Console.WriteLine("What is name of the new department?");
            var newDepartmentName = Console.ReadLine();

            departmentRepo.UpdateDepartment(departmentToUpdate, new Department {
                DepartmentName = newDepartmentName
            });

            //Add a new employee


            departmentRepo.DeleteDepartment(7);
            departmentRepo.DeleteDepartment(8);
            departmentRepo.DeleteDepartment(9);
        }
コード例 #6
0
        static void Main(string[] args)
        {
            var departmentRepo = new DepartmentRepository();

            var allDepartments = departmentRepo.GetAllDepartments();

            Console.WriteLine("All Departments");
            Console.WriteLine("----------------");
            foreach (var dept in allDepartments)
            {
                Console.WriteLine(dept.DepartmentName);
            }

            var hardCodeId = 3;

            var departmentWithId3 = departmentRepo.GetDepartmentById(hardCodeId);

            Console.WriteLine("-----------------");
            Console.WriteLine($"Department with id {hardCodeId} is {departmentWithId3.DepartmentName}");


            var employeeRepo = new EmployeeRepository();

            var allEmployees = employeeRepo.GetAllEmployees();

            Console.WriteLine("All Employees");
            Console.WriteLine("----------------");
            foreach (var emp in allEmployees)
            {
                Console.WriteLine(emp.FirstName);
                Console.WriteLine(emp.LastName);
            }

            var empHardCodeId = 3;

            var empWithId3 = employeeRepo.GetEmployeeById(empHardCodeId);

            Console.WriteLine("-----------------");
            Console.WriteLine($"Department with id {empHardCodeId} is {empWithId3.FirstName} {empWithId3.LastName}");

            Console.WriteLine();
            Console.WriteLine();
            Console.WriteLine();
            Console.WriteLine();

            var allEmployeesWithDept = employeeRepo.GetAllEmployeesWithDepartment();

            Console.WriteLine("Employees with Department");
            Console.WriteLine("------------------");
            foreach (var emp in allEmployeesWithDept)
            {
                Console.WriteLine(emp.FirstName);
                Console.WriteLine(emp.LastName);
                Console.WriteLine(emp.Department);
            }

            var legal = new Department();

            Console.WriteLine("What department would you like to add?");

            legal.DepartmentName = Console.ReadLine();

            departmentRepo.AddDepartment(legal);

            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
            });

            departmentRepo.DeleteDepartment(7);
            departmentRepo.DeleteDepartment(8);
            departmentRepo.DeleteDepartment(9);
        }
コード例 #7
0
        static void Main(string[] args)
        {
            var departmentRepo = new DepartmentRepository();

            //Console.WriteLine("Getting All Departments:");
            //Console.WriteLine();

            List <Department> allDepartments = departmentRepo.GetAllDepartments();

            //foreach (Department dept in allDepartments)
            //{
            //    Console.WriteLine($"{dept.Id} {dept.DeptName}");
            //}


            //Console.WriteLine("----------------------------");
            //Console.WriteLine("Getting Department with Id 1");

            //Department singleDepartment = departmentRepo.GetDepartmentById(1);

            //Console.WriteLine($"{singleDepartment.Id} {singleDepartment.DeptName}");

            //Department legalDept = new Department
            //{
            //    DeptName = "Legal"
            //};

            //departmentRepo.AddDepartment(legalDept);

            //Console.WriteLine("-------------------------------");
            //Console.WriteLine("Added the new Legal Department!");

            var employeeRepo = new EmployeeRepository();
            var employees    = employeeRepo.GetAllEmployees();

            //foreach(var employee in employees)
            //{
            //    Console.WriteLine($"{employee.FirstName} {employee.LastName} is in {employee.Department.DeptName}");
            //}

            while (true)
            {
                Console.WriteLine("Select an option ");
                Console.WriteLine("1. Add A Department");
                Console.WriteLine("2. Add An Employee");
                Console.WriteLine("3. Update A Department");
                Console.WriteLine("4. Update An Employee");
                Console.WriteLine("5. Delete A Department");
                Console.WriteLine("6. Delete A Employee");



                switch (int.Parse(Console.ReadLine()))
                {
                case 1:

                    Console.WriteLine("Enter your department name");
                    var        departmentNameEntered = Console.ReadLine();
                    Department newDept = new Department
                    {
                        DeptName = departmentNameEntered
                    };
                    departmentRepo.AddDepartment(newDept);
                    Console.WriteLine("You have added your department!");
                    break;

                case 2:
                    Console.WriteLine("Enter the employees first name");
                    var firstNameEntered = Console.ReadLine();
                    Console.WriteLine("Enter the employees last name");
                    var lastNameEntered = Console.ReadLine();
                    Console.WriteLine("Select the department id");
                    foreach (var department in allDepartments)
                    {
                        Console.WriteLine($" {department.Id} {department.DeptName}");
                    }
                    var      deptIdEntered = int.Parse(Console.ReadLine());
                    Employee newEmployee   = new Employee
                    {
                        FirstName    = firstNameEntered,
                        LastName     = lastNameEntered,
                        DepartmentId = deptIdEntered
                    };
                    employeeRepo.CreateNewEmployee(newEmployee);
                    Console.WriteLine("You have added an employee");
                    break;

                case 3:
                    Console.WriteLine("Enter the department id you want to update");
                    foreach (var department in allDepartments)
                    {
                        Console.WriteLine($" {department.Id} {department.DeptName}");
                    }
                    var DeptId = int.Parse(Console.ReadLine());
                    Console.WriteLine("Enter the updated department name");
                    var updatedDeptName = Console.ReadLine();
                    var updatedDept     = new Department
                    {
                        Id       = DeptId,
                        DeptName = updatedDeptName
                    };
                    departmentRepo.UpdateDepartment(DeptId, updatedDept);

                    break;

                case 4:
                    Console.WriteLine("Enter the id of the employee you want to update");
                    foreach (var employee in employees)
                    {
                        Console.WriteLine($" {employee.Id} {employee.FirstName} {employee.LastName}");
                    }
                    var updatedEmpId = int.Parse(Console.ReadLine());
                    Console.WriteLine("Enter updated first name:");
                    var updatedFirst = Console.ReadLine();
                    Console.WriteLine("Enter updated last name");
                    var updatedLast = Console.ReadLine();
                    Console.WriteLine("Enter the updated department");
                    foreach (var department in allDepartments)
                    {
                        Console.WriteLine($" {department.Id} {department.DeptName}");
                    }
                    var updatedDeptId = int.Parse(Console.ReadLine());

                    var updatedEmployee = new Employee
                    {
                        FirstName    = updatedFirst,
                        LastName     = updatedLast,
                        DepartmentId = updatedDeptId
                    };
                    employeeRepo.UpdateEmployee(updatedEmpId, updatedEmployee);
                    break;

                case 5:
                    Console.WriteLine("Select the department you want to delete");
                    foreach (var department in allDepartments)
                    {
                        Console.Write($"{department.Id} {department.DeptName} ");
                        var relatedEmp = employees.Where(emp => emp.DepartmentId == department.Id).ToList();
                        foreach (var emp in relatedEmp)
                        {
                            Console.Write($" {emp.Id} {emp.FirstName} {emp.LastName}");
                        }
                        Console.WriteLine();
                    }
                    var selectedDept = int.Parse(Console.ReadLine());
                    foreach (var emp in employees)
                    {
                        try
                        {
                            if (emp.Department.Id != selectedDept)
                            {
                                departmentRepo.DeleteDepartment(selectedDept);
                                break;
                            }
                        }
                        catch
                        {
                            Console.WriteLine("Delete the employees in that department first");
                            break;
                        }
                    }
                    break;

                case 6:
                    Console.WriteLine("Select the employee you would like to fire");
                    foreach (var emp in employees)
                    {
                        Console.WriteLine($"{emp.Id} {emp.FirstName} {emp.LastName} {emp.Department.DeptName}");
                    }
                    var empId = int.Parse(Console.ReadLine());
                    employeeRepo.DeleteEmployee(empId);
                    break;

                default:
                    break;
                }
            }
        }