public void ViewDepts() { EmpDeptEntities con = new EmpDeptEntities(); var Departments = con.Departments; foreach (var dept in Departments) { Console.WriteLine($"{dept.Id} - {dept.Name}"); } }
public void DisplayAllEmp() { EmpDeptEntities con = new EmpDeptEntities(); var Departments = con.Departments; var Employees = con.Employees; foreach (Department dept in Departments) { Console.WriteLine($"{dept.Name}-{dept.Location}"); Console.WriteLine("Id\tFirst Name\tLast Name\tGender\tSalary"); foreach (var emp in Employees) { if (emp.DepartmentId == dept.Id) { Console.WriteLine($"{emp.Id}\t{emp.FirstName}\t\t{emp.LastName}\t\t{emp.Gender}\t{emp.Salary}"); } } } }