[Blog bot]

Источник: http://axstart.spaces.live.com/Blog/...C0A0!322.entry
==============

Introduction


Last week we used an AX Web service in combination with InfoPath. The solution we build had still some limitations. This week we will create an InfoPath Document that post documents to the AIF inbound file adapter. There is no difference on user experience when he posts to a web service or the AIF File inbound adapter.
 Create a file inbound service in AX


We can reuse all Axapta code from the previous session, but I make some additional enhancement on them. Till now, the created ProjJournalTrans records where nicely, but if we look more closely on it; it’s not as beautiful as expected. A lot of fields where not set:

• Cost Price
• Sales Price
• Taxgroep
• Period
  Dimensions

Personally I also don’t like that the user had to set the LinePropertyID. So let’s improve the prepareForSave method. Our Interface can become match more cleaver and user friendly
public boolean prepareForSave(AxdStack _axdStack,  str _dataSourceName)
{
    //TODO: Remember to make code for validating fields that are added to the initMandatoryFieldsMap method
    //      that are not mandatory in the table
    ProjJournalTable projJournalTable;
    JournalID       journalID;
    axProjJournalTrans    axProjJournalTrans;
    ProjJournalTrans      projJournalTrans;
    ;
    switch (classidget(_axdStack.top()))
    {
        case classnum(AxProjJournalTrans) :
            axProjJournalTrans = _axdStack.top();
            journalID          = strfmt("Week %1",wkofyr(axProjJournalTrans.parmProjTransDate()));
            if(!ProjJournalTable::exist(journalID))
            {
                projJournalTable.initFromProjJournalName(ProjJournalName::Find("Hour"));
                projJournalTable.JournalId  = journalID;
                projJournalTable.insert();
            }
            axProjJournalTrans.projJournalTrans().initFromProjTable(ProjTable::find(projJournalTrans.ProjId));
            axProjJournalTrans.projJournalTrans().setTransDate();
            axProjJournalTrans.setFieldAsTouched(fieldnum(projJournalTrans,dimension));
            axProjJournalTrans.setFieldAsTouched(fieldnum(projJournalTrans,CostPrice));
            axProjJournalTrans.setFieldAsTouched(fieldnum(projJournalTrans,salesPrice));
            axProjJournalTrans.setFieldAsTouched(fieldnum(projJournalTrans,PeriodDate));
            axProjJournalTrans.setFieldAsTouched(fieldnum(projJournalTrans,TaxGroupId));
            axProjJournalTrans.setFieldAsTouched(fieldnum(projJournalTrans,TaxItemGroupId));
            axProjJournalTrans.setFieldAsTouched(fieldnum(projJournalTrans,CategoryId));
            axProjJournalTrans.setFieldAsTouched(fieldnum(projJournalTrans,TransDate));
            axProjJournalTrans.parmJournalId(journalID);
            //TODO Put validating code for ProjJournalTrans here
            return true;
 
        default :
            error(strfmt("@SYS88979",classId2Name(classidget(_axdStack.top()))));
            return false;
    }
    return false;
}

 
NOTE: Changes on table fields without using the ParmFIeldName method need an addition setFieldAsTouched call, otherwise the changes are lost.

  Create the new file inbound service


We will reuse the existing file Inbound adaptor of the Contoso VPC (c:\AIF\Inbound). The InfoPath document will post the xml messages in this map and AX AIF Batch will process them. It is also posible to process the messages with below x++ job.
static void AifReceiveSend(Args _args)
{
    ;
    // receive documents in inbound processing queue and process
    new AifGatewayReceiveService().run();
    new AifInboundProcessingService().run();
 
    // create documents in outbound processing queue and process
   // new AifOutboundProcessingService().run();
   // new AifGatewaySendService().run();
}

 
NOTE: Change class AifInboundProcessingService method run for debugging purpose. You have to replace the  runas(……) code with  AifInboundProcessingService::processRequest(message); After debugging your AIF inbound process can gets corrupted. In that case you have to clean up manually the table AifResourceLock & AifGatewayQueue

 
Before we can connect InfoPath to the file inbound adapter, we have to get all XSD information.

• Select the createListProjHours Action Form of AX.
• Press View schema button
  Press Save as button (use createListProjJours name).

Create an InfoPath document


Open InfoPath 2007 on the VPC. Select design a Form Template. Select XML or Schema and press OK.


InfoPath will open a wizard that helps you to find and connect the right way to the XSD of ProjHours. The main XSD is the message.XSD. Select this one from C:\Program Files\Microsoft Dynamics AX\Application\Share\Include

 
   
 
   
       
           
           
       
   
   
   
                 
           
           
           
           
           
           
       
   
 
   
       
           
       
   
 


 

