public async Task <ActionResult <JobForEmployee> > PostJobForEmployee(JobForEmployee jobForEmployee) { _context.JobForEmployees.Add(jobForEmployee); await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(GetJobForEmployee), new { id = jobForEmployee.Id }, jobForEmployee)); }
public async Task <IActionResult> PutJobForEmployee(int id, JobForEmployee jobForEmployee) { if (id != jobForEmployee.Id) { return(BadRequest()); } _context.Entry(jobForEmployee).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!JobForEmployeeExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public static void Init(IServiceProvider serviceProvider) { using (var db = new SkillzContext(serviceProvider.GetRequiredService <DbContextOptions <SkillzContext> >())) { Employee emp1 = new Employee { Surname = "AT", FirstName = "Autotest", SecondName = "Test", Login = "******", Password = "******" }; Job job = new Job { Name = "QA automation" }; List <Skill> skills = new List <Skill>() { new Skill { Name = "Java" }, new Skill { Name = "Selenium" }, new Skill { Name = "Docker" }, new Skill { Name = "C#" }, new Skill { Name = "Python" }, new Skill { Name = "TeamCity" }, new Skill { Name = "Jenkins" }, new Skill { Name = "Selenoid" } }; db.Employees.Add(emp1); db.Jobs.Add(job); db.Skills.AddRange(skills.ToArray()); db.SaveChanges(); emp1 = db.Employees.ToList().FirstOrDefault(); job = db.Jobs.ToList().FirstOrDefault(); JobForEmployee jfe = new JobForEmployee { EmployeeId = emp1.Id, JobId = job.Id }; db.JobForEmployees.Add(jfe); db.SaveChanges(); skills = db.Skills.ToList(); foreach (var s in skills) { db.SkillsForJobs.Add(new SkillsForJob { JobId = job.Id, SkillId = s.Id }); } foreach (var s in skills) { if (s.Name == "Python") { db.EmployeeSkills.Add(new EmployeeSkill { EmployeeId = emp1.Id, SkillId = s.Id, Level = EmployeeSkill.State.None }); } else if (s.Name == "Docker" || s.Name == "Java") { db.EmployeeSkills.Add(new EmployeeSkill { EmployeeId = emp1.Id, SkillId = s.Id, Level = EmployeeSkill.State.Learn }); } else { db.EmployeeSkills.Add(new EmployeeSkill { EmployeeId = emp1.Id, SkillId = s.Id, Level = EmployeeSkill.State.Complete }); } } db.SaveChanges(); } }