public string GetTokenSecret(string token)
 {
     Debug.WriteLine("GetTokenSecret: " + token);
     using (var db = new UsersContext())
     {
         return db.OAuthTokens.Single(t => t.Token == token).Secret;
     }
 }
        public ActionResult DeleteAll()
        {
            using (var db = new UsersContext())
            {

                db.Database.ExecuteSqlCommand(DELETE_ALL);
                db.SaveChanges();
            }
            return this.RedirectToActionPermanent("Membership");
        }
        public ActionResult Membership()
        {
            ViewBag.Message = "Membership Page";

            UserProfile[] users;
            using (var db = new UsersContext())
            {
                users = db.UserProfiles.Include(u => u.Tokens).ToArray();
            }
            return View(users);
        }
 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 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("DefaultConnection", "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);
                }
            }
        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);
        }