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();
}
public static void CollectId()
{
Console.Clear();
while (true)
{
Console.WriteLine("Please enter the id of the department you wish to view");
Console.Write("> ");
string response = Console.ReadLine();
int id = Int32.Parse(response);
DepartmentRepository departments = new DepartmentRepository();
var foundDepartment = departments.GetDepartmentById(id);
Console.WriteLine();
Console.WriteLine($"{foundDepartment.Id}: {foundDepartment.DeptName}");
Console.WriteLine();
Console.WriteLine($"Press any key to return to the previous menu");
Console.ReadLine();
Console.Clear();
break;
}
}
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!");
}
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;
}
}
public static void CollectInput()
{
Console.Clear();
while (true)
{
Console.WriteLine("Please enter the id of the department you wish to delete");
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("Are you sure you wish to delete? y/n");
Console.Write(" >");
string choice = Console.ReadLine();
if (choice == "y")
{
departments.DeleteDepartment(id);
Console.WriteLine();
Console.WriteLine("Department deleted");
Console.WriteLine();
Console.WriteLine($"Press any key to return to the previous menu");
Console.ReadLine();
Console.Clear();
break;
}
else if (choice == "n")
{
Console.Clear();
break;
}
}
}
static void Main(string[] args)
// ******************** GET ALL ********************
{
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}");
}
EmployeeRepository employeeRepo = new EmployeeRepository();
Console.WriteLine();
Console.WriteLine("Getting All Employees:");
Console.WriteLine();
List <Employee> allEmployees = employeeRepo.GetAllEmployees();
foreach (Employee e in allEmployees)
{
Console.WriteLine($"{e.Id} {e.FirstName} {e.LastName} {e.DepartmentId}");
}
// ******************** GET ONE ********************
Console.WriteLine("----------------------------");
Console.WriteLine("getting DEPARTMENT with id 1");
Department singleDepartment = departmentRepo.GetDepartmentById(1);
Console.WriteLine($"{singleDepartment.Id} {singleDepartment.DeptName}");
Console.WriteLine("----------------------------");
Console.WriteLine("getting EMPLOYEE with id 1");
Employee singleEmployee = employeeRepo.getEmployeeById(1);
Console.WriteLine($"{singleEmployee.Id} {singleEmployee.FirstName} {singleEmployee.LastName} {singleEmployee.DepartmentId}");
// ******************** GET ALL + DEPT ********************
DepartmentRepository departmentRepoAll = new DepartmentRepository();
Console.WriteLine();
Console.WriteLine("---------------------------------------");
Console.WriteLine("Getting All Employees With Departments:");
List <Employee> allEmployeesAll = employeeRepo.GetAllEmployeesWithDepartment();
foreach (Employee e in allEmployeesAll)
{
Console.WriteLine($"{e.Id} {e.FirstName} {e.LastName} - {e.Department.DeptName}");
}
// ******************** ADD ********************
Department legalDept = new Department
{
DeptName = "Legal"
};
departmentRepo.AddDepartment(legalDept); // departmentRepo has been initialized in line 13
Console.WriteLine("-------------------------------");
Console.WriteLine("Added the new Legal Department!");
Employee cherkesky = new Employee
{
FirstName = "Guy",
LastName = "Cherkesky",
DepartmentId = 2
};
employeeRepo.AddEmployee(cherkesky); // employeeRepo has been initialized in line 25
Console.WriteLine("-------------------------------");
Console.WriteLine("Added the new talented Employee!");
}
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);
}
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);
}
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();
EmployeeRepository employeeRepo = new EmployeeRepository();
Console.WriteLine("Getting all Employees:");
Console.WriteLine();
List <Employee> allEmployees = employeeRepo.GetEmployees();
foreach (Employee empl in allEmployees)
{
Console.WriteLine(empl.FirstName);
Console.WriteLine(empl.LastName);
}
Console.WriteLine("----------------------------");
Console.WriteLine("Getting Employees with Id 1");
Employee singleEmployee = employeeRepo.GetEmployeeById(1);
Console.WriteLine($"{singleEmployee.Id} {singleEmployee.FirstName} {singleEmployee.LastName}");
//public List<Employee> GetAllEmployeesWithDepartment() < ---Employee objects should have a Department property
//public void AddEmployee(Employee employee)
//public void UpdateEmployee(int id, Employee employee) < ---Use the SQL UPDATE statement
//public void DeleteEmployee(int id)
//COPY AND PASTE ABOVE THIS LINE
}
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);
}
static void Main(string[] args)
{
while (true)
{
/// users chooses from one of these prompts
Console.WriteLine("Choose from one of the options below?");
Console.WriteLine("--------------------------------------");
Console.WriteLine("1. Show all deparments");
Console.WriteLine("2. Show specific department by Id");
Console.WriteLine("3. Add new department");
Console.WriteLine("4. Update department Id");
Console.WriteLine("5. Delete department by Id");
Console.WriteLine("6. Show all employees");
Console.WriteLine("7. Show specific employee by Id");
Console.WriteLine("8. Add a new employee");
Console.WriteLine("9. Update an employee");
Console.WriteLine("10. Delete an employee");
var choice = Console.ReadLine();
DepartmentRepository departments = new DepartmentRepository();
EmployeeRepository employees = new EmployeeRepository();
switch (Int32.Parse(choice))
{
case 1:
Console.WriteLine("Getting all Departments:");
Console.WriteLine();
List <Department> allDepartments = departments.GetAllDepartments();
foreach (Department dept in allDepartments)
{
Console.WriteLine($"{dept.Id} {dept.DeptName}");
}
break;
case 2:
Console.WriteLine("Enter department Id.");
var deptChoice = int.Parse(Console.ReadLine());
Console.WriteLine($"Getting department {deptChoice}");
Department singleDepartment = departments.GetDepartmentById(deptChoice);
Console.WriteLine($"{singleDepartment.Id}. {singleDepartment.DeptName}");
break;
case 3:
Console.WriteLine("Enter the name of new department.");
var deptName = Console.ReadLine();
Department newDepartment = new Department
{
DeptName = deptName
};
departments.AddDepartment(newDepartment);
Console.WriteLine($"Add new {deptName} to Departments.");
break;
case 4:
//Console.WriteLine("Enter the name of the department you wish to update.");
//var deptName = Console.ReadLine();
break;
case 5:
Console.WriteLine("Enter the Id of the deptarment you would like to delete.");
var deleteChoice = int.Parse(Console.ReadLine());
departments.DeleteDepartment(deleteChoice);
Console.WriteLine($"Department with Id of {deleteChoice} was deleted.");
break;
case 6:
Console.WriteLine("Getting all employees");
Console.WriteLine("");
List <Employee> allEmployees = employees.GetAllEmployees();
foreach (Employee e in allEmployees)
{
Console.WriteLine($"{e.Id}. {e.FirstName} {e.LastName}");
}
break;
case 7:
Console.WriteLine("Enter employee by Id.");
var employeeId = int.Parse(Console.ReadLine());
Console.WriteLine($"Getting employee {employeeId}");
Employee singleEmployee = employees.GetEmployeeById(employeeId);
Console.WriteLine($"{singleEmployee.Id} {singleEmployee.FirstName} {singleEmployee.LastName}");
break;
case 8:
Console.WriteLine("Enter the first name of new employee.");
var eFirstName = Console.ReadLine();
Console.WriteLine("Enter the last name of new employee.");
var eLastName = Console.ReadLine();
Console.WriteLine("Enter departmentId of new employee.");
var eDeptName = int.Parse(Console.ReadLine());
Employee newEmployee = new Employee
{
FirstName = eFirstName,
LastName = eLastName,
DepartmentId = eDeptName
};
employees.AddEmployee(newEmployee);
Console.WriteLine($"Add new {eFirstName} {eLastName} to employees.");
break;
case 9:
//Console.WriteLine("Enter the name of the department you wish to update.");
//var deptName = Console.ReadLine();
break;
case 10:
Console.WriteLine("Enter the Id of the employee you would like to delete.");
var deleteEmployee = int.Parse(Console.ReadLine());
employees.DeleteEmployee(deleteEmployee);
Console.WriteLine($"Department with Id of {deleteEmployee} was deleted.");
break;
default:
break;
}
}
}
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);
}
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.DepartmentName}");
}
var hardCodedId = 3;
var departmentWithId3 = departmentRepo.GetDepartmentById(hardCodedId);
Console.WriteLine(".............................");
Console.WriteLine($"Department with Id {hardCodedId} is {departmentWithId3.DepartmentName}");
var employeeRepo = new EmployeeRepository();
List <Employee> allEmployees = employeeRepo.GetAllemployees();
foreach (Employee person in allEmployees)
{
Console.WriteLine($"{person.Id} {person.FirstName} {person.LastName} working in {person.DeptName}");
}
var employee1 = employeeRepo.GetEmployeeById(1);
Console.WriteLine(".............................");
Console.WriteLine($"Employee with Id 1 is {employee1.FirstName} {employee1.LastName} works in {employee1.DeptName}");
Console.WriteLine();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine();
//ADDING UPDATING DEPTS
//var newDept = new Department();
//Console.WriteLine("What dept would you like to add?");
//newDept.DepartmentName = Console.ReadLine();
//departmentRepo.AddDepartment(newDept);
//Console.WriteLine("what Dept Id to change?");
//var deptToUpdate = Int32.Parse(Console.ReadLine());
//Console.WriteLine("what to call it?");
//var newDeptName = Console.ReadLine();
//departmentRepo.UpdateDepartment(deptToUpdate, new Department { DepartmentName = newDeptName });
//delete department
//departmentRepo.DeleteDepartment(1);
//ADDING NEW EMPLOYEE
//employeeRepo.AddEmployee(new Employee { FirstName = "jojo", LastName = "bob", DepartmentId = 1 });
//UPDATING EMPLOYEE
// employeeRepo.UpdateEmployee(4, new Employee { FirstName = "hoho", LastName = "bob", DepartmentId = 1 });
//DELETE EMPLOYEE
employeeRepo.DeleteEmployee(4);
}
static void Main(string[] args)
{
while (true)
{
Console.WriteLine("What would you like to do?");
Console.WriteLine("");
Console.WriteLine("1. Show all departments");
Console.WriteLine("2. Show specific department by Id");
Console.WriteLine("3. Add new department");
Console.WriteLine("4. Update department information");
Console.WriteLine("5. Delete department by Id");
Console.WriteLine("6. Show all employees");
Console.WriteLine("7. Show specific employee by Id");
Console.WriteLine("8. Show all employees by department");
Console.WriteLine("9. Add new employee");
Console.WriteLine("10. Update employee information");
Console.WriteLine("11. Delete employee by Id");
var choice = Console.ReadLine();
DepartmentRepository departmentRepo = new DepartmentRepository();
EmployeeRepository employeeRepo = new EmployeeRepository();
switch (Int32.Parse(choice))
{
case 1:
Console.WriteLine("Getting All Departments:");
Console.WriteLine();
List <Department> allDepartments = departmentRepo.GetAllDepartments();
foreach (Department dept in allDepartments)
{
Console.WriteLine($"{dept.Id} {dept.DeptName}");
}
break;
case 2:
Console.WriteLine("Enter Id of department");
var departmentChoice = int.Parse(Console.ReadLine());
Console.WriteLine($"Getting department with Id of {departmentChoice}");
Department singleDepartment = departmentRepo.GetDepartmentById(departmentChoice);
Console.WriteLine($"{singleDepartment.Id} {singleDepartment.DeptName}");
break;
case 3:
Console.WriteLine("Enter the name of the new department");
var departmentName = Console.ReadLine();
Department newDepartment = new Department
{
DeptName = departmentName
};
departmentRepo.AddDepartment(newDepartment);
Console.WriteLine($"Added the new {departmentName} Department!");
break;
case 4:
Console.WriteLine("Update Department Info");
//TBD
break;
case 5:
Console.WriteLine("Enter the Id of the department you would like to delete");
var deleteDeptChoice = int.Parse(Console.ReadLine());
departmentRepo.DeleteDepartment(deleteDeptChoice);
Console.WriteLine($"Department with the Id of {deleteDeptChoice} has been deleted.");
break;
case 6:
Console.WriteLine("Getting All Employees:");
Console.WriteLine();
List <Employee> allEmployees = employeeRepo.GetAllEmployees();
foreach (Employee emp in allEmployees)
{
Console.WriteLine($"{emp.FirstName} {emp.LastName}");
}
break;
case 7:
Console.WriteLine("Enter the Id of the employee you would like to view");
var chosenEmployeeId = int.Parse(Console.ReadLine());
Employee singleEmployee = employeeRepo.GetEmployeeById(chosenEmployeeId);
Console.WriteLine($"Getting Employee with Id of {chosenEmployeeId}.");
Console.WriteLine($"{singleEmployee.Id} {singleEmployee.FirstName} {singleEmployee.LastName}");
break;
case 8:
List <Employee> allDepartmentEmployees = employeeRepo.GetAllEmployeesWithDepartment();
foreach (Employee emp in allDepartmentEmployees)
{
Console.WriteLine($"{emp.FirstName} {emp.LastName} - {emp.Department.DeptName}");
}
break;
case 9:
Console.WriteLine("Enter new employee's first name");
var newEmployeeFirstName = Console.ReadLine();
Console.WriteLine("Enter new employee's last name");
var newEmployeeLastName = Console.ReadLine();
Console.WriteLine("Enter new employee's department Id");
var newEmployeeDeptId = int.Parse(Console.ReadLine());
Employee newEmployee = new Employee
{
FirstName = newEmployeeFirstName,
LastName = newEmployeeLastName,
DepartmentId = newEmployeeDeptId
};
employeeRepo.AddEmployee(newEmployee);
Console.WriteLine($"Added {newEmployee.FirstName} {newEmployee.LastName} as a new employee!");
break;
case 10:
Console.WriteLine("Update Employee Info");
//TBD
break;
case 11:
Console.WriteLine("Enter the Id of the employee you would like to delete");
var deleteEmployeeId = int.Parse(Console.ReadLine());
employeeRepo.DeleteEmployee(deleteEmployeeId);
Console.WriteLine($"Employee with the Id of {deleteEmployeeId} has been deleted");
break;
default:
break;
}
}
}
