membership plugin

Question

User1519602350 posted

Code:

if (IsPost && Validation.IsValid()) {
        var username = Request["UserName"];
        var password = Request["Password"];
        WebSecurity.CreateUserAndAccount(username, password);
        Roles.AddUsersToRoles(new[] { username }, new[] { "Author" });
        Response.Redirect("~/Admin");
    }

Requirement:

I am using webpages membership plugin. Above is my code,  i would like to include duplicate username check model state error. Please help me on this,

Thanks

Answer 1

User-1438792522 posted

Hi see this sample

http://www.aspdotnet-suresh.com/2012/01/programmatically-create-users-in-aspnet.html

Answer 2

User540310021 posted

            var username = Request["UserName"];
            var password = Request["Password"];

            var db = Database.Open("yourdatabase");
           
            // Check if user already exists
            var user = db.QuerySingle("SELECT UserName FROM Yourtable WHERE LOWER(UserName) = LOWER(@0)", username);  
            
            if(user == null){

                WebSecurity.CreateUserAndAccount(username, password);
                Roles.AddUsersToRoles(new[] { username }, new[] { "Author" });
                Response.Redirect("~/Admin");

            }  
            else{
                ModelState.AddFormError("username already in use");
            }