Code Review
Code Review
In this section we will look at the custom code and components within the Expense Report solution. Several code walkthroughs are presented to describe the key features of the solution. Keep in mind that these code walkthroughs are not meant to offer an exhaustive, start-to-finish explanation of every piece of the solution. Rather, they are meant to show those elements that will be most interesting and valuable to developers and provide insights into concepts that developers will need to modify the solutions for their own requirements.
Topics in this section include:
InfoPath Expense Report Form describes the custom code and special techniques used in the Expense Report form.
Integration with BizTalk Server 2004 describes the BizTalk orchestration that uses business rules to route the submitted Expense Report form to the next person in the business process and submit the form's underlying XML content to a database.
Finance Database identifies the portions of the Finance database that are used by the Expense Report solution.
SQLXML Adapter FPC describes the primary class that is used to move expense data to and from the Finance database.
Expense Manager Web Application describes the custom application that is used to generate an expense report, move form data from InfoPath 2003 to BizTalk Server 2004, move form data from BizTalk to the Finance database, and query the Finance database to return a list of expense reports for the current user.
Web Part for SharePoint Products and Technologies describes the custom Web Part where new and existing expense forms are launched and the status of submitted forms can be tracked.
Integration with Excel 2003 describes the custom code used to create a Microsoft® PivotTable® dynamic view in Excel 2003 showing approved expenses from reports in which a given user was assigned.