Expense Manager Web Application

The Expense Manager Web Application consists of three Web service pages and one ASP.NET page. It is responsible for:

• Generating the Expense Report form from the Finance database.
  
  
• Signing the routing information within the form.
  
  
• Streaming the form down to the user.
  
  
• Receiving the form on submit.
  
  
• Verifying the digital signatures.
  
  
• Submitting the form's XML payload to the BizTalk 2004 orchestration.
  
  
• Receiving the form's XML payload back from the orchestration.
  
  
• Inserting the data from the form back into the SQL Server Finance database.

The different parts of the Expense Manager Web Application are:

• Query.ASMX

  The Query.ASMX Web service is responsible for generating the list of expense reports for the user context.

• ExpenseForm.ASMX

  The ExpenseForm.ASMX Web service is responsible for generating the InfoPath form and receiving the form back from the user on submit.

• ExpenseReport.ASPX

  The ExpenseReport.ASPX page is linked to by the custom Web Part and in turn, calls the ExpenseForm.ASMX Web service to generate the requested Expense Report form.

• Submit.ASMX

  The Submit.ASMX Web service is called by the BizTalk orchestration after it has updated the form's XML payload, assigning the form to the next person in the review chain or setting the form's status to approved. The Submit.ASMX Web service page submits the form to the SQLXML Adapter class which shreds the relevant form information into the Finance database expense tables.