protected string GetUrlFromSettingsByName(string serviceUrl, IOrganizationService service) { string url = string.Empty; QueryExpression query = new QueryExpression("new_parameter"); ColumnSet columns = new ColumnSet(); columns.AddColumns("new_description", "new_name", "new_value"); query.ColumnSet = columns; query.Criteria = new FilterExpression(); query.Criteria.FilterOperator = LogicalOperator.And; ConditionExpression conditionIdByName = new ConditionExpression("new_name", ConditionOperator.Equal, serviceUrl); query.Criteria.Conditions.AddRange(conditionIdByName); EntityCollection col = service.RetrieveMultiple(query); if (col.Entities.Count > 0) { if (col.Entities[0].Contains("new_value")) { return(url = col.Entities[0].GetAttributeValue <string>("new_value")); } } return(url); }
private Entity GetCurrencyDetail(Guid id, string[] Columns) { ConditionExpression conditionExpression = new ConditionExpression(); conditionExpression.AttributeName = "transactioncurrencyid"; conditionExpression.Operator = ConditionOperator.Equal; conditionExpression.Values.Add((object)id); FilterExpression filterExpression = new FilterExpression(); filterExpression.Conditions.Add(conditionExpression); filterExpression.FilterOperator = LogicalOperator.And; ColumnSet columnSet = new ColumnSet(); columnSet.AddColumns(Columns); RetrieveMultipleResponse multipleResponse = (RetrieveMultipleResponse)this.service.Execute((OrganizationRequest) new RetrieveMultipleRequest() { Query = (QueryBase) new QueryExpression() { ColumnSet = columnSet, Criteria = filterExpression, EntityName = "transactioncurrency" } }); if (multipleResponse.EntityCollection.Entities != null && multipleResponse.EntityCollection.Entities.Count > 0) { return(Enumerable.First <Entity>((IEnumerable <Entity>)multipleResponse.EntityCollection.Entities)); } else { return((Entity)null); } }
private void AddRole(IOrganizationService service, string ObjectName, string solutionName) { ///Define fields to query string fieldQuery = "name"; string fieldReturn = "roleid"; string entity = "role"; //Build query expression QueryExpression query = new QueryExpression(entity); ColumnSet column = new ColumnSet(); column.AddColumns(new string[] { fieldReturn }); query.ColumnSet = column; query.Criteria.AddCondition(new ConditionExpression(fieldQuery, ConditionOperator.Equal, ObjectName)); //Retrieve records EntityCollection response = service.RetrieveMultiple(query); if (response == null || response.Entities.Count == 0) { AppendTextBox("Error: could not retrieve " + ObjectName); return; } Guid componentid = (Guid)(response.Entities[0].Attributes[fieldReturn]); int componentType = 20; AddComponent(service, solutionName, componentType, componentid); return; }
private static void LabContactQuery(IOrganizationService service) { var qe = new QueryExpression("contact"); var cs = new ColumnSet(); var fe = new FilterExpression(); var ce = new ConditionExpression(); cs.AddColumns("fullname", "parentcustomerid"); ce.AttributeName = "jobtitle"; ce.Operator = ConditionOperator.Equal; ce.Values.Add("Purchasing Manager"); fe.AddCondition(ce); qe.ColumnSet = cs; qe.Criteria.AddFilter(fe); var contacts = service.RetrieveMultiple(qe); foreach (var a in contacts.Entities) { Console.WriteLine(a.Attributes["fullname"]); } }
/// <summary> /// Get a collection of Business Entities where the specified attribute(s) have the specified value(s) /// </summary> /// <param name="service">IOrganizationService to execute CRM requests.</param> /// <param name="entityName">Entity type to return e.g. "contact"</param> /// <param name="attributeNames">string array of attribute names e.g. {"field","field"}</param> /// <param name="attributeValues">object array of attribute values e.g. {"John", "Smith"}</param> /// <param name="columnsToReturn">Optional string array of columns to return. If null or empty, all columns are returned.</param> /// <param name="sortAttributeName">string of sorting attribute name</param> /// <param name="sortOrder">OrderType to order returned results either Ascending or Descending</param> /// <returns>EntityCollection of entities with attribute values that match the ones specified</returns> /// <example>GetEntityCollectionByAttributes(service, "contact", {"field","field"},{"John","Smith"},{"column"}) returns all contact entity instances where field=john and field=smith. Returns contactIDs only.</example> public static EntityCollection GetEntityCollectionByAttributes(IOrganizationService service, string entityName, string[] attributeNames, object[] attributeValues, string[] columnsToReturn, string sortAttributeName, OrderType sortOrder) { if (service != null && attributeNames != null && attributeValues != null) { if (attributeNames.Length != attributeValues.Length) { throw new ArgumentException("Number of attribute names is not the same as number of attribute values"); } QueryByAttribute attributeQuery = new QueryByAttribute(); attributeQuery.EntityName = entityName; attributeQuery.Attributes.AddRange(attributeNames); if (columnsToReturn != null && columnsToReturn.Length > 0) { ColumnSet columnSet = new ColumnSet(); columnSet.AddColumns(columnsToReturn); attributeQuery.ColumnSet = columnSet; } attributeQuery.Values.AddRange(attributeValues); attributeQuery.AddOrder(sortAttributeName, sortOrder); RetrieveMultipleRequest request = new RetrieveMultipleRequest(); request.Query = attributeQuery; RetrieveMultipleResponse response = (RetrieveMultipleResponse)service.Execute(request); EntityCollection returnedEntities = response.EntityCollection; return(returnedEntities); } return(null); }
private static void LabAccountQuery(IOrganizationService service) { var qe = new QueryExpression(); var cs = new ColumnSet(); var fe = new FilterExpression(); var ce = new ConditionExpression(); cs.AddColumns("name", "accountid"); ce.AttributeName = "statecode"; ce.Operator = ConditionOperator.Equal; ce.Values.Add("Active"); fe.AddCondition(ce); qe.ColumnSet = cs; qe.Criteria = fe; qe.EntityName = "account"; qe.AddOrder("name", OrderType.Ascending); var accountList = service.RetrieveMultiple(qe); foreach (var act in accountList.Entities) { Console.WriteLine("Name: {0}, Account Id: {1}", act.Attributes["name"], act.Attributes["accountid"]); } }
public static Entity GetAutoNumberConfig(IOrganizationService oService, string strObjectType, string entityName) { EntityCollection ec = null; try { QueryExpression query = new QueryExpression(); ColumnSet qpColSet = new ColumnSet(); string[] strColumnList = { "pnp_autonumberid", "pnp_prefix", "pnp_counter", "pnp_suffix", "pnp_autonumberattribute" }; qpColSet.AddColumns(strColumnList); query.ColumnSet = qpColSet; query.EntityName = strObjectType; ConditionExpression ce = new ConditionExpression("pnp_name", ConditionOperator.Equal, entityName.Trim()); query.Criteria.AddCondition(ce); RetrieveMultipleRequest retrieve = new RetrieveMultipleRequest(); retrieve.Query = query; ec = oService.RetrieveMultiple(query); } catch (SoapException ex) { throw ex; } catch (Exception ex) { throw ex; } return((Entity)ec.Entities[0]); }
private void RetrieveData() { var columns = this.attributes.Select(a => a.LogicalName).ToList(); if (!columns.Contains(this.entity.PrimaryNameAttribute)) { columns.Add(this.entity.PrimaryNameAttribute); } // Check if the record already exists on target organization var sourceqry = BuildFetchXml(entity.LogicalName, columns.ToArray(), Filter); var targetcolumnset = new ColumnSet(this.entity.PrimaryNameAttribute); // Make sure we have a state on the entity if (this.entity.Attributes.Any(a => a != null && !string.IsNullOrEmpty(a.LogicalName) && a.LogicalName.Equals("statecode"))) { targetcolumnset.AddColumns("statecode", "statuscode"); } var targetqry = new QueryExpression(entity.LogicalName) { ColumnSet = targetcolumnset }; SetProgress(0, "Retrieving records..."); var sourceRetrieveTask = Task.Factory.StartNew <EntityCollection>(() => { return(RetrieveAll(sourceService, sourceqry)); }); var targetRetrieveTask = Task.Factory.StartNew <EntityCollection>(() => { return(RetrieveAll(targetService, targetqry)); }); Task.WaitAll(sourceRetrieveTask, targetRetrieveTask); sourceRecords = sourceRetrieveTask.Result; targetRecords = targetRetrieveTask.Result; }
private EntityCollection getExisitingAccountDetails(Guid _accountId) { ColumnSet accountColumns = new ColumnSet("name", "fdx_goldmineaccountnumber", "fdx_gonogo", "address1_line1", "address1_line2", "address1_city", "fdx_stateprovinceid", "fdx_zippostalcodeid", "telephone1"); accountColumns.AddColumns("fdx_prospectgroup", "defaultpricelevelid", "fdx_prospectpriority", "fdx_prospectscore", "fdx_prospectpercentile", "fdx_ratesource", "fdx_pprrate", "fdx_subrate", "fdx_prospectradius", "fdx_prospectdatalastupdated", "fdx_prospectscoreblankmessage"); QueryExpression accountQuery = CRMQueryExpression.getQueryExpression("account", accountColumns, new CRMQueryExpression[] { new CRMQueryExpression("accountid", ConditionOperator.Equal, _accountId) }); EntityCollection accountCollection = service.RetrieveMultiple(accountQuery); return(accountCollection); }
public JsonResult ContactReassignmentEmail(dynamic data) { log.Info("DuplicateContactEmailToSupport"); string hdcSupportEmail = ConfigurationManager.AppSettings["HDCSupportEmail"]; ColumnSet columns = new ColumnSet(); columns.AddColumns(new string[] { "firstname", "lastname", "emailaddress1", "concap_loggedinuser" }); Entity duplicateContact = EntityApiUtils.ReadContactByEmail(ServiceProxy, data.duplicateContactEmail.Value, columns); Entity rep = EntityApiUtils.ReadContactById(ServiceProxy, Guid.Parse(data.repId.Value), new ColumnSet(true)); Entity owningRep = null; string contactFirstName = EntityApiUtils.GetStringValue(duplicateContact, "firstname"); string contactLastName = EntityApiUtils.GetStringValue(duplicateContact, "lastname"); string submitedRepName = EntityApiUtils.GetStringValue(rep, "fullname"); string owningRepName = ""; string repEmail = EntityApiUtils.GetStringValue(rep, "emailaddress1"); if (duplicateContact.Contains("concap_loggedinuser")) { owningRepName = ((EntityReference)duplicateContact["concap_loggedinuser"]).Name; owningRep = EntityApiUtils.ReadContactById(ServiceProxy, ((EntityReference)duplicateContact["concap_loggedinuser"]).Id, new ColumnSet(true)); } string emailDescription = "<p>HDC App Admin,</p>"; emailDescription += "<p>I am requesting that the contact below gets reassigned to me:</p>"; emailDescription += "<ul><li>" + contactFirstName + " " + contactLastName + "</li>"; emailDescription += "<li>" + data.duplicateContactEmail.Value + "</li></ul>"; emailDescription += "<p>Please contact me for details.</p>"; emailDescription += "<p><strong>TTI Rep requesting contact reassignment: </strong></p>"; emailDescription += "<ul><li>" + submitedRepName + "</li>"; emailDescription += "<li>" + EntityApiUtils.GetStringValue(rep, "store.concap_name") + ", " + EntityApiUtils.GetStringValue(rep, "store.concap_city") + ", " + EntityApiUtils.GetStringValue(rep, "store.concap_stateprovince") + "</li>"; emailDescription += "<li>" + EntityApiUtils.GetStringValue(rep, "telephone1") + "</li>"; emailDescription += "<li>" + EntityApiUtils.GetStringValue(rep, "emailaddress1") + "</li></ul>"; emailDescription += "<p><strong>TTI Rep who owns existing contact: </strong></p>"; emailDescription += "<ul><li>" + owningRepName + "</li>"; emailDescription += "<li>" + EntityApiUtils.GetStringValue(owningRep, "store.concap_name") + ", " + EntityApiUtils.GetStringValue(rep, "store.concap_city") + ", " + EntityApiUtils.GetStringValue(rep, "store.concap_stateprovince") + "</li>"; emailDescription += "<li>" + EntityApiUtils.GetStringValue(owningRep, "telephone1") + "</li>"; emailDescription += "<li>" + EntityApiUtils.GetStringValue(owningRep, "emailaddress1") + "</li></ul>"; emailDescription += "<p><strong>TTI Manager of existing contact owner: </strong></p>"; emailDescription += "<ul><li>" + EntityApiUtils.GetStringValue(owningRep, "manager.concap_name") + "</li>"; emailDescription += "<li>" + EntityApiUtils.GetStringValue(owningRep, "manager.emailaddress") + "</li></ul>"; log.Info("Sending reassignment email..."); var task = SendEmailAsync(repEmail, hdcSupportEmail, repEmail, "HDC Contact Reassignment Request", emailDescription, null); return(new JsonResult() { Data = "An email has been submitted for contact reassignment. An Administrator will be in contact with you regarding this request" }); }
// Method to calculate price in an invoice private static void CalculateInvoice(EntityReference entity, IOrganizationService service) { Entity e = service.Retrieve(entity.LogicalName, entity.Id, new ColumnSet("statecode")); OptionSetValue statecode = (OptionSetValue)e["statecode"]; if (statecode.Value == 0) { ColumnSet columns = new ColumnSet(); columns.AddColumns("totaltax", "totallineitemamount", "totalamountlessfreight", "discountamount"); Entity invoice = service.Retrieve(entity.LogicalName, entity.Id, columns); QueryExpression query = new QueryExpression("invoicedetail"); query.ColumnSet.AddColumns("quantity", "invoiceispricelocked", "priceperunit"); query.Criteria.AddCondition("invoiceid", ConditionOperator.Equal, entity.Id); QueryExpression query1 = new QueryExpression("invoicedetail"); query1.ColumnSet.AddColumns("quantity", "invoiceispricelocked"); query1.Criteria.AddCondition("invoiceid", ConditionOperator.Equal, entity.Id); EntityCollection ec = service.RetrieveMultiple(query); EntityCollection ec1 = service.RetrieveMultiple(query1); invoice["totallineitemamount"] = 0; decimal total = 0; decimal discount = 0; decimal tax = 0; for (int i = 0; i < ec.Entities.Count; i++) { total = total + ((decimal)ec.Entities[i]["quantity"] * ((Money)ec.Entities[i]["priceperunit"]).Value); (ec1.Entities[i])["extendedamount"] = new Money(((decimal)ec.Entities[i]["quantity"] * ((Money)ec.Entities[i]["priceperunit"]).Value)); service.Update(ec1.Entities[i]); } invoice["totallineitemamount"] = new Money(total); // Calculate discount based on the total amount discount = CalculateDiscount(total); total = total - discount; invoice["discountamount"] = new Money(discount); invoice["totalamountlessfreight"] = new Money(total); service.Update(invoice); // Calculate tax after the discount is applied tax = CalculateTax(total); total = total + tax; invoice["totaltax"] = new Money(tax); invoice["totalamount"] = new Money(total); service.Update(invoice); } return; }
private byte[] GetAnnotationBody(IOrganizationService orgService, Annotation annotation) { if (annotation != null) { ColumnSet columnSet = new ColumnSet(); columnSet.AddColumns(Annotation.Fields.AnnotationId, Annotation.Fields.DocumentBody); Entity annotationEntity = orgService.Retrieve(Annotation.EntityLogicalName, annotation.Id, columnSet); object documentBody = annotationEntity[Annotation.Fields.DocumentBody]; return(documentBody == null || string.IsNullOrEmpty((string)documentBody) ? null : Convert.FromBase64String((string)documentBody)); } return(null); }
public void Can_add_attributes() { var strongTypeColumnSet = new ColumnSet <xts_entity>(); ColumnSet columnSet = strongTypeColumnSet; strongTypeColumnSet.AddColumns( e => e.xts_attribute, e => e.xts_withcolumnattribute ); Assert.Equal(2, strongTypeColumnSet.Columns.Count()); Assert.Equal(2, columnSet.Columns.Count); Assert.Equal("xts_attribute", columnSet.Columns[0]); Assert.Equal("xts_column", columnSet.Columns[1]); }
public void Extensions_ColumnSet_AddColumns() { var cs = new ColumnSet(); cs.AddColumns <TestColumnSetEntity>(c => new { c.TestColumnSetEntity1 }); Assert.AreEqual("testcolumnsetentity", cs.Columns.Single()); cs = new ColumnSet(); cs.AddColumns <TestColumnSetEntity>(c => new { c.Id }); Assert.AreEqual("testcolumnsetentityid", cs.Columns.Single()); cs = new ColumnSet(); cs.AddColumns <TestColumnSetEntity>(c => new { c.CreatedOn }); Assert.AreEqual("createdon", cs.Columns.Single()); }
public void AddColumns_Test() { // Setup ColumnSet <TestEntity> columnSet = new ColumnSet <TestEntity>(); string expected1 = nameof(TestEntity.ReferenceTypeProperty).ToLower(); string expected2 = nameof(TestEntity.ValueTypeProperty).ToLower(); // Act columnSet.AddColumns(t => t.ReferenceTypeProperty, t => t.ValueTypeProperty); var actual = columnSet.Columns; // Assert Assert.AreEqual(2, actual.Count); Assert.AreEqual(expected1, actual[0]); Assert.AreEqual(expected2, actual[1]); }
public void AddColumnsTest() { // Setup string expectedColumn1 = nameof(TestEntity.ReferenceTypeProperty).ToLower(); string expectedColumn2 = nameof(TestEntity.ValueTypeProperty).ToLower(); // Act ColumnSet columnSet = new ColumnSet(); columnSet.AddColumns <TestEntity>(t => t.ReferenceTypeProperty, t => t.ValueTypeProperty); // Assert Assert.AreEqual(2, columnSet.Columns.Count); Assert.AreEqual(expectedColumn1, columnSet.Columns[0]); Assert.AreEqual(expectedColumn2, columnSet.Columns[1]); }
/// <summary> /// Reloads the attributes from CRM /// </summary> /// <typeparam name="T"></typeparam> /// <param name="entity"></param> /// <param name="service"></param> /// <returns></returns> public static T Reload <T>(this T entity, IOrganizationService service) where T : Entity { foreach (var aliased in entity.Attributes.Where(a => a.Key.Contains('.') || a.Value is AliasedValue).ToList()) { entity.Attributes.Remove(aliased.Key); } var columns = new ColumnSet(false); columns.AddColumns(entity.Attributes.Keys.ToArray()); var value = service.GetEntity <T>(entity.Id, columns); entity.Attributes = value.Attributes; return(entity); }
private static QueryExpression GetContactsQuery(string[] fields) { if (fields.Length == 0) //Returnerar en query med bestämda attributes eller samtliga { return(new QueryExpression { EntityName = "contact", ColumnSet = new ColumnSet(true) }); } var columnSet = new ColumnSet(); fields = fields.Select(s => s.ToLowerInvariant()).ToArray(); columnSet.AddColumns(fields); return(new QueryExpression { EntityName = "contact", ColumnSet = columnSet }); }
/// <summary> /// This method returns Translator API settings object /// </summary> /// <param name="service">IOrganizationService object</param> /// <param name="tracingService">ITracingService object</param> /// <returns>TranslateApiSettings object</returns> internal static TranslateApiSettings GetTranslatorAPISettings(IOrganizationService service, ITracingService tracingService) { EntityCollection retrieved; TranslateApiSettings apiSettings = new TranslateApiSettings(); var cols = new ColumnSet(); cols.AddColumns(new string[] { "msdyn_apikey", "msdyn_name", "msdyn_isautotranslationenabled" }); try { var query = new QueryExpression { ColumnSet = cols, EntityName = "msdyn_automatickmtranslationsetting", }; retrieved = service.RetrieveMultiple(query); if (retrieved.Entities.Count == 1) { if (retrieved.Entities[0].Attributes.Contains("msdyn_apikey")) { apiSettings.ClientSecret = (string)retrieved.Entities[0].Attributes["msdyn_apikey"]; } if (retrieved.Entities[0].Attributes.Contains("msdyn_name")) { apiSettings.ClientID = (string)retrieved.Entities[0].Attributes["msdyn_name"]; } if (retrieved.Entities[0].Attributes.Contains("msdyn_isautotranslationenabled")) { apiSettings.Isautotranslationenabled = (bool)retrieved.Entities[0].Attributes["msdyn_isautotranslationenabled"]; } } } catch (Exception ex) { tracingService.Trace("GetTranslatorAPISettings: {0}", ex.Message); } return(apiSettings); }
static void Main(string[] args) { QueryExpression qe = new QueryExpression("contact"); ColumnSet cs = new ColumnSet(); FilterExpression fe = new FilterExpression(); //ConditionExpression ce = new ConditionExpression(); cs.AddColumns("fullname", "parentcustomerid"); //ce.AttributeName = "jobtitle"; //ce.Operator = ConditionOperator.Equal; //ce.Values.Add("Менеджер по закупкам"); //fe.AddCondition(ce); qe.ColumnSet = cs; qe.Criteria.AddFilter(fe); EntityCollection contacts = Service.Service.GetOrganization().RetrieveMultiple(qe); foreach (var item in contacts.Entities) { Console.WriteLine(item.Attributes["fullname"].ToString()); } Console.Read(); }
/// <summary> /// This method returns record of automatickmtranslationsetting custom entity /// </summary> /// <param name="service">IOrganizationService object</param> /// <param name="tracingService">ITracingService object</param> /// <returns>returns count of records</returns> internal static int GetTranslatorAPISettingsRecordsCount(IOrganizationService service, ITracingService tracingService) { EntityCollection retrieved; int recordsCount = 0; var cols = new ColumnSet(); cols.AddColumns(new string[] { "msdyn_apikey", "msdyn_name", "msdyn_isautotranslationenabled" }); try { var query = new QueryExpression { ColumnSet = cols, EntityName = "msdyn_automatickmtranslationsetting", }; retrieved = service.RetrieveMultiple(query); recordsCount = retrieved.Entities.Count; } catch (Exception ex) { tracingService.Trace("GetTranslatorAPISettingsRecordsCount: {0}", ex.Message); } return(recordsCount); }
/// <summary> /// This method saves the record /// </summary> /// <returns></returns> public async System.Threading.Tasks.Task <Entity> Save() { Entity modifiedRecord; // If it is regarding, then pass all the record information which contains mapped data to modifiedrecord. if (isRegarding) { modifiedRecord = Record; } // Otherwise, create blank record else { modifiedRecord = new Entity(); } modifiedRecord.LogicalName = EntityMetadataEx.EntityMetadata.LogicalName; // If update, then assign Id if (isUpdate) { modifiedRecord.Id = Record.Id; } // Only update modified fields foreach (var field in Fields) { // If no data changed, then no need to pass the value. if (isUpdate && field.FieldData == Record[field.FieldMetadata.LogicalName]) { continue; } // If required fields have no value, then show error message. if ((bool)field.FieldMetadata.IsValidForCreate && (field.FieldMetadata.RequiredLevel.Value == AttributeRequiredLevel.ApplicationRequired || field.FieldMetadata.RequiredLevel.Value == AttributeRequiredLevel.SystemRequired) && field.FieldData == null) { MessageDialog dialog = new MessageDialog(string.Format(loader.GetString("RequiredField"), field.FieldMetadata.DisplayName.UserLocalizedLabel.Label)); await dialog.ShowAsync(); lvFields.SelectedItem = ((lvFields.FindName("lbl" + field.FieldMetadata.LogicalName) as TextBlock).Parent as StackPanel).Parent; lvFields.UpdateLayout(); lvFields.ScrollIntoView(lvFields.SelectedItem); return(null); } // If value has been changed, then pass the data to modified record. modifiedRecord[field.FieldMetadata.LogicalName] = field.FieldData; } progressRing.IsActive = true; // Create/Update record. Entity result = await CRMHelper.UpsertRecord(modifiedRecord); // If this is update then retrieve latest data again from server after update and return. if (isUpdate) { ColumnSet columnSet = new ColumnSet(); columnSet.AddColumns(Fields.Select(x => x.FieldMetadata.LogicalName).ToArray()); return(await CRMHelper.RetrieveRecord(EntityMetadataEx.EntityMetadata, result.Id, columnSet)); } // If this is new record, then simply return result. else { return(result); } }
public void Execute(IServiceProvider serviceProvider) { // throw new InvalidPluginExecutionException("proceedInReservation " + proceedInReservation); //throw new InvalidPluginExecutionException("ghada ^_^"); #region definitionAttributes string entityName = "new_contracting"; EntityReference destination = null; #endregion //Extract the tracing service for use in debugging sandboxed plug-ins. ITracingService tracingService = (ITracingService)serviceProvider.GetService(typeof(ITracingService)); // Obtain the execution context from the service provider. IPluginExecutionContext context = (IPluginExecutionContext) serviceProvider.GetService(typeof(IPluginExecutionContext)); IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory)); IOrganizationService service = serviceFactory.CreateOrganizationService(context.UserId); try { if (context.Depth > 1) { return; } // The InputParameters collection contains all the data passed in the message request. if (context.InputParameters.Contains("Target") && context.InputParameters["Target"] is Entity) { // Obtain the target entity from the input parameters. Entity entity = (Entity)context.InputParameters["Target"]; // Verify that the target entity represents an sale. // If not, this plug-in was not registered correctly. if (entity.LogicalName != entityName) { return; } var proceedInReservation = new OptionSetValue(); if (entity.Attributes.Contains("ohd_proceedinreservationos")) { proceedInReservation = entity.GetAttributeValue <OptionSetValue>("ohd_proceedinreservationos"); } //Update if (context.MessageName.ToLower() == "update") { #region Retrieve All Blob Storage // Instantiate QueryExpression QEohd_blobstorage var QEohd_blobstorage = new QueryExpression("ohd_blobstorage"); // Add columns to QEohd_blobstorage.ColumnSet QEohd_blobstorage.ColumnSet.AddColumns("createdon", "ohd_uri", "ohd_url", "ohd_blobstorageid"); QEohd_blobstorage.AddOrder("ohd_uri", OrderType.Ascending); // Define filter QEohd_blobstorage.Criteria QEohd_blobstorage.Criteria.AddCondition("ohd_blobazurestorageid", ConditionOperator.Equal, context.PrimaryEntityId); // Add link-entity QEohd_blobstorage_new_contracting var QEohd_blobstorage_new_contracting = QEohd_blobstorage.AddLink("new_contracting", "ohd_blobazurestorageid", "new_contractingid"); QEohd_blobstorage_new_contracting.EntityAlias = "al"; // Add link-entity QEohd_blobstorage_new_contracting_ohd_destination var QEohd_blobstorage_new_contracting_ohd_destination = QEohd_blobstorage_new_contracting.AddLink("ohd_destination", "ohd_destination", "ohd_destinationid"); QEohd_blobstorage_new_contracting_ohd_destination.EntityAlias = "am"; // Define filter QEohd_blobstorage_new_contracting_ohd_destination.LinkCriteria QEohd_blobstorage_new_contracting_ohd_destination.LinkCriteria.AddCondition("ohd_name", ConditionOperator.Equal, "Owest"); var blobStorageResult = service.RetrieveMultiple(QEohd_blobstorage); #endregion #region Retrieve Sale Recod to Get Destination //retrieve contact record ColumnSet fields = new ColumnSet() { AllColumns = false }; fields.AddColumns("ohd_destination"); Entity saleEntity = service.Retrieve(entityName, context.PrimaryEntityId, fields); #endregion if (saleEntity != null) { destination = saleEntity.Contains("ohd_destination") ? (EntityReference)saleEntity.Attributes["ohd_destination"] : new EntityReference(); if ((blobStorageResult == null || blobStorageResult.Entities.Count < 1) && (int)(proceedInReservation.Value) == 1 && (destination != null && destination.Name.ToLower() == "Owest".ToLower())) { //throw new InvalidPluginExecutionException("Sorry!! You must choose at least one attachment related to the sale"); throw new InvalidPluginExecutionException("Please attach required file(s) to proceed in reservation"); } else { return; } } } //Create else if (context.MessageName.ToLower() == "create") { // throw new InvalidPluginExecutionException("ghada 1"); destination = entity.Attributes.Contains("ohd_destination") ? (Microsoft.Xrm.Sdk.EntityReference)entity.Attributes["ohd_destination"] : new EntityReference(); #region Retrieve Sale Recod to Get Destination //retrieve contact record ColumnSet fields = new ColumnSet() { AllColumns = false }; fields.AddColumns("ohd_name"); Entity saleEntity = service.Retrieve("ohd_destination", destination.Id, fields); #endregion if (saleEntity != null) { if ((int)(proceedInReservation.Value) == 1 && (destination != null && saleEntity["ohd_name"].ToString().ToLower() == "Owest".ToLower())) { entity.Attributes["ohd_proceedinreservationos"] = new OptionSetValue(0); } } else { return; } } } } catch (Exception ex) { throw new InvalidPluginExecutionException(ex.Message, ex); } }
[STAThread] // Required to support the interactive login experience static void Main(string[] args) { CrmServiceClient service = null; try { service = SampleHelpers.Connect("Connect"); if (service.IsReady) { // Create any entity records that the demonstration code requires SetUpSample(service); #region Demonstrate // TODO Add demonstration code here //<snippetCreateandublishProducts1> // Create a product family Product newProductFamily = new Product { Name = "Example Product Family", ProductNumber = "PF001", ProductStructure = new OptionSetValue(2) }; _productFamilyId = _serviceProxy.Create(newProductFamily); Console.WriteLine("\nCreated '{0}'", newProductFamily.Name); // Create a product property DynamicProperty newProperty = new DynamicProperty { Name = "Example Property", RegardingObjectId = new EntityReference(Product.EntityLogicalName, _productFamilyId), IsReadOnly = true, IsRequired = true, IsHidden = false, DataType = new OptionSetValue(3), //Single line of text DefaultValueString = "Default Value" }; _productPropertyId = _serviceProxy.Create(newProperty); Console.WriteLine("\nCreated '{0}' for the product family", newProperty.Name); // Create couple of product records under the product family Product newProduct1 = new Product { Name = "Example Product 1", ProductNumber = "P001", ProductStructure = new OptionSetValue(1), ParentProductId = new EntityReference(Product.EntityLogicalName, _productFamilyId), QuantityDecimal = 2, DefaultUoMScheduleId = new EntityReference(UoMSchedule.EntityLogicalName, _unitGroupId), DefaultUoMId = new EntityReference(UoM.EntityLogicalName, _unit.Id) }; _product1Id = _serviceProxy.Create(newProduct1); Console.WriteLine("\nCreated '{0}' under the product family", newProduct1.Name); Product newProduct2 = new Product { Name = "Example Product 2", ProductNumber = "P002", ProductStructure = new OptionSetValue(1), ParentProductId = new EntityReference(Product.EntityLogicalName, _productFamilyId), QuantityDecimal = 2, DefaultUoMScheduleId = new EntityReference(UoMSchedule.EntityLogicalName, _unitGroupId), DefaultUoMId = new EntityReference(UoM.EntityLogicalName, _unit.Id) }; _product2Id = _serviceProxy.Create(newProduct2); Console.WriteLine("Created '{0}' under the product family", newProduct2.Name); // Create a price list items for the products ProductPriceLevel newPriceListItem1 = new ProductPriceLevel { PriceLevelId = new EntityReference(PriceLevel.EntityLogicalName, _priceListId), ProductId = new EntityReference(Product.EntityLogicalName, _product1Id), UoMId = new EntityReference(UoM.EntityLogicalName, _unit.Id), Amount = new Money(20) }; _priceListItem1Id = _serviceProxy.Create(newPriceListItem1); Console.WriteLine("\nCreated price list for '{0}'", newProduct1.Name); ProductPriceLevel newPriceListItem2 = new ProductPriceLevel { PriceLevelId = new EntityReference(PriceLevel.EntityLogicalName, _priceListId), ProductId = new EntityReference(Product.EntityLogicalName, _product2Id), UoMId = new EntityReference(UoM.EntityLogicalName, _unit.Id), Amount = new Money(20) }; _priceListItem2Id = _serviceProxy.Create(newPriceListItem2); Console.WriteLine("Created price list for '{0}'", newProduct2.Name); // Set the product relationship // Set Example Product 1 and Example Product 2 as substitute of each other (bi-directional) ProductSubstitute newProductRelation = new ProductSubstitute { SalesRelationshipType = new OptionSetValue(3), Direction = new OptionSetValue(1), ProductId = new EntityReference(Product.EntityLogicalName, _product1Id), SubstitutedProductId = new EntityReference(Product.EntityLogicalName, _product2Id) }; _productRelationId = _serviceProxy.Create(newProductRelation); Console.WriteLine("\nCreated a substitute relation between the two products."); //</snippetCreateandublishProducts1> // Override a product property at the product level // In this case we will override the property for 'Example Product 1' DynamicProperty newOverrideProperty = new DynamicProperty(); newOverrideProperty.BaseDynamicPropertyId = new EntityReference(DynamicProperty.EntityLogicalName, _productPropertyId); newOverrideProperty.RegardingObjectId = new EntityReference(Product.EntityLogicalName, _product1Id); _productOverridenPropertyId = _serviceProxy.Create(newOverrideProperty); // Retrieve the attributes of the cloned property you want to update ColumnSet columns = new ColumnSet(); columns.AddColumns("name", "isreadonly", "isrequired"); DynamicProperty retrievedOverridenProperty = (DynamicProperty)_serviceProxy.Retrieve( DynamicProperty.EntityLogicalName, _productOverridenPropertyId, columns); // Update the attributes retrievedOverridenProperty.Name = "Overridden Example Property"; retrievedOverridenProperty.IsReadOnly = true; retrievedOverridenProperty.IsRequired = false; _serviceProxy.Update(retrievedOverridenProperty); Console.WriteLine("\nOverridden the product property for 'Example Product 1'."); // Prompt the user whether to publish the product family and products bool publishRecords = true; Console.WriteLine("\nDo you want the product records published? (y/n)"); String answer = Console.ReadLine(); publishRecords = (answer.StartsWith("y") || answer.StartsWith("Y")); if (publishRecords) { PublishProductHierarchyRequest publishReq = new PublishProductHierarchyRequest { Target = new EntityReference(Product.EntityLogicalName, _productFamilyId) }; PublishProductHierarchyResponse published = (PublishProductHierarchyResponse)_serviceProxy.Execute(publishReq); if (published.Results != null) { Console.WriteLine("Published the product records"); } // Overwrite a product property Console.WriteLine("\nRevising 'Example Product 1' to demonstrate product property overwrite."); // Retrieve the StateCode of Product that you want to revise ColumnSet cols = new ColumnSet(); cols.AddColumns("name", "statecode"); Product retrievedPublishedProduct = (Product)_serviceProxy.Retrieve( Product.EntityLogicalName, _product1Id, cols); // Update the state of the Product to "Under Revision" retrievedPublishedProduct.StateCode = ProductState.UnderRevision; UpdateRequest updatePropertyState = new UpdateRequest { Target = retrievedPublishedProduct }; _serviceProxy.Execute(updatePropertyState); Console.WriteLine("\nChanged '{0}' to 'Under Revision' state.", retrievedPublishedProduct.Name); DynamicProperty newOverwriteProperty = new DynamicProperty(); newOverwriteProperty.BaseDynamicPropertyId = new EntityReference(DynamicProperty.EntityLogicalName, _productOverridenPropertyId); newOverwriteProperty.RegardingObjectId = new EntityReference(Product.EntityLogicalName, _product1Id); _productOverwrittenPropertyId = _serviceProxy.Create(newOverwriteProperty); // Retrieve the attributes of the cloned property you want to update ColumnSet myCols = new ColumnSet(); myCols.AddColumns("name", "isreadonly", "isrequired"); DynamicProperty retrievedOverwrittenProperty = (DynamicProperty)_serviceProxy.Retrieve( DynamicProperty.EntityLogicalName, _productOverwrittenPropertyId, myCols); // Update the attributes of the cloned property to complete the overwrite retrievedOverwrittenProperty.Name = "Overwritten Example Property"; retrievedOverwrittenProperty.IsReadOnly = true; retrievedOverridenProperty.IsRequired = false; _serviceProxy.Update(retrievedOverwrittenProperty); Console.WriteLine("\nOverwritten the product property for 'Example Product 1'."); // Retrieve the StateCode of Product that you want to publish ColumnSet prodCols = new ColumnSet(); prodCols.AddColumns("name", "statecode"); Product retrievedRevisedProduct = (Product)_serviceProxy.Retrieve( Product.EntityLogicalName, _product1Id, prodCols); // Update the state of the Product to "Active" retrievedRevisedProduct.StateCode = ProductState.Active; UpdateRequest publishProduct1 = new UpdateRequest { Target = retrievedRevisedProduct }; _serviceProxy.Execute(publishProduct1); Console.WriteLine("\nPublished '{0}'.", retrievedRevisedProduct.Name); } #endregion Demonstrate } else { const string UNABLE_TO_LOGIN_ERROR = "Unable to Login to Common Data Service"; if (service.LastCrmError.Equals(UNABLE_TO_LOGIN_ERROR)) { Console.WriteLine("Check the connection string values in cds/App.config."); throw new Exception(service.LastCrmError); } else { throw service.LastCrmException; } } } catch (Exception ex) { SampleHelpers.HandleException(ex); } finally { if (service != null) { service.Dispose(); } Console.WriteLine("Press <Enter> to exit."); Console.ReadLine(); } }
// Method to calculate price in an invoice private static void CalculateInvoice(EntityReference entity, IOrganizationService service) { Entity e = service.Retrieve(entity.LogicalName, entity.Id, new ColumnSet("statecode")); OptionSetValue statecode = (OptionSetValue)e["statecode"]; if (statecode.Value == 0) { ColumnSet columns = new ColumnSet(); columns.AddColumns("totaltax", "totallineitemamount", "totalamountlessfreight", "discountamount"); Entity invoice = service.Retrieve(entity.LogicalName, entity.Id, columns); QueryExpression query = new QueryExpression("invoicedetail"); query.ColumnSet.AddColumns("quantity", "invoiceispricelocked", "priceperunit"); query.Criteria.AddCondition("invoiceid", ConditionOperator.Equal, entity.Id); QueryExpression query1 = new QueryExpression("invoicedetail"); query1.ColumnSet.AddColumns("quantity", "invoiceispricelocked"); query1.Criteria.AddCondition("invoiceid", ConditionOperator.Equal, entity.Id); EntityCollection ec = service.RetrieveMultiple(query); EntityCollection ec1 = service.RetrieveMultiple(query1); invoice["totallineitemamount"] = 0; decimal total = 0; decimal discount = 0; decimal tax = 0; for (int i = 0; i < ec.Entities.Count; i++) { total = total + ((decimal)ec.Entities[i]["quantity"] * ((Money)ec.Entities[i]["priceperunit"]).Value); (ec1.Entities[i])["extendedamount"] = new Money(((decimal)ec.Entities[i]["quantity"] * ((Money)ec.Entities[i]["priceperunit"]).Value)); service.Update(ec1.Entities[i]); } invoice["totallineitemamount"] = new Money(total); // Calculate discount based on the total amount discount = CalculateDiscount(total); total = total - discount; invoice["discountamount"] = new Money(discount); invoice["totalamountlessfreight"] = new Money(total); service.Update(invoice); // Calculate tax after the discount is applied tax = CalculateTax(total); total = total + tax; invoice["totaltax"] = new Money(tax); invoice["totalamount"] = new Money(total); service.Update(invoice); } return; }
/// <summary> /// Retrieve the Id for each entityName that has a filterAttribute value in the filterIdList. /// </summary> private static List <Guid> RetrieveReferenceAttributeIds(CrmOrganization org, string entityName, string retrieveAttribute, string filterAttribute, IList <Guid> filterIdList) { #region Argument Validation if (org == null) { throw new ArgumentNullException("org"); } else if (entityName == null) { throw new ArgumentNullException("entityName"); } else if (retrieveAttribute == null) { throw new ArgumentNullException("retrieveAttribute"); } else if (filterAttribute == null) { throw new ArgumentNullException("filterAttribute"); } else if (retrieveAttribute == filterAttribute) { throw new ArgumentException("Attributes must be different"); } #endregion Argument Validation if (filterIdList.Count == 0) { return(new List <Guid>()); } //Generate the query var cols = new ColumnSet(); cols.AddColumns(retrieveAttribute); var idCondition = new ConditionExpression(); idCondition.AttributeName = filterAttribute; idCondition.Operator = ConditionOperator.In; idCondition.Values.Clear(); idCondition.Values.AddRange(ConvertIdArrayToObjectArray(filterIdList)); var query = new QueryExpression(); query.ColumnSet = cols; query.Criteria.AddCondition(idCondition); query.EntityName = entityName; //Loop through the results var resultList = new List <Guid>(); foreach (var entity in org.OrganizationService.RetrieveMultipleAllPages(query).Entities) { foreach (KeyValuePair <string, object> prop in entity.Attributes) { if (prop.Key == retrieveAttribute) { Type propType = prop.Value.GetType(); if (propType == typeof(Guid)) { resultList.Add((Guid)prop.Value); } else if (propType == typeof(EntityReference)) { resultList.Add(((EntityReference)prop.Value).Id); } else { throw new ArgumentException("Unknown property returned " + prop.GetType().FullName); } } } } return(resultList); }
protected string GetUrlFromSettingsByName(string serviceUrl, IOrganizationService service) { string url = string.Empty; QueryExpression query = new QueryExpression("new_parameter"); ColumnSet columns = new ColumnSet(); columns.AddColumns("new_description", "new_name", "new_value"); query.ColumnSet = columns; query.Criteria = new FilterExpression(); query.Criteria.FilterOperator = LogicalOperator.And; ConditionExpression conditionIdByName = new ConditionExpression("new_name", ConditionOperator.Equal, serviceUrl); query.Criteria.Conditions.AddRange(conditionIdByName); EntityCollection col = service.RetrieveMultiple(query); if (col.Entities.Count > 0) { if (col.Entities[0].Contains("new_value")) { return url = col.Entities[0].GetAttributeValue<string>("new_value"); } } return url; }
/// <summary> /// Create and configure the organization service proxy. /// Initiate creating all entity records that this sample requires. /// Create a product family with a product property and two child product records. /// Create a substitute relation between the two products. /// Override the product property for one of the child products. /// Publish the product family hierarchy, including the child records. /// Revise a child product to overwrite the overridden property. /// Publish the child product. /// Optionally delete any entity records that were created for this sample. /// </summary> /// <param name="serverConfig">Contains server connection information.</param> /// <param name="promptforDelete">When True, the user will be prompted to delete all /// created entities.</param> public void Run(ServerConnection.Configuration serverConfig, bool promptForDelete) { try { // Connect to the Organization service. // The using statement assures that the service proxy will be properly disposed. using (_serviceProxy = ServerConnection.GetOrganizationProxy(serverConfig)) { // This statement is required to enable early-bound type support. _serviceProxy.EnableProxyTypes(); // Call the method to create any data that this sample requires. CreateRequiredRecords(); //<snippetCreateandublishProducts1> // Create a product family Product newProductFamily = new Product { Name = "Example Product Family", ProductNumber = "PF001", ProductStructure = new OptionSetValue(2) }; _productFamilyId = _serviceProxy.Create(newProductFamily); Console.WriteLine("\nCreated '{0}'", newProductFamily.Name); // Create a product property DynamicProperty newProperty = new DynamicProperty { Name = "Example Property", RegardingObjectId = new EntityReference(Product.EntityLogicalName, _productFamilyId), IsReadOnly = true, IsRequired = true, IsHidden = false, DataType = new OptionSetValue(3), //Single line of text DefaultValueString = "Default Value" }; _productPropertyId = _serviceProxy.Create(newProperty); Console.WriteLine("\nCreated '{0}' for the product family", newProperty.Name); // Create couple of product records under the product family Product newProduct1 = new Product { Name = "Example Product 1", ProductNumber = "P001", ProductStructure = new OptionSetValue(1), ParentProductId = new EntityReference(Product.EntityLogicalName, _productFamilyId), QuantityDecimal = 2, DefaultUoMScheduleId = new EntityReference(UoMSchedule.EntityLogicalName, _unitGroupId), DefaultUoMId = new EntityReference(UoM.EntityLogicalName, _unit.Id) }; _product1Id = _serviceProxy.Create(newProduct1); Console.WriteLine("\nCreated '{0}' under the product family", newProduct1.Name); Product newProduct2 = new Product { Name = "Example Product 2", ProductNumber = "P002", ProductStructure = new OptionSetValue(1), ParentProductId = new EntityReference(Product.EntityLogicalName, _productFamilyId), QuantityDecimal = 2, DefaultUoMScheduleId = new EntityReference(UoMSchedule.EntityLogicalName, _unitGroupId), DefaultUoMId = new EntityReference(UoM.EntityLogicalName, _unit.Id) }; _product2Id = _serviceProxy.Create(newProduct2); Console.WriteLine("Created '{0}' under the product family", newProduct2.Name); // Create a price list items for the products ProductPriceLevel newPriceListItem1 = new ProductPriceLevel { PriceLevelId = new EntityReference(PriceLevel.EntityLogicalName, _priceListId), ProductId = new EntityReference(Product.EntityLogicalName, _product1Id), UoMId = new EntityReference(UoM.EntityLogicalName, _unit.Id), Amount = new Money(20) }; _priceListItem1Id = _serviceProxy.Create(newPriceListItem1); Console.WriteLine("\nCreated price list for '{0}'", newProduct1.Name); ProductPriceLevel newPriceListItem2 = new ProductPriceLevel { PriceLevelId = new EntityReference(PriceLevel.EntityLogicalName, _priceListId), ProductId = new EntityReference(Product.EntityLogicalName, _product2Id), UoMId = new EntityReference(UoM.EntityLogicalName, _unit.Id), Amount = new Money(20) }; _priceListItem2Id = _serviceProxy.Create(newPriceListItem2); Console.WriteLine("Created price list for '{0}'", newProduct2.Name); // Set the product relationship // Set Example Product 1 and Example Product 2 as substitute of each other (bi-directional) ProductSubstitute newProductRelation = new ProductSubstitute { SalesRelationshipType = new OptionSetValue(3), Direction = new OptionSetValue(1), ProductId = new EntityReference(Product.EntityLogicalName, _product1Id), SubstitutedProductId = new EntityReference(Product.EntityLogicalName, _product2Id) }; _productRelationId = _serviceProxy.Create(newProductRelation); Console.WriteLine("\nCreated a substitute relation between the two products."); //</snippetCreateandublishProducts1> // Override a product property at the product level // In this case we will override the property for 'Example Product 1' DynamicProperty newOverrideProperty = new DynamicProperty(); newOverrideProperty.BaseDynamicPropertyId = new EntityReference(DynamicProperty.EntityLogicalName, _productPropertyId); newOverrideProperty.RegardingObjectId = new EntityReference(Product.EntityLogicalName, _product1Id); _productOverridenPropertyId = _serviceProxy.Create(newOverrideProperty); // Retrieve the attributes of the cloned property you want to update ColumnSet columns = new ColumnSet(); columns.AddColumns("name", "isreadonly", "isrequired"); DynamicProperty retrievedOverridenProperty = (DynamicProperty)_serviceProxy.Retrieve( DynamicProperty.EntityLogicalName, _productOverridenPropertyId, columns); // Update the attributes retrievedOverridenProperty.Name = "Overridden Example Property"; retrievedOverridenProperty.IsReadOnly = true; retrievedOverridenProperty.IsRequired = false; _serviceProxy.Update(retrievedOverridenProperty); Console.WriteLine("\nOverridden the product property for 'Example Product 1'."); // Prompt the user whether to publish the product family and products bool publishRecords = true; Console.WriteLine("\nDo you want the product records published? (y/n)"); String answer = Console.ReadLine(); publishRecords = (answer.StartsWith("y") || answer.StartsWith("Y")); if (publishRecords) { PublishProductHierarchyRequest publishReq = new PublishProductHierarchyRequest { Target = new EntityReference(Product.EntityLogicalName, _productFamilyId) }; PublishProductHierarchyResponse published = (PublishProductHierarchyResponse)_serviceProxy.Execute(publishReq); if (published.Results != null) { Console.WriteLine("Published the product records"); } // Overwrite a product property Console.WriteLine("\nRevising 'Example Product 1' to demonstrate product property overwrite."); // Retrieve the StateCode of Product that you want to revise ColumnSet cols = new ColumnSet(); cols.AddColumns("name", "statecode"); Product retrievedPublishedProduct = (Product)_serviceProxy.Retrieve( Product.EntityLogicalName, _product1Id, cols); // Update the state of the Product to "Under Revision" retrievedPublishedProduct.StateCode = ProductState.UnderRevision; UpdateRequest updatePropertyState = new UpdateRequest { Target = retrievedPublishedProduct }; _serviceProxy.Execute(updatePropertyState); Console.WriteLine("\nChanged '{0}' to 'Under Revision' state.", retrievedPublishedProduct.Name); DynamicProperty newOverwriteProperty = new DynamicProperty(); newOverwriteProperty.BaseDynamicPropertyId = new EntityReference(DynamicProperty.EntityLogicalName, _productOverridenPropertyId); newOverwriteProperty.RegardingObjectId = new EntityReference(Product.EntityLogicalName, _product1Id); _productOverwrittenPropertyId = _serviceProxy.Create(newOverwriteProperty); // Retrieve the attributes of the cloned property you want to update ColumnSet myCols = new ColumnSet(); myCols.AddColumns("name", "isreadonly", "isrequired"); DynamicProperty retrievedOverwrittenProperty = (DynamicProperty)_serviceProxy.Retrieve( DynamicProperty.EntityLogicalName, _productOverwrittenPropertyId, myCols); // Update the attributes of the cloned property to complete the overwrite retrievedOverwrittenProperty.Name = "Overwritten Example Property"; retrievedOverwrittenProperty.IsReadOnly = true; retrievedOverridenProperty.IsRequired = false; _serviceProxy.Update(retrievedOverwrittenProperty); Console.WriteLine("\nOverwritten the product property for 'Example Product 1'."); // Retrieve the StateCode of Product that you want to publish ColumnSet prodCols = new ColumnSet(); prodCols.AddColumns("name", "statecode"); Product retrievedRevisedProduct = (Product)_serviceProxy.Retrieve( Product.EntityLogicalName, _product1Id, prodCols); // Update the state of the Product to "Active" retrievedRevisedProduct.StateCode = ProductState.Active; UpdateRequest publishProduct1 = new UpdateRequest { Target = retrievedRevisedProduct }; _serviceProxy.Execute(publishProduct1); Console.WriteLine("\nPublished '{0}'.", retrievedRevisedProduct.Name); } DeleteRequiredRecords(promptForDelete); } } catch { // You can handle an exception here or pass it back to the calling method. throw; } }