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;
}
}
}
