public CheckedItemWrapper(ICollection <string> properties, Aras.IOM.Item item)
{
Item = item;
Values = properties.ToDictionary(
property => property,
property => item.getProperty(property));
}
private void MethodButton_Click(object sender, EventArgs e)
{
if (CheckError())
{
return;
}
Aras.IOM.Item result = innovator.applyMethod("VC_IsUserAdmin", "<id>" + innovator.getUserID() + "</id>");
if (result.isError())
{
msgBox.AppendText("\n\nMethod Error: " + result.getErrorDetail());
return;
}
msgBox.AppendText("\n\nResult of execution method VC_IsUserAdmin:\n");
msgBox.AppendText("\n " + result.getResult());
}
private void SQLButton_Click(object sender, EventArgs e)
{
if (CheckError())
{
return;
}
Aras.IOM.Item result = innovator.applySQL("select login_name, first_name, last_name from [user]");
if (result.isError())
{
msgBox.AppendText("\n\nSQL Error: " + result.getErrorDetail());
return;
}
result = result.getItemsByXPath("//Item");
msgBox.AppendText("\n\nSQL Found " + result.getItemCount() + " User Items:\n");
for (var i = 0; i < result.getItemCount(); i++)
{
msgBox.AppendText("\n " + (i + 1) + " " + result.getItemByIndex(i).getProperty("first_name", "na") + " " + result.getItemByIndex(i).getProperty("last_name", "na"));
}
}
private void AMLButton_Click(object sender, EventArgs e)
{
if (CheckError())
{
return;
}
Aras.IOM.Item result = innovator.applyAML("<AML><Item type='User' action='get' select='first_name,last_name'></Item></AML>");
if (result.isError())
{
msgBox.AppendText("\n\nAML Error: " + result.getErrorDetail());
return;
}
result = result.getItemsByXPath("//Item");
msgBox.AppendText("\n\nAML Found " + result.getItemCount() + " User Items:\n");
for (var i = 0; i < result.getItemCount(); i++)
{
msgBox.AppendText("\n " + (i + 1) + " " + result.getItemByIndex(i).getProperty("first_name", "na") + " " + result.getItemByIndex(i).getProperty("last_name", "na"));
}
}
private void QueryButton_Click(object sender, EventArgs e)
{
if (CheckError())
{
return;
}
Aras.IOM.Item selectUsersItem = innovator.newItem("User", "get");
selectUsersItem.setAttribute("select", "first_name,last_name");
selectUsersItem = selectUsersItem.apply();
if (selectUsersItem.isError())
{
msgBox.AppendText("\n\nQuery Error: " + selectUsersItem.getErrorDetail());
return;
}
selectUsersItem = selectUsersItem.getItemsByXPath("//Item[@type='User']");
msgBox.AppendText("\n\nQuery Found " + selectUsersItem.getItemCount() + " User Items:\n");
for (var i = 0; i < selectUsersItem.getItemCount(); i++)
{
msgBox.AppendText("\n " + (i + 1) + " " + selectUsersItem.getItemByIndex(i).getProperty("first_name", "na") + " " + selectUsersItem.getItemByIndex(i).getProperty("last_name", "na"));
}
}
private static string EnsureSingleItem(string expectedItemType, string expectedAction, ref Aras.IOM.Item item)
{
var allItems = item.Enumerate().Where(i =>
(string.IsNullOrEmpty(expectedItemType) || i.getType() == expectedItemType) &&
(string.IsNullOrEmpty(expectedAction) || i.getAction() == expectedAction)).ToList();
if (allItems.Count > 1)
{
string typeFilter = !string.IsNullOrEmpty(expectedItemType) ? $" of '{expectedItemType}' type" : string.Empty;
string actionFilter = !string.IsNullOrEmpty(expectedAction) ? $" with '{expectedAction}' action" : string.Empty;
return($"AML has to contain single Item {typeFilter}{actionFilter} in order to be processed.");
}
else if (allItems.Count == 1)
{
item = allItems[0];
return(null);
}
else // if (allItems.Count == 0)
{
return($"No Items of '{expectedItemType}' type with '{expectedAction}' action found.");
}
}
