MOD: Add DeleteUser functionality : The Official Microsoft ASP.NET Forums

Reply

G Andrew Dut...

Member

227 Points

46 Posts

ASPInsiders

MOD: Add DeleteUser functionality

Apr 04, 2003 09:51 PM|LINK

UPDATE: One thing I forgot to mention in the post below is that the modification described will apply to all communities within the CSK install that you modify. Greetings all, At the risk of having this obsoleted by the next release of the CSK, here are the steps required to add the ability to delete users from the Edit Users administration section (these instructions are for the VBSDK version, but the others should be similar): - Modify the file Default.aspx, located in \CommunityStarterKitVBSDK\Admin\EditUsers\, as follows(note the comments, and that this code also includes a modification to display all users by default, rather than just those beginning with 'a'):

<script runat=>


    Sub OrderChanged(s As Object, e As EventArgs)
         UserList.CurrentPageIndex = 0
    End Sub 'OrderChanged

    

    

    Sub UserList_PageIndexChanged(s As Object, e As DataGridPageChangedEventArgs)
         UserList.CurrentPageIndex = e.NewPageIndex
    End Sub 'UserList_PageIndexChanged

    

    

    '*******************************************************
    '
    ' Bind matching users to DataGrid.
    '
    '*******************************************************
    Protected Overrides Sub OnPreRender(e As EventArgs)
         UserList.DataSource = AdminUtility.GetUsersForLetter(ctlAlphaPicker.SelectedLetter, Int32.Parse(dropSortBy.SelectedItem.Value), Int32.Parse(dropOrderBy.SelectedItem.Value))
         UserList.DataBind()
    End Sub 'OnPreRender

</script>
"Edit Users" Runat="Server"/>


"75%" cellspacing="0" cellpadding="0" border="0">

"left" valign="top">

Edit Users






The Edit Users page allows you to add, edit, delete, or view information about the users in your community.
You can view all users at once, or alphabetically by letter. Furthermore, you can sort your results by username, the user's full name, or by the date joined.
To edit a user, click on the desired username.






From this page, you can also create, edit, or delete roles for your users. Roles can be used to prohibit all but selected users from secure areas in your community.
For example, you may want to only allow users with 'Gold' book club status to access the book club community. To create a new role, click the
Edit Role link.








       <form runat=>
        "100%">
         
            
            
                 by default. Original Tag below.
               "ctlAlphaPicker" OnLetterChanged="OrderChanged" Runat="Server" />
            --%>
            "ctlAlphaPicker" SelectedLetter="All" OnLetterChanged="OrderChanged" Runat="Server" />
            
            
            Sort By:
            "dropSortBy" AutoPostBack="True" OnSelectedIndexChanged="OrderChanged" Runat="Server">
              "Username" Value="0"/>
              "Full Name" Value="1"/>
              "Date Joined" Value="2"/>
            
            
            
            Order By:
            "dropOrderBy" AutoPostBack="True" OnSelectedIndexChanged="OrderChanged" Runat="Server">
              "Ascending" value="0" />
              "Descending" value="1" />
            
            
         
         
        


        "UserList"
width="100%" AutoGenerateColumns="False" AllowPaging="True" OnPageIndexChanged="UserList_PageIndexChanged" PageSize="20"
PagerStyle-Mode="NumericPages" BorderColor="#999999" BorderStyle="None"
BorderWidth="1px" BackColor="White"
CellPadding="3"
GridLines="Vertical" Runat="Server">
        "True" BackColor="#DCDDDE">
        
        "#dddddd">
        
            "User_Username" DataNavigateUrlField="User_Username" DataNavigateUrlFormatString="EditUser.aspx?username={0}" HeaderText="Username"/>
            "FullName" HeaderText="Full Name"/>
            "User_DateCreated" DataFormatString="{0:d}" HeaderText="Date Joined"/>
            
            "Delete User" DataNavigateUrlField="User_Username" DataNavigateUrlFormatString="DeleteUser.aspx?username={0}" HeaderText="Delete?"/>
        
        
        


        

        "3" cellspacing="0" border="0" class="body">
        
            "EditRoles.aspx">Edit Roles
            |
            "..\Default.aspx">Return to Admin
            |
            "..\..\Default.aspx">Return to Site
        
        
        

        </form>

- Add a file called DeleteUser.aspx, containing the following code, to the \CommunityStarterKitVBSDK\Admin\EditUsers\ folder:

