Update total time in Case

  4.create total timespan field in Case, update this field value based on timespan update in child records.


Step1: Create Total timespan field in Case entity.

Step2: Create the fetch xml to retrieve the records which having  total time in timespan

Step3: Get the all the records using fetch xml

Step4: Using foreach get the total time in timespan and add the total time using foreach

Step5: Update the that time in case entity 


C# code For  above 

using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Query;
using Microsoft.Xrm.Sdk.Workflow;
using System;
using System.Activities;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Week3rdtasks
{
    public class Totaltimeforcasesolving : IPlugin
    {
        public void Execute(IServiceProvider serviceProvider)
        {
            IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));
            IOrganizationServiceFactory factory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));
            IOrganizationService service = (IOrganizationService)factory.CreateOrganizationService(context.UserId);
            ITracingService tracing = (ITracingService)serviceProvider.GetService(typeof(ITracingService));
            if (context.Depth == 1)
            {
                try
                {
                    tracing.Trace("entity update");
                    if (context.InputParameters.Contains("Target") && context.InputParameters["Target"] is Entity)
                    {
                        Entity Caseobject = (Entity)context.InputParameters["Target"];
                        string query = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>" +
      "<entity name='cr8d7_timespan'>" +
        "<attribute name='cr8d7_timespanid' />" +
        "<attribute name='cr8d7_name' />" +
         "<attribute name='cr8d7_totaltimeoncase' />" +
        "<attribute name='createdon' />" +
        "<order attribute='cr8d7_name' descending='false' />" +
        "<filter type='and'>" +
          "<condition attribute='cr8d7_casestatus' operator='eq' uitype='incident' value='"+Caseobject.Id+"' />" +
          "<condition attribute='cr8d7_totaltimeoncase' operator='not-null' />" +
        "</filter>" +
      "</entity>" +
    "</fetch>";
                        EntityCollection AllTimespandata = service.RetrieveMultiple(new FetchExpression(query));
                        int Totaltimetaken = 0;
                        foreach (Entity Singeltimedaat in AllTimespandata.Entities)
                        {                           
                            tracing.Trace("total entitys" + AllTimespandata.Entities.Count);                        
                            int singelcasetime = Singeltimedaat.GetAttributeValue<int>("cr8d7_totaltimeoncase");
                            Totaltimetaken = Totaltimetaken + singelcasetime;
                            tracing.Trace("time taken " + Totaltimetaken);
                        }
                        tracing.Trace("time taken to complte" + Totaltimetaken);
                        Caseobject["cr8d7_timetocomplte"] = Totaltimetaken;

                        service.Update(Caseobject);
                        return;

                    }
                }
                catch (Exception ex)
                {
                    throw new InvalidPluginExecutionException(ex.Message);
                }
            }
        }
    }
}

Trigger the plugin on case status update and post operation pipeline






Comments

Post a Comment

Popular posts from this blog

create HTML page show all contact related to specific account, add this webresource as a subgrid in the form

Image
  We need to create one html and add the JavaScript and CSS. After Add the webresource to Form. For this fist we need to create hml like below <!DOCTYPE html> <html> <head>     <title>Contact Records</title>     <style>         table, th, td {             border: 1px solid black;             border-collapse:collapse;             border-color:yellow;         }         td{             text-align:center;             color:blue;             background-color:blue;                      }         th{             background-color:red;         }        ...
Read more

Connect MS Crm To Postman For Webapi Calls.

Image
 Connect MS Crm To Postman For Web api Calls. Step1: For the postman connection we need to create azure account with active directory in azure portal with Your Crm userid and password. Step2: Select the Azure active deprecatory and it will open below page And select the App registration i.e. available in the lest navigation Step3: After selecting it will open the and below page click on new app registration Step4: In the below page, we need to give the app name and redirected URL as localhost as Web and supported account for any organization and click on register Step5: After register copy the client id and paste it some where, for the future reference And click on manifest in left navigation Step6:Set the Auth URL As below for further use Step7: Change the below marked code and set as true for the both and click on save Step8: Select the Api Permission in left navigation and click on Add permission  Step9: After that select Dynamic Crm As api permission Step10: Select the...
Read more

create one PCF control and embed into crm

Image
  create one PCF control and embed into Crm These pcf controls are the custom controls. we can create different control for the different data types in Crm. In this post we can discuss about numeric data type. For the creation, we require nodejs and power cli. Step1: Download the nodejs from the browser and install it. Stwp2: Open the Developer power shell for vs 2019 Step2: Check wheather app is installed or not. Enter the Below command node -v   .It will show the version of the node js Step3: Download and install the visual studio code. Step4: Download the Power Cli from the below link https://learn.microsoft.com/en-us/power-platform/developer/cli/introduction. Step4: its open like below and click install Step5: Go to file manager and create new one project folder Step6: Chnage the path by entering the below command cd Your file path. Step5: Validate the Power cli by entering the below command pac install latest it will show like below Enter the below com...
Read more