public bool UpdateUserRole(UserRoleAdminViewModel model)
{
int rowsAffected = 0;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(SQL_UpdateUserRole, connection);
command.Parameters.AddWithValue("@userID", model.UserID);
command.Parameters.AddWithValue("@role", model.UserRoleID);
rowsAffected = command.ExecuteNonQuery();
}
if (rowsAffected == 1)
{
return(true);
}
else
{
return(false);
}
}
// [AuthorizationFilter("1")]
public IActionResult EditRole(int id)
{
UserRoleAdminViewModel model = new UserRoleAdminViewModel();
model.UserID = id;
model.UserName = userSqlDal.GetUserByID(id).Name;
model.UserEmail = userSqlDal.GetUserByID(id).Email;
model.UserRoleID = userSqlDal.GetUserByID(id).Role;
return(View(model));
}
public IActionResult EditRole(UserRoleAdminViewModel model, int id)
{
if (!ModelState.IsValid)
{
return(View(model));
}
else
{
bool result = userSqlDal.UpdateUserRole(model);
LogChanges("UPDATE ROLE: " +
(String.IsNullOrEmpty(model.User.Email)?"":model.UserEmail) +
"to role: " +
(String.IsNullOrEmpty(model.User.RoleDescription) ? "" : model.User.RoleDescription));
return(RedirectToAction("Index", "Admin"));
}
}
