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);
}