<%@ Page Language="VB" smartnavigation="true" %>
<%@ Register TagPrefix="community" Namespace="ASPNET.StarterKit.Communities" Assembly="ASPNET.StarterKit.Communities" %>
<%@ Register TagPrefix="communityAdmin" TagName="RolePicker" Src="..\Controls\RolePicker.ascx" %>
<%@ Register TagPrefix="User" TagName="AdminHeader" Src="~/Admin/Controls/AdminHeader.ascx" %>
<%@ import Namespace="ASPNET.StarterKit.Communities.Admin" %>
<script runat=>

    '*******************************************************
    '
    ' When the page first loads, set the username label
    ' text and the domain label text to the appropriate
    ' values.
    '
    '*******************************************************
    Sub Page_Load(s As Object, e As EventArgs)
         If Not Page.IsPostBack Then
            'Note that if we were storing this value in a database
            '  we would need to check it for script or other unexpected input!
            UserName.Text = Request.QueryString("username")
            Domain.Text = CommunityUtility.GetCommunityInfo().Domain
         End If
    End Sub 'Page_Load
    
        
    '*******************************************************
    '
    ' Delete the user from the database.
    '
    '*******************************************************
    Sub btnDelete_Click(s As Object, e As EventArgs)
       Try
          UserUtility.DeleteUser(Request.QueryString("username"))
       Catch ex As Exception
          ErrorUtility.RecordError("DeleteUser Error", ex)
       End Try
       Response.Redirect("Default.aspx")
    End Sub 'btnDelete_Click

</script>
"Delete User" Runat="Server" />
Delete User from "Domain" runat="server"/>

 On this page, you can delete a user's profile.

<form runat=>
 
  
   To delete user "UserName" runat="server"/> from this community, click the Delete User button below.
  
 
  "btnDelete" Text="Delete User" OnClick="btnDelete_Click" Runat="Server" />
</form>
"3" cellspacing="0" border="0" class="body">
 
  "Default.aspx">Return to Edit Users
  |
  "..\Default.aspx">Return to Admin
  |
  "..\..\Default.aspx">Return to Site

- Add the following method to the file UserUtility.vb, located in \Source\Engine\Framework\Users\Components\ (note that this will require recompiling the Community codebase, which you can do using the BuildAll.bat file located in the \Source\Engine\ folder):

    '*********************************************************************
    '
    ' DeleteUser Method
    '
    ' Deletes a user from the database.
    '
    ' Added by G. Andrew Duthie on 4/4/2003
    '
    '*********************************************************************
    Public Shared Sub DeleteUser(UserName As String)
        Dim conPortal As New SqlConnection(CommunityGlobals.ConnectionString)
        Dim cmdUpdate As New SqlCommand("Community_UsersDeleteUser", conPortal)
        cmdUpdate.CommandType = CommandType.StoredProcedure
        cmdUpdate.Parameters.Add("@communityID", CommunityGlobals.CommunityID)
        cmdUpdate.Parameters.Add("@userName", UserName)
        
        conPortal.Open()
        cmdUpdate.ExecuteNonQuery()
        conPortal.Close()
    End Sub 'DeleteRole

- Add a Stored Procedure to the CommunityStarterKit database called Community_UsersDeleteUser, as follows:

CREATE PROCEDURE Community_UsersDeleteUser 
(
  @communityID int,
  @userName NVarchar(50)
)
AS
DELETE Community_UsersInRoles 
WHERE UserRoles_UserName = @userName 
AND UserRoles_CommunityID = @communityID 

DELETE Community_Users 
WHERE User_UserName = @userName 
AND User_CommunityID = @communityID
GO

WARNING: Use the modification code at your own risk! It has not been tested nor checked by any eyes other than my own, so it's entirely possible that there could be a bug or two. If you find any bugs, please let me know on this thread. I also plan to write a more detailed explanation of this modification on my Web site. Color-coding courtesy of: Mark-up ASP.net posts here MarkItUp.com hth, G. Andrew Duthie

My Blog

Code Camps in the Mid-Atlantic

Reply

thecrispy1

Star

12167 Points

2434 Posts

MVP

Re: MOD: Add DeleteUser functionality

Apr 05, 2003 03:32 AM|LINK

Thanks for the addition. I am playing around with the kit, only for one community though. I will try it out and let you know how it is going.

Chris Paterra

Reply

clauer@dotne...

Member

90 Points

18 Posts

Microsoft

Re: MOD: Add DeleteUser functionality

Apr 12, 2003 10:04 AM|LINK

Thank you for this useful piece of code. Before i go and translate this in C# (i use the CS SDK version), has anyone already done the job? It would save me precious time... Thanks in advance,

Christophe Lauer - http://www.dotnet-fr.org

Reply

Jay Miller

Member

20 Points

4 Posts

Re: MOD: Add DeleteUser functionality

Apr 15, 2003 11:49 AM|LINK

