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