public IActionResult GrantRoleRole(string id) { using (var ole = new OracleConnection(config.GetConnectionString("DefaultConnection"))) { GrantRoleToRoleViewModel vmGrantRoleToRole = new GrantRoleToRoleViewModel(); vmGrantRoleToRole.Role = id; var roleList = ole.Query <RoleListModel>("SELECT ROLE FROM DBA_ROLES"); vmGrantRoleToRole.Roles = roleList.Select(x => new SelectListItem() { Text = x.ROLE.ToString(), Value = x.ROLE.ToString() }); return(View(vmGrantRoleToRole)); } }
public IActionResult GrantRoleRole(GrantRoleToRoleViewModel model) { if (ModelState.IsValid) { try { using (var conn = new OracleConnection(config.GetConnectionString("DefaultConnection"))) { conn.Open(); OracleCommand cmd = conn.CreateCommand(); cmd.CommandText = $"GRANT {model.Role} TO {model.GrantedRole} "; cmd.ExecuteNonQuery(); return(RedirectToAction("ListRoleRolePrivs", "Role")); } } catch (Exception e) { } } return(RedirectToAction(nameof(RoleController.ListRoleRolePrivs), "Role")); }