The Loans Processing Using Business Rules sample demonstrates how to use a set of rules managed within an orchestration, and how to use a combination of inputs known as facts, to calculate settings for some fields within a document being processed. Facts can be the result of calling a .NET-based assembly, the values retrieved from the XML of the message, or the data retrieved from a database. The sample also demonstrates how you can change the rules at any time, affecting subsequent calculations without the need to redeploy.

This sample demonstrates these capabilities within the context of a simplified loan processing scenario. BizTalk Server orchestration picks up and processes a loan application, also known as a loan case, in XML message format. This orchestration uses the Business Rule Engine to evaluate incoming messages according to the rules, modifying the message with the result of the application of the rules, and then writing the message as a file to an output folder.

Based on facts from several sources, including the message being processed, this sample sets the IncomeStatus, CommitmentsStatus, EmploymentStatus, and ResidencyStatus elements of the message being processed.

Note  For important information about all samples in this SDK, see Samples.

To download the updated BizTalk Server 2004 SDK, go to http://go.microsoft.com/fwlink/?LinkId=24723.

Location in SDK

<Samples Path>\Business Rules\Loans Processing using Business Rules\

File Inventory

The following table shows the files in this sample and describes their purpose.

To Build and Initialize This Sample

Use the following procedure to build and initialize the Loans Processing Using Business Rules sample.

1. In a command window, navigate to the following folder:

   <Samples Path>\Business Rules\Loans Processing using Business Rules

2. Run the file Setup.bat, which performs the following actions:
   • Cleans up the GAC to eliminate any residual data from previous runs of this sample.
   • Compiles and deploys the fact retriever program, myFactRetreiever.dll.
   • Using the SQL script file Create_CustInfo_Table.sql, adds a table named CustInfo to the Northwind sample SQL database.
   • Cleans up the shared SQL rule store to eliminate residue of previous runs of this sample.
   • Creates, publishes, and deploys the most recent version (1.0) of the loans processing rule set.

     Note  You can use the Business Rule Composer tool supplied with BizTalk Server to examine the rules that have been set programmatically.

   • Creates the input (In) and output (Out) folders for this sample.
   • Compiles and deploys the remaining Visual Studio .NET projects for this sample, including the BizTalk project that contains the orchestration you use to coordinate this sample.
   • Creates and binds the BizTalk Server receive location, and the send and receive ports.

     Note  This sample displays the following warnings when creating and binding ports:

     Warning: Receive handler not specified for receive location "LoansProcessor_1.0.0.0_LoansProcessor.My_Sample_Service_Incoming_ReceiveLocation"; updating with first receive handler with matching transport type.

     Warning: Host not specified for orchestration "LoansProcessor.My_Sample_Service"; updating with first available host.

     You can safely ignore these warnings. (To accommodate for possible naming differences in user installations, the host name and receive handler have been omitted from the binding file. The Btsdeploy.exe utility uses the first receive handler that supports the adapter type and the default host.)

   • Enables the receive location, and starts the send port.
   • Enlists and starts the orchestration.

Note  If your BizTalk host name is not BizTalkServerApplication, modify the file Setup.bat and the file LoanProcessorBinding.xml to reflect the proper host name.

Note  You should confirm that BizTalk Server did not report any errors during the build and initialization process before attempting to run this sample.

Note  If you choose to open and build the projects in this sample without running the file Setup.bat, you must first create a strong name key pair using the .NET Framework Strong Name utility (sn.exe). Use this key pair to sign the resulting assemblies.

Note  To undo changes made by Setup.bat, run Cleanup.bat. You must run Cleanup.bat before running Setup.bat a second time.

To Run This Sample

Use the following procedure to run the Loans Processing Using Business Rules sample.

1. Paste a copy of the file sampleLoan.xml into the \In folder.
2. Observe the .xml file created in the folder Out. It contains the input XML message with data added to the following four status elements at the end of the XML structure: IncomeStatus, CommitmentsStatus, EmploymentStatus, and ResidencyStatus.

You can use the Business Rule Composer tool to change the rules in the rule set, and then redeploy those rules.

To use the Business Rule Composer tool to change one or more of the rules in a rule set

1. Click Start, point to Programs, point to Microsoft BizTalk Server 2004, and then click Business Rule Composer.
2. In the SQL Server dialog box, click OK to connect to the rule store.
3. In Policy Explorer, below the node LoanProcessing, right-click the Version 1.0 - Deployed node, and then click Copy.
4. Right-click LoanProcessing, and then click Paste.
5. Change any rule or action in a way that will result in different values for the IncomeStatus, CommitmentsStatus, EmploymentStatus, and ResidencyStatus elements. Ensure that you also change the value of the negation portion (essentially, the Else clause) of any rule that you choose to change.

   The following table shows the set of rules used by this sample. Unless specifically mentioned otherwise, facts are from the incoming XML message. The string (db) indicates a database as the source of a fact.

   Rule number and name	Description
   1. Income Status Rule	IF BasicSalary + OtherIncome > 0 THEN IncomeStatus = Valid
   2. Commitments Status Rule	IF ID == ID (db)     AND IF CreditCardBalance (db) > 500 THEN CommitmentsStatus =         "Compute Commitments"
   3. Employment Status Rule	IF EmploymentType | TimeInMonths > 18 THEN EmploymentStatus = Valid
   4. Residency Status Rule	IF PlaceOfResidence | TimeInMonths > 18 THEN ResidencyStatus = Valid
   !1, !2, !3, !4. Negation Rules	Conditions that are a logical NOT of the corresponding condition described in rules 1-4. Resulting actions are a change in the string that is being set.

6. Right-click the Version 1.1(not saved) node, and then click Save.
7. Right-click the Version 1.1 node, and then click Publish.
8. Right-click the Version 1.1 node, and then click Deploy.
9. Wait for 60 seconds for the changes to propagate to the shared SQL Server rule store.
10. Paste a copy of the file sampleLoan.xml into the folder In.
11. Observe the .xml file created in the folder Out. It contains the input XML message with data added to the following four status elements at the end of the XML structure: IncomeStatus, CommitmentsStatus, EmploymentStatus, and ResidencyStatus. The data added to these elements will differ, or not, from the previous run, based on the nature of the changes made in step 5in this procedure.

Remarks

If you want to view the tracking information for this sample within Health Activity Tracking (HAT), you must undeploy and then redeploy the relevant rule set (Loans Processing) by using the Rule Engine Deployment Wizard.

This sample demonstrates how you can use business rules to apply business policies in the form of rules within an orchestration. It also demonstrates how you can change the policies, and have the change in the policy reflected dynamically within the orchestration without having to recompile or redeploy the orchestration solution.

Input loan cases to this sample are XML messages that have the following structure:

    Name
    ID
    Income
        BasicSalary
        OtherIncome
    EmploymentType
        TimeInMonths
    PlaceOfResidence
        TimeInMonths
    CommitmentsStatus
    IncomeStatus
    EmploymentStatus
    ResidencyStatus

See Also

Business Rules (BizTalk Server Samples Folder)