public static void Main(string[] args)
{
var employeesWithProjectAfter = FindEmployeesWithProjectStartAfterDate(2002);
foreach (var employee in employeesWithProjectAfter)
{
Console.WriteLine(employee.FirstName + ' ' + employee.LastName);
}
var employeesWithProjectAfterNative = FindEmployeesWithProjectStartAfterDateNative(2002);
foreach (var employee in employeesWithProjectAfterNative)
{
Console.WriteLine(employee.FirstName + ' ' + employee.LastName);
}
var employeesByDepartmentAndManager = FindEmployeesByDeparmentAndManager("Sales", Softuni.Employees.Find(273));
foreach (var employee in employeesByDepartmentAndManager)
{
Console.WriteLine(employee.FirstName + ' ' + employee.LastName);
}
var employees = Softuni.Employees.Where(e => new[] { 1, 5, 22, 83 }.Contains(e.EmployeeID)).ToList();
var newProject = new Project { Description = "Description Test", Employees = employees, StartDate = new DateTime(2014, 1, 2), Name = "Test" };
InsertProject(newProject);
var projects = Softuni.usp_getAllProjectsForEmployee("Guy", "Gilbert");
foreach (var project in projects)
{
Console.WriteLine(project.Name + "---" + project.Description);
}
}
private static Project InsertProject(Project newProject)
{
var insertedProject = Softuni.Projects.Add(newProject);
Softuni.SaveChanges();
return insertedProject;
}
