public IEnumerable <DT.UserGroupBase> GetAllLeightweightUsersAndGroups() { List <DT.UserGroup> userGroups = new List <DT.UserGroup>(); List <DT.UserGroupBase> result = new List <DT.UserGroupBase>(); List <Guid> accessUserGuids = null; using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var query = from u in context.aspnet_Users select u.UserId; accessUserGuids = query.ToList(); } var lightweightUsers = accessUserGuids.Select(x => BuildLightweightUserDto(x)); using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { var query = from u in context.UserGroupBases.OfType <DA.UserGroup>() select Convert.ToDto(u); userGroups = query.ToList(); } result.AddRange(lightweightUsers); result.AddRange(userGroups); return(result); }
public IEnumerable <DT.Role> GetRoles() { using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var query = from u in context.aspnet_Roles select Convert.ToDto(u); return(query.ToList()); } }
private DT.User BuildUserDto(Guid userId) { DA.aspnet_User aspUser = null; DA.aspnet_Membership aspMembership = null; DA.User accessUser = null; using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var userQuery = from u in context.aspnet_Users where u.UserId == userId select u; if (userQuery.Count() == 1) { aspUser = userQuery.First(); } var memQuery = from u in context.aspnet_Memberships where u.UserId == userId select u; if (memQuery.Count() == 1) { aspMembership = memQuery.First(); } } if (aspUser != null || aspMembership != null) { using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { var query = from u in context.UserGroupBases.OfType <DA.User>() where u.Id == userId select u; if (query.Count() == 1) { accessUser = query.First(); } else { //if the user is not in the access db add it (this makes it easy to upgrade with an existing asp.net authentication db) DA.User user = new DA.User(); user.Id = userId; user.FullName = "Not set"; context.UserGroupBases.InsertOnSubmit(user); context.SubmitChanges(); accessUser = user; } } } if (aspUser == null || aspMembership == null || accessUser == null) { throw new Exception("User with id " + userId + " not found."); } else { return(Convert.ToDto(accessUser, aspUser, aspMembership)); } }
public IEnumerable <DT.LightweightUser> GetAllLightweightUsers() { List <Guid> accessUserGuids = null; using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var query = from u in context.aspnet_Users select u.UserId; accessUserGuids = query.ToList(); } return(accessUserGuids.Select(x => BuildLightweightUserDto(x))); }
public DT.User AddUser(DT.User user) { RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); DA.User accessUser; DA.aspnet_User aspUser; DA.aspnet_Membership aspMembership; bool userExistsInASP; Convert.ToEntity(user, out accessUser, out aspUser, out aspMembership, out userExistsInASP); if (userExistsInASP) { if (accessUser.Id == null || accessUser.Id == Guid.Empty) { accessUser.Id = aspMembership.UserId; } using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { context.UserGroupBases.InsertOnSubmit(accessUser); context.SubmitChanges(); } MembershipUser membershipUser = Membership.GetUser((object)accessUser.Id); if (membershipUser != null) { membershipUser.Email = aspMembership.Email; membershipUser.IsApproved = aspMembership.IsApproved; membershipUser.Comment = aspMembership.Comment; Membership.UpdateUser(membershipUser); } } else { MembershipUser membershipUser = Membership.CreateUser(aspUser.UserName, aspUser.UserName, aspMembership.Email); membershipUser.IsApproved = aspMembership.IsApproved; membershipUser.Comment = aspMembership.Comment; Membership.UpdateUser(membershipUser); Guid userId = (Guid)membershipUser.ProviderUserKey; accessUser.Id = userId; using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { context.UserGroupBases.InsertOnSubmit(accessUser); context.SubmitChanges(); } } using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var newAspUser = context.aspnet_Users.Where(x => x.UserId == accessUser.Id).FirstOrDefault(); var newAspMembership = context.aspnet_Memberships.Where(x => x.UserId == accessUser.Id).FirstOrDefault(); return(Convert.ToDto(accessUser, newAspUser, newAspMembership)); } }
public IEnumerable <DT.Role> GetRolesOfCurrentUser() { Guid userId = UserManager.CurrentUserId; using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var query = from ur in context.aspnet_UsersInRoles from r in context.aspnet_Roles where ur.UserId == userId && ur.RoleId == r.RoleId select Convert.ToDto(r); return(query.ToList()); } }
public IEnumerable <DT.User> GetAllUsers() { RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); List <Guid> accessUserGuids = null; using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var query = from u in context.aspnet_Users select u.UserId; accessUserGuids = query.ToList(); } return(accessUserGuids.Select(x => BuildUserDto(x))); }
public void AddRoleToGroup(DT.UserGroup userGroup, DT.Role role) { Guid[] userIds; string[] aspUsers; using (DA.AccessServiceDataContext accessContext = new DA.AccessServiceDataContext()) { userIds = (from u in accessContext.UserGroupUserGroups where u.UserGroupUserGroupId == userGroup.Id select u.UserGroupId).ToArray(); } using (DA.ASPNETAuthenticationDataContext aspContext = new DA.ASPNETAuthenticationDataContext()) { aspUsers = (from u in aspContext.aspnet_Users where userIds.Contains(u.UserId) select u.UserName).ToArray(); } Roles.AddUsersToRole(aspUsers, role.Name); }
public void RemoveRoleFromGroup(DT.UserGroup userGroup, DT.Role role) { RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); Guid[] userIds; string[] aspUsers; using (DA.AccessServiceDataContext accessContext = new DA.AccessServiceDataContext()) { userIds = (from u in accessContext.UserGroupUserGroups where u.UserGroupUserGroupId == userGroup.Id select u.UserGroupId).ToArray(); } using (DA.ASPNETAuthenticationDataContext aspContext = new DA.ASPNETAuthenticationDataContext()) { aspUsers = (from u in aspContext.aspnet_Users where userIds.Contains(u.UserId) select u.UserName).ToArray(); } Roles.RemoveUsersFromRole(aspUsers.ToArray(), role.Name); }
public static void ToEntity(DT.User source, out DA.User accessUser, out DA.aspnet_User aspUser, out DA.aspnet_Membership aspMembership, out bool userExistsInASP) { userExistsInASP = false; accessUser = new DA.User(); aspUser = new DA.aspnet_User(); aspMembership = new DA.aspnet_Membership(); if (source.Id != Guid.Empty) { using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var userCol = context.aspnet_Users.Where(s => s.UserId == source.Id); var membershipCol = context.aspnet_Memberships.Where(s => s.UserId == source.Id); if (userCol.Count() > 0 && membershipCol.Count() > 0) { aspUser = userCol.First(); aspMembership = membershipCol.First(); userExistsInASP = true; } } } accessUser.Id = source.Id; accessUser.FullName = source.FullName; aspUser.UserId = source.Id; aspUser.LastActivityDate = source.LastActivityDate; aspUser.UserName = source.UserName; aspMembership.UserId = source.Id; aspMembership.Comment = source.Comment; aspMembership.CreateDate = source.CreationDate; aspMembership.Email = source.Email; aspMembership.IsApproved = source.IsApproved; aspMembership.LastLoginDate = source.LastLoginDate; aspMembership.LastPasswordChangedDate = source.LastPasswordChangedDate; }
public IEnumerable<DT.Role> GetRolesOfCurrentUser() { Guid userId = UserManager.CurrentUserId; using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var query = from ur in context.aspnet_UsersInRoles from r in context.aspnet_Roles where ur.UserId == userId && ur.RoleId == r.RoleId select Convert.ToDto(r); return query.ToList(); } }
public static void ToEntity(DT.User source, out DA.User accessUser, out DA.aspnet_User aspUser, out DA.aspnet_Membership aspMembership, out bool userExistsInASP) { userExistsInASP = false; accessUser = new DA.User(); aspUser = new DA.aspnet_User(); aspMembership = new DA.aspnet_Membership(); if (source.Id != Guid.Empty) { using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var userCol = context.aspnet_Users.Where(s => s.UserId == source.Id); var membershipCol = context.aspnet_Memberships.Where(s => s.UserId == source.Id); if (userCol.Count() > 0 && membershipCol.Count() > 0) { aspUser = userCol.First(); aspMembership = membershipCol.First(); userExistsInASP = true; } } } accessUser.Id = source.Id; accessUser.FullName = source.FullName; aspUser.UserId = source.Id; aspUser.LastActivityDate = source.LastActivityDate; aspUser.UserName = source.UserName; aspMembership.UserId = source.Id; aspMembership.Comment = source.Comment; aspMembership.CreateDate = source.CreationDate; aspMembership.Email = source.Email; aspMembership.IsApproved = source.IsApproved; aspMembership.LastLoginDate = source.LastLoginDate; aspMembership.LastPasswordChangedDate = source.LastPasswordChangedDate; }
public IEnumerable<DT.User> GetAllUsers() { RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); List<Guid> accessUserGuids = null; using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var query = from u in context.aspnet_Users select u.UserId; accessUserGuids = query.ToList(); } return accessUserGuids.Select(x => BuildUserDto(x)); }
public IEnumerable<DT.LightweightUser> GetAllLightweightUsers() { List<Guid> accessUserGuids = null; using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var query = from u in context.aspnet_Users select u.UserId; accessUserGuids = query.ToList(); } return accessUserGuids.Select(x => BuildLightweightUserDto(x)); }
public DT.User AddUser(DT.User user) { RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); DA.User accessUser; DA.aspnet_User aspUser; DA.aspnet_Membership aspMembership; bool userExistsInASP; Convert.ToEntity(user, out accessUser, out aspUser, out aspMembership, out userExistsInASP); if (userExistsInASP) { if (accessUser.Id == null || accessUser.Id == Guid.Empty) { accessUser.Id = aspMembership.UserId; } using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { context.UserGroupBases.InsertOnSubmit(accessUser); context.SubmitChanges(); } MembershipUser membershipUser = Membership.GetUser((object)accessUser.Id); if (membershipUser != null) { membershipUser.Email = aspMembership.Email; membershipUser.IsApproved = aspMembership.IsApproved; membershipUser.Comment = aspMembership.Comment; Membership.UpdateUser(membershipUser); } } else { MembershipUser membershipUser = Membership.CreateUser(aspUser.UserName, aspUser.UserName, aspMembership.Email); membershipUser.IsApproved = aspMembership.IsApproved; membershipUser.Comment = aspMembership.Comment; Membership.UpdateUser(membershipUser); Guid userId = (Guid)membershipUser.ProviderUserKey; accessUser.Id = userId; using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { context.UserGroupBases.InsertOnSubmit(accessUser); context.SubmitChanges(); } } using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var newAspUser = context.aspnet_Users.Where(x => x.UserId == accessUser.Id).FirstOrDefault(); var newAspMembership = context.aspnet_Memberships.Where(x => x.UserId == accessUser.Id).FirstOrDefault(); return Convert.ToDto(accessUser, newAspUser, newAspMembership); } }
private DT.LightweightUser BuildLightweightUserDto(Guid userId) { DA.aspnet_User aspUser = null; DA.aspnet_Membership aspMembership = null; DA.User accessUser = null; List <DA.aspnet_Role> roles = new List <DA.aspnet_Role>(); List <DA.UserGroup> groups = new List <DA.UserGroup>(); using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var userQuery = from u in context.aspnet_Users where u.UserId == userId select u; var memQuery = from u in context.aspnet_Memberships where u.UserId == userId select u; if (memQuery.Count() == 1) { aspMembership = memQuery.First(); } if (userQuery.Count() == 1) { aspUser = userQuery.First(); roles = (from ur in context.aspnet_UsersInRoles where ur.UserId == aspUser.UserId join r in context.aspnet_Roles on ur.RoleId equals r.RoleId select r).ToList(); } } if (aspUser != null || aspMembership != null) { using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { var query = from u in context.UserGroupBases.OfType <DA.User>() where u.Id == userId select u; if (query.Count() == 1) { accessUser = query.First(); groups = (from ug in context.UserGroupUserGroups where ug.UserGroupId == accessUser.Id join g in context.UserGroupBases.OfType <DA.UserGroup>() on ug.UserGroupUserGroupId equals g.Id select g).ToList(); } else { //if the user is not in the access db add it (this makes it easy to upgrade with an existing asp.net authentication db) DA.User user = new DA.User(); user.Id = userId; user.FullName = "Not set"; context.UserGroupBases.InsertOnSubmit(user); context.SubmitChanges(); accessUser = user; } } } if (aspUser == null || accessUser == null || aspMembership == null) { throw new Exception("User with id " + userId + " not found."); } else { return(Convert.ToDto(accessUser, aspUser, aspMembership, roles, groups)); } }
public IEnumerable<DT.UserGroupBase> GetAllLeightweightUsersAndGroups() { List<DT.UserGroup> userGroups = new List<DT.UserGroup>(); List<DT.UserGroupBase> result = new List<DT.UserGroupBase>(); List<Guid> accessUserGuids = null; using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var query = from u in context.aspnet_Users select u.UserId; accessUserGuids = query.ToList(); } var lightweightUsers = accessUserGuids.Select(x => BuildLightweightUserDto(x)); using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { var query = from u in context.UserGroupBases.OfType<DA.UserGroup>() select Convert.ToDto(u); userGroups = query.ToList(); } result.AddRange(lightweightUsers); result.AddRange(userGroups); return result; }
public IEnumerable<DT.Role> GetRoles() { using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var query = from u in context.aspnet_Roles select Convert.ToDto(u); return query.ToList(); } }
public void AddRoleToGroup(DT.UserGroup userGroup, DT.Role role) { Guid[] userIds; string[] aspUsers; using (DA.AccessServiceDataContext accessContext = new DA.AccessServiceDataContext()) { userIds = (from u in accessContext.UserGroupUserGroups where u.UserGroupUserGroupId == userGroup.Id select u.UserGroupId).ToArray(); } using (DA.ASPNETAuthenticationDataContext aspContext = new DA.ASPNETAuthenticationDataContext()) { aspUsers = (from u in aspContext.aspnet_Users where userIds.Contains(u.UserId) select u.UserName).ToArray(); } Roles.AddUsersToRole(aspUsers, role.Name); }
private DT.LightweightUser BuildLightweightUserDto(Guid userId) { DA.aspnet_User aspUser = null; DA.aspnet_Membership aspMembership = null; DA.User accessUser = null; List<DA.aspnet_Role> roles = new List<DA.aspnet_Role>(); List<DA.UserGroup> groups = new List<DA.UserGroup>(); using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var userQuery = from u in context.aspnet_Users where u.UserId == userId select u; var memQuery = from u in context.aspnet_Memberships where u.UserId == userId select u; if (memQuery.Count() == 1) { aspMembership = memQuery.First(); } if (userQuery.Count() == 1) { aspUser = userQuery.First(); roles = (from ur in context.aspnet_UsersInRoles where ur.UserId == aspUser.UserId join r in context.aspnet_Roles on ur.RoleId equals r.RoleId select r).ToList(); } } if (aspUser != null || aspMembership != null) { using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { var query = from u in context.UserGroupBases.OfType<DA.User>() where u.Id == userId select u; if (query.Count() == 1) { accessUser = query.First(); groups = (from ug in context.UserGroupUserGroups where ug.UserGroupId == accessUser.Id join g in context.UserGroupBases.OfType<DA.UserGroup>() on ug.UserGroupUserGroupId equals g.Id select g).ToList(); } else { //if the user is not in the access db add it (this makes it easy to upgrade with an existing asp.net authentication db) DA.User user = new DA.User(); user.Id = userId; user.FullName = "Not set"; context.UserGroupBases.InsertOnSubmit(user); context.SubmitChanges(); accessUser = user; } } } if (aspUser == null || accessUser == null || aspMembership == null) { throw new Exception("User with id " + userId + " not found."); } else { return Convert.ToDto(accessUser, aspUser, aspMembership, roles, groups); } }
public void RemoveRoleFromGroup(DT.UserGroup userGroup, DT.Role role) { RoleVerifier.AuthenticateForAllRoles(AccessServiceRoles.Administrator); Guid[] userIds; string[] aspUsers; using (DA.AccessServiceDataContext accessContext = new DA.AccessServiceDataContext()) { userIds = (from u in accessContext.UserGroupUserGroups where u.UserGroupUserGroupId == userGroup.Id select u.UserGroupId).ToArray(); } using (DA.ASPNETAuthenticationDataContext aspContext = new DA.ASPNETAuthenticationDataContext()) { aspUsers = (from u in aspContext.aspnet_Users where userIds.Contains(u.UserId) select u.UserName).ToArray(); } Roles.RemoveUsersFromRole(aspUsers.ToArray(), role.Name); }
private string GetUserName(Guid userId) { try { // we cannot use the ServiceLocator.Instance.UserManager since the janitor service // is not hosted in the iis the MemberShip.GetUser method causes exceptions // needs to be further investigated current workaround: use the authenticationcontext // we could also connect to the access service to get the user name using (ASPNETAuthenticationDataContext dc = new ASPNETAuthenticationDataContext()) { var user = dc.aspnet_Users.SingleOrDefault(x => x.UserId == userId); return user != null ? user.UserName : UnknownUserName; } } catch (Exception) { return UnknownUserName; } }
private DT.User BuildUserDto(Guid userId) { DA.aspnet_User aspUser = null; DA.aspnet_Membership aspMembership = null; DA.User accessUser = null; using (DA.ASPNETAuthenticationDataContext context = new DA.ASPNETAuthenticationDataContext()) { var userQuery = from u in context.aspnet_Users where u.UserId == userId select u; if (userQuery.Count() == 1) { aspUser = userQuery.First(); } var memQuery = from u in context.aspnet_Memberships where u.UserId == userId select u; if (memQuery.Count() == 1) { aspMembership = memQuery.First(); } } if (aspUser != null || aspMembership != null) { using (DA.AccessServiceDataContext context = new DA.AccessServiceDataContext()) { var query = from u in context.UserGroupBases.OfType<DA.User>() where u.Id == userId select u; if (query.Count() == 1) { accessUser = query.First(); } else { //if the user is not in the access db add it (this makes it easy to upgrade with an existing asp.net authentication db) DA.User user = new DA.User(); user.Id = userId; user.FullName = "Not set"; context.UserGroupBases.InsertOnSubmit(user); context.SubmitChanges(); accessUser = user; } } } if (aspUser == null || aspMembership == null || accessUser == null) { throw new Exception("User with id " + userId + " not found."); } else { return Convert.ToDto(accessUser, aspUser, aspMembership); } }