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 static DT.LightweightUser ToDto(DA.User source, DA.aspnet_User aspUserSource, DA.aspnet_Membership aspMembershipSource, List <DA.aspnet_Role> roles, List <DA.UserGroup> groups) { return(new DT.LightweightUser() { Id = source.Id, FullName = source.FullName, UserName = aspUserSource.UserName, EMail = aspMembershipSource.Email, //TODO: check if the roles and groups are include in source Roles = roles.Select(x => Convert.ToDto(x)).ToArray(), Groups = groups.Select(x => Convert.ToDto(x)).ToArray() }); }
public static DT.User ToDto(DA.User source, DA.aspnet_User aspUserSource, DA.aspnet_Membership aspMembershipSource) { return(new DT.User() { Id = source.Id, FullName = source.FullName, Comment = aspMembershipSource.Comment, CreationDate = aspMembershipSource.CreateDate, Email = aspMembershipSource.Email, IsApproved = aspMembershipSource.IsApproved, LastActivityDate = aspUserSource.LastActivityDate, LastLoginDate = aspMembershipSource.LastLoginDate, LastPasswordChangedDate = aspMembershipSource.LastPasswordChangedDate, UserName = aspUserSource.UserName }); }
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; }
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)); } }
partial void Deleteaspnet_User(aspnet_User instance);
partial void Updateaspnet_User(aspnet_User instance);
partial void Insertaspnet_User(aspnet_User instance);
private void detach_aspnet_Users(aspnet_User entity) { this.SendPropertyChanging(); entity.aspnet_Application = null; }