• browse for your createListProjHours.XDS that you saved from the action Form in AX
• Press Next
  Press No for any additional data sources and press finished.

From this point we have an InfoPath form with data source that can do the job.

  Designing the Form

• Drag the fields to the form that you need. First we drag the Header node to the design. When dropping it into the design we select ‘Controls in Layout Table’
• Next select the end of your document and press Insert/repeating Table.
• Select the ProjJournalTrans record and press next.
  Select the fields that are needed for the InfoPath dialog and press Finish

Our InfoPath design will looks like:

  Programming in InfoPath


We have the general design for our InfoPath dialog available, but we don’t have match intelligence. It would be better if we dynamical generate:

• MessageID
• Source Endpoint User
• Source Endpoint
  Destination Endpoint

We can do this by using the Visual Studio Tools for Applications. Select Tools/Programming/Load event. InfoPath wants that you save first your InfoPath Form so we do that (call it ProjHoursFile). Next a C# project is generated.
Go to the FormEvents_Loading method and add these lines of code:
public void FormEvents_Loading(object sender, LoadingEventArgs e)
        {
            string guidID = System.Guid.NewGuid().ToString();
            XPathNavigator root = this.MainDataSource.CreateNavigator();
 
            root.SelectSingleNode("/ns1:Envelope/ns1:Header/ns1:MessageId", this.NamespaceManager).SetValue(guidID);
            root.SelectSingleNode("/ns1:Envelope/ns1:Header/ns1:SourceEndpointUser", this.NamespaceManager).SetValue(System.Environment.ExpandEnvironmentVariables("%userdomain%\%username%"));
            root.SelectSingleNode("/ns1:Envelope/ns1:Header/ns1:SourceEndpoint", this.NamespaceManager).SetValue("ProjHours");
            root.SelectSingleNode("/ns1:Envelope/ns1:Header/ns1:DestinationEndpoint", this.NamespaceManager).SetValue("DMO");
            root.SelectSingleNode("/ns1:Envelope/ns1:Header/ns1:Action", this.NamespaceManager).SetValue("createListProjHours");
        }

 
Next Build (compile) your solution in Visual Studio. Close Visual Studio and do your first test in InfoPath by pressing the Preview button. And ……….. we get an error!

This error tells us that we are not allowed to check for the user and domain name. Think about secure x++ code you have to ask permission for it. So let’s ask for permission. Close the preview and go back to visual studio and add next line in the FormEvent_loading method
new EnvironmentPermission(PermissionState.Unrestricted).Assert();

 
Also add the library for this Class at top of your c# project
using System.Security.Permissions;

 
Now the code is ready for secure coding but our InfoPath Form is not trusted jet. To get our InfoPath trusted, do the next steps:

• Select Tools/Form Options
• Select Security and Trust
• Deactivate automatically determine security level
• Select full trust
  Select sign this Form and create a certificate (this is not mandatory as long you don’t publish this Form)

Submit to the file inbound adapter of AX

• Drag a button Control to the design of InfoPath.
• Double click on this button.
• Set the action to Submit.
• Press Submit Options button.
  Configure the Submit options (select Perform custom action using code)

• Press Edit Code button

 
public void FormEvents_Submit(object sender, SubmitEventArgs e)
    {
         try
        {
            string filepath = "\\Dynamicsvm\Inbound\";
            string file = System.Guid.NewGuid().ToString() + ".xml";
 
            XmlDocument soapXML = new XmlDocument();
            soapXML.Load(this.MainDataSource.CreateNavigator().ReadSubtree());
            XPathNavigator soapXMLnav = soapXML.CreateNavigator();
 
            new FileIOPermission(FileIOPermissionAccess.Write, filepath + file).Assert();
            soapXML.Save(filepath + file);
            e.CancelableArgs.Cancel = false;
        }
        catch (Exception)
        {
            MessageBox.Show("aif message is not stored");
        }
   }

 
Preview your InfoPath form again and test the web service with next data
EmplID
RAV
ProjID
40010
CategoryID
Install
Qty
8
LinePropertyID
Charge

 
Testing, debugging & fixing
If you submit your data and you get an error. The information of this error is a little bit incomplete. Detailed information about the error is available in AX. Look at the Form at Menu/Basic/Periodic/AIF/Exceptions.

Good luck
 
article in PDF format + code  download

What’s Next


Next week we will create lookups and make offline working possible.
 

Источник: http://axstart.spaces.live.com/Blog/...C0A0!322.entry