public static void UpdateUserRole(Guid userId, string roleName)
{
Role role = new Role();
using (var ctx = new DataClasses1DataContext())
{
role = ctx.Roles.FirstOrDefault(x => x.RoleName == roleName);
}
UsersInRole uir;
using (var ctx = new DataClasses1DataContext())
{
uir = ctx.UsersInRoles.FirstOrDefault(x => x.RoleId == role.RoleId && x.UserId == userId);
if (uir != null)
{
ctx.UsersInRoles.DeleteOnSubmit(uir);
}
else
{
uir = new UsersInRole();
uir.UserId = userId;
uir.RoleId = role.RoleId;
ctx.UsersInRoles.InsertOnSubmit(uir);
}
ctx.SubmitChanges();
}
}
private void detach_UsersInRoles(UsersInRole entity)
{
this.SendPropertyChanging();
entity.User = null;
}
private void attach_UsersInRoles(UsersInRole entity)
{
this.SendPropertyChanging();
entity.User = this;
}
partial void DeleteUsersInRole(UsersInRole instance);
partial void UpdateUsersInRole(UsersInRole instance);
partial void InsertUsersInRole(UsersInRole instance);
