/// <summary>
/// Retorna um registro por id
/// </summary>
/// <param name="id">ID do registro</param>
/// <param name="useAllColumns">retornar todos os campos true/false</param>
/// <returns></returns>
public virtual EntityType Obter(Guid id, bool useAllColumns)
{
if (Contexto.Proxy.CallerId != Guid.Empty)
{
Contexto.Proxy.CallerId = Guid.Empty;
}
Microsoft.Xrm.Sdk.Query.ColumnSet colums = new Microsoft.Xrm.Sdk.Query.ColumnSet(useAllColumns);
return(Contexto.Proxy.Retrieve(this.NomeLogico, id, colums) as EntityType);
}
// Note: we ignore columnset
public Entity Retrieve(string entityName, Guid id, Microsoft.Xrm.Sdk.Query.ColumnSet columnSet)
{
foreach (Entity entity in data[entityName].Entities)
{
// TODO: factor this check out to method
Guid key;
if (entity.GetType().Name == "Entity")
{
Entity de = ( Entity )entity;
key = ( Guid )de[entityName + "id"];
}
else
{
// TODO: we guess at id field name - should look for Key field type instead
key = ( Guid )entity.GetType().GetProperty(entityName + "id").GetValue(entity, null);
}
Guid keyID = key;
if (keyID == id)
{
return(entity);
}
}
return(null);
}
private static Entity getRelatedEntity(IOrganizationService orgService, string entityName, Microsoft.Xrm.Sdk.Query.ColumnSet entityAttributes, string attributeName, string attributeValue)
{
Entity entity = null;
QueryExpression queryExpression = new QueryExpression(entityName);
queryExpression.ColumnSet = entityAttributes;
queryExpression.Criteria.AddCondition(attributeName, ConditionOperator.Equal, attributeValue);
EntityCollection entityCollection = orgService.RetrieveMultiple(queryExpression);
if (entityCollection.Entities.Count > 0)
{
entity = entityCollection.Entities[0];
}
return(entity);
}
protected override void Execute(CodeActivityContext executionContext)
{
ITracingService tracingService = executionContext.GetExtension <ITracingService>();
IWorkflowContext context = executionContext.GetExtension <IWorkflowContext>();
IOrganizationServiceFactory serviceFactory = executionContext.GetExtension <IOrganizationServiceFactory>();
IOrganizationService service = serviceFactory.CreateOrganizationService(context.UserId);
tracingService.Trace("{0}{1}", "Start Custom Workflow Activity: CheckSubmissionCategoryLimit", DateTime.Now.ToLongTimeString());
//Check to see if the EntityReference has been set
EntityReference submissonCategoryReference = this.submissonCategory.Get(executionContext);
if (submissonCategoryReference == null)
{
throw new InvalidOperationException("Submission Category has not been specified", new ArgumentNullException("Submission Category"));
}
else if (submissonCategoryReference.LogicalName != "caps_submissioncategory")
{
throw new InvalidOperationException("Input must reference a submission category record",
new ArgumentException("Input must be of type submission category", "Submission Category"));
}
EntityReference capitalPlanReference = this.capitalPlan.Get(executionContext);
if (capitalPlanReference == null)
{
throw new InvalidOperationException("Capital Plan has not been specified", new ArgumentNullException("Capital Plan"));
}
else if (capitalPlanReference.LogicalName != "caps_submission")
{
throw new InvalidOperationException("Input must reference a capital plan record",
new ArgumentException("Input must be of type capital plan", "Capita Plan"));
}
//Set default values for outputs
var error = false;
var errorMessage = "";
//Get Submission Category
Microsoft.Xrm.Sdk.Query.ColumnSet columns = new Microsoft.Xrm.Sdk.Query.ColumnSet("caps_projectlimit");
var submissionCategoryRecord = service.Retrieve(submissonCategoryReference.LogicalName, submissonCategoryReference.Id, columns) as CAPS.DataContext.caps_SubmissionCategory;
//Get Submission (Capital Plan)
Microsoft.Xrm.Sdk.Query.ColumnSet columnsCapitalPlan = new Microsoft.Xrm.Sdk.Query.ColumnSet("caps_callforsubmission");
var capitalPlanRecord = service.Retrieve(capitalPlanReference.LogicalName, capitalPlanReference.Id, columnsCapitalPlan) as CAPS.DataContext.caps_Submission;
tracingService.Trace("Capital Plan ID: {0}", capitalPlanRecord.caps_CallforSubmission.Id);
//Get Submission Categories for the Capital Plan
using (var crmContext = new CrmServiceContext(service))
{
tracingService.Trace("Project's Submission Category ID: {0}", submissonCategoryReference.Id);
//First check that the submission category of the project is valid, if it's isn't return an error.
var validSubmissionCategories = from a in crmContext.caps_CallForSubmission_caps_SubmissionCatSet
join b in crmContext.caps_CallForSubmissionSet on a.caps_callforsubmissionid equals b.caps_CallForSubmissionId
where a.caps_callforsubmissionid == capitalPlanRecord.caps_CallforSubmission.Id
select a.caps_submissioncategoryid;
if (!validSubmissionCategories.ToList().Contains(submissonCategoryReference.Id))
{
//This is not an allow submission category
error = true;
errorMessage = string.Format("This project cannot be added to {0} as the submission category of {1} is not allowed.", capitalPlanReference.Name, submissonCategoryReference.Name);
}
//if submission category has a count, check the count in the capital plan, otherwise return
if (!error && submissionCategoryRecord.caps_ProjectLimit.GetValueOrDefault(0) > 0)
{
tracingService.Trace("Submission Category Limit: {0}", submissionCategoryRecord.caps_ProjectLimit.Value.ToString());
var records = crmContext.caps_ProjectSet.Where(r => r.caps_SubmissionCategory.Id == submissonCategoryReference.Id && r.caps_Submission.Id == capitalPlanReference.Id).ToList();
tracingService.Trace("Record Count: {0}", records.Count.ToString());
if (records.Count() > submissionCategoryRecord.caps_ProjectLimit.Value)
{
error = true;
errorMessage = string.Format("This project cannot be added to {0} as you have already reached the limit of {1} {2} Projects. All subsequent projects will not be added.", capitalPlanReference.Name, submissionCategoryRecord.caps_ProjectLimit.Value.ToString(), submissonCategoryReference.Name);
}
}
}
this.error.Set(executionContext, error);
this.errorMessage.Set(executionContext, errorMessage);
}