// Removes a TeamMember from a Team without deleteing them from the database public DbError RemoveTeamMemeber(TeamMemberModel teamMember) { try { context.Teams.Find(teamMember.TeamID).TeamMembers.Remove(teamMember); teamMember.DateLeft = DateTime.Now; context.SaveChanges(); } catch (Exception ex) { interfaceException = ex; WriteException(ex); throw; return(DbError.FAILED_TO_REMOVE); } return(DbError.SUCCESS); }
// Removes a TeamMember from a Team and deletes them from the database public DbError DeleteTeamMember(TeamMemberModel teamMember) { TeamMemberModel _teamMember = new TeamMemberModel(); try { _teamMember = context.TeamMembers.Single(x => x.Team.TeamID == teamMember.TeamID && x.User.UserID == teamMember.UserID); context.TeamMembers.Remove(_teamMember); context.SaveChanges(); } catch (Exception ex) { interfaceException = ex; WriteException(ex); return(DbError.FAILED_TO_DELETE); } return(DbError.SUCCESS); }
// Takes in a fully filled out TeamMember and adds it to the database public DbError AddTeamMember(TeamMemberModel teamMember) { try { context.TeamMembers.Add(teamMember); //UserModel user = new UserModel(); //user = context.Users.Find(teamMember.User.UserID); teamMember.User.Teams.Add(context.Teams.Find(teamMember.Team.TeamID)); //teamMember.User.Teams.Add(teamMember.Team); context.Teams.Find(teamMember.TeamID).TeamMembers.Add(teamMember); context.SaveChanges(); } catch (Exception ex) { interfaceException = ex; WriteException(ex); return(DbError.FAILED_TO_ADD); } return(DbError.SUCCESS); }