static void ReadDatabase()
{
using (var context = new PcrmContext())
{
Console.WriteLine("Employees:");
foreach (var e in context.Employees.ToList())
{
Console.WriteLine($" Employee #{e.Id}: {e.Firstname} {e.Lastname}");
foreach (var pro in e.Projects)
{
Console.WriteLine($" -{pro.Name}");
}
}
Console.WriteLine("Projects:");
foreach (var p in context.Projects.ToList())
{
Console.WriteLine($" Project #{p.Id}: {p.Name} - {p.Description}");
Console.Write("=> ");
foreach (var emp in p.Employees)
{
Console.Write($"{emp.Firstname} {emp.Lastname}, ");
}
Console.WriteLine();
}
}
}
public Employee GetEmployee(int id)
{
using (_context = new PcrmContext())
{
return(_context.Employees.Find(id));
}
}
private static void InsertEmployee()
{
Employee emp = new Employee
{
Firstname = "Ordos",
Lastname = "Feuermensch",
Department = "Zeitlose Insel",
Salary = 80
};
using (var context = new PcrmContext())
{
var project = context.Projects.Find(1);
emp.Projects.Add(project);
if (context.Employees.Where(e => e.Firstname.Equals(emp.Firstname)).Any())
{
context.Employees.Add(emp);
context.SaveChanges();
}
}
}
