public void DeleteSkill(int skillid) { Skill skillToDelete = context.Skills.Where(s => s.Id == skillid).FirstOrDefault(); context.Skills.Remove(skillToDelete); context.SaveChanges(); }
public DboEmployee CreateEmployee(Employee employee) { context.Employees.Add(employee); context.SaveChanges(); List <DboSkill> skills = new List <DboSkill>(); foreach (var item in employee.EmployeeSkills) { Skill skill = context.Skills.Where(s => s.Id == item.SkillId).FirstOrDefault(); DboSkill dboSkill = new DboSkill() { Id = skill.Id, Name = skill.Name }; skills.Add(dboSkill); } DboEmployee dboEmployee = (DboEmployee)employee; dboEmployee.Skills = skills; return(dboEmployee); }
public ProjectIDEmployee AddEmployeeToProject(ProjectIDEmployee projectIDEmployee) { Project project = context.Projects.Include(p => p.EmployeeProjectHourPerWeeks).Where(p => p.Id == projectIDEmployee.ProjectId).FirstOrDefault(); Employee employee = employeeServices.FindEmployeeById(projectIDEmployee.EmployeeId); List <HourPerWeek> hours = (List <HourPerWeek>)GetEmployeesHoursPerWeek(projectIDEmployee.EmployeeId, projectIDEmployee.ProjectId); int current = 0; foreach (var item in hours) { current += item.Hour; } project.CurrentHours = current; EmployeeProjectHourPerWeeks employeeProjectHourPerWeeks = new EmployeeProjectHourPerWeeks(); employeeProjectHourPerWeeks.Employee = employee; employeeProjectHourPerWeeks.Project = project; employeeProjectHourPerWeeks.HoursPerWeeks = hours; employee.EmployeeProjectHourPerWeeks.Add(employeeProjectHourPerWeeks); project.EmployeeProjectHourPerWeeks.Add(employeeProjectHourPerWeeks); context.SaveChanges(); context.SaveChanges(); return(projectIDEmployee); }
public int Save() { try { return(_context.SaveChanges()); } catch (DbEntityValidationException e) { throw e; } }
public void InitializeDatabase() { if (!context.Skills.Any()) { var skills = new List <Skill> { new Skill { Name = "C# Junior developer" }, new Skill { Name = "C# Senior developer" }, new Skill { Name = "Java Junior developer" }, new Skill { Name = "Java Senior developer" }, new Skill { Name = "Python Junior developer" }, new Skill { Name = "Python Senior developer" }, new Skill { Name = "Angular Junior developer" }, new Skill { Name = "Angular Senior developer" }, new Skill { Name = "C++ Junior developer" }, new Skill { Name = "C++ Senior developer" }, new Skill { Name = "C Junior developer" }, new Skill { Name = "C Senior developer" }, new Skill { Name = "Ruby Junior developer" }, new Skill { Name = "Ruby Senior developer" }, new Skill { Name = "JavaScript Junior developer" }, new Skill { Name = "JavaScript Senior developer" } }; context.AddRange(skills); } if (!context.Employees.Any()) { var emloyees = new List <Employee> { new Employee { Name = "Tóth Tibor", Email = "*****@*****.**", EmployeeProjectHourPerWeeks = new List <EmployeeProjectHourPerWeeks>() }, new Employee { Name = "Ferenczi Judit", Email = "*****@*****.**", EmployeeProjectHourPerWeeks = new List <EmployeeProjectHourPerWeeks>() }, new Employee { Name = "Ambrus Attila", Email = "*****@*****.**", EmployeeProjectHourPerWeeks = new List <EmployeeProjectHourPerWeeks>() }, new Employee { Name = "Kellner Menyhárt", Email = "*****@*****.**", EmployeeProjectHourPerWeeks = new List <EmployeeProjectHourPerWeeks>() } }; context.AddRange(emloyees); } if (!context.Projects.Any()) { var projects = new List <Project> { new Project { Name = "Project X", Company = "DreamWorks", Risk = 0.1, StartDate = DateTime.Now, DueDate = new DateTime(2019, 01, 01), CurrentHours = 0, ProjectLeader = new Employee(), PlannedHours = 200, EmployeeProjectHourPerWeeks = new List <EmployeeProjectHourPerWeeks>() }, new Project { Name = "Man on the mooN", Company = "GraphiSoft", Risk = 0.1, StartDate = DateTime.Now, DueDate = new DateTime(2019, 01, 01), CurrentHours = 0, ProjectLeader = new Employee(), PlannedHours = 200, EmployeeProjectHourPerWeeks = new List <EmployeeProjectHourPerWeeks>() }, new Project { Name = "Monitor", Company = "LG", Risk = 0.1, StartDate = DateTime.Now, DueDate = new DateTime(2019, 01, 01), CurrentHours = 0, ProjectLeader = new Employee(), PlannedHours = 200, EmployeeProjectHourPerWeeks = new List <EmployeeProjectHourPerWeeks>() } }; context.AddRange(projects); } context.SaveChanges(); }