public void getAnnotationAttachment() { IOrganizationService service = CRMHelper.ConnectToMSCRM(); QueryExpression query = new QueryExpression("annotation"); query.ColumnSet = new ColumnSet(new string[] { "filesize" }); query.Criteria.AddCondition("filesize", ConditionOperator.GreaterThan, 0); EntityCollection List = CRMHelper.RetrieveMultiple(query, service); decimal totalSize = 0; foreach (Entity Item in List.Entities) { decimal filesize = Convert.ToDecimal(Item.Attributes["filesize"].ToString()); totalSize = totalSize + filesize; } Console.WriteLine("Total File Size :" + totalSize); decimal inKB = totalSize / 1024; decimal inMB = inKB / 1024; decimal inGB = inMB / 1024; Console.ReadLine(); }
public void cleanupContacts() { DateTime DateFilter = DateTime.Now.AddDays(-1); QueryExpression query = new QueryExpression("account"); IOrganizationService service = CRMHelper.ConnectToMSCRM1(); Console.WriteLine("IOrganization Service Object Created"); EntityCollection EntityList = CRMHelper.RetrieveMultiple(query, service); ExecuteMultipleRequest mulitRequest = null; int offset = 1; Console.WriteLine("Total Record to be Deleted are : " + EntityList.Entities.Count); mulitRequest = getNewObject(); for (int count = 0; count < EntityList.Entities.Count; count++) { if (offset % 200 == 0) { // Execute all the requests in the request collection using a single web method call. ExecuteMultipleResponse multipleResponse = (ExecuteMultipleResponse)service.Execute(mulitRequest); Console.WriteLine("Bunch of 200 Record Deleted & Total record Proceed are : " + count); mulitRequest = getNewObject(); } Entity Item = EntityList.Entities[count]; DeleteRequest deleteRequest = new DeleteRequest { Target = Item.ToEntityReference() }; mulitRequest.Requests.Add(deleteRequest); offset = count + 1; } }
public void getEmailAttachment() { IOrganizationService service = CRMHelper.ConnectToMSCRM(); QueryExpression query = new QueryExpression("activitymimeattachment"); query.ColumnSet = new ColumnSet(new string[] { "filesize" }); Console.WriteLine("IOrganization Service Object Created"); EntityCollection EntityList = CRMHelper.RetrieveMultiple(query, service); List <int> FileSizeList = new List <int>(); foreach (Entity Item in EntityList.Entities) { if (Item.Attributes.Contains("filesize")) { FileSizeList.Add(Convert.ToInt32(Item["filesize"])); } } var TotalSize = 0; foreach (int Item in FileSizeList) { TotalSize = TotalSize + Item; } var SizeKB = TotalSize / 1024; var SizeMB = SizeKB / 1024; var SizeGB = SizeMB / 1024; }
public void getAllContactsCount() { QueryExpression query = new QueryExpression("contact"); query.Criteria.AddCondition("statecode", ConditionOperator.Equal, 0); IOrganizationService service = CRMHelper.ConnectToMSCRM(); EntityCollection List = CRMHelper.RetrieveMultiple(query, service); Console.ReadLine(); }
public EntityCollection getAllEmployee() { QueryExpression query = new QueryExpression("new_employee"); query.ColumnSet = new ColumnSet(new string[] { "new_name", "new_loyalti", "new_jobtitle", "new_grade" }); IOrganizationService service = CRMHelper.ConnectToMSCRM(); EntityCollection List = CRMHelper.RetrieveMultiple(query, service); return(List); }
public void updateContactOwner() { QueryExpression query = new QueryExpression("contact"); query.ColumnSet = new ColumnSet(new string[] { "new_parentaccount", "ownerid", "fullname" }); LinkEntity contactLink = new LinkEntity("contact", "account", "new_parentaccount", "accountid", JoinOperator.Inner); contactLink.EntityAlias = "Company"; contactLink.Columns = new ColumnSet(new string[] { "ownerid" }); query.LinkEntities.Add(contactLink); IOrganizationService service = CRMHelper.ConnectToMSCRM1(); EntityCollection contactList = CRMHelper.RetrieveMultiple(query, service); ExecuteMultipleRequest mulitRequest = null; int offset = 1; Console.WriteLine("Total Record to be Deleted are : " + contactList.Entities.Count); mulitRequest = getNewObject(); for (int count = 0; count < contactList.Entities.Count; count++) { Guid OwnerId = Guid.Empty; string fullName = string.Empty; string accountName = string.Empty; if (contactList.Entities[count].Attributes.Contains("fullname")) { fullName = contactList.Entities[count].Attributes["fullname"].ToString(); } AliasedValue val = (AliasedValue)contactList.Entities[count].Attributes["Company.ownerid"]; EntityReference ownerIdRef = (EntityReference)val.Value; OwnerId = ownerIdRef.Id; accountName = ownerIdRef.Name; Guid ContactOwner = contactList.Entities[count].GetAttributeValue <EntityReference>("ownerid").Id; Entity contact = new Entity("contact"); if (ContactOwner != OwnerId) { Console.WriteLine("Miss-Match Owner of For Contact : " + fullName + " And Account is : " + accountName); contact.Id = contactList.Entities[count].Id; contact.Attributes.Add("ownerid", new EntityReference("systemuser", OwnerId)); UpdateRequest updateRequest = new UpdateRequest { Target = contact }; mulitRequest.Requests.Add(updateRequest); } } ExecuteMultipleResponse multipleResponse = (ExecuteMultipleResponse)service.Execute(mulitRequest); Console.ReadLine(); }
public void DeleteWaitingJobs() { DateTime DateFilter = DateTime.Now.AddDays(-1); List <string> statusList = new List <string>(); statusList.Add("1"); statusList.Add("3"); QueryExpression query = new QueryExpression("asyncoperation"); query.Criteria.AddCondition("statuscode", ConditionOperator.NotEqual, 30); query.Criteria.AddCondition("createdon", ConditionOperator.OnOrBefore, DateFilter); query.Criteria.AddCondition("operationtype", ConditionOperator.Equal, 10); IOrganizationService service = CRMHelper.ConnectToMSCRM(); Console.WriteLine("IOrganization Service Object Created"); EntityCollection EntityList = CRMHelper.RetrieveMultiple(query, service); int count = 1; ExecuteMultipleRequest mulitRequest = null; Console.WriteLine("Total Record to be Deleted are : " + EntityList.Entities.Count); for (int i = 0; i < EntityList.Entities.Count; i++) { if (i == 1 || i % 1000 == 0) { mulitRequest = getNewObject(); } Entity Item = EntityList.Entities[i]; DeleteRequest deleteRequest = new DeleteRequest { Target = Item.ToEntityReference() }; mulitRequest.Requests.Add(deleteRequest); if (count % 1000 == 0 || count == EntityList.Entities.Count) { // Execute all the requests in the request collection using a single web method call. ExecuteMultipleResponse multipleResponse = (ExecuteMultipleResponse)service.Execute(mulitRequest); Console.WriteLine("Bunch of 1000 Record Deleted & Total record Proceed are :" + count); } count++; } }
public void deactiveContacts(string EntityName) { DateTime DateFilter = DateTime.Now.AddDays(-1); QueryExpression query = new QueryExpression(EntityName); query.Criteria.AddCondition("statecode", ConditionOperator.Equal, 0); IOrganizationService service = CRMHelper.ConnectToMSCRM1(); Console.WriteLine("IOrganization Service Object Created"); EntityCollection EntityList = CRMHelper.RetrieveMultiple(query, service); ExecuteMultipleRequest mulitRequest = null; int offset = 1; Console.WriteLine("Total Record to be Deleted are : " + EntityList.Entities.Count); mulitRequest = getNewObject(); for (int count = 0; count < EntityList.Entities.Count; count++) { if (offset % 200 == 0) { // Execute all the requests in the request collection using a single web method call. ExecuteMultipleResponse multipleResponse = (ExecuteMultipleResponse)service.Execute(mulitRequest); Console.WriteLine("Bunch of 200 Record Deleted & Total record Proceed are : " + count); mulitRequest = getNewObject(); } Entity Item = EntityList.Entities[count]; //StateCode = 1 and StatusCode = 2 for deactivating Account or Contact SetStateRequest setStateRequest = new SetStateRequest() { EntityMoniker = new EntityReference { Id = Item.Id, LogicalName = Item.LogicalName }, State = new OptionSetValue(1), Status = new OptionSetValue(2) }; mulitRequest.Requests.Add(setStateRequest); offset = count + 1; } }
public EntityCollection getAllUSZipCode(IOrganizationService service) { QueryExpression query = new QueryExpression("new_zipcode"); query.ColumnSet = new ColumnSet(new string[] { "new_zipcode", "new_country" }); FilterExpression feOr = new FilterExpression(LogicalOperator.Or); for (char c = 'a'; c <= 'z'; c++) { feOr.AddCondition("new_zipcode", ConditionOperator.BeginsWith, c.ToString()); } FilterExpression feAnd = new FilterExpression(LogicalOperator.And); feAnd.AddCondition("new_country", ConditionOperator.Equal, "US"); query.Criteria.AddFilter(feAnd); query.Criteria.AddFilter(feOr); EntityCollection zipCodeList = CRMHelper.RetrieveMultiple(query, service); return(zipCodeList); }