public IActionResult GrantRoleObjectPrivs(string id) { var roleObjectsPrivsViewModel = new GrantRoleObjectPrivsViewModel(); roleObjectsPrivsViewModel.Role = id; using (var ole = new OracleConnection(config.GetConnectionString("DefaultConnection"))) { var roleSelect = ole.Query <GrantRoleObjectPrivsViewModel>($"select * from ROLE_TAB_PRIVS where role='{id}' and PRIVILEGE='SELECT'").FirstOrDefault(); if (roleSelect != null) { roleObjectsPrivsViewModel.Select = true; } var roleInsert = ole.Query <GrantRoleObjectPrivsViewModel>($"select * from ROLE_TAB_PRIVS where role='{id}' and PRIVILEGE='INSERT'").FirstOrDefault(); if (roleInsert != null) { roleObjectsPrivsViewModel.Insert = true; } var roleDelete = ole.Query <GrantRoleObjectPrivsViewModel>($"select * from ROLE_TAB_PRIVS where role='{id}' and PRIVILEGE='DELETE'").FirstOrDefault(); if (roleDelete != null) { roleObjectsPrivsViewModel.Delete = true; } return(View(roleObjectsPrivsViewModel)); } }
public IActionResult GrantRoleObjectPrivs(GrantRoleObjectPrivsViewModel model) { if (ModelState.IsValid) { EditObjectPrivs(model.Role, model.Table_Name, "SELECT", model.Select); EditObjectPrivs(model.Role, model.Table_Name, "INSERT", model.Insert); EditObjectPrivs(model.Role, model.Table_Name, "DELETE", model.Delete); } // return View(model); return(RedirectToAction(nameof(RoleController.ListRoleObjectPrivs), "Role")); }