public ActionResult DeleteAll() { using (var db = new UsersContext()) { db.Database.ExecuteSqlCommand(DELETE_ALL); db.SaveChanges(); } return this.RedirectToActionPermanent("Membership"); }
public void ExpireRequestTokenAndStoreNewAccessToken(string consumerKey, string requestToken, string accessToken, string accessTokenSecret) { Debug.WriteLine("ExpireRequestTokenAndStoreNewAccessToken: " + accessToken); this.requestTokens.Remove(requestToken); using (var db = new UsersContext()) { db.OAuthTokens.Add(new OAuthToken { Token = accessToken, Secret = accessTokenSecret }); db.SaveChanges(); } }
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl) { string provider = null; string providerUserId = null; if (WebSecurity.CurrentUser.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId)) { return RedirectToAction("Manage", "Account"); } 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 var userProfile = new UserProfile() { UserName = model.UserName }; db.UserProfiles.Add(userProfile); db.SaveChanges(); OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName); var isLoggedIn = OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false); if (!isLoggedIn) { throw new Exception("Login failed"); } var secret = ""; if (provider == "MxClient") { secret = GetMxSecret(model); } var newToken = new OAuthToken() { Provider = provider, ProviderUserId = providerUserId, Token = model.AccessToken, Secret = secret, UserId = userProfile.UserId }; db.OAuthTokens.Add(newToken); var rows = db.SaveChanges(); Debug.WriteLine("Rows updated: " + rows); 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); }
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); }