D365 FetchXML query into plugin

Generate the xml query using xrmtoolbox and try with this code sample.

 String eventsessionFetchXML = $@"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>  
                <entity name='baseevt_eventsession' >  
                 <attribute name='baseevt_eventid' />  
                 <attribute name='baseevt_sessionenddatetime' />  
                 <attribute name='baseevt_sessionstartdatetime' />  
                 <attribute name='baseevt_name' />  
                 <attribute name='baseevt_description' />  
                 <filter>  
                  <condition attribute='baseevt_eventid' operator='eq' value='{inputEntity.Id.ToString()}' />  
                 </filter>  
                </entity>  
               </fetch>";  
         var eventSessionresult = localContext.OrganizationService.RetrieveMultiple(new FetchExpression(eventsessionFetchXML));  
         if (!eventSessionresult.Entities.Any())  
         {  
           return; // don't do anything if there are not suitable Contacts  
         }  
         foreach (Entity eventSession in eventSessionresult.Entities)  
         {  
           EventSessionbasexy eventSessionbasexy = new EventSessionbasexy()  
           {  
             Name = eventSession.GetAttributeValue<string>("baseevt_name"),  
           };  
                          // insert new record  
           eventSessionbasexy.Id = localContext.OrganizationService.Create(eventSessionbasexy.ToEntity<Entity>());  
         }

Comments

C# run powershell script as administrator

Recently I was fetching a problem that I need to run a PowerShell script that will change TFS user Display name and SID. I was trying to run that script from C# that was not working due to TFS security update and TLS certificate. Using this code block I resolve the Issue. var newProcessInfo = new System.Diagnostics.ProcessStartInfo(); newProcessInfo.FileName = @"C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe"; newProcessInfo.Verb = "runas"; // Define Run as administrator newProcessInfo.Arguments = script; //Define your powershell script newProcessInfo.UseShellExecute = false; newProcessInfo.RedirectStandardOutput = true; // This will enable to read Powershell run output newProcessInfo.RedirectStandardError = true; Process proces = System.Diagnostics.Process.Start(newProcessInfo); proces.WaitForExit(); // I want to read the output string from powershell window StringBuilder output = new StringBuilder(); output.Append("Started"); while (!proces.St

ASP.NET MVC razor SAP Crystal report

Crete a new project: Add a aspx Master Page Create a new folder Reports and 2 sub folder crystal & crystalviewer Now add a web form page in crystalviewer folder. Add the master page namespace in your web form page. MasterPageFile ="~/Views/Shared/ReportSite.Master" Replace your web form by this code < asp : Content ID ="Content1" ContentPlaceHolderID ="ContentPlaceHolder1" runat ="server"> </ asp : Content > Now go to design mode of your web form drag & drop the crystal report viewer in your web form. After that your page will be look look like this. Replace the code: < CR : CrystalReportViewer ID ="EmployeeList" runat ="server" HasCrystalLogo ="False" AutoDataBind ="True" Height ="50px" EnableParameterPrompt ="false" EnableDatabaseLogonPrompt

mvc razor textboxfor change event change another textboxfor value

Based on value of Weight, Rate , CNF & AWB it will change the value of Freight , TTLCNF anfd TTLFright . Freight= Weight*Rate; TTLCNF = Weight*CNF; TTLFright= Freight+ TTLCNF + AWB; @Html.TextBoxFor(model => model.Weight, new { onChange="return GetWight(this);"}) @Html.TextBoxFor(model => model.Rate, new { onChange="return GetWight(this);"})/Kg @Html.TextBoxFor(model => model.Freight, new {disabled = "disabled" , @readonly = "readonly" ,onChange="return GetTTLFright(this);"}) @Html.TextBoxFor(model => model.CNFPK, new { onChange="return GetCNFPK(this);"}) @Html.TextBoxFor(model => model.TTLCNF, new {disabled = "disabled" , @readonly = "readonly",onChange="return GetTTLFright(this);" }) @Html.TextBoxFor(model => model.AWB, new { onChange="return GetTTLFright(this);"}) and script <script> function GetW

Powered by Passion

Search This Blog