public string[] FindUsersInRole(string p_RoleName, string p_usernameToMatch)
    {
        IDataReader l_RoleReader = new RoleProviderDA().FindUsersInRole(p_RoleName, p_usernameToMatch);

        List <string> l_Users = new List <string>();

        if (l_RoleReader != null)
        {
            if (((System.Data.SqlClient.SqlDataReader)l_RoleReader).HasRows)
            {
                while (l_RoleReader.Read())
                {
                    l_Users.Add(l_RoleReader.GetString(13));
                }

                if (!l_RoleReader.IsClosed)
                {
                    l_RoleReader.Close();
                }
            }
        }

        return(l_Users.ToArray());
    }
    public string[] GetAllRolesNames()
    {
        IDataReader l_RoleReader = new RoleProviderDA().GetAllRolesNames();

        List <string> l_Roles = new List <string>();

        if (l_RoleReader != null)
        {
            if (((System.Data.SqlClient.SqlDataReader)l_RoleReader).HasRows)
            {
                while (l_RoleReader.Read())
                {
                    l_Roles.Add(l_RoleReader.GetString(1));
                }

                if (!l_RoleReader.IsClosed)
                {
                    l_RoleReader.Close();
                }
            }
        }

        return(l_Roles.ToArray());
    }
    public string[] GetAllRolesNames()
    {
        IDataReader l_RoleReader = new RoleProviderDA().GetAllRolesNames();

        List<string> l_Roles = new List<string>();
        if (l_RoleReader != null)
        {
            if (((System.Data.SqlClient.SqlDataReader)l_RoleReader).HasRows)
            {
                while (l_RoleReader.Read())
                {
                    l_Roles.Add(l_RoleReader.GetString(1));
                }

                if (!l_RoleReader.IsClosed)
                {
                    l_RoleReader.Close();
                }
            }
        }

        return l_Roles.ToArray();
    }
    public string[] FindUsersInRole(string p_RoleName, string p_usernameToMatch)
    {
        IDataReader l_RoleReader = new RoleProviderDA().FindUsersInRole(p_RoleName, p_usernameToMatch);

        List<string> l_Users = new List<string>();
        if (l_RoleReader != null)
        {
            if (((System.Data.SqlClient.SqlDataReader)l_RoleReader).HasRows)
            {
                while (l_RoleReader.Read())
                {
                    l_Users.Add(l_RoleReader.GetString(13));
                }

                if (!l_RoleReader.IsClosed)
                {
                    l_RoleReader.Close();
                }
            }
        }

        return l_Users.ToArray();
    }