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