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;
}
}
