public static void AddProject(
            string name,
            string description,
            DateTime startDate,
            List<int> employeesId = null,
            DateTime? endDate = null)
        {
            var db = new SoftUniEntities1();
            var employees = new List<Employee>();

            foreach (var employeeId in employeesId)
            {
                var employee = db.Employees
                    .Where(e => e.EmployeeID == employeeId)
                    .FirstOrDefault();

                if (employee != null)
                {
                    employees.Add(employee);
                }
            }

            var project = new Project
            {
                Name = name,
                Description = description,
                StartDate = startDate,
                EndDate = endDate,
                Employees = employees
            };

            db.Projects.Add(project);
            db.SaveChanges();
            Console.WriteLine("Project added");
        }
Exemple #2
0
        public static void AddNewProject(
            string projectName,
            DateTime startDate,
            DateTime? endDate = null,
            string projectDescription = null,
            params int[] employeesId
            )
        {
            var project = new Project
            {
                Name = projectName,
                Description = projectDescription,
                StartDate = startDate,
                EndDate = endDate,
            };

            using (var db = new SoftUniEntities())
            {

                foreach (var id in employeesId)
                {
                    project.Employees.Add(db.Employees.Find(id));
                }

                db.Projects.Add(project);
                db.SaveChanges();
            }
        }