public void AddUserToRole(HsrOrderApp.BL.DomainModel.User user, HsrOrderApp.BL.DomainModel.Role role) { try { User dbUser = db.UserSet.First(u => u.UserId == user.UserId); Role dbRole = db.RoleSet.First(r => r.RoleId == role.RoleId); dbUser.Roles.Add(dbRole); db.SaveChanges(); } catch (OptimisticConcurrencyException ex) { if (ExceptionPolicy.HandleException(ex, "DA Policy")) { throw; } } }
public void RemoveUserFromRole(HsrOrderApp.BL.DomainModel.User user, HsrOrderApp.BL.DomainModel.Role role) { try { User dbUser = db.Users.FirstOrDefault(u => u.UserId == user.UserId); UserInRole dbUserInRole = dbUser.UserInRoles.FirstOrDefault(u => u.RoleId == role.RoleId); if (dbUserInRole == null) { // user not in role anyway return; } db.UserInRoles.DeleteOnSubmit(dbUserInRole); db.SubmitChanges(); } catch (ChangeConflictException ex) { if (ExceptionPolicy.HandleException(ex, "DA Policy")) { throw; } } }
public void AddUserToRole(HsrOrderApp.BL.DomainModel.User user, HsrOrderApp.BL.DomainModel.Role role) { try { UserInRole dbUserInRole = db.UserInRoles.FirstOrDefault(ur => ur.RoleId == role.RoleId && ur.UserId == user.UserId); if (dbUserInRole != null) { // user already in role return; } dbUserInRole = new UserInRole(); dbUserInRole.Role = db.Roles.FirstOrDefault(r => r.RoleId == role.RoleId); dbUserInRole.User = db.Users.FirstOrDefault(u => u.UserId == user.UserId); db.UserInRoles.InsertOnSubmit(dbUserInRole); db.SubmitChanges(); } catch (ChangeConflictException ex) { if (ExceptionPolicy.HandleException(ex, "DA Policy")) { throw; } } }