private void g_button_submit_Click(object sender, RoutedEventArgs e) { string action = this.g_combobox_action.SelectionBoxItem.ToString(); //Grant or revoke: CS505Project1.Domains.GrantAction grantAction = new Domains.GrantAction(); grantAction.grantor_name = _currentUser; grantAction.grantee_name = this.g_combobox_user.SelectedItem.ToString(); grantAction.table_name = this.g_combobox_table.SelectedItem.ToString(); string operation = (this.g_combobox_operation.SelectedValue as ComboBoxItem).Content.ToString(); string grant = (this.g_combobox_grant.SelectedValue as ComboBoxItem).Content.ToString(); if (operation == "SELECT") { grantAction.operation = Domains.Operation_Type.SELECT; } else { grantAction.operation = Domains.Operation_Type.INSERT; } if (grant == "With") { grantAction.grant = true; } else { grantAction.grant = false; } try { if (action == "Revoke") { //Try Revoke dbServices.Revoke(grantAction); } else { //Try Grant dbServices.Grant(grantAction); } } catch (Exception ex) { MessageBox.Show(ex.Message); return; } MessageBox.Show("Action successful!"); }
//INCORRECT private void np_button_submit_Click(object sender, RoutedEventArgs e) { //Get data from fields: string s_permission = this.np_combobox_permission.SelectionBoxItem.ToString(); string user_name = this.np_combobox_user.SelectedValue.ToString(); string table_name = this.np_combobox_table.SelectedValue.ToString(); string operation = this.np_combobox_operation.SelectedValue.ToString(); string grant = this.np_combobox_grant.SelectedValue.ToString(); #region Permission object Assignment CS505Project1.Domains.Permission permission = new Domains.Permission(); permission.user_name = user_name; permission.table_name = table_name; if (s_permission == "Forbid") { permission.type = Domains.Permission_Type.FORBIDDEN; } else { permission.type = Domains.Permission_Type.PERMITTED; } if (operation == "SELECT") { permission.write = false; } else { permission.write = true; } if (grant == "With") { permission.grant = true; } else { permission.grant = false; } #endregion CS505Project1.Domains.GrantAction grantAction = new Domains.GrantAction(); grantAction.grantor_name = _currentUser; grantAction.grantee_name = user_name; if (operation == "SELECT") { grantAction.operation = CS505Project1.Domains.Operation_Type.SELECT; } else { grantAction.operation = CS505Project1.Domains.Operation_Type.INSERT; } if (grant == "With") { grantAction.grant = true; } else { grantAction.grant = false; } try { dbServices.AddPermissOrForbid(permission); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { //hide old controls this.Admin_Grid.Visibility = System.Windows.Visibility.Visible; //show permission control this.New_Permission_Grid.Visibility = System.Windows.Visibility.Hidden; } }