public static void DisplayDepartmentEmp()
{
DBfirstDemoEntities db = new DBfirstDemoEntities();
try
{
Console.WriteLine("enter the department id according to the following table:");
var deptlist = db.Departments;
var emplist = db.Employees;
foreach (var dep1 in deptlist)
{
Console.WriteLine(dep1.ID + " " + dep1.Name);
}
int identity = int.Parse(Console.ReadLine());
Department dep = db.Departments.FirstOrDefault(x => x.ID == identity);
Console.WriteLine("Department: " + dep.Name);
Console.WriteLine(" Employees:");
Console.WriteLine("\t ID \t FirstName \t LastName \t Gender \t Salary");
foreach (var emp1 in emplist)
{
if (emp1.DepartmentID == dep.ID)
{
Console.WriteLine($"\t {emp1.ID} \t {emp1.FirstName} \t\t {emp1.LastName} \t {emp1.Gender} \t\t {emp1.Salary}");
}
}
}
catch (Exception e)
{
Console.WriteLine("error:" + e.Message);
}
}
public static void DisplayEmployee()
{
using (var db = new DBfirstDemoEntities())
{
var deptlist = db.Departments;
var emplist = db.Employees;
Console.WriteLine("ID \t FirstName \t LastName \t Gender \t Salary \t DepartmentID");
foreach (var emp in emplist)
{
Console.WriteLine($"{emp.ID} \t {emp.FirstName} \t\t {emp.LastName} \t {emp.Gender} \t\t {emp.Salary} \t\t\t {emp.DepartmentID}");
}
}
}
public static void InsertEmployee()
{
Console.WriteLine("enter firstname,lastname,gender,salary and department of of an employee");
Employee e = new Employee();
e.FirstName = Console.ReadLine();
e.LastName = Console.ReadLine();
e.Gender = Console.ReadLine();
e.Salary = int.Parse(Console.ReadLine());
e.DepartmentID = int.Parse(Console.ReadLine());
DBfirstDemoEntities db = new DBfirstDemoEntities();
db.Employees.Add(e);
db.SaveChanges();
}
public static void DeleteEmployee()
{
DBfirstDemoEntities db = new DBfirstDemoEntities();
try
{
Console.WriteLine("enter the id to update");
int identity = int.Parse(Console.ReadLine());
Employee emp = db.Employees.First(x => x.ID == identity);
db.Employees.Remove(emp);
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("error:" + e.Message);
}
}
public static void UpdateEmployee()
{
DBfirstDemoEntities db = new DBfirstDemoEntities();
try
{
Console.WriteLine("enter the id to update");
int identity = int.Parse(Console.ReadLine());
Employee emp = db.Employees.First(x => x.ID == identity);
Console.WriteLine("enter firstname,lastname,gender,salary,department id");
emp.FirstName = Console.ReadLine();
emp.LastName = Console.ReadLine();
emp.Gender = Console.ReadLine();
emp.Salary = int.Parse(Console.ReadLine());
emp.DepartmentID = int.Parse(Console.ReadLine());
db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("error:" + e.Message);
}
}