Christopher, Have you translated this to C# yet (or found someone else that has)? If so, could you please forward me the code. Thanks. Jay jmiller@astradigital.com

Reply

stylesie

Member

56 Points

13 Posts

C# Translation: MOD: Add DeleteUser functionality

May 11, 2003 04:32 AM|LINK

Heres the "Delete user translastion" in C#. Everything else is just the same for VB or C#. //********************************************************************* // // DeleteUser Method // // Deletes a user from the database. // //********************************************************************* public static void DeleteUser(string username) { SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString); SqlCommand cmdUpdate = new SqlCommand("Community_UsersDeleteUser", conPortal); cmdUpdate.CommandType = CommandType.StoredProcedure; cmdUpdate.Parameters.Add("@communityID", CommunityGlobals.CommunityID); cmdUpdate.Parameters.Add("@username", username); conPortal.Open(); cmdUpdate.ExecuteNonQuery(); conPortal.Close(); }

Colin Styles.

DipIT(AP)

Reply

stylesie

Member

56 Points

13 Posts

Re: C# Translation: MOD: Add DeleteUser functionality

May 13, 2003 12:04 AM|LINK

//******************************************************* // // When the page first loads, set the username label // // text and the domain label text to the appropriate // // values. // //******************************************************* private void Page_Load(object sender, System.EventArgs e) { if (!Page.IsPostBack) { // Note that if we were storing this value in a database // we would need to check it for script or other unexpected input! UserName.Text = Request.QueryString("username") Domain.Text = CommunityUtility.GetCommunityInfo().Domain } } //******************************************************* // // Delete the user from the database. // //******************************************************* private void btnDelete_Click(object sender, System.EventArgs e) { try { UserUtility.DeleteUser(Request.QueryString("username")) } catch ( Exception ex ) { ErrorUtility.RecordError("DeleteUser Error", ex) } Response.Redirect("Default.aspx") }

Colin Styles.

DipIT(AP)

Reply

haydenmead

Member

10 Points

2 Posts

Re: MOD: Add DeleteUser functionality

May 14, 2003 11:41 AM|LINK

I wonder if you could offer any help? Everything works up until I try and use the buildall.bat file when i get an error bc0212, it is unable to write to a dll. When I go into the community admin and try and delete a user i get a compilation error with the message underneath. Can anyone offer any advice to a complete newbie! Cheers, H C:\WINDOWS\system32> "c:\windows\microsoft.net\framework\v1.0.3705\vbc.exe" /t:library /utf8output /R:"c:\windows\microsoft.net\framework\v1.0.3705\temporary asp.net files\root\a9a90ba7\9420fe86\assembly\dl\700e9e34\00d0effc_d8cdc201\aspnet.starterkit.communities.dll" /R:"c:\windows\assembly\gac\system.web\1.0.3300.0__b03f5f7f11d50a3a\system.web.dll" /R:"c:\windows\assembly\gac\system.xml\1.0.3300.0__b77a5c561934e089\system.xml.dll" /R:"c:\windows\assembly\gac\system.data\1.0.3300.0__b77a5c561934e089\system.data.dll" /R:"c:\windows\microsoft.net\framework\v1.0.3705\temporary asp.net files\root\a9a90ba7\9420fe86\wj53aoau.dll" /R:"c:\windows\assembly\gac\system.drawing\1.0.3300.0__b03f5f7f11d50a3a\system.drawing.dll" /R:"c:\windows\assembly\gac\system\1.0.3300.0__b77a5c561934e089\system.dll" /R:"c:\windows\assembly\gac\system.enterpriseservices\1.0.3300.0__b03f5f7f11d50a3a\system.enterpriseservices.dll" /R:"c:\windows\assembly\gac\system.web.services\1.0.3300.0__b03f5f7f11d50a3a\system.web.services.dll" /out:"C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET Files\root\a9a90ba7\9420fe86\jztz8jd0.dll" /debug- /win32resource:"C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET Files\root\a9a90ba7\9420fe86\jztz8jd0.res" "C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705\Temporary ASP.NET Files\root\a9a90ba7\9420fe86\jztz8jd0.0.vb" Microsoft (R) Visual Basic .NET Compiler version 7.00.9466 for Microsoft (R) .NET Framework version 1.00.3705 Copyright (C) Microsoft Corporation 1987-2001. All rights reserved. C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter Kit (VBSDK)\CommunityStarterKitVBSDK\Admin\EditUsers\DeleteUser.aspx(63) : error BC30456: 'DeleteUser' is not a member of 'ASPNET.StarterKit.Communities.UserUtility'. UserUtility.DeleteUser(Request.QueryString("username"))