public PipelineRole GetRoleInOrganization(Guid organizationId)
        {
            if (OrganizationUsers == null)
            {
                OrganizationUsers = new List <OrganizationUser>();
            }

            OrganizationUser organizationUser = OrganizationUsers.FirstOrDefault(x => x.OrganizationId == organizationId);

            if (organizationUser == null)
            {
                return(PipelineRole.None);
            }

            return(organizationUser.Role);
        }
        public List <Organization> FindOrganizations()
        {
            if (OrganizationUsers == null)
            {
                OrganizationUsers = new List <OrganizationUser>();
            }

            List <Organization> organizations = new List <Organization>();

            organizations = OrganizationUsers.Select(x => x.Organization).ToList();

            var organizationsProjects = ProjectUsers.Where(x => x.Project.Status == EntityStatus.Active).Select(x => x.Project.Organization);

            organizations.AddRange(organizationsProjects);

            return(organizations.Distinct().ToList());
        }
        /// <summary>
        /// Get Organization Users/Followers
        /// GET /organizations/{OrganizationId}/users
        /// </summary>
        public object Get(OrganizationUsers request)
        {
            var query = string.Format("select u.*, sp.Name as StateProvinceName, sp.Abbreviation as StateProvinceAbbreviation " +
                "from User u " +
                "inner join OrganizationAlly oa " +
                "on u.Id = oa.UserId " +
                "left join StateProvince sp " +
                "on u.StateProvinceId = sp.Id " +
                "where oa.OrganizationId = {0}", request.OrganizationId);

            var users = Db.Select<UserDto>(query);

            return new OrganizationUsersResponse
            {
                Users = users
            };
        }