protected void UsersEntityDataSource_Selected(object sender, EntityDataSourceSelectedEventArgs e) { var userIds = e.Results.Cast <Data.Membership>().Select(x => x.UserId).ToArray(); var db = new Data.SecurityEntities(); users = (from row in db.Users where userIds.Contains(row.UserId) select row).ToArray(); db.Dispose(); db = null; }
public void UpdateRole() { var db = new Data.SecurityEntities(); var role = Data.Role.GetRole(CreatedRoleTextBox.Text, db); role.ApplicationId = new Guid(ApplicationIdTextBox.Text); role.Description = DescriptionTextBox.Text; role.LoweredRoleName = RoleNameTextBox.Text.ToLower(); role.RoleName = RoleNameTextBox.Text; db.SaveChanges(); RiseUpdated(new RoleEditEventArgs(RoleNameTextBox.Text)); }
protected void RolesDataSource_QueryCreated(object sender, QueryCreatedEventArgs e) { if (!string.IsNullOrEmpty(SearchUserId.Text)) { var userId = new Guid(SearchUserId.Text); var db = new Data.SecurityEntities(); if (SearchFilterLabel.Text == "InRole") { e.Query = db.Users.Where(x => x.UserId == userId).SelectMany(x => x.Roles).OrderBy(x => x.RoleName); } else if (SearchFilterLabel.Text == "NotInRole") { var q1 = db.Users.Where(x => x.UserId == userId).SelectMany(x => x.Roles); e.Query = db.Roles.Except(q1).OrderBy(x => x.RoleName); } } }
public void CreateRole() { CreatedRoleTextBox.Text = ""; var db = new Data.SecurityEntities(); var role = new Data.Role() { ApplicationId = new Guid(ApplicationIdTextBox.Text), Description = DescriptionTextBox.Text, LoweredRoleName = RoleNameTextBox.Text.ToLower(), RoleId = new Guid(RoleIdTextBox.Text), RoleName = RoleNameTextBox.Text, }; db.Roles.AddObject(role); db.SaveChanges(); switch (PostCreateMode) { case PostCreateModeEnum.None: break; case PostCreateModeEnum.Create: PrepareToCreate(); break; case PostCreateModeEnum.Update: PrepareToUpdate(); LoadRole(role.RoleId); break; default: break; } CreateStatusLabel.ForeColor = System.Drawing.Color.Green; CreateStatusLabel.Text = "Role '" + role.RoleName + "' was created."; CreatedRoleTextBox.Text = role.RoleName; RiseCreated(new RoleEditEventArgs(role)); }