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