Keyvan Nayyeri

private void codeActivity1_ExecuteCode(object sender, EventArgs e)

{

    Console.WriteLine("Hello Gholi!");

}

void btnOk_Click(object sender, RoutedEventArgs args)

{

    SqlTrackingService trackingService = new SqlTrackingService

        ("Data Source=KEYVANNAYYERI;Initial Catalog=SqlTrackingServiceSample;Integrated Security=True");

    WorkflowRuntime workflowRuntime = new WorkflowRuntime();

    workflowRuntime.AddService(trackingService);

    workflowRuntime.StartRuntime();

    WorkflowInstance instance =

        workflowRuntime.CreateWorkflow(typeof(MyWorkflow.Workflow1));

    instance.Load();

    instance.Start();

    instance.Terminate("Terminate Workflow for Example!");

    workflowRuntime.StopRuntime();

    MessageBox.Show("Finished!", "SqlTrackingService Sample");

}

CREATE PROCEDURE dbo.SelectWorkflows

AS

SELECT     Type.TypeFullName, WorkflowInstance.WorkflowInstanceId, WorkflowInstance.WorkflowInstanceInternalId

FROM         Type INNER JOIN

                      WorkflowInstance ON Type.TypeId = WorkflowInstance.WorkflowTypeId

CREATE PROCEDURE dbo.SelectWorkflowInstanceWithTracking

@InstanceID int

AS

    SELECT     TrackingWorkflowEvent.Description, WorkflowInstanceEvent.EventDateTime

    FROM         WorkflowInstanceEvent INNER JOIN

                          TrackingWorkflowEvent ON WorkflowInstanceEvent.TrackingWorkflowEventId = TrackingWorkflowEvent.TrackingWorkflowEventId AND

                          WorkflowInstanceEvent.TrackingWorkflowEventId = TrackingWorkflowEvent.TrackingWorkflowEventId

    WHERE     (WorkflowInstanceEvent.WorkflowInstanceInternalId = @InstanceID)

private void Form1_Load(object sender, EventArgs e)

{

    SqlConnection connection =

        new SqlConnection(this.connectionString);

    SqlCommand selectWorkflows =

        new SqlCommand("SelectWorkflows", connection);

    selectWorkflows.CommandType =

        CommandType.StoredProcedure;

    DataSet ds = new DataSet();

    SqlDataAdapter adapter = new SqlDataAdapter();

    adapter.SelectCommand = selectWorkflows;

    adapter.Fill(ds);

    dataGridView1.DataSource = ds.Tables[0].DefaultView;

    dataGridView1.Refresh();

    dataGridView1.SelectionChanged +=

        new EventHandler(dataGridView1_SelectionChanged);

}

void dataGridView1_SelectionChanged(object sender, EventArgs e)

{

    SqlConnection connection =

        new SqlConnection(this.connectionString);

    SqlCommand selectWorkflows =

        new SqlCommand("SelectWorkflowInstanceWithTracking", connection);

    selectWorkflows.CommandType =

        CommandType.StoredProcedure;

    selectWorkflows.Parameters.AddWithValue

        ("InstanceID", dataGridView1.SelectedRows[0].Cells[2].Value);

    DataSet ds = new DataSet();

    SqlDataAdapter adapter = new SqlDataAdapter();

    adapter.SelectCommand = selectWorkflows;

    adapter.Fill(ds);

    dataGridView2.DataSource = ds.Tables[0].DefaultView;

    dataGridView2.Refresh();

}