protected override void ProcessRecord()
{
var db = new CommenceDatabase();
string result = db.ViewCategory(fromCategory); // if fromCategory is not found, nothing happens
if (result.ToLower() != "ok")
{
WriteError(new ErrorRecord(new Vovin.CmcLibNet.CommenceDDEException(result),
"CategoryNotFound",
ErrorCategory.InvalidResult,
db));
return;
}
string clarifyState = db.ClarifyItemNames();
try {
int connectedItemCount = -1;
// no item supplied, process entire category
if (string.IsNullOrEmpty(fromItem))
{
int numItems = db.GetItemCount(fromCategory);
List <string> itemNames = db.GetItemNames(fromCategory);
db.ClarifyItemNames("TRUE");
for (int i = 1; i <= numItems; i++) // DDE-call indexes in Commence are 1-based
{
// since this not rely on string values, it should be reliable
connectedItemCount = db.ViewConnectedCount(i, connectionName, toCategory);
WriteObject(new
{
ItemName = itemNames[i - 1],
FromCategory = fromCategory,
Connection = connectionName,
ToCategory = toCategory,
Count = connectedItemCount
},
false); // return and do not enumerate. I.e. pass every object separately.
}
}
else
{
if (!string.IsNullOrEmpty(clarifyValue) && !string.IsNullOrEmpty(clarifySeparator))
{
fromItem = db.GetClarifiedItemName(fromItem, clarifySeparator, clarifyValue);
db.ClarifyItemNames("TRUE");
}
connectedItemCount = db.GetConnectedItemCount(fromCategory, fromItem, connectionName, toCategory);
WriteObject(new
{
ItemName = fromItem,
FromCategory = fromCategory,
Connection = connectionName,
ToCategory = toCategory,
Count = connectedItemCount
},
false);
}
if (connectedItemCount == -1)
{
WriteError(new ErrorRecord(new Vovin.CmcLibNet.CommenceDDEException("Vovin.CmcLibNet was unable to get a valid result from Commence."),
"CommenceDDEError",
ErrorCategory.InvalidArgument,
db));
WriteVerbose("A count of -1 means an error occurred while trying to receive the count from Commence.\n"
+ "This is likely caused by one or more of the arguments being invalid.\n"
+ "Note that connection- and viewnames in Commence are case-sensitive!\n\n"
+ "A clarify separator may include spaces. Make sure to include them in the command.\n\n");
return;
}
}
finally
{
db.ClarifyItemNames(clarifyState); // restore state
db.Close();
}
}