public static bool EditEmployeeProjTeamXref(Models.Employee employee)
{
try
{
EmployeeProjTeamXref employeeProjTeamXref = _db.EmployeeProjTeamXrefs.FirstOrDefault(emp => emp.EmployeeId == employee.EmployeeId);
employeeProjTeamXref.EmployeeId = employee.EmployeeId;
employeeProjTeamXref.ProjectId = _db.Projects.FirstOrDefault(proj => proj.ProjectName.Equals(employee.Project))?.ProjectId;
employeeProjTeamXref.TeamId = _db.Teams.FirstOrDefault(team => team.TeamName.Equals(employee.Team))?.TeamId;
_db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public static bool DeleteEmployeeProjTeamXref(Models.Employee employee)
{
try
{
EmployeeProjTeamXref employeeProjTeamXref = new EmployeeProjTeamXref();
employeeProjTeamXref.EmployeeId = employee.EmployeeId;
employeeProjTeamXref.ProjectId = _db.Projects.FirstOrDefault(proj => proj.ProjectName.Equals(employee.Project))?.ProjectId;
employeeProjTeamXref.TeamId = _db.Teams.FirstOrDefault(team => team.TeamName.Equals(employee.Team))?.TeamId;
employeeProjTeamXref.EmployeeProjXrefId = _db.EmployeeProjTeamXrefs.FirstOrDefault(eptXref => eptXref.EmployeeId == employeeProjTeamXref.EmployeeId &&
employeeProjTeamXref.ProjectId != null && eptXref.ProjectId == employeeProjTeamXref.ProjectId &&
employeeProjTeamXref.TeamId != null && eptXref.TeamId == employeeProjTeamXref.TeamId).EmployeeProjXrefId;
_db.EmployeeProjTeamXrefs.Remove(employeeProjTeamXref);
_db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
