TRACKING in Visual Basic .NET

Generation Data Matrix 2d barcode in Visual Basic .NET TRACKING

Figure 13-5. The Friendly view from the Details tab Notice in the Data section that it includes the Name and Phone elements just like the ListBoxTrackingParticipant did.

The last participant that you ll implement will write the events to a database. The tracking participant will receive the track events based on the queries defined in the TrackingProfile. The tracking participant is responsible for performing the database updates, which gives you complete control of how this is stored.

The first step is to create the tables in the database. To store the four types of tracking events, you will use the following tables: TrackInstance TrackBookmark TrackActivity TrackCustom

Open the LeadData.dbml file, which should display the O/R Designer. In the Server Explorer, expand the 13 data connection to get the list of tables in the database. (If the tracking tables are not listed, right-click the data connection and choose Refresh.) Drag these four tables to the O/R Designer. The diagram should look like the one shown in Figure 13-6.

Note You might get a warning telling you that the data connection you re using is different from the one initially used by the O/R Designer because you initially created the LeadData.dbml file in 11 and used the 11 data connection. The warning asks if you want to update the connection used by the designer. You should choose Yes.

In the Solution Explorer, right-click the Extensions folder and choose Add Class. For the class name, enter SqlTrackingParticipant.cs. The implementation for this class is shown in Listing 13-4. Listing 13-4. Implementation of the SqlTrackingParticipant Class using using using using using System; System.Activities.Tracking; System.Collections.Generic; System.Text; System.Data.Linq;

namespace LeadGenerator { public class SqlTrackingParticipant : TrackingParticipant { private string _connectionString { get; set; } private const String participantName = "SqlTrackingParticipant"; public SqlTrackingParticipant(string connectionString) { _connectionString = connectionString; } protected override void Track(TrackingRecord record, TimeSpan timeout) { WorkflowInstanceRecord instanceTrackingRecord = record as WorkflowInstanceRecord; if (instanceTrackingRecord != null) { TrackInstance t = new TrackInstance(); t.WorkflowID = instanceTrackingRecord.InstanceId; t.Status = instanceTrackingRecord.State; t.EventDate = DateTime.UtcNow; // Insert a record into the TrackInstance table LeadDataDataContext dc = new LeadDataDataContext(_connectionString); dc.TrackInstances.InsertOnSubmit(t); dc.SubmitChanges(); } BookmarkResumptionRecord bookTrackingRecord = record as BookmarkResumptionRecord; if (bookTrackingRecord != null) { TrackBookmark t = new TrackBookmark();

t.WorkflowID = bookTrackingRecord.InstanceId; t.BookmarkName = bookTrackingRecord.BookmarkName; t.EventDate = DateTime.UtcNow; // Insert a record into the TrackBookmark table LeadDataDataContext dc = new LeadDataDataContext(_connectionString); dc.TrackBookmarks.InsertOnSubmit(t); dc.SubmitChanges(); } ActivityStateRecord activityStateRecord = record as ActivityStateRecord; if (activityStateRecord != null) { TrackActivity t = new TrackActivity(); t.ActivityName = activityStateRecord.Activity.Name; t.WorkflowID = activityStateRecord.InstanceId; t.Status = activityStateRecord.State; t.EventDate = DateTime.UtcNow; // Concatenate all the variables into a string IDictionary<String, object> variables = activityStateRecord.Variables; StringBuilder s = new StringBuilder(); if (variables.Count > 0) { foreach (KeyValuePair<string, object> v in variables) { s.AppendLine(String.Format("{0}: Value = [{1}]", v.Key, v.Value)); } } // Store the variables string t.Variables = s.ToString(); // Insert a record into the TrackActivity table LeadDataDataContext dc = new LeadDataDataContext(_connectionString); dc.TrackActivities.InsertOnSubmit(t); dc.SubmitChanges(); } CustomTrackingRecord customTrackingRecord = record as CustomTrackingRecord; if (customTrackingRecord != null) {

TrackCustom t = new TrackCustom(); t.WorkflowID = customTrackingRecord.InstanceId; t.CustomEventName = customTrackingRecord.Name; t.EventDate = DateTime.UtcNow; // Concatenate all the user data into a string string s = ""; if ((customTrackingRecord != null) && (customTrackingRecord.Data.Count > 0)) { foreach (string data in customTrackingRecord.Data.Keys) { if (s.Length > 1) s += "\r\n"; s += String.Format("{0}: Value = [{1}]", data, customTrackingRecord.Data[data]); } } t.UserData = s; // Insert a record into the TrackUser table LeadDataDataContext dc = new LeadDataDataContext(_connectionString); dc.TrackCustoms.InsertOnSubmit(t); dc.SubmitChanges(); } } } } As with the ListBoxTrackingParticipant, this class overrides the Track() method. A generic TrackingRecord is passed in to this method. It is then cast to the each of the four record types: WorkflowInstanceRecord, BookmarkResumptionRecord, ActivityStateRecord, and CustomTrackingRecord. If the cast succeeds, the subsequent code creates the corresponding LINQ class (TrackInstance, TrackBookmark, TrackActivity, or TrackCustom, respectively) that is then inserted into the database.