public SimpleMembershipInitializer() { Database.SetInitializer<UsersContext>(null); try { using (var context = new UsersContext()) { if (!context.Database.Exists()) { // Create the SimpleMembership database without Entity Framework migration schema ((IObjectContextAdapter)context).ObjectContext.CreateDatabase(); } } WebSecurity.InitializeDatabaseConnection(Fhr.ProductOffice.Models.DbApi.GetProviderConnectionString(), "System.Data.SqlClient", "UserProfile", "UserId", "UserName", autoCreateTables: true); } catch (Exception ex) { throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex); } }
protected override ValidationResult IsValid(object value, ValidationContext validationContext) { if (value == null) return new ValidationResult("Please set a name!"); string name = (string)value; bool invalid = false; UsersContext db = new UsersContext(); if (validationContext.ObjectInstance is RegisterModel) { if (0 < db.UserProfiles.Where(r => r.UserName.ToLower() == ((RegisterModel)validationContext.ObjectInstance).UserName.ToLower()).Count()) invalid = true; } else if (validationContext.ObjectInstance is UserProfile) { UserProfile up = (UserProfile)validationContext.ObjectInstance; if (0 < db.UserProfiles.Where(r => r.UserName.ToLower() == up.UserName.ToLower() && r.UserId != up.UserId).Count()) invalid = true; } else throw new Exception("validationContext is not acceptable type."); if (invalid) return new ValidationResult("Such a name exists already. Please choose another one."); return ValidationResult.Success; }
protected override ValidationResult IsValid(object value, ValidationContext validationContext) { if (value == null) return new ValidationResult("Please set a value!"); bool active = (bool)value; bool invalid = false; UsersContext db = new UsersContext(); if (validationContext.ObjectInstance is RegisterModel) { } else if (validationContext.ObjectInstance is UserProfile) { UserProfile up = (UserProfile)validationContext.ObjectInstance; //WebSecurity.InitializeDatabaseConnection() if (up.UserId == WebSecurity.CurrentUserId && !up.Active) invalid = true; } else throw new Exception("validationContext is not acceptable type."); if (invalid) return new ValidationResult("It is impossible to set own account inactive."); return ValidationResult.Success; }
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl) { string provider = null; string providerUserId = null; if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId)) { return RedirectToAction("Manage"); } if (ModelState.IsValid) { // Insert a new user into the database using (UsersContext db = new UsersContext()) { UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower()); // Check if user already exists if (user == null) { // Insert name into the profile table db.UserProfiles.Add(new UserProfile { UserName = model.UserName }); db.SaveChanges(); OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName); OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false); return RedirectToLocal(returnUrl); } else { ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name."); } } } ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName; ViewBag.ReturnUrl = returnUrl; return View(model); }