public DboProject CreateProject(Project project)
{
project.ProjectLeader = employeeServices.FindEmployeeById(project.ProjectLeader.Id);
project.NumberOfWeeks = HelperServices.GetWeekOfYear(project.DueDate) - HelperServices.GetWeekOfYear(project.StartDate);
context.Projects.Add(project);
context.SaveChanges();
List <DboSkill> skills = new List <DboSkill>();
foreach (var item in project.ProjectSkills)
{
Skill skill = context.Skills.Where(s => s.Id == item.SkillId).FirstOrDefault();
DboSkill dboSkill = new DboSkill()
{
Id = skill.Id,
Name = skill.Name
};
skills.Add(dboSkill);
}
DboProject dboProject = (DboProject)project;
dboProject.Skills = skills;
return(dboProject);
}
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 DboSkill EditSkill(Skill skill)
{
Skill skillToEdit = context.Skills.Where(s => s.Id == skill.Id).FirstOrDefault();
skillToEdit.Name = skill.Name;
context.SaveChanges();
DboSkill dboSkill = new DboSkill();
dboSkill.Id = skill.Id;
dboSkill.Name = skill.Name;
return(dboSkill);
}
public List <DboSkill> GetSkillsForEmployee(int employeeId)
{
List <EmployeeSkills> employeeSkills = new List <EmployeeSkills>();
List <DboSkill> dboSkills = new List <DboSkill>();
employeeSkills = context.EmployeeSkills.Where(ps => ps.EmployeeId == employeeId).Include(ps => ps.Skill).ToList();
foreach (var item in employeeSkills)
{
DboSkill dboSkill = new DboSkill();
dboSkill.Id = item.Skill.Id;
dboSkill.Name = item.Skill.Name;
dboSkills.Add(dboSkill);
}
return(dboSkills);
}
public List <DboSkill> GetSkillsForProject(int projectId)
{
List <ProjectSkills> projectSkills = new List <ProjectSkills>();
List <DboSkill> dboSkills = new List <DboSkill>();
projectSkills = context.ProjectSkills.Where(ps => ps.ProjectId == projectId).Include(ps => ps.Skill).ToList();
foreach (var item in projectSkills)
{
DboSkill dboSkill = new DboSkill();
dboSkill.Id = item.Skill.Id;
dboSkill.Name = item.Skill.Name;
dboSkills.Add(dboSkill);
}
return(dboSkills);
}
