protected void UsersGridView_RowDeleting(object sender, GridViewDeleteEventArgs e) { int selectedRow = e.RowIndex; string UserID = UsersGridView.DataKeys[selectedRow].Values["Id"].ToString(); using (userConnection db = new userConnection()) { AspNetUser deletedUser = (from users in db.AspNetUsers where users.Id == UserID select users).FirstOrDefault(); db.AspNetUsers.Remove(deletedUser); db.SaveChanges(); } //refresh the grid this.getUsers(); }
//private void GetUser() //{ // int UserID = Convert.ToInt32(Request.QueryString["StudentID"]); // //connect to DB // using (comp2007db db = new comp2007db()) // { // User updatedUser = (from user in db.Users where user.id == UserID select user).FirstOrDefault(); // if (updatedUser != null) // { // LastnameTextBox.Text = updatedUser.LastName; // FirstNameTextBox.Text = updatedUser.FirstName; // emailTextBox.Text = updatedUser.email; // passwordTextBox.Text = updatedUser.password; // confirmPasswordTextBox.Text = updatedUser.password; // } // } //} protected void RegisterButton_Click(object sender, EventArgs e) { if (Request.QueryString.Count > 0) { using (userConnection db = new userConnection()) { AspNetUser newUser = new AspNetUser(); string UserID = Request.QueryString["Id"].ToString(); newUser = (from users in db.AspNetUsers where users.Id == UserID select users).FirstOrDefault(); newUser.UserName = userNameTextBox.Text; newUser.Email = emailTextBox.Text; db.SaveChanges(); // redirect to users list Response.Redirect("Users.aspx"); } } var userStore = new UserStore <IdentityUser>(); var userManager = new UserManager <IdentityUser>(userStore); //create a new user object var user = new IdentityUser() { UserName = userNameTextBox.Text, Email = emailTextBox.Text }; // create a new user in the db and store the result IdentityResult result = userManager.Create(user, passwordTextBox.Text); // check if succesfully registered if (result.Succeeded) { if (Session["admin"] != null) { Response.Redirect("Users.aspx"); } // authenticate and login our new user var authenticationmanager = HttpContext.Current.GetOwinContext().Authentication; var userIdentity = userManager.CreateIdentity(user, DefaultAuthenticationTypes.ApplicationCookie); // sign in authenticationmanager.SignIn(new AuthenticationProperties() { }, userIdentity); // redirect to default page Session["userName"] = user.UserName; if (user.UserName == "admin") { Session["admin"] = true; } Response.Redirect("Default.aspx"); } else { // display the error in the error div statusLabel.Text = result.Errors.FirstOrDefault(); alertFlash.Visible = true; } ////connect to EF DB //using (comp2007db db = new comp2007db()) //{ // // use the user model to save a new record // User newUser = new User(); // int UserID = 0; // if (Request.QueryString.Count > 0) // { // // get user id from url // UserID = Convert.ToInt32(Request.QueryString["UserID"]); // // get the current user from the DB // newUser = (from user in db.Users where user.id == UserID select user).FirstOrDefault(); // } // // add for data to new user record // newUser.LastName = LastnameTextBox.Text; // newUser.FirstName = FirstNameTextBox.Text; // newUser.email = emailTextBox.Text; // newUser.password = passwordTextBox.Text; // // add a new user to User Table Collection // if (UserID == 0) // { // db.Users.Add(newUser); // } // try // { // // run insert commands to database // db.SaveChanges(); // } // catch(Exception ex) // { // string script = "<script>alert('" + ex.Message + "');</script>"; // Page.ClientScript.RegisterStartupScript(GetType(), script,"errorMessage"); // } // Response.Redirect("~/Default.aspx"); //} }