public SimpleMembershipInitializer()
{
//Database.SetInitializer<UsersContext>(null);
Database.SetInitializer <NuvolaResumeContext>(null);
try
{
//using (var context = new UsersContext())
using (var context = new NuvolaResumeContext())
{
if (!context.Database.Exists())
{
// Create the SimpleMembership database without Entity Framework migration schema
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
}
WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfiles", "ID", "UserName", false);
//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 string[] GetRolesForUserByUserId(int UserId)
{
using (NuvolaResumeContext context = new NuvolaResumeContext())
{
UserProfile user = repository.UserProfile_GetUserProfile(UserId);
if (user != null)
{
IEnumerable <webpages_UsersInRoles> items = repository.Roles_GetRolesForUserId(UserId);
var lroles = from role in items
join webRole in context.webpages_Roles on
role.RoleId equals webRole.RoleId
select new
{
webRole.RoleName
};
string[] roles = lroles.Select(x => x.RoleName).ToArray <string>();
return(roles);
}
}
return(null);
}
public override string[] GetRolesForUser(string username)
{
using (NuvolaResumeContext context = new NuvolaResumeContext())
{
IEnumerable <webpages_UsersInRoles> items = repository.Roles_GetRolesForUser(username);
var lroles = from role in items
join webRole in context.webpages_Roles on
role.RoleId equals webRole.RoleId
select new
{
webRole.RoleName
};
string[] roles = lroles.Select(x => x.RoleName).ToArray <string>();
return(roles);
}
}
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())
using (NuvolaResumeContext db = new NuvolaResumeContext())
{
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));
}
public override string[] GetUsersInRole(string roleName)
{
using (NuvolaResumeContext context = new NuvolaResumeContext())
{
var items = from urole in context.webpages_UsersInRoles
join role in context.webpages_Roles on urole.RoleId equals role.RoleId
join user in context.UserProfiles on urole.UserId equals user.ID
where role.RoleName == roleName
select new
{
ID = urole.ID,
RoleId = urole.RoleId,
UserId = urole.UserId,
UserName = user.UserName
};
string[] users = items.Select(x => x.UserName).ToArray <string>();
return(users);
}
}
public override void AddUsersToRoles(string[] usernames, string[] roleNames)
{
using (NuvolaResumeContext context = new NuvolaResumeContext())
{
foreach (string user in usernames)
{
int userId = WebSecurity.GetUserId(user);
foreach (string role in roleNames)
{
int roleId = GetRoleId(role);
context.webpages_UsersInRoles.Add(
new webpages_UsersInRoles()
{
RoleId = roleId,
UserId = userId
}
);
context.SaveChanges();
}
}
}
}
