private void btnContainees_Click(object sender, System.EventArgs e)
{
FolderNode folder;
// Reset the data grid
dgrdContainees.DataSource = null;
dgrdContainees.Show();
btnGetContent.Enabled = false;
// Get the ID of the folder we are to search for containees
if (treeFolders.SelectedNode == null)
{
MessageBox.Show("You must first select a folder node");
return;
}
folder = (FolderNode)treeFolders.SelectedNode.Tag;
string strFolderId = folder.Id;
// Properties to exclude in the query results
string[] strExclude = new string[2];
strExclude[0] = "DateCreated";
strExclude[1] = "DateLastModified";
// Get the folder's Containees list object
CEWSI.ObjectRequestType objContaineesRequest = new CEWSI.ObjectRequestType();
CEWSI.ObjectSpecification objContaineesSpec = new CEWSI.ObjectSpecification();
objContaineesSpec.classId = "Folder";
objContaineesSpec.objectId = strFolderId;
objContaineesSpec.objectStore = MainForm.Library;
objContaineesSpec.propertyId = "Containees";
objContaineesRequest.SourceSpecification = objContaineesSpec;
objContaineesRequest.id = "1";
// Make sure to ask for the Head property of the RCR
objContaineesRequest.PropertyFilter = new CEWSI.PropertyFilterType();
CEWSI.FilterElementType filterHead = new CEWSI.FilterElementType();
CEWSI.FilterElementType filterCName = new CEWSI.FilterElementType();
CEWSI.FilterElementType filterId = new CEWSI.FilterElementType();
CEWSI.FilterElementType filterCreator = new CEWSI.FilterElementType();
CEWSI.FilterElementType filterContentSize = new CEWSI.FilterElementType();
CEWSI.FilterElementType filterTitle = new CEWSI.FilterElementType();
filterHead.Value = "Head";
filterCName.Value = "ContainmentName";
filterId.Value = "Id";
filterCreator.Value = "Creator";
filterContentSize.Value = "ContentSize";
filterTitle.Value = "DocumentTitle";
objContaineesRequest.PropertyFilter.IncludeProperties = new CEWSI.FilterElementType[6];
objContaineesRequest.PropertyFilter.IncludeProperties[0] = filterHead;
objContaineesRequest.PropertyFilter.IncludeProperties[1] = filterCName;
objContaineesRequest.PropertyFilter.IncludeProperties[2] = filterId;
objContaineesRequest.PropertyFilter.IncludeProperties[3] = filterCreator;
objContaineesRequest.PropertyFilter.IncludeProperties[4] = filterContentSize;
objContaineesRequest.PropertyFilter.IncludeProperties[5] = filterTitle;
objContaineesRequest.PropertyFilter.ExcludeProperties = strExclude;
objContaineesRequest.PropertyFilter.maxRecursion = 1;
objContaineesRequest.PropertyFilter.maxRecursionSpecified = true;
// Test continuation objContaineesRequest.maxElements = 2;
// objContaineesRequest.maxElementsSpecified = true;
// Create the request array
CEWSI.ObjectRequestType[] objRequestArray = new CEWSI.ObjectRequestType[1];
objRequestArray[0] = objContaineesRequest;
// Fill in the security headers...
CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
MainForm.Domain, MainForm.Password, MainForm.URL);
// Send off the request
CEWSI.ObjectResponseType[] objResponses = null;
try
{
objResponses = objBinding.GetObjects(WSIUtil.GetLocalization(), objRequestArray);
}
catch (System.Net.WebException ex)
{
MessageBox.Show("An exception occurred while querying for containees: [" + ex.Message + "]");
return;
}
catch (Exception allEx)
{
MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
return;
}
// Get the containees
if (objResponses.Length < 1)
{
MessageBox.Show("No containees found");
return;
}
if (objResponses[0].GetType() == typeof(CEWSI.ErrorStackResponse))
{
CEWSI.ErrorStackResponse objErrResponse = (CEWSI.ErrorStackResponse)objResponses[0];
CEWSI.ErrorStackType objStack = objErrResponse.ErrorStack;
CEWSI.ErrorRecordType objErr = objStack.ErrorRecord[0];
MessageBox.Show("Error [" + objErr.Description + "] occurred. " +
" Err source is [" + objErr.Source + "]");
return;
}
CEWSI.ObjectSetResponse objSetResponse = (CEWSI.ObjectSetResponse)objResponses[0];
CEWSI.ObjectSetType objResults = objSetResponse.ObjectSet;
if (objResults.Object == null || objResults.Object.Length < 1)
{
MessageBox.Show("No containees found");
return;
}
// Query was successful; display a list of result rows
// First create a data table that has our columns in it
System.Data.DataColumn dtCol;
System.Data.DataRow dtRow;
System.Data.DataTable dtblResults = new System.Data.DataTable("Results");
dtCol = new System.Data.DataColumn("RCRId");
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
dtCol = new System.Data.DataColumn("ContainmentName");
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
dtCol = new System.Data.DataColumn("Id");
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
dtCol = new System.Data.DataColumn("ClassID");
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
dtCol = new System.Data.DataColumn("Title");
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
dtCol = new System.Data.DataColumn("Creator");
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
dtCol = new System.Data.DataColumn("ContentSize");
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
// For each containee, make an entry in our data table
CEWSI.ObjectValue objHead = null;
foreach (CEWSI.ObjectValue objContainee in (CEWSI.ObjectValue[])objResults.Object)
{
dtRow = dtblResults.NewRow();
foreach (CEWSI.PropertyType objProp in objContainee.Property)
{
if (objProp.propertyId == "ContainmentName")
{
dtRow["ContainmentName"] = IdmObjectType.getPropertyValue(objProp);
}
if (objProp.propertyId == "Id")
{
dtRow["RCRId"] = IdmObjectType.getPropertyValue(objProp);
}
if (objProp.propertyId == "Head")
{
objHead = (CEWSI.ObjectValue)((CEWSI.SingletonObject)objProp).Value;
dtRow["ClassId"] = objHead.classId.ToString();
foreach (CEWSI.PropertyType objHeadProp in objHead.Property)
{
if (objHeadProp.propertyId == "Id")
{
dtRow["Id"] = IdmObjectType.getPropertyValue(objHeadProp);
}
if (objHeadProp.propertyId == "Creator")
{
dtRow["Creator"] = IdmObjectType.getPropertyValue(objHeadProp);
}
if (objHeadProp.propertyId == "ContentSize")
{
dtRow["ContentSize"] = IdmObjectType.getPropertyValue(objHeadProp);
}
if (objHeadProp.propertyId == "DocumentTitle")
{
dtRow["Title"] = IdmObjectType.getPropertyValue(objHeadProp);
}
}
}
}
dtblResults.Rows.Add(dtRow);
btnGetContent.Enabled = true;
}
dgrdContainees.DataSource = dtblResults;
dgrdContainees.Show();
g_dtblResults = dtblResults;
}
private void btnCreate_Click_1(object sender, System.EventArgs e)
{
long lngPropCount = 1;
long lngActionCount = 1;
string strContentLocation = "";
string strRetrievalName = "";
ulong ulContentSize = 0;
// If content was specified, do some sanity checks and prepare...
if (chkContent.Checked)
{
// Extract the location, retrieval name, and MIME type
if (txtContentLocation.Text == "")
{
MessageBox.Show("Looks like you forgot to specify a content location - aborting");
return;
}
if (txtMimeType.Text == "")
{
MessageBox.Show("Looks like you forgot to specify a MIME type - aborting");
return;
}
strContentLocation = txtContentLocation.Text.Replace('/', '\\');
int nStart = strContentLocation.LastIndexOf('\\');
strRetrievalName = (nStart > 1) ? strContentLocation.Substring(nStart + 1, (strContentLocation.Length - nStart - 1)) : strContentLocation;
// Verify that the file exists and get its size
ulContentSize = getFileContentSize(strContentLocation);
if (ulContentSize == 0)
{
MessageBox.Show("The specified content file either does not exist, or is of zero length");
return;
}
lngPropCount += 1;
}
// Sanity checks if content by reference was specified...
if (chkContentReference.Checked)
{
if (txtContentURL.Text == "")
{
MessageBox.Show("Looks like you forgot to specify a content URL - aborting");
return;
}
if (txtMimeType.Text == "")
{
MessageBox.Show("Looks like you forgot to specify a MIME type - aborting");
return;
}
lngPropCount += 1;
}
// Get the WS binding object
// (this will be used to set WS-Security parameters)
CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
MainForm.Domain, MainForm.Password, MainForm.URL);
// We first need to create a Create verb, populate it
CEWSI.CreateAction createVerb = new CEWSI.CreateAction();
createVerb.classId = txtDocClass.Text;
// If the user wants to check the document in, then we'll add a separate
// Checkin verb as well
CEWSI.CheckinAction checkinVerb = new CEWSI.CheckinAction();
if (chkCheckIn.Checked)
{
checkinVerb.checkinMinorVersion = true;
checkinVerb.checkinMinorVersionSpecified = true;
lngActionCount += 1;
}
CEWSI.ChangeRequestType objChange = new CEWSI.ChangeRequestType();
objChange.Action = new CEWSI.ActionType[lngActionCount];
objChange.Action[0] = (CEWSI.ActionType)createVerb;
if (chkCheckIn.Checked)
{
objChange.Action[1] = (CEWSI.ActionType)checkinVerb;
}
objChange.TargetSpecification = new CEWSI.ObjectReference();
objChange.TargetSpecification.classId = "ObjectStore";
objChange.TargetSpecification.objectId = MainForm.Library;
objChange.id = "1";
// Build a list of properties to set in the new document
CEWSI.ModifiablePropertyType[] objInputProps = new CEWSI.ModifiablePropertyType[lngPropCount];
CEWSI.SingletonString objString = new CEWSI.SingletonString();
objString.Value = txtTitle.Text;
objString.propertyId = "DocumentTitle";
objInputProps[0] = objString;
if (chkContent.Checked || chkContentReference.Checked)
{
// Create content properties array
// ContentTransfer elements will take three properties:
// * RetrievalName
// * Content
// * ContentType
// ContentReference elements will take two properties:
// * ContentLocation
// * ContentType
CEWSI.PropertyType[] ctProps = null;
if (chkContent.Checked)
{
ctProps = new CEWSI.PropertyType[3];
}
else
{
ctProps = new CEWSI.PropertyType[2];
}
// Set the ContentType property
CEWSI.SingletonString typeProp = new CEWSI.SingletonString();
typeProp.propertyId = "ContentType";
typeProp.Value = txtMimeType.Text;
ctProps[0] = typeProp;
// Create the dependent object type object
CEWSI.DependentObjectType ct = new CEWSI.DependentObjectType();
ct.dependentAction = CEWSI.DependentObjectTypeDependentAction.Insert;
ct.dependentActionSpecified = true;
// ContentTransfer case
if (chkContent.Checked)
{
// create RetrievalName name property
CEWSI.SingletonString nameProp = new CEWSI.SingletonString();
nameProp.propertyId = "RetrievalName";
nameProp.Value = strRetrievalName;
ctProps[1] = nameProp;
// create content data object
CEWSI.ContentData contData = new CEWSI.ContentData();
contData.propertyId = "Content";
CEWSI.InlineContent ic = new CEWSI.InlineContent();
ic.Binary = getSouceFileContent(strContentLocation);
contData.Value = ic;
ctProps[2] = contData;
// Dependent object is of type ContentTransfer
ct.classId = "ContentTransfer";
}
// ContentReference case
else
{
// Create the ContentLocation property
CEWSI.SingletonString locationProp = new CEWSI.SingletonString();
locationProp.propertyId = "ContentLocation";
locationProp.Value = txtContentURL.Text;
ctProps[1] = locationProp;
// Dependent object is of type ContentReference
ct.classId = "ContentReference";
}
// create content object list
ct.Property = ctProps;
CEWSI.DependentObjectType[] contentObjects = new CEWSI.DependentObjectType[1];
contentObjects[0] = ct;
// Create the content element list and set it into the document's properties
CEWSI.ListOfObject objContentList = new CEWSI.ListOfObject();
objContentList.propertyId = "ContentElements";
objContentList.Value = contentObjects;
objInputProps[1] = objContentList;
}
objChange.ActionProperties = objInputProps;
// Send off the request
CEWSI.ChangeResponseType[] objResponseArray = null;
CEWSI.ExecuteChangesRequest objRequest = new CEWSI.ExecuteChangesRequest();
objRequest.refresh = true;
objRequest.refreshSpecified = true;
objRequest.ChangeRequest = new CEWSI.ChangeRequestType[1];
objRequest.ChangeRequest[0] = objChange;
try
{
objResponseArray = objBinding.ExecuteChanges(WSIUtil.GetLocalization(), objRequest);
}
catch (System.Net.WebException ex)
{
MessageBox.Show("An exception occurred while creating a document: [" + ex.Message + "]");
return;
}
catch (Exception allEx)
{
MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
return;
}
// Created a document! Sanity check the results
string strObjectId = "";
bool bFound = false;
if (objResponseArray == null || objResponseArray.Length < 1)
{
MessageBox.Show("The change request was executed, but a valid object was not returned");
return;
}
CEWSI.ChangeResponseType objResponse = objResponseArray[0];
foreach (CEWSI.PropertyType objProp in objResponse.Property)
{
if (objProp.propertyId.CompareTo("Id") == 0)
{
strObjectId = IdmObjectType.getPropertyValue(objProp);
bFound = true;
break;
}
}
if (!bFound)
{
MessageBox.Show("The document was created, but the results do not contain a document ID!");
return;
}
if (chkFile.Checked)
{
MessageBox.Show("Successfully created a document! ID = [" + strObjectId + "]. Now filing.");
FileDoc(strObjectId, txtDocClass.Text, txtTitle.Text, txtFolderName.Text);
}
else
{
MessageBox.Show("Successfully created a document! ID = [" + strObjectId + "]");
}
return;
}
private void btnCreate_Click(object sender, System.EventArgs e)
{
// We first need to create a Create verb, populate it
CEWSI.CreateAction createVerb = new CEWSI.CreateAction();
CEWSI.ChangeRequestType objChange = new CEWSI.ChangeRequestType();
objChange.Action = new CEWSI.ActionType[1];
objChange.TargetSpecification = new CEWSI.ObjectReference();
objChange.TargetSpecification.classId = "ObjectStore";
objChange.TargetSpecification.objectId = MainForm.Library;
objChange.id = "1";
// Build a list of properties to set in the new property template
// The following meta-properties will be set:
// SymbolicName String
// IsNameProperty Boolean
// Cardinality Integer
// IsPersistent Boolean
// DisplayNames ListOfObject
CEWSI.ModifiablePropertyType[] objInputProps = new CEWSI.ModifiablePropertyType[5];
// Symbolic name
CEWSI.SingletonString objSymName = new CEWSI.SingletonString();
objSymName.Value = txtSymName.Text;
objSymName.propertyId = "SymbolicName";
objInputProps[0] = objSymName;
// Hardcode the IsNameProperty for now
CEWSI.SingletonBoolean objIsName = new CEWSI.SingletonBoolean();
objIsName.Value = false;
objIsName.ValueSpecified = true;
objIsName.propertyId = "IsNameProperty";
objInputProps[1] = objIsName;
// Hardcode the Cardinality for now
CEWSI.SingletonInteger32 objCardinality = new CEWSI.SingletonInteger32();
objCardinality.Value = 0;
objCardinality.ValueSpecified = true;
objCardinality.propertyId = "Cardinality";
objInputProps[2] = objCardinality;
// Hardcode the IsPersistent property for now
CEWSI.SingletonBoolean objIsPersistent = new CEWSI.SingletonBoolean();
objIsPersistent.Value = true;
objIsPersistent.ValueSpecified = true;
objIsPersistent.propertyId = "IsPersistent";
objInputProps[3] = objIsPersistent;
// Set up the DisplayNames property
// DisplayNames is a dependent object that has the following properties:
// LocaleName String
// LocalizedText String
CEWSI.ListOfObject objNameList = new CEWSI.ListOfObject();
objNameList.propertyId = "DisplayNames";
CEWSI.DependentObjectType[] theNames = new CEWSI.DependentObjectType[1];
CEWSI.DependentObjectType dispName = new CEWSI.DependentObjectType();
theNames[0] = dispName;
objNameList.Value = theNames;
dispName.dependentAction = CEWSI.DependentObjectTypeDependentAction.Insert;
dispName.dependentActionSpecified = true;
dispName.classId = "LocalizedString";
CEWSI.PropertyType[] nameProps = new CEWSI.PropertyType[2];
CEWSI.SingletonString objLocale = new CEWSI.SingletonString();
objLocale.propertyId = "LocaleName";
objLocale.Value = "en-us";
nameProps[0] = objLocale;
CEWSI.SingletonString objText = new CEWSI.SingletonString();
objText.propertyId = "LocalizedText";
objText.Value = txtSymName.Text;
nameProps[1] = objText;
dispName.Property = nameProps;
objInputProps[4] = objNameList;
// Set the class of the new template according to the data type
switch (cmbDataType.Text)
{
case "String":
createVerb.classId = "PropertyTemplateString";
break;
case "Boolean":
createVerb.classId = "PropertyTemplateBoolean";
break;
case "Float":
createVerb.classId = "PropertyTemplateFloat64";
break;
case "Integer":
createVerb.classId = "PropertyTemplateInteger32";
break;
case "ID":
createVerb.classId = "PropertyTemplateId";
break;
case "Object":
createVerb.classId = "PropertyTemplateObject";
break;
case "Binary":
createVerb.classId = "PropertyTemplateBinary";
break;
case "DateTime":
createVerb.classId = "PropertyTemplateDateTime";
break;
default:
MessageBox.Show("Invalid property type selected!");
return;
}
objChange.ActionProperties = objInputProps;
objChange.Action[0] = (CEWSI.ActionType)createVerb;
// Fill in the security headers...
CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
MainForm.Domain, MainForm.Password, MainForm.URL);
// Send off the request
CEWSI.ChangeResponseType[] objResponseArray = null;
CEWSI.ExecuteChangesRequest objRequest = new CEWSI.ExecuteChangesRequest();
objRequest.refresh = true;
objRequest.refreshSpecified = true;
objRequest.ChangeRequest = new CEWSI.ChangeRequestType[1];
objRequest.ChangeRequest[0] = objChange;
try
{
objResponseArray = objBinding.ExecuteChanges(WSIUtil.GetLocalization(), objRequest);
}
catch (System.Net.WebException ex)
{
MessageBox.Show("An exception occurred while creating a property template: [" + ex.Message + "]");
return;
}
catch (Exception allEx)
{
MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
return;
}
// Created a template! Sanity check the results
string strObjectId = "";
bool bFound = false;
if (objResponseArray == null || objResponseArray.Length < 1)
{
MessageBox.Show("The change request was executed, but a valid object was not returned");
return;
}
CEWSI.ChangeResponseType objResponse = objResponseArray[0];
foreach (CEWSI.PropertyType objProp in objResponse.Property)
{
if (objProp.propertyId.CompareTo("Id") == 0)
{
strObjectId = IdmObjectType.getPropertyValue(objProp);
bFound = true;
break;
}
}
if (!bFound)
{
MessageBox.Show("The property template was created, but the results do not contain an ID!");
return;
}
MessageBox.Show("Successfully created a property template! ID = [" + strObjectId + "]");
return;
}
private void btnCreateSubclass_Click(object sender, System.EventArgs e)
{
String strParentClassName;
String strParentClassId;
int iRow;
CEWSI.PropertyType prop;
CEWSI.ObjectReference objRef;
// First find the selected parent class, and extract the name and ID for it
iRow = dgrdResults.CurrentRowIndex;
if (iRow < 0)
{
MessageBox.Show("Please select a class first");
return;
}
prop = g_Classes[iRow].Property[4];
if (prop == null)
{
MessageBox.Show("Cannot find the This property");
return;
}
if (prop.GetType() == typeof(CEWSI.SingletonObject))
{
CEWSI.SingletonObject objSO = (CEWSI.SingletonObject)prop;
objRef = (CEWSI.ObjectReference)((CEWSI.SingletonObject)prop).Value;
try
{
objRef = (CEWSI.ObjectReference)objSO.Value;
strParentClassName = objRef.classId;
strParentClassId = objRef.objectId;
}
catch (System.Exception)
{
MessageBox.Show("Cannot extract the class and Id of the selected item");
return;
}
}
else
{
MessageBox.Show("Expected to find an object valued property");
return;
}
// Create a Create verb, populate it
CEWSI.CreateAction createVerb = new CEWSI.CreateAction();
createVerb.classId = strParentClassName;
CEWSI.ChangeRequestType objChange = new CEWSI.ChangeRequestType();
objChange.Action = new CEWSI.ActionType[1];
objChange.TargetSpecification = new CEWSI.ObjectReference();
objChange.TargetSpecification.classId = strParentClassName;
objChange.TargetSpecification.objectId = strParentClassId;
objChange.TargetSpecification.objectStore = MainForm.Library;
objChange.id = "1";
// Build a list of properties to set in the new property template
// The following meta-properties will be set:
// SymbolicName String
// DisplayNames ListOfObject
CEWSI.ModifiablePropertyType[] objInputProps = new CEWSI.ModifiablePropertyType[2];
// Symbolic name
CEWSI.SingletonString objSymName = new CEWSI.SingletonString();
objSymName.Value = txtSymbolicName.Text;
objSymName.propertyId = "SymbolicName";
objInputProps[0] = objSymName;
// Set up the DisplayNames property
// DisplayNames is a dependent object that has the following properties:
// LocaleName String
// LocalizedText String
CEWSI.ListOfObject objNameList = new CEWSI.ListOfObject();
objNameList.propertyId = "DisplayNames";
CEWSI.DependentObjectType[] theNames = new CEWSI.DependentObjectType[1];
CEWSI.DependentObjectType dispName = new CEWSI.DependentObjectType();
theNames[0] = dispName;
objNameList.Value = theNames;
dispName.dependentAction = CEWSI.DependentObjectTypeDependentAction.Insert;
dispName.dependentActionSpecified = true;
dispName.classId = "LocalizedString";
CEWSI.PropertyType[] nameProps = new CEWSI.PropertyType[2];
CEWSI.SingletonString objLocale = new CEWSI.SingletonString();
objLocale.propertyId = "LocaleName";
objLocale.Value = "en-us";
nameProps[0] = objLocale;
CEWSI.SingletonString objText = new CEWSI.SingletonString();
objText.propertyId = "LocalizedText";
objText.Value = txtSymbolicName.Text;
nameProps[1] = objText;
dispName.Property = nameProps;
objInputProps[1] = objNameList;
objChange.ActionProperties = objInputProps;
objChange.Action[0] = (CEWSI.ActionType)createVerb;
// Fill in the security headers...
CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
MainForm.Domain, MainForm.Password, MainForm.URL);
// Send off the request
CEWSI.ChangeResponseType[] objResponseArray = null;
CEWSI.ExecuteChangesRequest objRequest = new CEWSI.ExecuteChangesRequest();
objRequest.refresh = true;
objRequest.refreshSpecified = true;
objRequest.ChangeRequest = new CEWSI.ChangeRequestType[1];
objRequest.ChangeRequest[0] = objChange;
try
{
objResponseArray = objBinding.ExecuteChanges(WSIUtil.GetLocalization(), objRequest);
}
catch (System.Net.WebException ex)
{
MessageBox.Show("An exception occurred while creating a new class: [" + ex.Message + "]");
return;
}
catch (Exception allEx)
{
MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
return;
}
// Created a class! Sanity check the results
string strObjectId = "";
bool bFound = false;
if (objResponseArray == null || objResponseArray.Length < 1)
{
MessageBox.Show("The change request was executed, but a valid object was not returned");
return;
}
CEWSI.ChangeResponseType objResponse = objResponseArray[0];
foreach (CEWSI.PropertyType objProp in objResponse.Property)
{
if (objProp.propertyId.CompareTo("Id") == 0)
{
strObjectId = IdmObjectType.getPropertyValue(objProp);
bFound = true;
break;
}
}
if (!bFound)
{
MessageBox.Show("The class was created, but the results do not contain an ID!");
return;
}
MessageBox.Show("Successfully created a new class! ID = [" + strObjectId + "]");
return;
}
private void btnQuery_Click(object sender, System.EventArgs e)
{
CEWSI.ObjectSetType objResponse = null;
// Perform the requested query
try
{
// Set up a connection to the web service.
// Fill in the security headers...
CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
MainForm.Domain, MainForm.Password, MainForm.URL);
// Create a search object
// Set up the scope for the query
// Set up the SQL for the search
CEWSI.RepositorySearch objSearch = new CEWSI.RepositorySearch();
CEWSI.ObjectStoreScope objSearchScope = new CEWSI.ObjectStoreScope();
objSearchScope.objectStore = MainForm.Library;
objSearch.SearchScope = objSearchScope;
objSearch.SearchSQL = "SELECT SymbolicName, Id, IsHidden, IsSystemOwned, This FROM ClassDefinition ";
objSearch.SearchSQL = objSearch.SearchSQL + " WHERE AllowsSubclasses=TRUE";
if (txtName.Text != "")
{
objSearch.SearchSQL = objSearch.SearchSQL + " AND SymbolicName LIKE '" + txtName.Text + "%'";
}
if (!chkIncludeSystem.Checked)
{
objSearch.SearchSQL = objSearch.SearchSQL + " AND IsSystemOwned=FALSE";
}
if (!chkIncludeHidden.Checked)
{
objSearch.SearchSQL = objSearch.SearchSQL + " AND IsHidden=FALSE";
}
// Execute the search
objResponse = objBinding.ExecuteSearch(WSIUtil.GetLocalization(), objSearch);
}
catch (System.Net.WebException ex)
{
MessageBox.Show("An exception occurred while querying: [" + ex.Message + "]");
return;
}
catch (Exception allEx)
{
MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
return;
}
// Sanity check the results data
long lColumnCount = 0;
long lRowCount = 0;
long i;
if (objResponse == null || objResponse.Object == null)
{
MessageBox.Show("The query completed successfully but the results were null!");
return;
}
if (objResponse.Object.Length < 1)
{
MessageBox.Show("No results were found for this query.");
return;
}
lColumnCount = objResponse.Object[0].Property.Length;
if (lColumnCount < 5)
{
MessageBox.Show("The query succeeded, but the results are missing requested data");
return;
}
// Query was successful; display a list of result rows
// First create a data table that has one column for each property
System.Data.DataColumn dtCol;
System.Data.DataRow dtRow;
CEWSI.PropertyType prop;
g_Classes = objResponse.Object;
lRowCount = g_Classes.Length;
System.Data.DataTable dtblResults = new System.Data.DataTable("Results");
// Name
dtCol = new System.Data.DataColumn("Name");
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
// Class
dtCol = new System.Data.DataColumn("Class");
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
// IsSystem
dtCol = new System.Data.DataColumn("IsSystem");
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
// IsHidden
dtCol = new System.Data.DataColumn("IsHidden");
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
// Populate the rows
CEWSI.ObjectReference objRef;
for (i = 0; i < lRowCount; i++)
{
dtRow = dtblResults.NewRow();
prop = g_Classes[i].Property[0];
dtRow["Name"] = IdmObjectType.getPropertyValue(prop);
prop = g_Classes[i].Property[4];
objRef = (CEWSI.ObjectReference)((CEWSI.SingletonObject)prop).Value;
dtRow["Class"] = objRef.classId;
prop = g_Classes[i].Property[3];
dtRow["IsSystem"] = IdmObjectType.getPropertyValue(prop);
prop = g_Classes[i].Property[2];
dtRow["IsHidden"] = IdmObjectType.getPropertyValue(prop);
dtblResults.Rows.Add(dtRow);
}
dgrdResults.PreferredColumnWidth = 140;
dgrdResults.DataSource = dtblResults;
dgrdResults.Show();
btnCreateSubclass.Enabled = true;
return;
}
private void btnQuery_Click(object sender, System.EventArgs e)
{
CEWSI.ObjectSetType objResponse = null;
// Perform the requested query
try
{
// Set up a connection to the web service.
// Fill in the security headers...
CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
MainForm.Domain, MainForm.Password, MainForm.URL);
// Create a search object
// Set up the scope for the query
// Set up the SQL for the search
CEWSI.RepositorySearch objSearch = new CEWSI.RepositorySearch();
CEWSI.ObjectStoreScope objSearchScope = new CEWSI.ObjectStoreScope();
objSearchScope.objectStore = MainForm.Library;
objSearch.SearchScope = objSearchScope;
objSearch.SearchSQL = "SELECT ";
if (txtSelect.Text == "")
{
objSearch.SearchSQL = objSearch.SearchSQL + "*";
}
else
{
objSearch.SearchSQL = objSearch.SearchSQL + txtSelect.Text;
}
objSearch.SearchSQL = objSearch.SearchSQL + " FROM " + txtFrom.Text;
if (txtWhere.Text != "")
{
objSearch.SearchSQL = objSearch.SearchSQL + " WHERE " + txtWhere.Text;
}
if (txtMaxRows.Text != "")
{
Int32 iRows = System.Int32.Parse(txtMaxRows.Text);
objSearch.maxElements = iRows;
objSearch.maxElementsSpecified = true;
}
// Execute the search
objResponse = objBinding.ExecuteSearch(WSIUtil.GetLocalization(), objSearch);
}
catch (System.Net.WebException ex)
{
MessageBox.Show("An exception occurred while querying: [" + ex.Message + "]");
return;
}
catch (Exception allEx)
{
MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
return;
}
// Sanity check the results data
long lColumnCount = 0;
long lRowCount = 0;
long i;
if (objResponse == null || objResponse.Object == null)
{
MessageBox.Show("The query completed successfully but the results were null!");
return;
}
if (objResponse.Object.Length < 1)
{
MessageBox.Show("No results were found for this query - exiting.");
return;
}
lColumnCount = objResponse.Object[0].Property.Length;
if (lColumnCount < 1)
{
MessageBox.Show("The query succeeded, but the results contain no properties - exiting");
return;
}
/*
* if( lColumnCount > 12 )
* {
* MessageBox.Show("The result set has more than 12 columns. Only the first 12 columns will be displayed");
* lColumnCount = 12;
* }
*/
// Query was successful; display a list of result rows
// First create a data table that has one column for each property in the
// returned data
System.Data.DataColumn dtCol;
System.Data.DataRow dtRow;
CEWSI.PropertyType prop;
CEWSI.ObjectValue[] objObjects = objResponse.Object;
lRowCount = objObjects.Length;
System.Data.DataTable dtblResults = new System.Data.DataTable("Results");
for (i = 0; i < lColumnCount; i++)
{
dtCol = new System.Data.DataColumn(objObjects[0].Property[i].propertyId);
dtCol.DataType = System.Type.GetType("System.String");
dtCol.DefaultValue = "";
dtblResults.Columns.Add(dtCol);
}
// Populate the rows
for (i = 0; i < lRowCount; i++)
{
dtRow = dtblResults.NewRow();
for (long iCol = 0; iCol < lColumnCount; iCol++)
{
prop = objObjects[i].Property[iCol];
dtRow[prop.propertyId] = IdmObjectType.getPropertyValue(prop);
}
dtblResults.Rows.Add(dtRow);
}
dgrdResults.DataSource = dtblResults;
dgrdResults.Show();
return;
}
private void btnCreate_Click(object sender, System.EventArgs e)
{
// Create the ChangeRequest
CEWSI.ChangeRequestType objChange = new CEWSI.ChangeRequestType();
CEWSI.CreateAction createVerb = new CEWSI.CreateAction();
createVerb.classId = txtFolderClass.Text;
objChange.Action = new CEWSI.ActionType[1];
objChange.Action[0] = (CEWSI.ActionType)createVerb;
objChange.TargetSpecification = new CEWSI.ObjectReference();
objChange.TargetSpecification.classId = "ObjectStore";
objChange.TargetSpecification.objectId = MainForm.Library;
objChange.id = "1";
CEWSI.ModifiablePropertyType[] objInputProps = new CEWSI.ModifiablePropertyType[2];
objChange.ActionProperties = objInputProps;
// Build a list of properties to set in the new folder (just the folder name and parent for now)
// -Folder name property
CEWSI.SingletonString objString = new CEWSI.SingletonString();
objString.Value = txtName.Text;
objString.propertyId = "FolderName";
objInputProps[0] = objString;
// -Parent property
CEWSI.ObjectSpecification objSpec = new CEWSI.ObjectSpecification();
CEWSI.SingletonObject objObject = new CEWSI.SingletonObject();
objSpec.classId = "Folder";
objSpec.path = txtParent.Text;
objSpec.objectStore = MainForm.Library;
objObject.propertyId = "Parent";
objObject.Value = (CEWSI.ObjectEntryType)objSpec;
objInputProps[1] = objObject;
// Fill in the security headers...
CEWSI.FNCEWS40PortTypeClient objBinding = WSIUtil.ConfigureBinding(MainForm.User,
MainForm.Domain, MainForm.Password, MainForm.URL);
// Send off the request
CEWSI.ChangeResponseType[] objResponseArray = null;
CEWSI.ExecuteChangesRequest objRequest = new CEWSI.ExecuteChangesRequest();
objRequest.refresh = true;
objRequest.refreshSpecified = true;
objRequest.ChangeRequest = new CEWSI.ChangeRequestType[1];
objRequest.ChangeRequest[0] = objChange;
try
{
objResponseArray = objBinding.ExecuteChanges(WSIUtil.GetLocalization(), objRequest);
}
catch (System.Net.WebException ex)
{
MessageBox.Show("An exception occurred while creating a folder: [" + ex.Message + "]");
return;
}
catch (Exception allEx)
{
MessageBox.Show("An exception occurred: [" + allEx.Message + "]");
return;
}
// Created a folder! Sanity check the results
string strObjectId = "";
bool bFound = false;
if (objResponseArray == null || objResponseArray.Length < 1)
{
MessageBox.Show("The change request was executed, but a valid object was not returned");
return;
}
CEWSI.ChangeResponseType objResponse = objResponseArray[0];
foreach (CEWSI.PropertyType objProp in objResponse.Property)
{
if (objProp.propertyId.CompareTo("Id") == 0)
{
strObjectId = IdmObjectType.getPropertyValue(objProp);
bFound = true;
break;
}
}
if (!bFound)
{
MessageBox.Show("The folder was created, but the results do not contain a folder ID!");
return;
}
MessageBox.Show("Successfully created a folder! ID = [" + strObjectId + "]");
return;
}
