public static void AddEmployee(Employee employee, Dictionary <Skill, int> employeeskill) //Добавление нового сотрудника. На вход даётся объект сотрудник и словарь объектов Навык и значение в какой степени сотрудник им владеет { if (context.Employees.Where(x => x.FirstName == employee.FirstName && x.SecondName == employee.SecondName && x.Patronymic == employee.Patronymic).FirstOrDefault() == null) //.Where(x=>x.FirstName==employee.FirstName && x.SecondName==employee.SecondName)) { context.Employees.Add(employee); context.SaveChanges(); EmployeeSkill employeeSkill = new EmployeeSkill(); foreach (var skill in employeeskill) { employeeSkill.Employee = context.Employees.Where(x => x.EmployeeId == context.Employees.Count()).FirstOrDefault(); employeeSkill.Skill = skill.Key; employeeSkill.SkillPoint = skill.Value; context.EmployeeSkills.Add(employeeSkill); context.SaveChanges(); } } return; }
public static void AddEmployee(Employee employee, Dictionary <Skill, int> employeeskill) { if (context.Employees.Where(x => x.FirstName == employee.FirstName && x.SecondName == employee.SecondName && x.Patronymic == employee.Patronymic).FirstOrDefault() == null)//.Where(x=>x.FirstName==employee.FirstName && x.SecondName==employee.SecondName)) { context.Employees.Add(employee); context.SaveChanges(); //Employee employee1 = context.Employees.Where(x => x.EmployeeId == context.Employees.Count()).FirstOrDefault(); EmployeeSkill employeeSkill = new EmployeeSkill(); foreach (var skill in employeeskill) { employeeSkill.Employee = context.Employees.Where(x => x.EmployeeId == context.Employees.Count()).FirstOrDefault(); employeeSkill.Skill = skill.Key; employeeSkill.SkillPoint = skill.Value; context.EmployeeSkills.Add(employeeSkill); context.SaveChanges(); } } return; }