sdk/samples/CrossTechnologySamples/ClassRegistration/workflowlibrary/registrationworkflow.cs

   1 using System;
   2 using System.Data;
   3 using System.Data.SqlClient;
   4 using System.Drawing;
   5 using System.Workflow.Runtime;
   6 using System.Workflow.Activities;
   7 using System.Workflow.Activities.Rules;
   8
   9 namespace Microsoft.Samples.ClassRegistration
  10 {
  11     public sealed partial class RegistrationWorkflow : SequentialWorkflowActivity
  12     {
  13         public RegistrationWorkflow()
  14         {
  15             InitializeComponent();
  16         }
  17
  18         private bool IsClassFull = true;
  19         private bool IsRegistered = false;
  20
  21         // Application settings
  22         static Properties.Settings _settings = Properties.Settings.Default;
  23
  24         // Workflow properties
  25         private String userIdValue;
  26         public String UserId
  27         {
  28             get { return this.userIdValue; }
  29             set { this.userIdValue = value; }
  30         }
  31
  32         private String sessionIdValue;
  33         public String SessionId
  34         {
  35             get { return this.sessionIdValue; }
  36             set { this.sessionIdValue = value; }
  37         }
  38
  39         private String registrationStatus;
  40         public String RegistrationStatus
  41         {
  42             get { return this.registrationStatus; }
  43         }
  44
  45         private void validateRegistration_ExecuteCode(object sender, EventArgs e)
  46         {
  47             Console.WriteLine("Validating registration.");
  48
  49             int studentCount = 0;
  50             int seatCount = 0;
  51
  52             SqlConnection connection = new SqlConnection(_settings.ClassRegistrationConnectionString);
  53             connection.Open();
  54
  55             // Get number of students registered for current session
  56             SqlCommand command = new SqlCommand("SELECT Count(*) FROM Registration where SessionId=@SessionId", connection);
  57             command.Parameters.AddWithValue("@SessionId", this.sessionIdValue);
  58             studentCount = (int)command.ExecuteScalar();
  59
  60             // Get seat count for current session
  61             command = new SqlCommand("SELECT SeatCount FROM ClassSession WHERE Id=@SessionId", connection);
  62             command.Parameters.AddWithValue("@SessionId", this.sessionIdValue);
  63             seatCount = (int)command.ExecuteScalar();
  64
  65             // Check if class is full
  66             this.IsClassFull = studentCount >= seatCount;
  67
  68             // Check for duplicate registration
  69             command = new SqlCommand("SELECT Count(*) FROM Registration WHERE SessionId=@SessionId AND StudentID=@StudentID", connection);
  70             command.Parameters.AddWithValue("@SessionId", this.sessionIdValue);
  71             command.Parameters.AddWithValue("@StudentId", this.userIdValue);
  72             IsRegistered = (int)command.ExecuteScalar() > 0;
  73
  74             // Close SQL Connection
  75             connection.Close();
  76         }
  77
  78         private void notifyStudentAlreadyRegistered_ExecuteCode(object sender, EventArgs e)
  79         {
  80             Console.WriteLine("Notify student that they've already registered for this session.");
  81         }
  82
  83         private void notifyStudentClassFull_ExecuteCode(object sender, EventArgs e)
  84         {
  85             Console.WriteLine("Nofify student that the requested session is already full.");
  86         }
  87
  88         private void updateRegistrationStatusWaitlisted_ExecuteCode(object sender, EventArgs e)
  89         {
  90             this.registrationStatus = "Waitlisted";
  91         }
  92
  93         private void updateRegistrationStatusApproved_ExecuteCode(object sender, EventArgs e)
  94         {
  95             this.registrationStatus = "Approved";
  96         }
  97
  98         private void updateRegistrationStatusRejected_ExecuteCode(object sender, EventArgs e)
  99         {
 100             this.registrationStatus = "Rejected";
 101         }
 102
 103         private void updateRegistrationStatusWaitingForApproval_ExecuteCode(object sender, EventArgs e)
 104         {
 105             this.registrationStatus = "Waiting for Approval";
 106         }
 107
 108         private void addRegistrationToDatabase_ExecuteCode(object sender, EventArgs e)
 109         {
 110             Console.WriteLine("Adding registration to database.");
 111
 112             // Create SQL Connection
 113             SqlConnection connection = new SqlConnection(_settings.ClassRegistrationConnectionString);
 114             connection.Open();
 115
 116             // Execute SQL Command
 117             string commandText = "INSERT INTO Registration (StudentId, SessionID, Status) " +
 118                                  "VALUES (@StudentId, @SessionID, @Status)";
 119
 120             SqlCommand command = new SqlCommand(commandText, connection);
 121             command.Parameters.AddWithValue("@StudentId", this.userIdValue);
 122             command.Parameters.AddWithValue("@SessionId", this.sessionIdValue);
 123             command.Parameters.AddWithValue("@Status", this.registrationStatus);
 124             command.ExecuteNonQuery();
 125         }
 126
 127         private void notifyStudentOfSessionStatus_ExecuteCode(object sender, EventArgs e)
 128         {
 129             Console.WriteLine("Notify student of session status.");
 130         }
 131     }
 132 }