private void popupAddPermission()
{
if (ID < 1)
{
if (DialogResult.Yes == MessageBox.Show(this, "You must save the permission template before adding permissions to it.\nDo you want to save it now?", "Save Permission Template?", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
save(false);
}
else
{
return;
}
}
frmPermissions fp = new frmPermissions();
foreach (ListViewItem lvi in lvPermissions.Items)
{
fp.AssignedIDs.Add(Toolkit.ToInt32(lvi.Tag, -1));
}
if (DialogResult.OK == MainFormPopupForm(fp, this, true))
{
// add selected permission to user, refresh
AdminProxy.AddPermissionsToTemplate(ID, fp.SelectedIDs);
RefreshData();
}
}
private void lvPermissions_DragDrop(object sender, DragEventArgs e)
{
var ddo = getDragDropObject(e);
AdminProxy.AddPermissionsToTemplate(ID, ddo.IDList);
RefreshData();
}
private void ddlResourceField_SelectedIndexChanged(object sender, EventArgs e)
{
// Sync(delegate() {
int resID = Toolkit.ToInt32(ddlResource.SelectedValue, -1);
int resFieldID = Toolkit.ToInt32(ddlResourceField.SelectedValue, -1);
if (ResourceType == "dataview")
{
var dt = AdminProxy.ListDataViewFields(resID, resFieldID).Tables["list_dataview_fields"];
if (dt.Rows.Count > 0)
{
lblType.Text = "(" + dt.Rows[0]["field_type"].ToString() + ")";
initCompareDropdown(ddlCompare, lblType.Text.ToLower(), ddlCompare.Text);
}
}
else if (ResourceType == "table")
{
var dt = AdminProxy.ListTableFields(resID, resFieldID, false).Tables["list_table_fields"];
if (dt.Rows.Count > 0)
{
lblType.Text = "(" + dt.Rows[0]["field_type"].ToString() + ")";
initCompareDropdown(ddlCompare, lblType.Text.ToLower(), ddlCompare.Text);
}
}
CheckDirty();
// });
}
public override void RefreshData()
{
this.Text = "Users - " + this.AdminProxy.Connection.ServerName + (Toolkit.IsProcessElevated() ? " - Administrator " : "");
var tags = rememberSelectedTags(lvUsers);
updateSplashText("listing users...");
var dt = AdminProxy.ListUsers(-1).Tables["list_users"];
initHooksForMdiParent(dt, "user_name", "sys_user_id");
lvUsers.Items.Clear();
foreach (DataRow dr in DataTable.Rows)
{
var lvi = new ListViewItem(new string[] {
dr["user_name"].ToString(),
dr["full_name"].ToString(),
dr["is_admin"].ToString(),
dr["is_enabled"].ToString(),
dr["language_name"].ToString(),
dr["web_user_name"].ToString()
});
lvi.ImageIndex = 0;
lvi.Tag = dr["sys_user_id"];
lvUsers.Items.Add(lvi);
}
selectRememberedTags(lvUsers, tags);
MainFormUpdateStatus(getDisplayMember("RefreshData{done}", "Refreshed Users"), false);
}
private void save(bool showParent)
{
ID = AdminProxy.SavePermission(Toolkit.ToInt32(ID, -1),
txtCode.Text,
txtName.Text,
txtDescription.Text,
Toolkit.ToInt32(ddlDataView.SelectedValue, -1),
Toolkit.ToInt32(ddlTable.SelectedValue, -1),
ddlCreate.Text,
ddlRead.Text,
ddlUpdate.Text,
ddlDelete.Text,
chkEnabled.Checked);
if (showParent)
{
MainFormSelectParentTreeNode();
MainFormUpdateStatus(getDisplayMember("Saved permission {0}", txtName.Text), true);
DialogResult = DialogResult.OK;
this.Close();
}
else
{
RefreshData();
MainFormUpdateStatus(getDisplayMember("Saved permission {0}", txtName.Text), true);
DialogResult = DialogResult.OK;
this.Close();
}
}
private void save()
{
string codeGroup = null;
if (ddlCodeGroup.SelectedIndex > 0)
{
codeGroup = ddlCodeGroup.Text;
}
ID = AdminProxy.SaveTableFieldMapping(Toolkit.ToInt32(ID, -1),
TableID,
txtFieldName.Text,
convertFieldPurpose(ddlPurpose.Text),
convertFieldType(ddlType.Text),
txtDefaultValue.Text,
chkPK.Checked,
chkForeignKey.Checked,
_foreignKeyTableFieldID,
(ddlLookupPicker.Text == "(None)" ? null: ddlLookupPicker.Text),
// stored as nullable, displaying required -- so it's just the opposite
!chkRequired.Checked,
convertFieldGuiHint(ddlGuiHint.Text),
chkReadOnly.Checked,
(ddlType.Text == "Text" ? Toolkit.ToInt32(txtMinLength.Text, 0) : 0),
(ddlType.Text == "Text" ? Toolkit.ToInt32(txtMaxLength.Text, 0) : 0),
(ddlType.Text == "Integer" ? Toolkit.ToInt32(txtPrecision.Text, 0) : 0),
(ddlType.Text == "Integer" ? Toolkit.ToInt32(txtScale.Text, 0) : 0),
chkAutoIncrement.Checked,
codeGroup, _dtLangs);
MainFormUpdateStatus(getDisplayMember("save{done}", "Saved table field mapping {0}", txtFieldName.Text), true);
}
private void cmiFieldShowDependencies_Click(object sender, EventArgs e)
{
if (lvFieldMappings.SelectedItems.Count == 1)
{
var fieldName = lvFieldMappings.SelectedItems[0].Text.ToString();
var dt = AdminProxy.GetTableFieldDependencies(_tableName, fieldName).Tables["table_field_dependencies"];
var msg = new frmMessageBox();
msg.btnYes.Visible = false;
msg.Text = "Dependencies for " + _tableName + "." + fieldName;
msg.btnNo.Text = "OK";
var txt = "";
if (dt.Rows.Count == 0)
{
txt = "(None)";
}
else
{
foreach (DataRow dr in dt.Rows)
{
txt += dr["display_member"].ToString() + "\r\n";
}
}
txt += "\r\n\r\nNote: Only dataview fields explicitly mapped to this table/field are shown above. The SQL statement within a dataview may still use it.\r\n\r\nIf editing or removing this field, please verify all dataviews afterwards to ensure system integrity.";
msg.txtMessage.Text = txt;
msg.ShowDialog(this);
}
}
public clsWSUS(clsConfig configobject)
{
cfg = configobject;
// Initialise SQL query
sql.ConnectionString = cfg.SQLConnectionString();
if (CheckDBConnection())
{
// Set connection to SQL server for all queries
cmdLastUpdate.Connection = sql;
cmdApprovedUpdates.Connection = sql;
cmdLastSync.Connection = sql;
cmdUnassignedComputers.Connection = sql;
cmdUpdateErrors.Connection = sql;
cmdComputerGroups.Connection = sql;
}
// Connect to WSUS server
try
{
server = AdminProxy.GetUpdateServer(cfg.WSUSServer, cfg.WSUSSecureConnection);
wsusStatus = "OK";
}
catch (Exception ex)
{
wsusStatus = "Error: " + ex.Message;
}
}
private void removeSelectedGroups(bool prompt)
{
if (lvGroups.SelectedItems.Count == 0)
{
return;
}
if (prompt)
{
if (DialogResult.Yes != MessageBox.Show(this, getDisplayMember("removeGroups{start_body}", "You are about to permanently remove this user from these group(s).\nDo you want to continue?"),
getDisplayMember("removeGroups{start_title}", "Remove From Groups?"), MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
return;
}
}
List <int> ids = new List <int>();
ids.Add(ID);
var count = 0;
foreach (ListViewItem lvi in lvGroups.SelectedItems)
{
var groupID = Toolkit.ToInt32(lvi.Tag, -1);
try {
AdminProxy.RemoveUsersFromGroup(groupID, ids);
count++;
} catch (Exception ex) {
MessageBox.Show(this, ex.Message, getDisplayMember("removeGroups{failed}", "Error Removing User From Group"));
}
}
refreshData(false, false, true);
MainFormUpdateStatus(getDisplayMember("removedfromgroup{done}", "Removed user from {0} group(s)", count.ToString("###,##0")), true);
}
private void popupAddUser()
{
if (ID < 1)
{
if (DialogResult.Yes == MessageBox.Show(this, getDisplayMember("popupAddUser{prompt_body}", "You must save the group before adding users to it.\nDo you want to save it now?"),
getDisplayMember("popupAddUser{prompt_title}", "Save Group?"), MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
save(false);
}
else
{
return;
}
}
var fu = new frmUsers();
foreach (ListViewItem lvi in lvUsers.Items)
{
fu.AssignedIDs.Add(Toolkit.ToInt32(lvi.Tag, -1));
}
if (DialogResult.OK == MainFormPopupForm(fu, this, true))
{
// add selected permission to user, refresh
AdminProxy.AddUsersToGroup(ID, fu.SelectedIDs);
RefreshData();
}
}
private void lvUsers_DragDrop(object sender, DragEventArgs e)
{
var ddo = getDragDropObject(e);
AdminProxy.AddUsersToGroup(ID, ddo.IDList);
RefreshData();
}
private void removeSelectedPermissions(bool prompt)
{
if (lvPermissions.SelectedItems.Count == 0)
{
return;
}
if (prompt)
{
if (DialogResult.Yes != MessageBox.Show(this, getDisplayMember("removePermissions{start_body}", "You are about to permanently remove these permission(s) from this user.\nDo you want to continue?"),
getDisplayMember("removePermissions{start_title}", "Remove Permissions?"), MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
return;
}
}
List <int> ids = new List <int>();
foreach (ListViewItem lvi in lvPermissions.SelectedItems)
{
ids.Add(Toolkit.ToInt32(lvi.Tag, -1));
}
AdminProxy.RemovePermissionsFromUser(ID, ids);
refreshData(false, true, false);
MainFormUpdateStatus(getDisplayMember("removePermissions{done}", "Removed permission(s) from user"), true);
}
private void btnOK_Click(object sender, EventArgs e)
{
if (ConnectionStringMode)
{
if (!String.IsNullOrEmpty(_settingName) && _settingName != txtName.Text)
{
// they changed the name. Remove the old one from the document before adding the new one.
this.AdminProxy.DeleteConnectionString(_settingName, _configFilePath);
}
this.AdminProxy.SaveConnectionString(txtName.Text, txtValue.Text, ddlProvider.Text, _configFilePath);
}
else
{
if (!String.IsNullOrEmpty(_settingName) && _settingName != txtName.Text)
{
// they changed the name. Remove the old one from the document before adding the new one.
AdminProxy.DeleteApplicationSetting(_settingName, _configFilePath);
}
AdminProxy.SaveApplicationSetting(txtName.Text, txtValue.Text, _configFilePath);
}
DialogResult = DialogResult.OK;
if (!Modal)
{
MainFormSelectParentTreeNode();
}
else
{
Close();
}
}
private void btnSave_Click_1(object sender, EventArgs e)
{
if (ddlAssembly.SelectedIndex < 0 || ddlAssembly.Text.Contains("<") || ddlClass.SelectedIndex < 0)
{
MessageBox.Show(this, getDisplayMember("save{asmreq_body}", "Both Assembly and Class must be specified."),
getDisplayMember("save{asmreq_title}", "No Class Specified"), MessageBoxButtons.OK, MessageBoxIcon.Information);
ddlClass.Focus();
return;
}
var vPath = getVirtualFolder() + ddlAssembly.Text;
ID = AdminProxy.SaveTrigger(ID,
Toolkit.ToInt32(ddlDataview.SelectedValue, -1),
Toolkit.ToInt32(ddlTable.SelectedValue, -1),
vPath,
_assemblyName,
ddlClass.Text,
txtTitle.Text,
txtDescription.Text,
chkEnabled.Checked,
false);
if (Modal)
{
MainFormRefreshData();
DialogResult = DialogResult.OK;
Close();
}
else
{
MainFormSelectParentTreeNode();
}
}
private void btnWebCooperatorSearch_Click(object sender, EventArgs e)
{
var f = new frmWebCooperator();
if (f.ShowDialog(this.Owner as mdiParent, this.AdminProxy) == DialogResult.OK)
{
_webCooperatorID = f.WebCooperatorID;
txtWebUserName.Text = "";
txtWebLastName.Text = "";
txtWebFirstName.Text = "";
var ds = AdminProxy.GetWebCooperatorInfo(_webCooperatorID);
var dt = ds.Tables["web_cooperator_info"];
if (dt != null)
{
if (dt.Rows.Count > 0)
{
var dr = dt.Rows[0];
txtWebFirstName.Text = dr["web_first_name"].ToString();
txtWebLastName.Text = dr["web_last_name"].ToString();
txtWebUserName.Text = dr["web_user_name"].ToString();
}
}
}
CheckDirty();
}
static void Main(string[] args)
{
//Create IUpdateServer variable and connect to WSUS Server
//replace the "REPLACETHIS" with your WSUS Server Name, SSL or NOT, and Port. Syntax here is (SERVERNAME, REQUIRESSL, PORT)
IUpdateServer server = AdminProxy.GetUpdateServer("REPLACETHIS", true, 443);
//Begin loop thru updates and filter updates to just unapproved updates from beginning of time to current time
foreach (IUpdate update in server.GetUpdates(ApprovedStates.NotApproved, DateTime.MinValue, DateTime.MaxValue, null, null))
{
//Convert UpdateType to string for comparison in following if statement
string updatetype = update.UpdateType.ToString();
//Filter for driver updates only
if (updatetype == "Driver")
{
//Write update name to console
Console.WriteLine("Declining update {0}", update.Title);
//Decline driver update
update.Decline();
//Write confimation to console
Console.WriteLine("Update Successfully Declined");
}
}
//Wait at end of program
string strWaitText = Environment.NewLine + "Press return to close";
Console.WriteLine(strWaitText);
Console.ReadLine();
}
private void cmiDataviewShowDependencies_Click(object sender, EventArgs e)
{
if (lvDataviews.SelectedItems.Count == 1)
{
var dvName = lvDataviews.SelectedItems[0].Tag.ToString();
var dt = AdminProxy.GetDataViewDependencies(dvName).Tables["dataview_dependencies"];
var msg = new frmMessageBox();
msg.btnYes.Visible = false;
msg.Text = "Dependencies for " + dvName;
msg.btnNo.Text = "OK";
if (dt.Rows.Count == 0)
{
msg.txtMessage.Text = "(None)";
}
else
{
var txt = "";
foreach (DataRow dr in dt.Rows)
{
txt += dr["display_member"].ToString() + "\r\n";
}
msg.txtMessage.Text = txt;
}
msg.ShowDialog(this);
}
}
public override void RefreshData()
{
//lvPerms.MultiSelect = !Modal;
this.Text = "Dataviews - " + this.AdminProxy.Connection.ServerName + (Toolkit.IsProcessElevated() ? " - Administrator " : "");
var tags = rememberSelectedTags(lvDataviews);
// this form has multiple uses, as does the underlying ListPermissions method.
// it can:
// List all permissions (0,[0])
// List permission info for a single permission (37,[0])
// List permissions that are NOT in a list (0, [2,3,4,5,6])
var specificCategory = this.CategoryName != null;
var ds = AdminProxy.ListDataViews(-1, CategoryName, specificCategory, null, false);
initHooksForMdiParent(ds.Tables["list_dataviews"], "dataview_name", "dataview_name", (specificCategory ? null : "category_code"));
lvDataviews.Items.Clear();
foreach (DataRow dr in ds.Tables["list_dataviews"].Rows)
{
var lvi = new ListViewItem(dr["dataview_name"].ToString(), 0);
lvi.Tag = dr["dataview_name"].ToString();
lvi.SubItems.Add(dr["title"].ToString());
lvi.SubItems.Add(dr["category_name"].ToString());
lvi.SubItems.Add(dr["database_area"].ToString());
lvi.SubItems.Add((Toolkit.ToDateTime(dr["last_touched_date"], DateTime.MinValue)).ToLocalTime().ToString());
lvi.SubItems.Add(dr["description"].ToString());
lvDataviews.Items.Add(lvi);
}
selectRememberedTags(lvDataviews, tags);
MainFormUpdateStatus(getDisplayMember("RefreshData{refreshed}", "Refreshed Dataviews"), false);
}
private void promptToDelete()
{
if (lvGroups.SelectedItems.Count > 0)
{
if (DialogResult.Yes == MessageBox.Show(this, getDisplayMember("promptToDelete{delete_body}", "Deleting the code group(s) will cause all dataviews and tables that are referencing them to appear as free-form textboxes in the Curator Tool.\r\nAre you sure you want to delete code group(s)"),
getDisplayMember("promptToDelete{delete_title}", "Delete Code Group(s)?"), MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
var delcount = 0;
foreach (ListViewItem lvi in lvGroups.SelectedItems)
{
var cg = lvi.Tag as string;
if (Array.IndexOf(frmCodeGroup.RESERVED_CODE_GROUPS, cg) > -1)
{
MessageBox.Show(this,
getDisplayMember("promptToDelete{required_body}", "Code group {0} cannot be deleted because it is required by the system.", cg),
getDisplayMember("promptToDelete{required_title}", "Code Group Required"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
AdminProxy.DeleteCodeGroup(lvi.Tag as string);
delcount++;
}
}
MainFormUpdateStatus(getDisplayMember("promptToDelete{deleted}", "Deleted {0} code group(s).", delcount.ToString("###,###,##0")), true);
RefreshData();
}
}
}
private void refreshEffectivePermissions()
{
string dv = ddlDataView.SelectedValue.ToString();
if (dv.StartsWith("--"))
{
dv = null;
}
string tbl = ddlTable.SelectedValue.ToString();
if (tbl.StartsWith("--"))
{
tbl = null;
}
var dt = AdminProxy.ListEffectivePermissions(ID, dv, tbl).Tables["effective_permissions"];
if (dt.Rows.Count > 0)
{
var dr = dt.Rows[0];
displayEffectivePermission(lblCreate, dr["create_permission"].ToString());
displayEffectivePermission(lblRead, dr["read_permission"].ToString());
displayEffectivePermission(lblUpdate, dr["update_permission"].ToString());
displayEffectivePermission(lblDelete, dr["delete_permission"].ToString());
}
}
public override void RefreshData()
{
//lvPerms.MultiSelect = !Modal;
this.Text = "Code Groups - " + this.AdminProxy.Connection.ServerName + (Toolkit.IsProcessElevated() ? " - Administrator " : "");
var tags = rememberSelectedTags(lvGroups);
// this form has multiple uses, as does the underlying ListPermissions method.
// it can:
// List all permissions (0,[0])
// List permission info for a single permission (37,[0])
// List permissions that are NOT in a list (0, [2,3,4,5,6])
var dt = AdminProxy.ListCodeGroups(null).Tables["list_code_groups"];
initHooksForMdiParent(dt, "group_name", "group_name");
lvGroups.Items.Clear();
foreach (DataRow dr in dt.Rows)
{
var lvi = new ListViewItem(dr["group_name"].ToString(), 0);
lvi.ImageIndex = 0;
lvi.SubItems.Add(dr["reference_count"].ToString());
lvi.SubItems.Add(dr["value_count"].ToString());
lvi.SubItems.Add((Toolkit.ToDateTime(dr["last_touched"], DateTime.MinValue)).ToLocalTime().ToString());
lvi.Tag = dr["group_name"].ToString();
lvGroups.Items.Add(lvi);
}
selectRememberedTags(lvGroups, tags);
MainFormUpdateStatus(getDisplayMember("RefreshData{refreshed}", "Refreshed Code Groups"), false);
}
private void btnChangePassword_Click(object sender, EventArgs e)
{
var f = new frmSetPassword();
if (f.ShowDialog(this, MainFormCurrentNodeText(txtUserName.Text)) == DialogResult.OK)
{
if (ID < 1)
{
// new user, can't change it yet. remember it for when we save the user
_password = f.Password;
lblPasswordNotSet.Visible = String.IsNullOrEmpty(_password);
btnSave.Enabled = String.IsNullOrEmpty(_password);
MarkDirty();
}
else
{
using (new AutoCursor(this)) {
AdminProxy.ChangePassword(ID, f.Password);
if (txtUserName.Text.ToLower() == AdminProxy.Connection.GrinGlobalUserName.ToLower())
{
AdminProxy.Connection.GrinGlobalPassword = f.Password;
if (AdminProxy.Connection.GrinGlobalRememberPassword)
{
MainFormSaveConnections(AdminProxy.Connection);
}
}
MainFormUpdateStatus(getDisplayMember("changePassword{done}", "Changed password for user {0}", MainFormCurrentNodeText(txtUserName.Text)), true);
}
}
}
}
private void removeSelectedPermissions(bool prompt)
{
if (lvPermissions.SelectedItems.Count == 0)
{
return;
}
if (prompt)
{
if (DialogResult.Yes != MessageBox.Show(this, getDisplayMember("promptToDelete{prompt_body}", "You are about to permanently remove these permission(s) from this group.\nDo you want to continue?"),
getDisplayMember("promptToDelete{prompt_title}", "Remove Permissions?"), MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
return;
}
}
List <int> ids = new List <int>();
foreach (ListViewItem lvi in lvPermissions.SelectedItems)
{
ids.Add(Toolkit.ToInt32(lvi.Tag, -1));
}
AdminProxy.RemovePermissionsFromGroup(ID, ids);
RefreshData();
}
public WSUS()
{
// I use impersonation to use other logon than mine. Remove the following "using" if not needed
using (Impersonation.LogonUser("mydomain.local", "admin_account_wsus", "Password", LogonType.Batch))
{
ComputerTargetScope scope = new ComputerTargetScope();
IUpdateServer server = AdminProxy.GetUpdateServer("wsus_server.mydomain.local", false, 80);
ComputerTargetCollection targets = server.GetComputerTargets(scope);
// Search
targets = server.SearchComputerTargets("any_server_name_or_ip");
// To get only on server FindTarget method
IComputerTarget target = FindTarget(targets, "any_server_name_or_ip");
Console.WriteLine(target.FullDomainName);
IUpdateSummary summary = target.GetUpdateInstallationSummary();
UpdateScope _updateScope = new UpdateScope();
// See in UpdateInstallationStates all other properties criteria
_updateScope.IncludedInstallationStates = UpdateInstallationStates.Downloaded;
UpdateInstallationInfoCollection updatesInfo = target.GetUpdateInstallationInfoPerUpdate(_updateScope);
int updateCount = updatesInfo.Count;
foreach (IUpdateInstallationInfo updateInfo in updatesInfo)
{
Console.WriteLine(updateInfo.GetUpdate().Title);
}
}
}
private void removeSelectedUsers(bool prompt)
{
if (lvUsers.SelectedItems.Count == 0)
{
return;
}
if (prompt)
{
if (DialogResult.Yes != MessageBox.Show(this, getDisplayMember("removeSelectedUsers{prompt_body}", "You are about to permanently remove these user(s) from this group.\nDo you want to continue?"),
getDisplayMember("removeSelectedUsers{prompt_title}", "Remove Users?"), MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
return;
}
}
List <int> ids = new List <int>();
foreach (ListViewItem lvi in lvUsers.SelectedItems)
{
ids.Add(Toolkit.ToInt32(lvi.Tag, -1));
}
try {
AdminProxy.RemoveUsersFromGroup(ID, ids);
} catch (Exception ex) {
MessageBox.Show(this, ex.Message, getDisplayMember("removeSelectedUsers{failed_title}", "Error Removing user(s)"));
}
RefreshData();
}
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
string username = null;
switch (lvUsers.SelectedItems.Count)
{
case 0:
MessageBox.Show(getDisplayMember("changedPassword{oneuserrequired}", "Please select at least one user to change a password for."));
return;
case 1:
username = lvUsers.SelectedItems[0].Text;
break;
default:
username = "******";
break;
}
var f = new frmSetPassword();
if (f.ShowDialog(this, username) == DialogResult.OK)
{
using (new AutoCursor(this)) {
foreach (ListViewItem lvi in lvUsers.SelectedItems)
{
AdminProxy.ChangePassword(Toolkit.ToInt32(lvi.Tag, -1), f.Password);
}
MainFormUpdateStatus(getDisplayMember("changedPassword{done}", "Changed password for {0} user(s)", lvUsers.SelectedItems.Count.ToString("###,##0")), true);
MainFormRefreshData();
}
}
}
public void Test()
{
var proxy = new AdminProxy(BaseAddress);
var admin = proxy.Get(new CredentialModel
{
Key = AdminKey
}).Result;
Assert.Contains(AppId, admin.Apps);
proxy.Update(new CredentialModel
{
Key = AdminKey
}, new UpdateCredentialModel
{
Key = "5"
}).Wait();
AdminKey = "5";
admin = proxy.Get(new CredentialModel
{
Key = AdminKey
}).Result;
Assert.Contains(AppId, admin.Apps);
}
private void lvPermissions_DragDrop(object sender, DragEventArgs e)
{
var ddo = getDragDropObject(e);
AdminProxy.AddPermissionsToUser(ID, ddo.IDList);
RefreshData();
MainFormUpdateStatus(getDisplayMember("permissionsDragDrop{addpermission}", "Added permission(s) to user"), true);
}
private void lvGroups_DragDrop(object sender, DragEventArgs e)
{
var ddo = getDragDropObject(e);
AdminProxy.AddUsersToGroup(ddo.IDList[0], new List <int>(new int[] { ID }));
RefreshData();
MainFormUpdateStatus(getDisplayMember("groupsDragDrop{addeduser}", "Added user to group"), true);
}
private void promptToDelete()
{
if (lvValues.SelectedItems.Count > 0)
{
if (DialogResult.No == MessageBox.Show(this,
getDisplayMember("promptToDelete{body}", "Are you sure you want to delete these values?"),
getDisplayMember("promptToDelete{title}", "Delete Values?"), MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
return;
}
else
{
var delcount = 0;
var skipcount = 0;
var dtTables = AdminProxy.ListTablesAndDataviewsByCodeGroup(txtName.Text).Tables["list_tables_and_dataviews_by_code_group"];
var tables = new List <string>();
var fields = new List <string>();
foreach (DataRow dr in dtTables.Rows)
{
var tbl = dr["table_name"].ToString();
if (!String.IsNullOrEmpty(tbl))
{
tables.Add(tbl);
fields.Add(dr["field_name"].ToString());
}
}
foreach (ListViewItem lvi in lvValues.SelectedItems)
{
var rowcount = 0;
for (var i = 0; i < tables.Count; i++)
{
rowcount += AdminProxy.GetCodeValueUsageCount(lvi.Text, tables[i], fields[i]);
}
if (rowcount > 0)
{
skipcount++;
MessageBox.Show(this,
getDisplayMember("promptToDelete{rowcount_body}", "Cannot delete value '{0}'. {1} rows of data are currently using it.", lvi.Text, rowcount.ToString()),
getDisplayMember("promptToDelete{rowcount_title}", "Value In Use"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
AdminProxy.DeleteCodeValue(Toolkit.ToInt32(lvi.Tag, -1), txtName.Text);
delcount++;
}
}
if (delcount > 0)
{
RefreshData();
}
MainFormUpdateStatus(getDisplayMember("promptToDelete{deleted}", "Deleted {0} code values, skipped {1}", delcount.ToString(), skipcount.ToString()), true);
}
}
}
private void promptToDelete()
{
if (lvMappings.SelectedItems.Count > 0)
{
var total = 0;
var fmb = new frmMessageBox();
fmb.btnYes.Text = "&Delete";
fmb.btnNo.Text = "&Cancel";
fmb.Text = "Delete Table Mapping(s)?";
var sb = new StringBuilder();
sb.AppendLine("Are you sure you want to delete table mappings for the following tables?\r\n");
foreach (ListViewItem lvi in lvMappings.SelectedItems)
{
sb.AppendLine(" " + lvi.Text);
}
fmb.txtMessage.Text = sb.ToString();
if (DialogResult.Yes == fmb.ShowDialog(this))
{
//if (DialogResult.Yes == MessageBox.Show(this, "Are you sure you want to delete table mapping(s)?", "Delete Table Mapping(s)?", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) {
foreach (ListViewItem lvi in lvMappings.SelectedItems)
{
try {
AdminProxy.DeleteTableMapping(Toolkit.ToInt32(lvi.Tag, -1), false);
total++;
} catch (Exception ex) {
if (ex.Message.Contains("delete the table mapping"))
{
fmb.btnYes.Text = "Continue &Deleting";
fmb.Text = "Remove References and Continue Delete?";
fmb.txtMessage.Text = ex.Message + "\r\n\r\nDo you want to remove the reference(s) and continue deleting " + lvi.Text + "?";
if (DialogResult.Yes == fmb.ShowDialog(this))
{
//if (DialogResult.Yes == MessageBox.Show(this, ex.Message + "\r\n\r\nDo you want to remove the reference(s) and continue deleting " + lvi.Text + "?", "Remove References and Continue Delete?", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) {
AdminProxy.DeleteTableMapping(Toolkit.ToInt32(lvi.Tag, -1), true);
total++;
}
else
{
// nothing to do
}
}
else
{
throw;
}
}
}
MainFormUpdateStatus(getDisplayMember("promptToDelete{done}", "Deleted {0} table mapping(s)", total.ToString("###,##0")), true);
RefreshData();
}
}
}
