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();
}
