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));
}
internal UserRoleRow(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);
}
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"];
}
