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