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