public override DataTable Clone() { UserRoleDataTable cln = ((UserRoleDataTable)(base.Clone())); cln.InitVars(); return(cln); }
private void InitClass() { this.DataSetName = "Users"; this.Prefix = ""; this.Namespace = "http://tempuri.org/Users.xsd"; this.Locale = new System.Globalization.CultureInfo("en-US"); this.CaseSensitive = false; this.EnforceConstraints = false; this.tableUser = new UserDataTable(); this.Tables.Add(this.tableUser); this.tableUserRole = new UserRoleDataTable(); this.Tables.Add(this.tableUserRole); this.tableRole = new RoleDataTable(); this.Tables.Add(this.tableRole); ForeignKeyConstraint fkc; fkc = new ForeignKeyConstraint("User_UserRole", new DataColumn[] { this.tableUser.loginColumn }, new DataColumn[] { this.tableUserRole.loginColumn }); this.tableUserRole.Constraints.Add(fkc); fkc.AcceptRejectRule = AcceptRejectRule.None; fkc.DeleteRule = Rule.Cascade; fkc.UpdateRule = Rule.Cascade; fkc = new ForeignKeyConstraint("RoleUserRole", new DataColumn[] { this.tableRole.nameColumn }, new DataColumn[] { this.tableUserRole.nameColumn }); this.tableUserRole.Constraints.Add(fkc); fkc.AcceptRejectRule = AcceptRejectRule.Cascade; fkc.DeleteRule = Rule.Cascade; fkc.UpdateRule = Rule.Cascade; this.relationUser_UserRole = new DataRelation("User_UserRole", new DataColumn[] { this.tableUser.loginColumn }, new DataColumn[] { this.tableUserRole.loginColumn }, false); this.relationUser_UserRole.Nested = true; this.Relations.Add(this.relationUser_UserRole); this.relationRoleUserRole = new DataRelation("RoleUserRole", new DataColumn[] { this.tableRole.nameColumn }, new DataColumn[] { this.tableUserRole.nameColumn }, false); this.Relations.Add(this.relationRoleUserRole); }
public async Task <JsonResult> CreateUserRole(UserRoleDataTable userRoles) { var user = await _userManager.FindByIdAsync(userRoles.UserId); var role = await _roleManager.FindByIdAsync(userRoles.RoleId); try { await _userManager.AddToRoleAsync(user, role.Name); return(Json(null)); } catch (Exception) { throw; } }
public void UpdateUserById(int id, UserRoleDataTable userRole) { var dbUserRole = db.UserRoles.Where(x => x.Id == id).FirstOrDefault(); if (dbUserRole != null) { dbUserRole.User.Name = userRole.UserName; dbUserRole.Role.Name = userRole.RoleName; db.Entry(dbUserRole).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception e) { throw e; } } }
public async Task <JsonResult> GetUserRoleTableData(DataTableInput model) { try { var userRoles = new List <UserRoleDataTable>(); var users = await _userManager.Users.ToListAsync(); foreach (var user in users) { var roles = await _userManager.GetRolesAsync(user); if (roles == null) { return(Json(null)); } foreach (var roleName in roles) { var role = await _roleManager.FindByNameAsync(roleName); var userRole = new UserRoleDataTable { User = user.UserName, UserId = user.Id.ToString(), Role = role.Name, RoleId = role.Id.ToString() }; userRoles.Add(userRole); } } var result = await _dataTableFactory.GetTableData(model, userRoles); return(Json(new { draw = result.draw, recordsTotal = result.recordsTotal, recordsFiltered = result.recordsFiltered, data = result.data })); } catch (Exception ex) { throw; } }
internal void InitVars() { this.tableUser = ((UserDataTable)(this.Tables["User"])); if ((this.tableUser != null)) { this.tableUser.InitVars(); } this.tableUserRole = ((UserRoleDataTable)(this.Tables["UserRole"])); if ((this.tableUserRole != null)) { this.tableUserRole.InitVars(); } this.tableRole = ((RoleDataTable)(this.Tables["Role"])); if ((this.tableRole != null)) { this.tableRole.InitVars(); } this.relationUser_UserRole = this.Relations["User_UserRole"]; this.relationRoleUserRole = this.Relations["RoleUserRole"]; }
internal UserRoleRow(DataRowBuilder rb) : base(rb) { this.tableUserRole = ((UserRoleDataTable)(this.Table)); }
private void InitClass() { this.DataSetName = "UserDS"; this.Prefix = ""; this.Namespace = "http://tempuri.org/UserDS.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableRole = new RoleDataTable(); base.Tables.Add(this.tableRole); this.tableUser = new UserDataTable(); base.Tables.Add(this.tableUser); this.tableUserRole = new UserRoleDataTable(); base.Tables.Add(this.tableUserRole); global::System.Data.ForeignKeyConstraint fkc; fkc = new global::System.Data.ForeignKeyConstraint("FK_User_Supervisor", new global::System.Data.DataColumn[] { this.tableUser.IDColumn}, new global::System.Data.DataColumn[] { this.tableUser.SupervisorIDColumn}); this.tableUser.Constraints.Add(fkc); fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None; fkc.DeleteRule = global::System.Data.Rule.None; fkc.UpdateRule = global::System.Data.Rule.None; fkc = new global::System.Data.ForeignKeyConstraint("FK_UserRole_User", new global::System.Data.DataColumn[] { this.tableUser.IDColumn}, new global::System.Data.DataColumn[] { this.tableUserRole.UserIDColumn}); this.tableUserRole.Constraints.Add(fkc); fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None; fkc.DeleteRule = global::System.Data.Rule.None; fkc.UpdateRule = global::System.Data.Rule.None; fkc = new global::System.Data.ForeignKeyConstraint("FK_UserRole_Role", new global::System.Data.DataColumn[] { this.tableRole.IDColumn}, new global::System.Data.DataColumn[] { this.tableUserRole.RoleIDColumn}); this.tableUserRole.Constraints.Add(fkc); fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None; fkc.DeleteRule = global::System.Data.Rule.None; fkc.UpdateRule = global::System.Data.Rule.None; }
internal void InitVars(bool initTable) { this.tableRole = ((RoleDataTable)(base.Tables["Role"])); if ((initTable == true)) { if ((this.tableRole != null)) { this.tableRole.InitVars(); } } this.tableUser = ((UserDataTable)(base.Tables["User"])); if ((initTable == true)) { if ((this.tableUser != null)) { this.tableUser.InitVars(); } } this.tableUserRole = ((UserRoleDataTable)(base.Tables["UserRole"])); if ((initTable == true)) { if ((this.tableUserRole != null)) { this.tableUserRole.InitVars(); } } }
internal UserRoleRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableUserRole = ((UserRoleDataTable)(this.Table)); }
private void InitClass() { this.DataSetName = "Users"; this.Prefix = ""; this.Namespace = "http://tempuri.org/Users.xsd"; this.Locale = new System.Globalization.CultureInfo("en-US"); this.CaseSensitive = false; this.EnforceConstraints = false; this.tableUser = new UserDataTable(); this.Tables.Add(this.tableUser); this.tableUserRole = new UserRoleDataTable(); this.Tables.Add(this.tableUserRole); this.tableRole = new RoleDataTable(); this.Tables.Add(this.tableRole); ForeignKeyConstraint fkc; fkc = new ForeignKeyConstraint("User_UserRole", new DataColumn[] { this.tableUser.loginColumn}, new DataColumn[] { this.tableUserRole.loginColumn}); this.tableUserRole.Constraints.Add(fkc); fkc.AcceptRejectRule = AcceptRejectRule.None; fkc.DeleteRule = Rule.Cascade; fkc.UpdateRule = Rule.Cascade; fkc = new ForeignKeyConstraint("RoleUserRole", new DataColumn[] { this.tableRole.nameColumn}, new DataColumn[] { this.tableUserRole.nameColumn}); this.tableUserRole.Constraints.Add(fkc); fkc.AcceptRejectRule = AcceptRejectRule.Cascade; fkc.DeleteRule = Rule.Cascade; fkc.UpdateRule = Rule.Cascade; this.relationUser_UserRole = new DataRelation("User_UserRole", new DataColumn[] { this.tableUser.loginColumn}, new DataColumn[] { this.tableUserRole.loginColumn}, false); this.relationUser_UserRole.Nested = true; this.Relations.Add(this.relationUser_UserRole); this.relationRoleUserRole = new DataRelation("RoleUserRole", new DataColumn[] { this.tableRole.nameColumn}, new DataColumn[] { this.tableUserRole.nameColumn}, false); this.Relations.Add(this.relationRoleUserRole); }