public int AssignRoleToUser(AssignRoleModel model)
{
try
{
ConnectionObj.Open();
CommandObj.CommandText = "spAssignRoleToUser";
CommandObj.CommandType = CommandType.StoredProcedure;
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("@UserId", model.UserId);
CommandObj.Parameters.AddWithValue("@BranchId", model.BranchId);
CommandObj.Parameters.AddWithValue("@RoleId", model.RoleId);
CommandObj.Parameters.AddWithValue("@IsActive", model.ActiveStatus);
CommandObj.Parameters.Add("@RowAffected", SqlDbType.Int);
CommandObj.Parameters["@RowAffected"].Direction = ParameterDirection.Output;
CommandObj.ExecuteNonQuery();
var rowAffected = Convert.ToInt32(CommandObj.Parameters["@RowAffected"].Value);
return(rowAffected);
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
throw new Exception("Could not assign role to user", exception);
}
finally
{
ConnectionObj.Close();
CommandObj.Dispose();
CommandObj.Parameters.Clear();
}
}
public ActionResult UnAssignRoleFromUser(AssignRoleModel model)
{
try
{
var anUser = (ViewUser)Session["user"];
model.AssignedByUserId = anUser.UserId;
model.ActiveStatus = 0;
bool result = _superAdminUserManager.AssignRoleToUser(model);
if (result)
{
TempData["RoleUnAssignedMessage"] = "Role UsAssigned Successfully!";
}
else
{
TempData["RoleUnAssignedMessage"] = "Failed to UsAssign Role";
}
var branches = _iBranchManager.GetAllBranches();
var roles = _iCommonManager.GetAllUserRoles();
ViewBag.BranchId = branches;
ViewBag.RoleId = roles;
return(View());
}
catch (Exception exception)
{
Log.WriteErrorLog(exception);
return(PartialView("_ErrorPartial", exception));
}
}
public async Task <IActionResult> SetRole(AssignRoleModel arm, string userId)
{
var user = await _userManager.FindByIdAsync(userId);
string roletext = Request.Form["Role"];
// if (!roletext.Any()) return RedirectToAction("CollectAllUsers", "Moderation");
// var role = (Role) Enum.Parse(typeof(Role), roletext);
Object roleParse = null;
if (!Enum.TryParse(typeof(Role), roletext, out roleParse))
{
return(RedirectToAction("CollectAllUsers", "Moderation"));
}
var role = (Role)roleParse;
// TODO Send a message to the user stating that the role could not be added
if (!await _roleService.IsSameRoleOrLower(User, role))
{
if (await _userManager.IsInRoleAsync(user, roletext))
{
await _userManager.RemoveFromRoleAsync(user, roletext);
}
else
{
_roleService.AssignToRole(user, role);
}
}
return(RedirectToAction("CollectAllUsers", "Moderation"));
}
public async Task <IActionResult> AssignRoleByEmail([FromBody] AssignRoleModel assignRoleModel)
{
var user = await _userManager.FindByEmailAsync(assignRoleModel.Email);
if (user == null)
{
return(BadRequest());
}
var isRoleExist = await _roleManager.RoleExistsAsync(assignRoleModel.RoleName);
if (isRoleExist == false)
{
return(BadRequest());
}
var roleAssigningResult = await _userManager.AddToRoleAsync(user, assignRoleModel.RoleName);
if (roleAssigningResult.Succeeded)
{
return(Ok());
}
else
{
return(BadRequest(roleAssigningResult.Errors));
}
}
public void Check_Assign_Role_Correct()
{
try
{
var models = this.GetCurrentData();
if (models.Count > 0)
{
var firstRow = models[0];
this.Login = new LoginPage(this.Driver, this.CurrentTest);
//Verify login page title
string loginPageTitle = this.Login.GetLoginTitle();
var p1 = firstRow.P1;
var p2 = firstRow.P2;
var p3 = firstRow.P3;
Assert.AreEqual(p3, loginPageTitle.ToLower());
//login to application
this.Login.LoginToHome(p1, p2);
this.Login.CheckForHome();
// go the next page
Home = new HomePage(this.Driver, this.CurrentTest);
var classData = Home.ChangeToAdmin(firstRow.P5);
//Assert.AreEqual(firstRow.P6, classData);
UserManagement = new UserManagementPage(this.Driver, this.CurrentTest);
UserManagement.ClickOnUserManagementAgain();
UserManagement.ValidateUserPage(firstRow.P7);
UserManagement.ClickAssignRole();
UserManagement = new UserManagementPage(this.Driver, this.CurrentTest);
UserManagement.ValidateRolePage(firstRow.P8);
var assignRole = new AssignRoleModel(this.Driver, this.CurrentTest);
assignRole.ValidateRolePage(firstRow.P9);
assignRole.AssignRole(firstRow.P10, firstRow.P11, firstRow.P12, firstRow.P13);
Home.GetUserLoggedOut();
this.TestPassed("Test passed");
}
}
catch (Exception ex)
{
this.LogException(ex);
throw;
}
}
public async Task <IActionResult> AssignRole(AssignRoleModel ass)
{
if (ModelState.IsValid)
{
var userTask = _userManager.FindByNameAsync(ass.User);
var roleTask = _roleManager.FindByNameAsync(ass.Role);
var user = await userTask;
var role = await roleTask;
if (user != null && role != null)
{
var result = await _userManager.AddToRoleAsync(user, role.Name);
}
}
return(View());
}
public void AssignUserToRole(AssignRoleModel userViewModel)
{
var departmentId = userViewModel.DepartmentId == Guid.Empty ? (Guid?)null : userViewModel.DepartmentId;
var divisionId = userViewModel.DivisionId == Guid.Empty ? (Guid?)null : userViewModel.DivisionId;
var companyId = userViewModel.CompanyId == Guid.Empty ? (Guid?)null : userViewModel.CompanyId;
var aur = new ApplicationUserRole()
{
UserRoleID = userViewModel.UserRoleID,
RoleID = userViewModel.RoleID,
UserID = userViewModel.UserID,
DepartmentId = departmentId,
DivisionId = divisionId,
CompanyId = companyId,
CreatedBy = Guid.Parse("5C7B1948-FEC5-4573-AFA3-BD72FECC2997"),
CreatedDate = DateTime.Now
};
_applicationUserRoleService.Insert(aur);
}
public void RemoveRoleFromUser(AssignRoleModel userViewModel)
{
_applicationUserRoleService.Delete(_applicationUserRoleService.Find(userViewModel.UserRoleID));
}
public bool AssignRoleToUser(AssignRoleModel model)
{
int rowAffected = gateway.AssignRoleToUser(model);
return(rowAffected > 0);
}
