public static DialogResult ShowConfirmation(ref bool removeUsers) { DropRoleConfirmation frm = new DropRoleConfirmation(); DialogResult result = frm.ShowDialog(); removeUsers = frm.checkBox1.Checked; return(result); }
public bool DropSelectedRoles(bool confirm) { if (grd.SelectedRows.Count == 0) { return(false); } bool removeUsers = false; if (confirm && DropRoleConfirmation.ShowConfirmation(ref removeUsers) != DialogResult.Yes) { return(false); } string roletype = String.Empty; using (SqlConnection conn = _cp.CreateSqlConnection(true, false)) { foreach (DataGridViewRow row in grd.SelectedRows) { if (row.Cells[2].Value == null || row.Cells[2].GetType() == typeof(DBNull)) { continue; } //Remove users if (removeUsers) { DbCmd.RemoveUsersFromRole(conn, row.Cells[2].Value.ToString()); } roletype = (string)row.Cells[3].Value; DbCmd.DropRole(conn, _cp.Database, row.Cells[2].Value.ToString(), roletype.ToLower() == "standard"); } } RefreshRoles(); return(true); }