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