Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/CGDocumentManager.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/CGDocumentManager.cs	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/CGDocumentManager.cs	(revision 772)
@@ -11,4 +11,5 @@
 using IndianHealthService.BMXNet;
 using System.Configuration;
+using Mono.Options;
 
 namespace IndianHealthService.ClinicalScheduling
@@ -28,4 +29,8 @@
 		private bool						m_bExitOK = true;
         public string                       m_sHandle = "0";
+        private string                      m_AccessCode="";
+        private string                      m_VerifyCode="";
+        private string                      m_Server="";
+        private int                         m_Port=0;
 
 		//M Connection member variables
@@ -251,7 +256,14 @@
 						else
 						{
-							//Use autologin
-							_current.m_ConnectInfo.LoadConnectInfo();
-						}
+                            if (m_Server != String.Empty && m_Port != 0 && m_AccessCode != String.Empty
+                                && m_VerifyCode != String.Empty)
+                                m_ConnectInfo.LoadConnectInfo(m_Server, m_Port, m_AccessCode, m_VerifyCode);
+
+                            else if (m_Server != String.Empty && m_Port != 0)
+                                m_ConnectInfo.LoadConnectInfo(m_Server, m_Port);
+
+                            else
+							    m_ConnectInfo.LoadConnectInfo();
+                        }
 						bRetry = false;
 					}
@@ -292,5 +304,5 @@
 
 				//Set application context
-				m_ds.SetStatus("Setting Application Context...");
+				m_ds.SetStatus("Setting Application Context to BSDXRPC...");
                 m_ds.Refresh();
 				m_ConnectInfo.AppContext = "BSDXRPC";
@@ -335,11 +347,20 @@
 		}
 
-		[STAThread()] static void Main()
+		[STAThread()] static void Main(string[] args)
 		{
             try
-            {
-                //Store the current manager
+            {   
+                 //Store the current manager
                 _current = new CGDocumentManager();
-
+                
+                var opset = new OptionSet () {
+                    { "s=", s => _current.m_Server = s },
+                    { "p=", p => _current.m_Port = int.Parse(p) },
+                    { "a=", a => _current.m_AccessCode = a },
+                    { "v=", v => _current.m_VerifyCode = v }
+                };
+
+                opset.Parse(args);
+                
                 try
                 {
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/CGView.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/CGView.cs	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/CGView.cs	(revision 772)
@@ -376,4 +376,5 @@
             // 
             this.mnuPrintClinicSchedules.Index = 9;
+            this.mnuPrintClinicSchedules.Shortcut = System.Windows.Forms.Shortcut.CtrlP;
             this.mnuPrintClinicSchedules.Text = "&Print Clinic Schedules";
             this.mnuPrintClinicSchedules.Click += new System.EventHandler(this.mnuPrintClinicSchedules_Click);
@@ -2371,48 +2372,4 @@
         }
 
-        private void PrintPatientLetter()
-        {
-            //Prompt for patient and
-            //Print letter for individual patient
-            try
-            {
-                //Display a dialog to collect Patient Name
-                DPatientLookup dPat = new DPatientLookup();
-                dPat.DocManager = m_DocManager;
-                if (dPat.ShowDialog(this) == DialogResult.Cancel)
-                {
-                    return;
-                }
-
-                Debug.Assert(dPat.PatientIEN != "");
-                int nPatientID = Convert.ToInt32(dPat.PatientIEN);
-                PrintPatientLetter(nPatientID);
-
-            }
-            catch (Exception ex)
-            {
-                MessageBox.Show(this, ex.Message, "Clinical Scheduling", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
-            }
-        }
-
-        private void PrintPatientLetter(int PatientID)
-        {
-            //Print letter for individual patient
-            try
-            {
-                DPatientLetter dPa = new DPatientLetter();
-                dPa.InitializeForm(DocManager, PatientID);
-
-                if (dPa.ShowDialog(this) != DialogResult.Cancel)
-                {
-                    return;
-                }
-            }
-            catch (Exception ex)
-            {
-                throw ex;
-            }
-        }
-
         #endregion Methods
 
@@ -3020,5 +2977,5 @@
 		private void mnuPrintPatientLetter_Click(object sender, System.EventArgs e)
 		{
-			PrintPatientLetter();
+			ViewPatientAppointments();
 		}
 
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/ClinicalScheduling.csproj
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/ClinicalScheduling.csproj	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/ClinicalScheduling.csproj	(revision 772)
@@ -110,22 +110,4 @@
       <HintPath>bin\Release\BMXNet20.dll</HintPath>
     </Reference>
-    <Reference Include="CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, processorArchitecture=MSIL">
-      <Private>False</Private>
-    </Reference>
-    <Reference Include="CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304">
-      <Private>False</Private>
-    </Reference>
-    <Reference Include="CrystalDecisions.Enterprise.InfoStore, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304">
-      <Private>False</Private>
-    </Reference>
-    <Reference Include="CrystalDecisions.ReportSource, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, processorArchitecture=MSIL">
-      <Private>False</Private>
-    </Reference>
-    <Reference Include="CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, processorArchitecture=MSIL">
-      <Private>False</Private>
-    </Reference>
-    <Reference Include="CrystalDecisions.Windows.Forms, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, processorArchitecture=MSIL">
-      <Private>False</Private>
-    </Reference>
     <Reference Include="System">
       <Name>System</Name>
@@ -229,28 +211,4 @@
       <SubType>Form</SubType>
     </Compile>
-    <Compile Include="crAppointmentList.cs">
-      <DependentUpon>crAppointmentList.rpt</DependentUpon>
-      <SubType>Component</SubType>
-      <DesignTime>True</DesignTime>
-      <AutoGen>True</AutoGen>
-    </Compile>
-    <Compile Include="crCancelLetter.cs">
-      <DependentUpon>crCancelLetter.rpt</DependentUpon>
-      <SubType>Component</SubType>
-      <DesignTime>True</DesignTime>
-      <AutoGen>True</AutoGen>
-    </Compile>
-    <Compile Include="crPatientLetter.cs">
-      <DependentUpon>crPatientLetter.rpt</DependentUpon>
-      <SubType>Component</SubType>
-      <DesignTime>True</DesignTime>
-      <AutoGen>True</AutoGen>
-    </Compile>
-    <Compile Include="crRebookLetter.cs">
-      <DependentUpon>crRebookLetter.rpt</DependentUpon>
-      <SubType>Component</SubType>
-      <DesignTime>True</DesignTime>
-      <AutoGen>True</AutoGen>
-    </Compile>
     <Compile Include="DAccessBlock.cs">
       <SubType>Form</SubType>
@@ -327,4 +285,8 @@
       <SubType>Form</SubType>
     </Compile>
+    <Compile Include="dsRebookAppts.cs">
+      <DependentUpon>dsRebookAppts.xsd</DependentUpon>
+      <SubType>Component</SubType>
+    </Compile>
     <Compile Include="dsRebookAppts.Designer.cs">
       <AutoGen>True</AutoGen>
@@ -332,4 +294,6 @@
       <DependentUpon>dsRebookAppts.xsd</DependentUpon>
     </Compile>
+    <Compile Include="Options.cs" />
+    <Compile Include="Printing.cs" />
     <Compile Include="UCPatientAppts.cs">
       <SubType>UserControl</SubType>
@@ -349,20 +313,4 @@
       <DependentUpon>CGView.cs</DependentUpon>
       <SubType>Designer</SubType>
-    </EmbeddedResource>
-    <EmbeddedResource Include="crAppointmentList.rpt">
-      <Generator>CrystalDecisions.VSDesigner.CodeGen.ReportCodeGenerator</Generator>
-      <LastGenOutput>crAppointmentList.cs</LastGenOutput>
-    </EmbeddedResource>
-    <EmbeddedResource Include="crCancelLetter.rpt">
-      <Generator>CrystalDecisions.VSDesigner.CodeGen.ReportCodeGenerator</Generator>
-      <LastGenOutput>crCancelLetter.cs</LastGenOutput>
-    </EmbeddedResource>
-    <EmbeddedResource Include="crPatientLetter.rpt">
-      <Generator>CrystalDecisions.VSDesigner.CodeGen.ReportCodeGenerator</Generator>
-      <LastGenOutput>crPatientLetter.cs</LastGenOutput>
-    </EmbeddedResource>
-    <EmbeddedResource Include="crRebookLetter.rpt">
-      <Generator>CrystalDecisions.VSDesigner.CodeGen.ReportCodeGenerator</Generator>
-      <LastGenOutput>crRebookLetter.cs</LastGenOutput>
     </EmbeddedResource>
     <EmbeddedResource Include="DAccessGroup.resx">
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/ClinicalScheduling.csproj.user
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/ClinicalScheduling.csproj.user	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/ClinicalScheduling.csproj.user	(revision 772)
@@ -36,5 +36,6 @@
     </RemoteDebugMachine>
     <StartAction>Project</StartAction>
-    <StartArguments>http://homedev.ihs.gov/otherprgms/clinicalscheduling/ClinicalScheduling.exe</StartArguments>
+    <StartArguments>
+    </StartArguments>
     <StartPage>
     </StartPage>
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/DAppointPage.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/DAppointPage.cs	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/DAppointPage.cs	(revision 772)
@@ -53,5 +53,4 @@
 		private System.Windows.Forms.Label label14;
         private System.Windows.Forms.TextBox txtHRN;
-        private System.Windows.Forms.Button cmdPrintLetter;
         private GroupBox groupBox4;
         private BindingSource dsPatientApptDisplay2BindingSource;
@@ -75,4 +74,5 @@
             this.tabControl1 = new System.Windows.Forms.TabControl();
             this.tabAppointment = new System.Windows.Forms.TabPage();
+            this.groupBox4 = new System.Windows.Forms.GroupBox();
             this.groupBox3 = new System.Windows.Forms.GroupBox();
             this.lblClinic = new System.Windows.Forms.Label();
@@ -108,8 +108,6 @@
             this.txtStreet = new System.Windows.Forms.TextBox();
             this.panel1 = new System.Windows.Forms.Panel();
-            this.cmdPrintLetter = new System.Windows.Forms.Button();
             this.cmdCancel = new System.Windows.Forms.Button();
             this.cmdOK = new System.Windows.Forms.Button();
-            this.groupBox4 = new System.Windows.Forms.GroupBox();
             this.patientApptsBindingSource = new System.Windows.Forms.BindingSource(this.components);
             this.dsPatientApptDisplay2BindingSource = new System.Windows.Forms.BindingSource(this.components);
@@ -148,4 +146,13 @@
             this.tabAppointment.TabIndex = 1;
             this.tabAppointment.Text = "Appointment";
+            // 
+            // groupBox4
+            // 
+            this.groupBox4.Location = new System.Drawing.Point(8, 254);
+            this.groupBox4.Name = "groupBox4";
+            this.groupBox4.Size = new System.Drawing.Size(439, 204);
+            this.groupBox4.TabIndex = 14;
+            this.groupBox4.TabStop = false;
+            this.groupBox4.Text = "Other Appointments";
             // 
             // groupBox3
@@ -456,5 +463,4 @@
             // panel1
             // 
-            this.panel1.Controls.Add(this.cmdPrintLetter);
             this.panel1.Controls.Add(this.cmdCancel);
             this.panel1.Controls.Add(this.cmdOK);
@@ -465,14 +471,4 @@
             this.panel1.TabIndex = 1;
             // 
-            // cmdPrintLetter
-            // 
-            this.cmdPrintLetter.CausesValidation = false;
-            this.cmdPrintLetter.Location = new System.Drawing.Point(12, 9);
-            this.cmdPrintLetter.Name = "cmdPrintLetter";
-            this.cmdPrintLetter.Size = new System.Drawing.Size(68, 24);
-            this.cmdPrintLetter.TabIndex = 3;
-            this.cmdPrintLetter.Text = "Print Letter";
-            this.cmdPrintLetter.Click += new System.EventHandler(this.cmdPrintLetter_Click);
-            // 
             // cmdCancel
             // 
@@ -493,13 +489,4 @@
             this.cmdOK.Text = "OK";
             this.cmdOK.Click += new System.EventHandler(this.cmdOK_Click);
-            // 
-            // groupBox4
-            // 
-            this.groupBox4.Location = new System.Drawing.Point(8, 254);
-            this.groupBox4.Name = "groupBox4";
-            this.groupBox4.Size = new System.Drawing.Size(439, 204);
-            this.groupBox4.TabIndex = 14;
-            this.groupBox4.TabStop = false;
-            this.groupBox4.Text = "Other Appointments";
             // 
             // patientApptsBindingSource
@@ -530,5 +517,4 @@
             this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
             this.Text = "Patient Appointment";
-            this.Load += new System.EventHandler(this.DAppointPage_Load);
             this.tabControl1.ResumeLayout(false);
             this.tabAppointment.ResumeLayout(false);
@@ -674,68 +660,4 @@
 		}
 
-		private void cmdViewAppointments_Click(object sender, System.EventArgs e)
-		{
-			try
-			{
-				Debug.Assert(m_sPatientIEN != "");
-				int nPatientID = Convert.ToInt32(m_sPatientIEN);
-				ViewPatientAppointments(nPatientID);
-			}
-			catch (Exception ex)
-			{
-				MessageBox.Show(this, ex.Message, "Clinical Scheduling", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
-			}
-		}
-
-		public void ViewPatientAppointments(int PatientID)
-		{
-			DPatientApptDisplay dPa = new DPatientApptDisplay();
-
-			dPa.InitializeForm(this.DocManager, PatientID);
-
-			if (dPa.ShowDialog(this) != DialogResult.Cancel)
-			{
-				return;
-			}
-		}
-
-
-		private void cmdPrintLetter_Click(object sender, System.EventArgs e)
-		{
-			try
-			{
-				Debug.Assert(m_sPatientIEN != "");
-				int nPatientID = Convert.ToInt32(m_sPatientIEN);
-				PrintPatientLetter(nPatientID);
-			}
-			catch (Exception ex)
-			{
-				MessageBox.Show(this, ex.Message, "Clinical Scheduling", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
-			}		
-		}
-
-		private void PrintPatientLetter(int PatientID)
-		{
-			//Print letter for individual patient
-			try
-			{
-				DPatientLetter dPa = new DPatientLetter();
-				dPa.InitializeForm(DocManager, PatientID);
-
-				if (dPa.ShowDialog(this) != DialogResult.Cancel)
-				{
-					return;
-				}
-			}
-			catch (Exception ex)
-			{
-				throw ex;
-			}
-		}
-
-		private void DAppointPage_Load(object sender, System.EventArgs e)
-		{
-			cmdPrintLetter.Enabled = !(m_dStartTime < DateTime.Today);
-		}
 
 		#endregion //Methods
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/DAppointPage.resx
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/DAppointPage.resx	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/DAppointPage.resx	(revision 772)
@@ -124,10 +124,4 @@
     <value>179, 17</value>
   </metadata>
-  <metadata name="dsPatientApptDisplay2BindingSource.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
-    <value>179, 17</value>
-  </metadata>
-  <metadata name="dsPatientApptDisplay2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
-    <value>17, 17</value>
-  </metadata>
   <metadata name="dsPatientApptDisplay2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
     <value>17, 17</value>
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/DPatientLetter.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/DPatientLetter.cs	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/DPatientLetter.cs	(revision 772)
@@ -1,12 +1,7 @@
 using System;
-using System.Drawing;
-using System.Collections;
-using System.ComponentModel;
 using System.Windows.Forms;
 using System.Data;
-using CrystalDecisions.Windows;
-using CrystalDecisions.Shared;
-using CrystalDecisions.CrystalReports.Engine;
-using IndianHealthService.BMXNet;
+using System.Drawing.Printing;
+using System.Drawing;
 
 namespace IndianHealthService.ClinicalScheduling
@@ -15,61 +10,18 @@
 	/// Summary description for DPatientLetter.
 	/// </summary>
-	public class DPatientLetter : System.Windows.Forms.Form
-	{
-		private CrystalDecisions.Windows.Forms.CrystalReportViewer crViewer1;
+	public class DPatientLetter : System.Windows.Forms.PrintPreviewDialog
+    {
 		/// <summary>
 		/// Required designer variable.
 		/// </summary>
-		private System.ComponentModel.Container components = null;
+        private System.ComponentModel.Container components = null;
+        private System.Drawing.Printing.PrintDocument printDocument1;
 
 		#region Fields
-
-		private string	m_sBodyText;
+        DateTime _dtBegin, _dtEnd; //global fields to use in passing to printing method
+        int _currentResourcePrinting = 0;
+        int _currentApptPrinting = 0;
+        dsPatientApptDisplay2 _ds;
 		#endregion Fields
-
-		#region Properties
-
-		public string BodyText
-		{
-			get
-			{
-				return m_sBodyText;
-			}
-			set
-			{
-				m_sBodyText = value;
-			}
-		}
-
-		#endregion Properties
-
-		public void InitializeForm(CGDocumentManager docManager, int nPatientID)
-		{
-			try
-			{	
-				crViewer1.DisplayGroupTree = true;
-
-				ClinicalScheduling.crPatientLetter cr = new crPatientLetter();
-				string sSql = "BSDX PATIENT APPT DISPLAY^" + nPatientID.ToString();
-				System.Data.DataSet ds = new System.Data.DataSet();
-				DataTable dtAppt = docManager.RPMSDataTable(sSql, "PatientAppts");
-				ds.Tables.Add(dtAppt.Copy());
-
-				System.Data.DataTable dt = 
-					docManager.GlobalDataSet.Tables["Resources"].Copy();
-				ds.Tables.Add(dt);
-
-				cr.Database.Tables["PatientAppts"].SetDataSource(ds.Tables["PatientAppts"]);
-				cr.Database.Tables["BSDXResource"].SetDataSource(ds.Tables["Resources"]);
-
-				crViewer1.SelectionFormula = "{PatientAppts.ApptDate} >= CurrentDate";
-				this.crViewer1.ReportSource = cr;
-				
-			}
-			catch (Exception ex)
-			{
-				throw ex;
-			}
-		}
 
 		public void InitializeFormClinicSchedule(CGDocumentManager docManager,
@@ -84,17 +36,17 @@
 					throw new Exception("At least one clinic must be selected.");
 				}
+                _dtBegin = dtBegin;
+                _dtEnd = dtEnd;
 				string sBegin = dtBegin.ToShortDateString();
 				string sEnd = dtEnd.ToShortDateString();
-				crViewer1.DisplayGroupTree = true;
 				this.Text="Clinic Schedules";
 
-				ClinicalScheduling.crAppointmentList cr = new crAppointmentList();
 				string sSql = "BSDX CLINIC LETTERS^" + sClinicList + "^" + sBegin + "^" + sEnd;
-
-				DataTable dtAppt = docManager.RPMSDataTable(sSql, "PatientAppts");				
-				cr.Database.Tables["PatientAppts"].SetDataSource(dtAppt);
-
-				this.crViewer1.ReportSource = cr;
-			}
+                string sSql2 = "BSDX RESOURCE LETTERS^" + sClinicList;
+
+                _ds = new dsPatientApptDisplay2();
+                _ds.BSDXResource.Merge(docManager.RPMSDataTable(sSql2, "Resources"));
+                _ds.PatientAppts.Merge(docManager.RPMSDataTable(sSql, "PatientAppts"));
+            }
 			catch (Exception ex)
 			{
@@ -113,7 +65,28 @@
 					throw new Exception("At least one clinic must be selected.");
 				}
-				crViewer1.DisplayGroupTree = true;
-
-				ClinicalScheduling.crRebookLetter cr = new crRebookLetter();
+
+				System.Data.DataSet ds = new System.Data.DataSet();
+				ds.Tables.Add(dtLetters.Copy());
+				
+				string sSql = "BSDX RESOURCE LETTERS^" + sClinicList;
+				DataTable dt = docManager.RPMSDataTable(sSql, "Resources");				
+				ds.Tables.Add(dt.Copy());				
+			}
+			catch (Exception ex)
+			{
+				throw ex;
+			}
+		}
+
+		public void InitializeFormCancellationLetters(CGDocumentManager docManager,
+			string sClinicList,
+			DataTable dtLetters)
+		{
+			try
+			{	
+				if (sClinicList == "")
+				{
+					throw new Exception("At least one clinic must be selected.");
+				}
 
 				System.Data.DataSet ds = new System.Data.DataSet();
@@ -123,42 +96,4 @@
 				DataTable dt = docManager.RPMSDataTable(sSql, "Resources");				
 				ds.Tables.Add(dt.Copy());
-
-				cr.Database.Tables["PatientAppts"].SetDataSource(ds.Tables["PatientAppts"]);
-				cr.Database.Tables["BSDXResource"].SetDataSource(ds.Tables["Resources"]);
-
-				this.crViewer1.ReportSource = cr;
-				
-			}
-			catch (Exception ex)
-			{
-				throw ex;
-			}
-		}
-
-		public void InitializeFormCancellationLetters(CGDocumentManager docManager,
-			string sClinicList,
-			DataTable dtLetters)
-		{
-			try
-			{	
-				if (sClinicList == "")
-				{
-					throw new Exception("At least one clinic must be selected.");
-				}
-				crViewer1.DisplayGroupTree = true;
-
-				ClinicalScheduling.crCancelLetter cr = new crCancelLetter();
-
-				System.Data.DataSet ds = new System.Data.DataSet();
-				ds.Tables.Add(dtLetters.Copy());
-				
-				string sSql = "BSDX RESOURCE LETTERS^" + sClinicList;
-				DataTable dt = docManager.RPMSDataTable(sSql, "Resources");				
-				ds.Tables.Add(dt.Copy());
-
-				cr.Database.Tables["PatientAppts"].SetDataSource(ds.Tables["PatientAppts"]);
-				cr.Database.Tables["BSDXResource"].SetDataSource(ds.Tables["Resources"]);
-
-				this.crViewer1.ReportSource = cr;
 				
 			}
@@ -183,7 +118,5 @@
 				string sBegin = dtBegin.ToShortDateString();
 				string sEnd = dtEnd.ToShortDateString();
-				crViewer1.DisplayGroupTree = true;
-
-				ClinicalScheduling.crPatientLetter cr = new crPatientLetter();
+
 				string sSql = "BSDX CLINIC LETTERS^" + sClinicList + "^" + sBegin + "^" + sEnd;
 
@@ -195,9 +128,4 @@
 				DataTable dt = docManager.RPMSDataTable(sSql, "Resources");				
 				ds.Tables.Add(dt.Copy());
-
-				cr.Database.Tables["PatientAppts"].SetDataSource(ds.Tables["PatientAppts"]);
-				cr.Database.Tables["BSDXResource"].SetDataSource(ds.Tables["Resources"]);
-
-				this.crViewer1.ReportSource = cr;
 				
 			}
@@ -243,29 +171,43 @@
 		private void InitializeComponent()
 		{
-			this.crViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
-			this.SuspendLayout();
-			// 
-			// crViewer1
-			// 
-			this.crViewer1.ActiveViewIndex = -1;
-			this.crViewer1.Dock = System.Windows.Forms.DockStyle.Fill;
-			this.crViewer1.Location = new System.Drawing.Point(0, 0);
-			this.crViewer1.Name = "crViewer1";
-			this.crViewer1.ReportSource = null;
-			this.crViewer1.Size = new System.Drawing.Size(648, 398);
-			this.crViewer1.TabIndex = 0;
-			// 
-			// DPatientLetter
-			// 
-			this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
-			this.ClientSize = new System.Drawing.Size(648, 398);
-			this.Controls.Add(this.crViewer1);
-			this.Name = "DPatientLetter";
-			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
-			this.Text = "Patient Letter";
-			this.ResumeLayout(false);
+            this.printDocument1 = new System.Drawing.Printing.PrintDocument();
+            this.SuspendLayout();
+            // 
+            // printDocument1
+            // 
+            this.printDocument1.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(this.printDocument1_PrintPage);
+            // 
+            // DPatientLetter
+            // 
+            this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
+            this.ClientSize = new System.Drawing.Size(648, 398);
+            this.Document = this.printDocument1;
+            this.Name = "DPatientLetter";
+            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
+            this.Text = "Patient Letter";
+            this.ResumeLayout(false);
 
 		}
 		#endregion
+
+        private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
+        {
+            // _currentResourcePrinting starts with zero. There will be at least this one.
+            ClinicalScheduling.Printing.PrintAppointments(_ds, e, _dtBegin, _dtEnd,
+                    _currentResourcePrinting, ref _currentApptPrinting);
+
+            //If the printing routine says it needs more pages to print the appointments,
+            //return here and have it print again.
+            if (e.HasMorePages == true) return;
+
+            // if there are more resouces to print, increment. Setting HasMorePages to true
+            // calls this routine again, so printing will happen with the incremented _currentResourcePrinting
+            if (_currentResourcePrinting < _ds.BSDXResource.Rows.Count - 1)
+            {
+                _currentResourcePrinting++;
+                e.HasMorePages = true;
+            }
+            
+        }
 	}
 }
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/DPatientLetter.resx
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/DPatientLetter.resx	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/DPatientLetter.resx	(revision 772)
@@ -4,5 +4,5 @@
     Microsoft ResX Schema 
     
-    Version 1.3
+    Version 2.0
     
     The primary goals of this format is to allow a simple XML format 
@@ -15,14 +15,15 @@
     ... ado.net/XML headers & schema ...
     <resheader name="resmimetype">text/microsoft-resx</resheader>
-    <resheader name="version">1.3</resheader>
+    <resheader name="version">2.0</resheader>
     <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
     <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
-    <data name="Name1">this is my long string</data>
+    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
     <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
     <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
-        [base64 mime encoded serialized .NET Framework object]
+        <value>[base64 mime encoded serialized .NET Framework object]</value>
     </data>
     <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
-        [base64 mime encoded string representing a byte array form of the .NET Framework object]
+        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
+        <comment>This is a comment</comment>
     </data>
                 
@@ -36,5 +37,5 @@
     mimetype set.
     
-    The mimetype is used forserialized objects, and tells the 
+    The mimetype is used for serialized objects, and tells the 
     ResXResourceReader how to depersist the object. This is currently not 
     extensible. For a given mimetype the value must be set accordingly:
@@ -46,5 +47,5 @@
     mimetype: application/x-microsoft.net.object.binary.base64
     value   : The object must be serialized with 
-            : System.Serialization.Formatters.Binary.BinaryFormatter
+            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter
             : and then encoded with base64 encoding.
     
@@ -60,7 +61,25 @@
     -->
   <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
+    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
     <xsd:element name="root" msdata:IsDataSet="true">
       <xsd:complexType>
         <xsd:choice maxOccurs="unbounded">
+          <xsd:element name="metadata">
+            <xsd:complexType>
+              <xsd:sequence>
+                <xsd:element name="value" type="xsd:string" minOccurs="0" />
+              </xsd:sequence>
+              <xsd:attribute name="name" use="required" type="xsd:string" />
+              <xsd:attribute name="type" type="xsd:string" />
+              <xsd:attribute name="mimetype" type="xsd:string" />
+              <xsd:attribute ref="xml:space" />
+            </xsd:complexType>
+          </xsd:element>
+          <xsd:element name="assembly">
+            <xsd:complexType>
+              <xsd:attribute name="alias" type="xsd:string" />
+              <xsd:attribute name="name" type="xsd:string" />
+            </xsd:complexType>
+          </xsd:element>
           <xsd:element name="data">
             <xsd:complexType>
@@ -69,7 +88,8 @@
                 <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
               </xsd:sequence>
-              <xsd:attribute name="name" type="xsd:string" msdata:Ordinal="1" />
+              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />
               <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
               <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
+              <xsd:attribute ref="xml:space" />
             </xsd:complexType>
           </xsd:element>
@@ -90,50 +110,14 @@
   </resheader>
   <resheader name="version">
-    <value>1.3</value>
+    <value>2.0</value>
   </resheader>
   <resheader name="reader">
-    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
   </resheader>
   <resheader name="writer">
-    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
+    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
   </resheader>
-  <data name="crViewer1.DefaultModifiers" type="System.CodeDom.MemberAttributes, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
-    <value>Private</value>
-  </data>
-  <data name="crViewer1.Modifiers" type="System.CodeDom.MemberAttributes, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
-    <value>Private</value>
-  </data>
-  <data name="crViewer1.Locked" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
-    <value>False</value>
-  </data>
-  <data name="$this.Locked" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
-    <value>False</value>
-  </data>
-  <data name="$this.Language" type="System.Globalization.CultureInfo, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
-    <value>(Default)</value>
-  </data>
-  <data name="$this.TrayLargeIcon" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
-    <value>False</value>
-  </data>
-  <data name="$this.Localizable" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
-    <value>False</value>
-  </data>
-  <data name="$this.GridSize" type="System.Drawing.Size, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
-    <value>8, 8</value>
-  </data>
-  <data name="$this.DrawGrid" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
-    <value>True</value>
-  </data>
-  <data name="$this.TrayHeight" type="System.Int32, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
-    <value>80</value>
-  </data>
-  <data name="$this.Name">
-    <value>DPatientLetter</value>
-  </data>
-  <data name="$this.SnapToGrid" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
-    <value>True</value>
-  </data>
-  <data name="$this.DefaultModifiers" type="System.CodeDom.MemberAttributes, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
-    <value>Private</value>
-  </data>
+  <metadata name="printDocument1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
+    <value>116, 17</value>
+  </metadata>
 </root>
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/DSelectLetterClinics.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/DSelectLetterClinics.cs	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/DSelectLetterClinics.cs	(revision 772)
@@ -9,6 +9,17 @@
 {
 	/// <summary>
-	/// Summary description for DSelectLetterClinics.
+	/// Use this dialog to select resources and dates (begin and end) for their examination.
+    /// <example>
+    /// DSelectLetterClinics ds = new DSelectLetterClinics();
+    /// ds.InitializePage(this.m_DocManager.GlobalDataSet, "Print Clinic Cancellation Letters");
+	///	ds.ShowDialog(this) 					
+    ///
+	/// //get the resource names and call the letter printer
+	///	string sClinics = ds.SelectedClinics;
+	///	DateTime dtBegin = ds.BeginDate;
+	///	DateTime dtEnd = ds.EndDate;
+    /// </example>
 	/// </summary>
+    /// 
 	public class DSelectLetterClinics : System.Windows.Forms.Form
 	{
@@ -31,7 +42,12 @@
 		private System.ComponentModel.Container components = null;
 
-		public DSelectLetterClinics()
+		/// <summary>
+		/// Ctor; also sets default enter and cancel buttons
+		/// </summary>
+        public DSelectLetterClinics()
 		{
 			InitializeComponent();
+            this.AcceptButton = cmdOK;
+            this.CancelButton = cmdCancel;
 		}
 
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/Options.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/Options.cs	(revision 772)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/Options.cs	(revision 772)
@@ -0,0 +1,1148 @@
+//
+// Options.cs
+//
+// Authors:
+//  Jonathan Pryor <jpryor@novell.com>
+//  Federico Di Gregorio <fog@initd.org>
+//
+// Copyright (C) 2008 Novell (http://www.novell.com)
+// Copyright (C) 2009 Federico Di Gregorio.
+//
+// Permission is hereby granted, free of charge, to any person obtaining
+// a copy of this software and associated documentation files (the
+// "Software"), to deal in the Software without restriction, including
+// without limitation the rights to use, copy, modify, merge, publish,
+// distribute, sublicense, and/or sell copies of the Software, and to
+// permit persons to whom the Software is furnished to do so, subject to
+// the following conditions:
+// 
+// The above copyright notice and this permission notice shall be
+// included in all copies or substantial portions of the Software.
+// 
+// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
+// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
+// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
+// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
+// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
+// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
+// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
+//
+
+// Compile With:
+//   gmcs -debug+ -r:System.Core Options.cs -o:NDesk.Options.dll
+//   gmcs -debug+ -d:LINQ -r:System.Core Options.cs -o:NDesk.Options.dll
+//
+// The LINQ version just changes the implementation of
+// OptionSet.Parse(IEnumerable<string>), and confers no semantic changes.
+
+//
+// A Getopt::Long-inspired option parsing library for C#.
+//
+// NDesk.Options.OptionSet is built upon a key/value table, where the
+// key is a option format string and the value is a delegate that is 
+// invoked when the format string is matched.
+//
+// Option format strings:
+//  Regex-like BNF Grammar: 
+//    name: .+
+//    type: [=:]
+//    sep: ( [^{}]+ | '{' .+ '}' )?
+//    aliases: ( name type sep ) ( '|' name type sep )*
+// 
+// Each '|'-delimited name is an alias for the associated action.  If the
+// format string ends in a '=', it has a required value.  If the format
+// string ends in a ':', it has an optional value.  If neither '=' or ':'
+// is present, no value is supported.  `=' or `:' need only be defined on one
+// alias, but if they are provided on more than one they must be consistent.
+//
+// Each alias portion may also end with a "key/value separator", which is used
+// to split option values if the option accepts > 1 value.  If not specified,
+// it defaults to '=' and ':'.  If specified, it can be any character except
+// '{' and '}' OR the *string* between '{' and '}'.  If no separator should be
+// used (i.e. the separate values should be distinct arguments), then "{}"
+// should be used as the separator.
+//
+// Options are extracted either from the current option by looking for
+// the option name followed by an '=' or ':', or is taken from the
+// following option IFF:
+//  - The current option does not contain a '=' or a ':'
+//  - The current option requires a value (i.e. not a Option type of ':')
+//
+// The `name' used in the option format string does NOT include any leading
+// option indicator, such as '-', '--', or '/'.  All three of these are
+// permitted/required on any named option.
+//
+// Option bundling is permitted so long as:
+//   - '-' is used to start the option group
+//   - all of the bundled options are a single character
+//   - at most one of the bundled options accepts a value, and the value
+//     provided starts from the next character to the end of the string.
+//
+// This allows specifying '-a -b -c' as '-abc', and specifying '-D name=value'
+// as '-Dname=value'.
+//
+// Option processing is disabled by specifying "--".  All options after "--"
+// are returned by OptionSet.Parse() unchanged and unprocessed.
+//
+// Unprocessed options are returned from OptionSet.Parse().
+//
+// Examples:
+//  int verbose = 0;
+//  OptionSet p = new OptionSet ()
+//    .Add ("v", v => ++verbose)
+//    .Add ("name=|value=", v => Console.WriteLine (v));
+//  p.Parse (new string[]{"-v", "--v", "/v", "-name=A", "/name", "B", "extra"});
+//
+// The above would parse the argument string array, and would invoke the
+// lambda expression three times, setting `verbose' to 3 when complete.  
+// It would also print out "A" and "B" to standard output.
+// The returned array would contain the string "extra".
+//
+// C# 3.0 collection initializers are supported and encouraged:
+//  var p = new OptionSet () {
+//    { "h|?|help", v => ShowHelp () },
+//  };
+//
+// System.ComponentModel.TypeConverter is also supported, allowing the use of
+// custom data types in the callback type; TypeConverter.ConvertFromString()
+// is used to convert the value option to an instance of the specified
+// type:
+//
+//  var p = new OptionSet () {
+//    { "foo=", (Foo f) => Console.WriteLine (f.ToString ()) },
+//  };
+//
+// Random other tidbits:
+//  - Boolean options (those w/o '=' or ':' in the option format string)
+//    are explicitly enabled if they are followed with '+', and explicitly
+//    disabled if they are followed with '-':
+//      string a = null;
+//      var p = new OptionSet () {
+//        { "a", s => a = s },
+//      };
+//      p.Parse (new string[]{"-a"});   // sets v != null
+//      p.Parse (new string[]{"-a+"});  // sets v != null
+//      p.Parse (new string[]{"-a-"});  // sets v == null
+//
+
+using System;
+using System.Collections;
+using System.Collections.Generic;
+using System.Collections.ObjectModel;
+using System.ComponentModel;
+using System.Globalization;
+using System.IO;
+using System.Runtime.Serialization;
+using System.Security.Permissions;
+using System.Text;
+using System.Text.RegularExpressions;
+
+#if LINQ
+using System.Linq;
+#endif
+
+#if TEST
+using NDesk.Options;
+#endif
+
+#if NDESK_OPTIONS
+namespace NDesk.Options
+#else
+namespace Mono.Options
+#endif
+{
+	static class StringCoda {
+
+		public static IEnumerable<string> WrappedLines (string self, params int[] widths)
+		{
+			IEnumerable<int> w = widths;
+			return WrappedLines (self, w);
+		}
+
+		public static IEnumerable<string> WrappedLines (string self, IEnumerable<int> widths)
+		{
+			if (widths == null)
+				throw new ArgumentNullException ("widths");
+			return CreateWrappedLinesIterator (self, widths);
+		}
+
+		private static IEnumerable<string> CreateWrappedLinesIterator (string self, IEnumerable<int> widths)
+		{
+			if (string.IsNullOrEmpty (self)) {
+				yield return string.Empty;
+				yield break;
+			}
+			using (var ewidths = widths.GetEnumerator ()) {
+				bool? hw = null;
+				int width = GetNextWidth (ewidths, int.MaxValue, ref hw);
+				int start = 0, end;
+				do {
+					end = GetLineEnd (start, width, self);
+					char c = self [end-1];
+					if (char.IsWhiteSpace (c))
+						--end;
+					bool needContinuation = end != self.Length && !IsEolChar (c);
+					string continuation = "";
+					if (needContinuation) {
+						--end;
+						continuation = "-";
+					}
+					string line = self.Substring (start, end - start) + continuation;
+					yield return line;
+					start = end;
+					if (char.IsWhiteSpace (c))
+						++start;
+					width = GetNextWidth (ewidths, width, ref hw);
+				} while (end < self.Length);
+			}
+		}
+
+		private static int GetNextWidth (IEnumerator<int> ewidths, int curWidth, ref bool? eValid)
+		{
+			if (!eValid.HasValue || (eValid.HasValue && eValid.Value)) {
+				curWidth = (eValid = ewidths.MoveNext ()).Value ? ewidths.Current : curWidth;
+				// '.' is any character, - is for a continuation
+				const string minWidth = ".-";
+				if (curWidth < minWidth.Length)
+					throw new ArgumentOutOfRangeException ("widths",
+							string.Format ("Element must be >= {0}, was {1}.", minWidth.Length, curWidth));
+				return curWidth;
+			}
+			// no more elements, use the last element.
+			return curWidth;
+		}
+
+		private static bool IsEolChar (char c)
+		{
+			return !char.IsLetterOrDigit (c);
+		}
+
+		private static int GetLineEnd (int start, int length, string description)
+		{
+			int end = System.Math.Min (start + length, description.Length);
+			int sep = -1;
+			for (int i = start; i < end; ++i) {
+				if (description [i] == '\n')
+					return i+1;
+				if (IsEolChar (description [i]))
+					sep = i+1;
+			}
+			if (sep == -1 || end == description.Length)
+				return end;
+			return sep;
+		}
+	}
+
+	public class OptionValueCollection : IList, IList<string> {
+
+		List<string> values = new List<string> ();
+		OptionContext c;
+
+		internal OptionValueCollection (OptionContext c)
+		{
+			this.c = c;
+		}
+
+		#region ICollection
+		void ICollection.CopyTo (Array array, int index)  {(values as ICollection).CopyTo (array, index);}
+		bool ICollection.IsSynchronized                   {get {return (values as ICollection).IsSynchronized;}}
+		object ICollection.SyncRoot                       {get {return (values as ICollection).SyncRoot;}}
+		#endregion
+
+		#region ICollection<T>
+		public void Add (string item)                       {values.Add (item);}
+		public void Clear ()                                {values.Clear ();}
+		public bool Contains (string item)                  {return values.Contains (item);}
+		public void CopyTo (string[] array, int arrayIndex) {values.CopyTo (array, arrayIndex);}
+		public bool Remove (string item)                    {return values.Remove (item);}
+		public int Count                                    {get {return values.Count;}}
+		public bool IsReadOnly                              {get {return false;}}
+		#endregion
+
+		#region IEnumerable
+		IEnumerator IEnumerable.GetEnumerator () {return values.GetEnumerator ();}
+		#endregion
+
+		#region IEnumerable<T>
+		public IEnumerator<string> GetEnumerator () {return values.GetEnumerator ();}
+		#endregion
+
+		#region IList
+		int IList.Add (object value)                {return (values as IList).Add (value);}
+		bool IList.Contains (object value)          {return (values as IList).Contains (value);}
+		int IList.IndexOf (object value)            {return (values as IList).IndexOf (value);}
+		void IList.Insert (int index, object value) {(values as IList).Insert (index, value);}
+		void IList.Remove (object value)            {(values as IList).Remove (value);}
+		void IList.RemoveAt (int index)             {(values as IList).RemoveAt (index);}
+		bool IList.IsFixedSize                      {get {return false;}}
+		object IList.this [int index]               {get {return this [index];} set {(values as IList)[index] = value;}}
+		#endregion
+
+		#region IList<T>
+		public int IndexOf (string item)            {return values.IndexOf (item);}
+		public void Insert (int index, string item) {values.Insert (index, item);}
+		public void RemoveAt (int index)            {values.RemoveAt (index);}
+
+		private void AssertValid (int index)
+		{
+			if (c.Option == null)
+				throw new InvalidOperationException ("OptionContext.Option is null.");
+			if (index >= c.Option.MaxValueCount)
+				throw new ArgumentOutOfRangeException ("index");
+			if (c.Option.OptionValueType == OptionValueType.Required &&
+					index >= values.Count)
+				throw new OptionException (string.Format (
+							c.OptionSet.MessageLocalizer ("Missing required value for option '{0}'."), c.OptionName), 
+						c.OptionName);
+		}
+
+		public string this [int index] {
+			get {
+				AssertValid (index);
+				return index >= values.Count ? null : values [index];
+			}
+			set {
+				values [index] = value;
+			}
+		}
+		#endregion
+
+		public List<string> ToList ()
+		{
+			return new List<string> (values);
+		}
+
+		public string[] ToArray ()
+		{
+			return values.ToArray ();
+		}
+
+		public override string ToString ()
+		{
+			return string.Join (", ", values.ToArray ());
+		}
+	}
+
+	public class OptionContext {
+		private Option                option;
+		private string                name;
+		private int                   index;
+		private OptionSet             set;
+		private OptionValueCollection c;
+
+		public OptionContext (OptionSet set)
+		{
+			this.set = set;
+			this.c   = new OptionValueCollection (this);
+		}
+
+		public Option Option {
+			get {return option;}
+			set {option = value;}
+		}
+
+		public string OptionName { 
+			get {return name;}
+			set {name = value;}
+		}
+
+		public int OptionIndex {
+			get {return index;}
+			set {index = value;}
+		}
+
+		public OptionSet OptionSet {
+			get {return set;}
+		}
+
+		public OptionValueCollection OptionValues {
+			get {return c;}
+		}
+	}
+
+	public enum OptionValueType {
+		None, 
+		Optional,
+		Required,
+	}
+
+	public abstract class Option {
+		string prototype, description;
+		string[] names;
+		OptionValueType type;
+		int count;
+		string[] separators;
+
+		protected Option (string prototype, string description)
+			: this (prototype, description, 1)
+		{
+		}
+
+		protected Option (string prototype, string description, int maxValueCount)
+		{
+			if (prototype == null)
+				throw new ArgumentNullException ("prototype");
+			if (prototype.Length == 0)
+				throw new ArgumentException ("Cannot be the empty string.", "prototype");
+			if (maxValueCount < 0)
+				throw new ArgumentOutOfRangeException ("maxValueCount");
+
+			this.prototype   = prototype;
+			this.names       = prototype.Split ('|');
+			this.description = description;
+			this.count       = maxValueCount;
+			this.type        = ParsePrototype ();
+
+			if (this.count == 0 && type != OptionValueType.None)
+				throw new ArgumentException (
+						"Cannot provide maxValueCount of 0 for OptionValueType.Required or " +
+							"OptionValueType.Optional.",
+						"maxValueCount");
+			if (this.type == OptionValueType.None && maxValueCount > 1)
+				throw new ArgumentException (
+						string.Format ("Cannot provide maxValueCount of {0} for OptionValueType.None.", maxValueCount),
+						"maxValueCount");
+			if (Array.IndexOf (names, "<>") >= 0 && 
+					((names.Length == 1 && this.type != OptionValueType.None) ||
+					 (names.Length > 1 && this.MaxValueCount > 1)))
+				throw new ArgumentException (
+						"The default option handler '<>' cannot require values.",
+						"prototype");
+		}
+
+		public string           Prototype       {get {return prototype;}}
+		public string           Description     {get {return description;}}
+		public OptionValueType  OptionValueType {get {return type;}}
+		public int              MaxValueCount   {get {return count;}}
+
+		public string[] GetNames ()
+		{
+			return (string[]) names.Clone ();
+		}
+
+		public string[] GetValueSeparators ()
+		{
+			if (separators == null)
+				return new string [0];
+			return (string[]) separators.Clone ();
+		}
+
+		protected static T Parse<T> (string value, OptionContext c)
+		{
+			Type tt = typeof (T);
+			bool nullable = tt.IsValueType && tt.IsGenericType && 
+				!tt.IsGenericTypeDefinition && 
+				tt.GetGenericTypeDefinition () == typeof (Nullable<>);
+			Type targetType = nullable ? tt.GetGenericArguments () [0] : typeof (T);
+			TypeConverter conv = TypeDescriptor.GetConverter (targetType);
+			T t = default (T);
+			try {
+				if (value != null)
+					t = (T) conv.ConvertFromString (value);
+			}
+			catch (Exception e) {
+				throw new OptionException (
+						string.Format (
+							c.OptionSet.MessageLocalizer ("Could not convert string `{0}' to type {1} for option `{2}'."),
+							value, targetType.Name, c.OptionName),
+						c.OptionName, e);
+			}
+			return t;
+		}
+
+		internal string[] Names           {get {return names;}}
+		internal string[] ValueSeparators {get {return separators;}}
+
+		static readonly char[] NameTerminator = new char[]{'=', ':'};
+
+		private OptionValueType ParsePrototype ()
+		{
+			char type = '\0';
+			List<string> seps = new List<string> ();
+			for (int i = 0; i < names.Length; ++i) {
+				string name = names [i];
+				if (name.Length == 0)
+					throw new ArgumentException ("Empty option names are not supported.", "prototype");
+
+				int end = name.IndexOfAny (NameTerminator);
+				if (end == -1)
+					continue;
+				names [i] = name.Substring (0, end);
+				if (type == '\0' || type == name [end])
+					type = name [end];
+				else 
+					throw new ArgumentException (
+							string.Format ("Conflicting option types: '{0}' vs. '{1}'.", type, name [end]),
+							"prototype");
+				AddSeparators (name, end, seps);
+			}
+
+			if (type == '\0')
+				return OptionValueType.None;
+
+			if (count <= 1 && seps.Count != 0)
+				throw new ArgumentException (
+						string.Format ("Cannot provide key/value separators for Options taking {0} value(s).", count),
+						"prototype");
+			if (count > 1) {
+				if (seps.Count == 0)
+					this.separators = new string[]{":", "="};
+				else if (seps.Count == 1 && seps [0].Length == 0)
+					this.separators = null;
+				else
+					this.separators = seps.ToArray ();
+			}
+
+			return type == '=' ? OptionValueType.Required : OptionValueType.Optional;
+		}
+
+		private static void AddSeparators (string name, int end, ICollection<string> seps)
+		{
+			int start = -1;
+			for (int i = end+1; i < name.Length; ++i) {
+				switch (name [i]) {
+					case '{':
+						if (start != -1)
+							throw new ArgumentException (
+									string.Format ("Ill-formed name/value separator found in \"{0}\".", name),
+									"prototype");
+						start = i+1;
+						break;
+					case '}':
+						if (start == -1)
+							throw new ArgumentException (
+									string.Format ("Ill-formed name/value separator found in \"{0}\".", name),
+									"prototype");
+						seps.Add (name.Substring (start, i-start));
+						start = -1;
+						break;
+					default:
+						if (start == -1)
+							seps.Add (name [i].ToString ());
+						break;
+				}
+			}
+			if (start != -1)
+				throw new ArgumentException (
+						string.Format ("Ill-formed name/value separator found in \"{0}\".", name),
+						"prototype");
+		}
+
+		public void Invoke (OptionContext c)
+		{
+			OnParseComplete (c);
+			c.OptionName  = null;
+			c.Option      = null;
+			c.OptionValues.Clear ();
+		}
+
+		protected abstract void OnParseComplete (OptionContext c);
+
+		public override string ToString ()
+		{
+			return Prototype;
+		}
+	}
+
+	[Serializable]
+	public class OptionException : Exception {
+		private string option;
+
+		public OptionException ()
+		{
+		}
+
+		public OptionException (string message, string optionName)
+			: base (message)
+		{
+			this.option = optionName;
+		}
+
+		public OptionException (string message, string optionName, Exception innerException)
+			: base (message, innerException)
+		{
+			this.option = optionName;
+		}
+
+		protected OptionException (SerializationInfo info, StreamingContext context)
+			: base (info, context)
+		{
+			this.option = info.GetString ("OptionName");
+		}
+
+		public string OptionName {
+			get {return this.option;}
+		}
+
+		[SecurityPermission (SecurityAction.LinkDemand, SerializationFormatter = true)]
+		public override void GetObjectData (SerializationInfo info, StreamingContext context)
+		{
+			base.GetObjectData (info, context);
+			info.AddValue ("OptionName", option);
+		}
+	}
+
+	public delegate void OptionAction<TKey, TValue> (TKey key, TValue value);
+
+	public class OptionSet : KeyedCollection<string, Option>
+	{
+		public OptionSet ()
+			: this (delegate (string f) {return f;})
+		{
+		}
+
+		public OptionSet (Converter<string, string> localizer)
+		{
+			this.localizer = localizer;
+		}
+
+		Converter<string, string> localizer;
+
+		public Converter<string, string> MessageLocalizer {
+			get {return localizer;}
+		}
+
+		protected override string GetKeyForItem (Option item)
+		{
+			if (item == null)
+				throw new ArgumentNullException ("option");
+			if (item.Names != null && item.Names.Length > 0)
+				return item.Names [0];
+			// This should never happen, as it's invalid for Option to be
+			// constructed w/o any names.
+			throw new InvalidOperationException ("Option has no names!");
+		}
+
+		[Obsolete ("Use KeyedCollection.this[string]")]
+		protected Option GetOptionForName (string option)
+		{
+			if (option == null)
+				throw new ArgumentNullException ("option");
+			try {
+				return base [option];
+			}
+			catch (KeyNotFoundException) {
+				return null;
+			}
+		}
+
+		protected override void InsertItem (int index, Option item)
+		{
+			base.InsertItem (index, item);
+			AddImpl (item);
+		}
+
+		protected override void RemoveItem (int index)
+		{
+			base.RemoveItem (index);
+			Option p = Items [index];
+			// KeyedCollection.RemoveItem() handles the 0th item
+			for (int i = 1; i < p.Names.Length; ++i) {
+				Dictionary.Remove (p.Names [i]);
+			}
+		}
+
+		protected override void SetItem (int index, Option item)
+		{
+			base.SetItem (index, item);
+			RemoveItem (index);
+			AddImpl (item);
+		}
+
+		private void AddImpl (Option option)
+		{
+			if (option == null)
+				throw new ArgumentNullException ("option");
+			List<string> added = new List<string> (option.Names.Length);
+			try {
+				// KeyedCollection.InsertItem/SetItem handle the 0th name.
+				for (int i = 1; i < option.Names.Length; ++i) {
+					Dictionary.Add (option.Names [i], option);
+					added.Add (option.Names [i]);
+				}
+			}
+			catch (Exception) {
+				foreach (string name in added)
+					Dictionary.Remove (name);
+				throw;
+			}
+		}
+
+		public new OptionSet Add (Option option)
+		{
+			base.Add (option);
+			return this;
+		}
+
+		sealed class ActionOption : Option {
+			Action<OptionValueCollection> action;
+
+			public ActionOption (string prototype, string description, int count, Action<OptionValueCollection> action)
+				: base (prototype, description, count)
+			{
+				if (action == null)
+					throw new ArgumentNullException ("action");
+				this.action = action;
+			}
+
+			protected override void OnParseComplete (OptionContext c)
+			{
+				action (c.OptionValues);
+			}
+		}
+
+		public OptionSet Add (string prototype, Action<string> action)
+		{
+			return Add (prototype, null, action);
+		}
+
+		public OptionSet Add (string prototype, string description, Action<string> action)
+		{
+			if (action == null)
+				throw new ArgumentNullException ("action");
+			Option p = new ActionOption (prototype, description, 1, 
+					delegate (OptionValueCollection v) { action (v [0]); });
+			base.Add (p);
+			return this;
+		}
+
+		public OptionSet Add (string prototype, OptionAction<string, string> action)
+		{
+			return Add (prototype, null, action);
+		}
+
+		public OptionSet Add (string prototype, string description, OptionAction<string, string> action)
+		{
+			if (action == null)
+				throw new ArgumentNullException ("action");
+			Option p = new ActionOption (prototype, description, 2, 
+					delegate (OptionValueCollection v) {action (v [0], v [1]);});
+			base.Add (p);
+			return this;
+		}
+
+		sealed class ActionOption<T> : Option {
+			Action<T> action;
+
+			public ActionOption (string prototype, string description, Action<T> action)
+				: base (prototype, description, 1)
+			{
+				if (action == null)
+					throw new ArgumentNullException ("action");
+				this.action = action;
+			}
+
+			protected override void OnParseComplete (OptionContext c)
+			{
+				action (Parse<T> (c.OptionValues [0], c));
+			}
+		}
+
+		sealed class ActionOption<TKey, TValue> : Option {
+			OptionAction<TKey, TValue> action;
+
+			public ActionOption (string prototype, string description, OptionAction<TKey, TValue> action)
+				: base (prototype, description, 2)
+			{
+				if (action == null)
+					throw new ArgumentNullException ("action");
+				this.action = action;
+			}
+
+			protected override void OnParseComplete (OptionContext c)
+			{
+				action (
+						Parse<TKey> (c.OptionValues [0], c),
+						Parse<TValue> (c.OptionValues [1], c));
+			}
+		}
+
+		public OptionSet Add<T> (string prototype, Action<T> action)
+		{
+			return Add (prototype, null, action);
+		}
+
+		public OptionSet Add<T> (string prototype, string description, Action<T> action)
+		{
+			return Add (new ActionOption<T> (prototype, description, action));
+		}
+
+		public OptionSet Add<TKey, TValue> (string prototype, OptionAction<TKey, TValue> action)
+		{
+			return Add (prototype, null, action);
+		}
+
+		public OptionSet Add<TKey, TValue> (string prototype, string description, OptionAction<TKey, TValue> action)
+		{
+			return Add (new ActionOption<TKey, TValue> (prototype, description, action));
+		}
+
+		protected virtual OptionContext CreateOptionContext ()
+		{
+			return new OptionContext (this);
+		}
+
+#if LINQ
+		public List<string> Parse (IEnumerable<string> arguments)
+		{
+			bool process = true;
+			OptionContext c = CreateOptionContext ();
+			c.OptionIndex = -1;
+			var def = GetOptionForName ("<>");
+			var unprocessed = 
+				from argument in arguments
+				where ++c.OptionIndex >= 0 && (process || def != null)
+					? process
+						? argument == "--" 
+							? (process = false)
+							: !Parse (argument, c)
+								? def != null 
+									? Unprocessed (null, def, c, argument) 
+									: true
+								: false
+						: def != null 
+							? Unprocessed (null, def, c, argument)
+							: true
+					: true
+				select argument;
+			List<string> r = unprocessed.ToList ();
+			if (c.Option != null)
+				c.Option.Invoke (c);
+			return r;
+		}
+#else
+		public List<string> Parse (IEnumerable<string> arguments)
+		{
+			OptionContext c = CreateOptionContext ();
+			c.OptionIndex = -1;
+			bool process = true;
+			List<string> unprocessed = new List<string> ();
+			Option def = Contains ("<>") ? this ["<>"] : null;
+			foreach (string argument in arguments) {
+				++c.OptionIndex;
+				if (argument == "--") {
+					process = false;
+					continue;
+				}
+				if (!process) {
+					Unprocessed (unprocessed, def, c, argument);
+					continue;
+				}
+				if (!Parse (argument, c))
+					Unprocessed (unprocessed, def, c, argument);
+			}
+			if (c.Option != null)
+				c.Option.Invoke (c);
+			return unprocessed;
+		}
+#endif
+
+		private static bool Unprocessed (ICollection<string> extra, Option def, OptionContext c, string argument)
+		{
+			if (def == null) {
+				extra.Add (argument);
+				return false;
+			}
+			c.OptionValues.Add (argument);
+			c.Option = def;
+			c.Option.Invoke (c);
+			return false;
+		}
+
+		private readonly Regex ValueOption = new Regex (
+			@"^(?<flag>--|-|/)(?<name>[^:=]+)((?<sep>[:=])(?<value>.*))?$");
+
+		protected bool GetOptionParts (string argument, out string flag, out string name, out string sep, out string value)
+		{
+			if (argument == null)
+				throw new ArgumentNullException ("argument");
+
+			flag = name = sep = value = null;
+			Match m = ValueOption.Match (argument);
+			if (!m.Success) {
+				return false;
+			}
+			flag  = m.Groups ["flag"].Value;
+			name  = m.Groups ["name"].Value;
+			if (m.Groups ["sep"].Success && m.Groups ["value"].Success) {
+				sep   = m.Groups ["sep"].Value;
+				value = m.Groups ["value"].Value;
+			}
+			return true;
+		}
+
+		protected virtual bool Parse (string argument, OptionContext c)
+		{
+			if (c.Option != null) {
+				ParseValue (argument, c);
+				return true;
+			}
+
+			string f, n, s, v;
+			if (!GetOptionParts (argument, out f, out n, out s, out v))
+				return false;
+
+			Option p;
+			if (Contains (n)) {
+				p = this [n];
+				c.OptionName = f + n;
+				c.Option     = p;
+				switch (p.OptionValueType) {
+					case OptionValueType.None:
+						c.OptionValues.Add (n);
+						c.Option.Invoke (c);
+						break;
+					case OptionValueType.Optional:
+					case OptionValueType.Required: 
+						ParseValue (v, c);
+						break;
+				}
+				return true;
+			}
+			// no match; is it a bool option?
+			if (ParseBool (argument, n, c))
+				return true;
+			// is it a bundled option?
+			if (ParseBundledValue (f, string.Concat (n + s + v), c))
+				return true;
+
+			return false;
+		}
+
+		private void ParseValue (string option, OptionContext c)
+		{
+			if (option != null)
+				foreach (string o in c.Option.ValueSeparators != null 
+						? option.Split (c.Option.ValueSeparators, StringSplitOptions.None)
+						: new string[]{option}) {
+					c.OptionValues.Add (o);
+				}
+			if (c.OptionValues.Count == c.Option.MaxValueCount || 
+					c.Option.OptionValueType == OptionValueType.Optional)
+				c.Option.Invoke (c);
+			else if (c.OptionValues.Count > c.Option.MaxValueCount) {
+				throw new OptionException (localizer (string.Format (
+								"Error: Found {0} option values when expecting {1}.", 
+								c.OptionValues.Count, c.Option.MaxValueCount)),
+						c.OptionName);
+			}
+		}
+
+		private bool ParseBool (string option, string n, OptionContext c)
+		{
+			Option p;
+			string rn;
+			if (n.Length >= 1 && (n [n.Length-1] == '+' || n [n.Length-1] == '-') &&
+					Contains ((rn = n.Substring (0, n.Length-1)))) {
+				p = this [rn];
+				string v = n [n.Length-1] == '+' ? option : null;
+				c.OptionName  = option;
+				c.Option      = p;
+				c.OptionValues.Add (v);
+				p.Invoke (c);
+				return true;
+			}
+			return false;
+		}
+
+		private bool ParseBundledValue (string f, string n, OptionContext c)
+		{
+			if (f != "-")
+				return false;
+			for (int i = 0; i < n.Length; ++i) {
+				Option p;
+				string opt = f + n [i].ToString ();
+				string rn = n [i].ToString ();
+				if (!Contains (rn)) {
+					if (i == 0)
+						return false;
+					throw new OptionException (string.Format (localizer (
+									"Cannot bundle unregistered option '{0}'."), opt), opt);
+				}
+				p = this [rn];
+				switch (p.OptionValueType) {
+					case OptionValueType.None:
+						Invoke (c, opt, n, p);
+						break;
+					case OptionValueType.Optional:
+					case OptionValueType.Required: {
+						string v     = n.Substring (i+1);
+						c.Option     = p;
+						c.OptionName = opt;
+						ParseValue (v.Length != 0 ? v : null, c);
+						return true;
+					}
+					default:
+						throw new InvalidOperationException ("Unknown OptionValueType: " + p.OptionValueType);
+				}
+			}
+			return true;
+		}
+
+		private static void Invoke (OptionContext c, string name, string value, Option option)
+		{
+			c.OptionName  = name;
+			c.Option      = option;
+			c.OptionValues.Add (value);
+			option.Invoke (c);
+		}
+
+		private const int OptionWidth = 29;
+
+		public void WriteOptionDescriptions (TextWriter o)
+		{
+			foreach (Option p in this) {
+				int written = 0;
+				if (!WriteOptionPrototype (o, p, ref written))
+					continue;
+
+				if (written < OptionWidth)
+					o.Write (new string (' ', OptionWidth - written));
+				else {
+					o.WriteLine ();
+					o.Write (new string (' ', OptionWidth));
+				}
+
+				bool indent = false;
+				string prefix = new string (' ', OptionWidth+2);
+				foreach (string line in GetLines (localizer (GetDescription (p.Description)))) {
+					if (indent) 
+						o.Write (prefix);
+					o.WriteLine (line);
+					indent = true;
+				}
+			}
+		}
+
+		bool WriteOptionPrototype (TextWriter o, Option p, ref int written)
+		{
+			string[] names = p.Names;
+
+			int i = GetNextOptionIndex (names, 0);
+			if (i == names.Length)
+				return false;
+
+			if (names [i].Length == 1) {
+				Write (o, ref written, "  -");
+				Write (o, ref written, names [0]);
+			}
+			else {
+				Write (o, ref written, "      --");
+				Write (o, ref written, names [0]);
+			}
+
+			for ( i = GetNextOptionIndex (names, i+1); 
+					i < names.Length; i = GetNextOptionIndex (names, i+1)) {
+				Write (o, ref written, ", ");
+				Write (o, ref written, names [i].Length == 1 ? "-" : "--");
+				Write (o, ref written, names [i]);
+			}
+
+			if (p.OptionValueType == OptionValueType.Optional ||
+					p.OptionValueType == OptionValueType.Required) {
+				if (p.OptionValueType == OptionValueType.Optional) {
+					Write (o, ref written, localizer ("["));
+				}
+				Write (o, ref written, localizer ("=" + GetArgumentName (0, p.MaxValueCount, p.Description)));
+				string sep = p.ValueSeparators != null && p.ValueSeparators.Length > 0 
+					? p.ValueSeparators [0]
+					: " ";
+				for (int c = 1; c < p.MaxValueCount; ++c) {
+					Write (o, ref written, localizer (sep + GetArgumentName (c, p.MaxValueCount, p.Description)));
+				}
+				if (p.OptionValueType == OptionValueType.Optional) {
+					Write (o, ref written, localizer ("]"));
+				}
+			}
+			return true;
+		}
+
+		static int GetNextOptionIndex (string[] names, int i)
+		{
+			while (i < names.Length && names [i] == "<>") {
+				++i;
+			}
+			return i;
+		}
+
+		static void Write (TextWriter o, ref int n, string s)
+		{
+			n += s.Length;
+			o.Write (s);
+		}
+
+		private static string GetArgumentName (int index, int maxIndex, string description)
+		{
+			if (description == null)
+				return maxIndex == 1 ? "VALUE" : "VALUE" + (index + 1);
+			string[] nameStart;
+			if (maxIndex == 1)
+				nameStart = new string[]{"{0:", "{"};
+			else
+				nameStart = new string[]{"{" + index + ":"};
+			for (int i = 0; i < nameStart.Length; ++i) {
+				int start, j = 0;
+				do {
+					start = description.IndexOf (nameStart [i], j);
+				} while (start >= 0 && j != 0 ? description [j++ - 1] == '{' : false);
+				if (start == -1)
+					continue;
+				int end = description.IndexOf ("}", start);
+				if (end == -1)
+					continue;
+				return description.Substring (start + nameStart [i].Length, end - start - nameStart [i].Length);
+			}
+			return maxIndex == 1 ? "VALUE" : "VALUE" + (index + 1);
+		}
+
+		private static string GetDescription (string description)
+		{
+			if (description == null)
+				return string.Empty;
+			StringBuilder sb = new StringBuilder (description.Length);
+			int start = -1;
+			for (int i = 0; i < description.Length; ++i) {
+				switch (description [i]) {
+					case '{':
+						if (i == start) {
+							sb.Append ('{');
+							start = -1;
+						}
+						else if (start < 0)
+							start = i + 1;
+						break;
+					case '}':
+						if (start < 0) {
+							if ((i+1) == description.Length || description [i+1] != '}')
+								throw new InvalidOperationException ("Invalid option description: " + description);
+							++i;
+							sb.Append ("}");
+						}
+						else {
+							sb.Append (description.Substring (start, i - start));
+							start = -1;
+						}
+						break;
+					case ':':
+						if (start < 0)
+							goto default;
+						start = i + 1;
+						break;
+					default:
+						if (start < 0)
+							sb.Append (description [i]);
+						break;
+				}
+			}
+			return sb.ToString ();
+		}
+
+		private static IEnumerable<string> GetLines (string description)
+		{
+			return StringCoda.WrappedLines (description, 
+					80 - OptionWidth, 
+					80 - OptionWidth - 2);
+		}
+	}
+}
+
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/Printing.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/Printing.cs	(revision 772)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/Printing.cs	(revision 772)
@@ -0,0 +1,79 @@
+﻿using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Drawing.Printing;
+using System.Drawing;
+using System.Data;
+using System.Drawing.Drawing2D;
+
+namespace IndianHealthService.ClinicalScheduling
+{
+    /// <summary>
+    /// Class that encapsulates printing functions in Clinical Scheduling
+    /// </summary>
+    public static class Printing
+    {
+        /// <summary>
+        /// Print Appointments
+        /// </summary>
+        /// <param name="ds">Strongly Typed DataSet contains Resources and Appointments</param>
+        /// <param name="e">PrintPageEventArgs from PrintDocument Print handler</param>
+        /// <param name="beg">Begin Datetime to print appointments</param>
+        /// <param name="end">End Datetime to print appointments</param>
+        /// <remarks>beg and end have no effect on operation--they are there for documentation for user only</remarks>
+        public static void PrintAppointments(dsPatientApptDisplay2 ds, PrintPageEventArgs e, DateTime beg, DateTime end,
+            int resourceToPrint, ref int apptPrinted)
+        {
+            Graphics g = e.Graphics;
+            //g.PageUnit = GraphicsUnit.Millimeter;
+            //SizeF szVCB = g.VisibleClipBounds.Size;
+            //PointF[] ptszVCB = {new PointF(szVCB.Width,szVCB.Height)};
+            //g.TransformPoints(CoordinateSpace.Page, CoordinateSpace.Device, ptszVCB);
+            //Create Fonts
+            Font f8 = new Font(FontFamily.GenericSerif, 8);
+            Font f10 = new Font(FontFamily.GenericSerif, 10);
+            Font f14bold = new Font(FontFamily.GenericSerif, 14, FontStyle.Bold);
+            
+            //Center Alignment for some stuff
+            StringFormat sf = new StringFormat();
+            sf.Alignment = StringAlignment.Center;
+            
+            g.DrawString("Confidential Patient Information", f8, Brushes.Black, e.PageBounds, sf);
+            
+            //Typical manipulable print area
+            Rectangle printArea = e.MarginBounds;
+            
+            dsPatientApptDisplay2.BSDXResourceRow r = ds.BSDXResource[resourceToPrint];
+            
+            string toprint;
+            if (beg == end) toprint = "Appointments for " + r.RESOURCE_NAME + " on " + beg.ToLongDateString();
+            else toprint = "Appointments for " + r.RESOURCE_NAME + " from " + beg.ToShortDateString() + " to "
+                + end.ToShortDateString();
+            g.DrawString(toprint, f14bold, Brushes.Black, printArea);
+            
+            printArea.Y += (int)f14bold.GetHeight();
+            g.DrawLine(new Pen(Brushes.Black, 0), printArea.X, printArea.Y, printArea.X + printArea.Width, printArea.Y);
+            printArea.Y += 5;
+            
+            System.Data.DataRow[] appts = r.GetChildRows(ds.Relations[0]); //only one relation
+
+            toprint = "";
+            StringFormat sf2 = new StringFormat();
+            sf2.SetTabStops(50, new float[] { 100, 200, 200 });
+
+            foreach (dsPatientApptDisplay2.PatientApptsRow a in appts)
+            {
+                toprint += a.ApptDate.ToString() + "\t" + a.Name +"(" + a.Sex + ")" + "\t" + "DOB: " + a.DOB.ToString("dd-MMM-yyyy") + "\t" + "ID: " + a.HRN;
+                toprint += "\n";
+                toprint += "Home Phone: " + a.HOMEPHONE + "\t" + "Address: " + a.STREET + ", " + a.CITY + ", " + a.STATE + " " + a.ZIP;
+                toprint += "\n";
+                toprint += "Note: " + a.NOTE;
+                toprint += "\n";
+                toprint += "Appointment made by " + a.APPT_MADE_BY + " on " + a.DATE_APPT_MADE;
+                toprint += "\n\n";
+            }
+            g.DrawString(toprint, f10, Brushes.Black, printArea, sf2);
+        }
+    }
+}
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/bin/Release/ClinicalScheduling.XML
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/bin/Release/ClinicalScheduling.XML	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/bin/Release/ClinicalScheduling.XML	(revision 772)
@@ -500,4 +500,19 @@
             </summary>
         </member>
+        <member name="T:IndianHealthService.ClinicalScheduling.Printing">
+            <summary>
+            Class that encapsulates printing functions in Clinical Scheduling
+            </summary>
+        </member>
+        <member name="M:IndianHealthService.ClinicalScheduling.Printing.PrintAppointments(IndianHealthService.ClinicalScheduling.dsPatientApptDisplay2,System.Drawing.Printing.PrintPageEventArgs,System.DateTime,System.DateTime,System.Int32,System.Int32@)">
+            <summary>
+            Print Appointments
+            </summary>
+            <param name="ds">Strongly Typed DataSet contains Resources and Appointments</param>
+            <param name="e">PrintPageEventArgs from PrintDocument Print handler</param>
+            <param name="beg">Begin Datetime to print appointments</param>
+            <param name="end">End Datetime to print appointments</param>
+            <remarks>beg and end have no effect on operation--they are there for documentation for user only</remarks>
+        </member>
         <member name="T:IndianHealthService.ClinicalScheduling.DResourceGroupItem">
             <summary>
@@ -676,6 +691,22 @@
         </member>
         <member name="T:IndianHealthService.ClinicalScheduling.DSelectLetterClinics">
-            <summary>
-            Summary description for DSelectLetterClinics.
+             <summary>
+             Use this dialog to select resources and dates (begin and end) for their examination.
+             <example>
+             DSelectLetterClinics ds = new DSelectLetterClinics();
+             ds.InitializePage(this.m_DocManager.GlobalDataSet, "Print Clinic Cancellation Letters");
+            	ds.ShowDialog(this) 					
+            
+             //get the resource names and call the letter printer
+            	string sClinics = ds.SelectedClinics;
+            	DateTime dtBegin = ds.BeginDate;
+            	DateTime dtEnd = ds.EndDate;
+             </example>
+             </summary>
+             
+        </member>
+        <member name="M:IndianHealthService.ClinicalScheduling.DSelectLetterClinics.#ctor">
+            <summary>
+            Ctor; also sets default enter and cancel buttons
             </summary>
         </member>
Index: heduling/trunk/cs/bsdx0200GUISourceCode/crAppointmentList.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/crAppointmentList.cs	(revision 771)
+++ 	(revision )
@@ -1,167 +1,0 @@
-﻿//------------------------------------------------------------------------------
-// <auto-generated>
-//     This code was generated by a tool.
-//     Runtime Version:2.0.50727.832
-//
-//     Changes to this file may cause incorrect behavior and will be lost if
-//     the code is regenerated.
-// </auto-generated>
-//------------------------------------------------------------------------------
-
-namespace IndianHealthService.ClinicalScheduling {
-    using System;
-    using System.ComponentModel;
-    using CrystalDecisions.Shared;
-    using CrystalDecisions.ReportSource;
-    using CrystalDecisions.CrystalReports.Engine;
-    
-    
-    public class crAppointmentList : ReportClass {
-        
-        public crAppointmentList() {
-        }
-        
-        public override string ResourceName {
-            get {
-                return "crAppointmentList.rpt";
-            }
-            set {
-                // Do nothing
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section1 {
-            get {
-                return this.ReportDefinition.Sections[0];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section2 {
-            get {
-                return this.ReportDefinition.Sections[1];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section6 {
-            get {
-                return this.ReportDefinition.Sections[2];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section8 {
-            get {
-                return this.ReportDefinition.Sections[3];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section3 {
-            get {
-                return this.ReportDefinition.Sections[4];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section9 {
-            get {
-                return this.ReportDefinition.Sections[5];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section7 {
-            get {
-                return this.ReportDefinition.Sections[6];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section4 {
-            get {
-                return this.ReportDefinition.Sections[7];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section5 {
-            get {
-                return this.ReportDefinition.Sections[8];
-            }
-        }
-    }
-    
-    [System.Drawing.ToolboxBitmapAttribute(typeof(CrystalDecisions.Shared.ExportOptions), "report.bmp")]
-    public class CachedcrAppointmentList : Component, ICachedReport {
-        
-        public CachedcrAppointmentList() {
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual bool IsCacheable {
-            get {
-                return true;
-            }
-            set {
-                // 
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual bool ShareDBLogonInfo {
-            get {
-                return false;
-            }
-            set {
-                // 
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual System.TimeSpan CacheTimeOut {
-            get {
-                return CachedReportConstants.DEFAULT_TIMEOUT;
-            }
-            set {
-                // 
-            }
-        }
-        
-        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
-            crAppointmentList rpt = new crAppointmentList();
-            rpt.Site = this.Site;
-            return rpt;
-        }
-        
-        public virtual string GetCustomizedCacheKey(RequestContext request) {
-            String key = null;
-            // // The following is the code used to generate the default
-            // // cache key for caching report jobs in the ASP.NET Cache.
-            // // Feel free to modify this code to suit your needs.
-            // // Returning key == null causes the default cache key to
-            // // be generated.
-            // 
-            // key = RequestContext.BuildCompleteCacheKey(
-            //     request,
-            //     null,       // sReportFilename
-            //     this.GetType(),
-            //     this.ShareDBLogonInfo );
-            return key;
-        }
-    }
-}
Index: heduling/trunk/cs/bsdx0200GUISourceCode/crCancelLetter.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/crCancelLetter.cs	(revision 771)
+++ 	(revision )
@@ -1,167 +1,0 @@
-﻿//------------------------------------------------------------------------------
-// <auto-generated>
-//     This code was generated by a tool.
-//     Runtime Version:2.0.50727.42
-//
-//     Changes to this file may cause incorrect behavior and will be lost if
-//     the code is regenerated.
-// </auto-generated>
-//------------------------------------------------------------------------------
-
-namespace IndianHealthService.ClinicalScheduling {
-    using System;
-    using System.ComponentModel;
-    using CrystalDecisions.Shared;
-    using CrystalDecisions.ReportSource;
-    using CrystalDecisions.CrystalReports.Engine;
-    
-    
-    public class crCancelLetter : ReportClass {
-        
-        public crCancelLetter() {
-        }
-        
-        public override string ResourceName {
-            get {
-                return "crCancelLetter.rpt";
-            }
-            set {
-                // Do nothing
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section1 {
-            get {
-                return this.ReportDefinition.Sections[0];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section2 {
-            get {
-                return this.ReportDefinition.Sections[1];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section3 {
-            get {
-                return this.ReportDefinition.Sections[2];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section7 {
-            get {
-                return this.ReportDefinition.Sections[3];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section SectionBody {
-            get {
-                return this.ReportDefinition.Sections[4];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section8 {
-            get {
-                return this.ReportDefinition.Sections[5];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section6 {
-            get {
-                return this.ReportDefinition.Sections[6];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section4 {
-            get {
-                return this.ReportDefinition.Sections[7];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section5 {
-            get {
-                return this.ReportDefinition.Sections[8];
-            }
-        }
-    }
-    
-    [System.Drawing.ToolboxBitmapAttribute(typeof(CrystalDecisions.Shared.ExportOptions), "report.bmp")]
-    public class CachedcrCancelLetter : Component, ICachedReport {
-        
-        public CachedcrCancelLetter() {
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual bool IsCacheable {
-            get {
-                return true;
-            }
-            set {
-                // 
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual bool ShareDBLogonInfo {
-            get {
-                return false;
-            }
-            set {
-                // 
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual System.TimeSpan CacheTimeOut {
-            get {
-                return CachedReportConstants.DEFAULT_TIMEOUT;
-            }
-            set {
-                // 
-            }
-        }
-        
-        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
-            crCancelLetter rpt = new crCancelLetter();
-            rpt.Site = this.Site;
-            return rpt;
-        }
-        
-        public virtual string GetCustomizedCacheKey(RequestContext request) {
-            String key = null;
-            // // The following is the code used to generate the default
-            // // cache key for caching report jobs in the ASP.NET Cache.
-            // // Feel free to modify this code to suit your needs.
-            // // Returning key == null causes the default cache key to
-            // // be generated.
-            // 
-            // key = RequestContext.BuildCompleteCacheKey(
-            //     request,
-            //     null,       // sReportFilename
-            //     this.GetType(),
-            //     this.ShareDBLogonInfo );
-            return key;
-        }
-    }
-}
Index: heduling/trunk/cs/bsdx0200GUISourceCode/crPatientLetter.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/crPatientLetter.cs	(revision 771)
+++ 	(revision )
@@ -1,167 +1,0 @@
-﻿//------------------------------------------------------------------------------
-// <auto-generated>
-//     This code was generated by a tool.
-//     Runtime Version:2.0.50727.42
-//
-//     Changes to this file may cause incorrect behavior and will be lost if
-//     the code is regenerated.
-// </auto-generated>
-//------------------------------------------------------------------------------
-
-namespace IndianHealthService.ClinicalScheduling {
-    using System;
-    using System.ComponentModel;
-    using CrystalDecisions.Shared;
-    using CrystalDecisions.ReportSource;
-    using CrystalDecisions.CrystalReports.Engine;
-    
-    
-    public class crPatientLetter : ReportClass {
-        
-        public crPatientLetter() {
-        }
-        
-        public override string ResourceName {
-            get {
-                return "crPatientLetter.rpt";
-            }
-            set {
-                // Do nothing
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section1 {
-            get {
-                return this.ReportDefinition.Sections[0];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section2 {
-            get {
-                return this.ReportDefinition.Sections[1];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section3 {
-            get {
-                return this.ReportDefinition.Sections[2];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section7 {
-            get {
-                return this.ReportDefinition.Sections[3];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section SectionBody {
-            get {
-                return this.ReportDefinition.Sections[4];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section8 {
-            get {
-                return this.ReportDefinition.Sections[5];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section6 {
-            get {
-                return this.ReportDefinition.Sections[6];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section4 {
-            get {
-                return this.ReportDefinition.Sections[7];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section5 {
-            get {
-                return this.ReportDefinition.Sections[8];
-            }
-        }
-    }
-    
-    [System.Drawing.ToolboxBitmapAttribute(typeof(CrystalDecisions.Shared.ExportOptions), "report.bmp")]
-    public class CachedcrPatientLetter : Component, ICachedReport {
-        
-        public CachedcrPatientLetter() {
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual bool IsCacheable {
-            get {
-                return true;
-            }
-            set {
-                // 
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual bool ShareDBLogonInfo {
-            get {
-                return false;
-            }
-            set {
-                // 
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual System.TimeSpan CacheTimeOut {
-            get {
-                return CachedReportConstants.DEFAULT_TIMEOUT;
-            }
-            set {
-                // 
-            }
-        }
-        
-        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
-            crPatientLetter rpt = new crPatientLetter();
-            rpt.Site = this.Site;
-            return rpt;
-        }
-        
-        public virtual string GetCustomizedCacheKey(RequestContext request) {
-            String key = null;
-            // // The following is the code used to generate the default
-            // // cache key for caching report jobs in the ASP.NET Cache.
-            // // Feel free to modify this code to suit your needs.
-            // // Returning key == null causes the default cache key to
-            // // be generated.
-            // 
-            // key = RequestContext.BuildCompleteCacheKey(
-            //     request,
-            //     null,       // sReportFilename
-            //     this.GetType(),
-            //     this.ShareDBLogonInfo );
-            return key;
-        }
-    }
-}
Index: heduling/trunk/cs/bsdx0200GUISourceCode/crRebookLetter.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/crRebookLetter.cs	(revision 771)
+++ 	(revision )
@@ -1,167 +1,0 @@
-﻿//------------------------------------------------------------------------------
-// <auto-generated>
-//     This code was generated by a tool.
-//     Runtime Version:2.0.50727.42
-//
-//     Changes to this file may cause incorrect behavior and will be lost if
-//     the code is regenerated.
-// </auto-generated>
-//------------------------------------------------------------------------------
-
-namespace IndianHealthService.ClinicalScheduling {
-    using System;
-    using System.ComponentModel;
-    using CrystalDecisions.Shared;
-    using CrystalDecisions.ReportSource;
-    using CrystalDecisions.CrystalReports.Engine;
-    
-    
-    public class crRebookLetter : ReportClass {
-        
-        public crRebookLetter() {
-        }
-        
-        public override string ResourceName {
-            get {
-                return "crRebookLetter.rpt";
-            }
-            set {
-                // Do nothing
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section1 {
-            get {
-                return this.ReportDefinition.Sections[0];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section2 {
-            get {
-                return this.ReportDefinition.Sections[1];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section3 {
-            get {
-                return this.ReportDefinition.Sections[2];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section7 {
-            get {
-                return this.ReportDefinition.Sections[3];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section SectionBody {
-            get {
-                return this.ReportDefinition.Sections[4];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section8 {
-            get {
-                return this.ReportDefinition.Sections[5];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section6 {
-            get {
-                return this.ReportDefinition.Sections[6];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section4 {
-            get {
-                return this.ReportDefinition.Sections[7];
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public CrystalDecisions.CrystalReports.Engine.Section Section5 {
-            get {
-                return this.ReportDefinition.Sections[8];
-            }
-        }
-    }
-    
-    [System.Drawing.ToolboxBitmapAttribute(typeof(CrystalDecisions.Shared.ExportOptions), "report.bmp")]
-    public class CachedcrRebookLetter : Component, ICachedReport {
-        
-        public CachedcrRebookLetter() {
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual bool IsCacheable {
-            get {
-                return true;
-            }
-            set {
-                // 
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual bool ShareDBLogonInfo {
-            get {
-                return false;
-            }
-            set {
-                // 
-            }
-        }
-        
-        [Browsable(false)]
-        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
-        public virtual System.TimeSpan CacheTimeOut {
-            get {
-                return CachedReportConstants.DEFAULT_TIMEOUT;
-            }
-            set {
-                // 
-            }
-        }
-        
-        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
-            crRebookLetter rpt = new crRebookLetter();
-            rpt.Site = this.Site;
-            return rpt;
-        }
-        
-        public virtual string GetCustomizedCacheKey(RequestContext request) {
-            String key = null;
-            // // The following is the code used to generate the default
-            // // cache key for caching report jobs in the ASP.NET Cache.
-            // // Feel free to modify this code to suit your needs.
-            // // Returning key == null causes the default cache key to
-            // // be generated.
-            // 
-            // key = RequestContext.BuildCompleteCacheKey(
-            //     request,
-            //     null,       // sReportFilename
-            //     this.GetType(),
-            //     this.ShareDBLogonInfo );
-            return key;
-        }
-    }
-}
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsPatientApptDisplay2.Designer.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsPatientApptDisplay2.Designer.cs	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsPatientApptDisplay2.Designer.cs	(revision 772)
@@ -2,5 +2,5 @@
 // <auto-generated>
 //     This code was generated by a tool.
-//     Runtime Version:2.0.50727.3053
+//     Runtime Version:2.0.50727.3603
 //
 //     Changes to this file may cause incorrect behavior and will be lost if
@@ -30,5 +30,5 @@
         private BSDXResourceDataTable tableBSDXResource;
         
-        private global::System.Data.DataRelation relationBSDXResourcePatientAppts;
+        private global::System.Data.DataRelation relationFK_BSDXResource_PatientAppts;
         
         private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
@@ -207,5 +207,5 @@
                 }
             }
-            this.relationBSDXResourcePatientAppts = this.Relations["BSDXResourcePatientAppts"];
+            this.relationFK_BSDXResource_PatientAppts = this.Relations["FK_BSDXResource_PatientAppts"];
         }
         
@@ -222,5 +222,5 @@
             base.Tables.Add(this.tableBSDXResource);
             global::System.Data.ForeignKeyConstraint fkc;
-            fkc = new global::System.Data.ForeignKeyConstraint("BSDXResourcePatientAppts", new global::System.Data.DataColumn[] {
+            fkc = new global::System.Data.ForeignKeyConstraint("FK_BSDXResource_PatientAppts", new global::System.Data.DataColumn[] {
                         this.tableBSDXResource.RESOURCEIDColumn}, new global::System.Data.DataColumn[] {
                         this.tablePatientAppts.RESOURCEIDColumn});
@@ -229,8 +229,8 @@
             fkc.DeleteRule = global::System.Data.Rule.Cascade;
             fkc.UpdateRule = global::System.Data.Rule.Cascade;
-            this.relationBSDXResourcePatientAppts = new global::System.Data.DataRelation("BSDXResourcePatientAppts", new global::System.Data.DataColumn[] {
+            this.relationFK_BSDXResource_PatientAppts = new global::System.Data.DataRelation("FK_BSDXResource_PatientAppts", new global::System.Data.DataColumn[] {
                         this.tableBSDXResource.RESOURCEIDColumn}, new global::System.Data.DataColumn[] {
                         this.tablePatientAppts.RESOURCEIDColumn}, false);
-            this.Relations.Add(this.relationBSDXResourcePatientAppts);
+            this.Relations.Add(this.relationFK_BSDXResource_PatientAppts);
         }
         
@@ -521,5 +521,5 @@
                         string Clinic, 
                         string TypeStatus, 
-                        BSDXResourceRow parentBSDXResourceRowByBSDXResourcePatientAppts, 
+                        BSDXResourceRow parentBSDXResourceRowByFK_BSDXResource_PatientAppts, 
                         string APPT_MADE_BY, 
                         System.DateTime DATE_APPT_MADE, 
@@ -548,6 +548,6 @@
                         ZIP,
                         HOMEPHONE};
-                if ((parentBSDXResourceRowByBSDXResourcePatientAppts != null)) {
-                    columnValuesArray[7] = parentBSDXResourceRowByBSDXResourcePatientAppts[0];
+                if ((parentBSDXResourceRowByFK_BSDXResource_PatientAppts != null)) {
+                    columnValuesArray[7] = parentBSDXResourceRowByFK_BSDXResource_PatientAppts[0];
                 }
                 rowPatientApptsRow.ItemArray = columnValuesArray;
@@ -604,5 +604,5 @@
                 this.columnTypeStatus = new global::System.Data.DataColumn("TypeStatus", typeof(string), null, global::System.Data.MappingType.Element);
                 base.Columns.Add(this.columnTypeStatus);
-                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(uint), null, global::System.Data.MappingType.Element);
+                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(int), null, global::System.Data.MappingType.Element);
                 base.Columns.Add(this.columnRESOURCEID);
                 this.columnAPPT_MADE_BY = new global::System.Data.DataColumn("APPT_MADE_BY", typeof(string), null, global::System.Data.MappingType.Element);
@@ -833,5 +833,5 @@
             
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
-            public BSDXResourceRow AddBSDXResourceRow(uint RESOURCEID, string RESOURCE_NAME, string LETTER_TEXT) {
+            public BSDXResourceRow AddBSDXResourceRow(int RESOURCEID, string RESOURCE_NAME, string LETTER_TEXT) {
                 BSDXResourceRow rowBSDXResourceRow = ((BSDXResourceRow)(this.NewRow()));
                 object[] columnValuesArray = new object[] {
@@ -865,5 +865,5 @@
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
             private void InitClass() {
-                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(uint), null, global::System.Data.MappingType.Element);
+                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(int), null, global::System.Data.MappingType.Element);
                 base.Columns.Add(this.columnRESOURCEID);
                 this.columnRESOURCE_NAME = new global::System.Data.DataColumn("RESOURCE_NAME", typeof(string), null, global::System.Data.MappingType.Element);
@@ -1112,8 +1112,8 @@
             
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
-            public uint RESOURCEID {
-                get {
-                    try {
-                        return ((uint)(this[this.tablePatientAppts.RESOURCEIDColumn]));
+            public int RESOURCEID {
+                get {
+                    try {
+                        return ((int)(this[this.tablePatientAppts.RESOURCEIDColumn]));
                     }
                     catch (global::System.InvalidCastException e) {
@@ -1249,8 +1249,8 @@
             public BSDXResourceRow BSDXResourceRow {
                 get {
-                    return ((BSDXResourceRow)(this.GetParentRow(this.Table.ParentRelations["BSDXResourcePatientAppts"])));
-                }
-                set {
-                    this.SetParentRow(value, this.Table.ParentRelations["BSDXResourcePatientAppts"]);
+                    return ((BSDXResourceRow)(this.GetParentRow(this.Table.ParentRelations["FK_BSDXResource_PatientAppts"])));
+                }
+                set {
+                    this.SetParentRow(value, this.Table.ParentRelations["FK_BSDXResource_PatientAppts"]);
                 }
             }
@@ -1432,7 +1432,7 @@
             
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
-            public uint RESOURCEID {
-                get {
-                    return ((uint)(this[this.tableBSDXResource.RESOURCEIDColumn]));
+            public int RESOURCEID {
+                get {
+                    return ((int)(this[this.tableBSDXResource.RESOURCEIDColumn]));
                 }
                 set {
@@ -1493,9 +1493,9 @@
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
             public PatientApptsRow[] GetPatientApptsRows() {
-                if ((this.Table.ChildRelations["BSDXResourcePatientAppts"] == null)) {
+                if ((this.Table.ChildRelations["FK_BSDXResource_PatientAppts"] == null)) {
                     return new PatientApptsRow[0];
                 }
                 else {
-                    return ((PatientApptsRow[])(base.GetChildRows(this.Table.ChildRelations["BSDXResourcePatientAppts"])));
+                    return ((PatientApptsRow[])(base.GetChildRows(this.Table.ChildRelations["FK_BSDXResource_PatientAppts"])));
                 }
             }
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsPatientApptDisplay2.xsd
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsPatientApptDisplay2.xsd	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsPatientApptDisplay2.xsd	(revision 772)
@@ -1,51 +1,57 @@
-<?xml version="1.0" encoding="utf-8" ?>
-<xs:schema id="dsPatientApptDisplay2" targetNamespace="http://tempuri.org/dsPatientApptDisplay2.xsd"
-	elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/dsPatientApptDisplay2.xsd"
-	xmlns:mstns="http://tempuri.org/dsPatientApptDisplay2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema"
-	xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
-	<xs:element name="dsPatientApptDisplay2" msdata:IsDataSet="true">
-		<xs:complexType>
-			<xs:choice maxOccurs="unbounded">
-				<xs:element name="PatientAppts">
-					<xs:complexType>
-						<xs:sequence>
-							<xs:element name="Name" type="xs:string" minOccurs="0" />
-							<xs:element name="DOB" type="xs:date" minOccurs="0" />
-							<xs:element name="Sex" type="xs:string" minOccurs="0" />
-							<xs:element name="HRN" type="xs:string" minOccurs="0" />
-							<xs:element name="ApptDate" type="xs:date" minOccurs="0" />
-							<xs:element name="Clinic" type="xs:string" minOccurs="0" />
-							<xs:element name="TypeStatus" type="xs:string" minOccurs="0" />
-							<xs:element name="RESOURCEID" type="xs:unsignedInt" minOccurs="0" />
-							<xs:element name="APPT_MADE_BY" type="xs:string" minOccurs="0" />
-							<xs:element name="DATE_APPT_MADE" type="xs:date" minOccurs="0" />
-							<xs:element name="NOTE" type="xs:string" minOccurs="0" />
-							<xs:element name="STREET" type="xs:string" minOccurs="0" />
-							<xs:element name="CITY" type="xs:string" minOccurs="0" />
-							<xs:element name="STATE" type="xs:string" minOccurs="0" />
-							<xs:element name="ZIP" type="xs:string" minOccurs="0" />
-							<xs:element name="HOMEPHONE" type="xs:string" minOccurs="0" />
-						</xs:sequence>
-					</xs:complexType>
-				</xs:element>
-				<xs:element name="BSDXResource">
-					<xs:complexType>
-						<xs:sequence>
-							<xs:element name="RESOURCEID" type="xs:unsignedInt" minOccurs="0" />
-							<xs:element name="RESOURCE_NAME" type="xs:string" minOccurs="0" />
-							<xs:element name="LETTER_TEXT" type="xs:string" minOccurs="0" />
-						</xs:sequence>
-					</xs:complexType>
-				</xs:element>
-			</xs:choice>
-		</xs:complexType>
-		<xs:key name="kBSDXResourceID">
-			<xs:selector xpath=".//mstns:BSDXResource" />
-			<xs:field xpath="mstns:RESOURCEID" />
-		</xs:key>
-		<xs:keyref name="BSDXResourcePatientAppts" refer="kBSDXResourceID">
-			<xs:selector xpath=".//mstns:PatientAppts" />
-			<xs:field xpath="mstns:RESOURCEID" />
-		</xs:keyref>
-	</xs:element>
+<?xml version="1.0" encoding="utf-8"?>
+<xs:schema id="dsPatientApptDisplay2" targetNamespace="http://tempuri.org/dsPatientApptDisplay2.xsd" xmlns:mstns="http://tempuri.org/dsPatientApptDisplay2.xsd" xmlns="http://tempuri.org/dsPatientApptDisplay2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
+  <xs:annotation>
+    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
+      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
+        <Connections />
+        <Tables />
+        <Sources />
+      </DataSource>
+    </xs:appinfo>
+  </xs:annotation>
+  <xs:element name="dsPatientApptDisplay2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsPatientApptDisplay2" msprop:Generator_DataSetName="dsPatientApptDisplay2">
+    <xs:complexType>
+      <xs:choice minOccurs="0" maxOccurs="unbounded">
+        <xs:element name="PatientAppts" msprop:Generator_UserTableName="PatientAppts" msprop:Generator_RowDeletedName="PatientApptsRowDeleted" msprop:Generator_TableClassName="PatientApptsDataTable" msprop:Generator_RowChangedName="PatientApptsRowChanged" msprop:Generator_RowClassName="PatientApptsRow" msprop:Generator_RowChangingName="PatientApptsRowChanging" msprop:Generator_RowEvArgName="PatientApptsRowChangeEvent" msprop:Generator_RowEvHandlerName="PatientApptsRowChangeEventHandler" msprop:Generator_TablePropName="PatientAppts" msprop:Generator_TableVarName="tablePatientAppts" msprop:Generator_RowDeletingName="PatientApptsRowDeleting">
+          <xs:complexType>
+            <xs:sequence>
+              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="DOB" msprop:Generator_UserColumnName="DOB" msprop:Generator_ColumnPropNameInRow="DOB" msprop:Generator_ColumnVarNameInTable="columnDOB" msprop:Generator_ColumnPropNameInTable="DOBColumn" type="xs:date" minOccurs="0" />
+              <xs:element name="Sex" msprop:Generator_UserColumnName="Sex" msprop:Generator_ColumnPropNameInRow="Sex" msprop:Generator_ColumnVarNameInTable="columnSex" msprop:Generator_ColumnPropNameInTable="SexColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="HRN" msprop:Generator_UserColumnName="HRN" msprop:Generator_ColumnPropNameInRow="HRN" msprop:Generator_ColumnVarNameInTable="columnHRN" msprop:Generator_ColumnPropNameInTable="HRNColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="ApptDate" msprop:Generator_UserColumnName="ApptDate" msprop:Generator_ColumnPropNameInRow="ApptDate" msprop:Generator_ColumnVarNameInTable="columnApptDate" msprop:Generator_ColumnPropNameInTable="ApptDateColumn" type="xs:date" minOccurs="0" />
+              <xs:element name="Clinic" msprop:Generator_UserColumnName="Clinic" msprop:Generator_ColumnPropNameInRow="Clinic" msprop:Generator_ColumnVarNameInTable="columnClinic" msprop:Generator_ColumnPropNameInTable="ClinicColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="TypeStatus" msprop:Generator_UserColumnName="TypeStatus" msprop:Generator_ColumnPropNameInRow="TypeStatus" msprop:Generator_ColumnVarNameInTable="columnTypeStatus" msprop:Generator_ColumnPropNameInTable="TypeStatusColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="RESOURCEID" msprop:Generator_UserColumnName="RESOURCEID" msprop:Generator_ColumnPropNameInRow="RESOURCEID" msprop:Generator_ColumnVarNameInTable="columnRESOURCEID" msprop:Generator_ColumnPropNameInTable="RESOURCEIDColumn" type="xs:int" minOccurs="0" />
+              <xs:element name="APPT_MADE_BY" msprop:Generator_UserColumnName="APPT_MADE_BY" msprop:Generator_ColumnPropNameInRow="APPT_MADE_BY" msprop:Generator_ColumnVarNameInTable="columnAPPT_MADE_BY" msprop:Generator_ColumnPropNameInTable="APPT_MADE_BYColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="DATE_APPT_MADE" msprop:Generator_UserColumnName="DATE_APPT_MADE" msprop:Generator_ColumnPropNameInRow="DATE_APPT_MADE" msprop:Generator_ColumnVarNameInTable="columnDATE_APPT_MADE" msprop:Generator_ColumnPropNameInTable="DATE_APPT_MADEColumn" type="xs:date" minOccurs="0" />
+              <xs:element name="NOTE" msprop:Generator_UserColumnName="NOTE" msprop:Generator_ColumnPropNameInRow="NOTE" msprop:Generator_ColumnVarNameInTable="columnNOTE" msprop:Generator_ColumnPropNameInTable="NOTEColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="STREET" msprop:Generator_UserColumnName="STREET" msprop:Generator_ColumnPropNameInRow="STREET" msprop:Generator_ColumnVarNameInTable="columnSTREET" msprop:Generator_ColumnPropNameInTable="STREETColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="CITY" msprop:Generator_UserColumnName="CITY" msprop:Generator_ColumnPropNameInRow="CITY" msprop:Generator_ColumnVarNameInTable="columnCITY" msprop:Generator_ColumnPropNameInTable="CITYColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="STATE" msprop:Generator_UserColumnName="STATE" msprop:Generator_ColumnPropNameInRow="STATE" msprop:Generator_ColumnVarNameInTable="columnSTATE" msprop:Generator_ColumnPropNameInTable="STATEColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="ZIP" msprop:Generator_UserColumnName="ZIP" msprop:Generator_ColumnPropNameInRow="ZIP" msprop:Generator_ColumnVarNameInTable="columnZIP" msprop:Generator_ColumnPropNameInTable="ZIPColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="HOMEPHONE" msprop:Generator_UserColumnName="HOMEPHONE" msprop:Generator_ColumnPropNameInRow="HOMEPHONE" msprop:Generator_ColumnVarNameInTable="columnHOMEPHONE" msprop:Generator_ColumnPropNameInTable="HOMEPHONEColumn" type="xs:string" minOccurs="0" />
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>
+        <xs:element name="BSDXResource" msprop:Generator_UserTableName="BSDXResource" msprop:Generator_RowDeletedName="BSDXResourceRowDeleted" msprop:Generator_TableClassName="BSDXResourceDataTable" msprop:Generator_RowChangedName="BSDXResourceRowChanged" msprop:Generator_RowClassName="BSDXResourceRow" msprop:Generator_RowChangingName="BSDXResourceRowChanging" msprop:Generator_RowEvArgName="BSDXResourceRowChangeEvent" msprop:Generator_RowEvHandlerName="BSDXResourceRowChangeEventHandler" msprop:Generator_TablePropName="BSDXResource" msprop:Generator_TableVarName="tableBSDXResource" msprop:Generator_RowDeletingName="BSDXResourceRowDeleting">
+          <xs:complexType>
+            <xs:sequence>
+              <xs:element name="RESOURCEID" msprop:Generator_UserColumnName="RESOURCEID" msprop:Generator_ColumnPropNameInRow="RESOURCEID" msprop:Generator_ColumnVarNameInTable="columnRESOURCEID" msprop:Generator_ColumnPropNameInTable="RESOURCEIDColumn" type="xs:int" />
+              <xs:element name="RESOURCE_NAME" msprop:Generator_UserColumnName="RESOURCE_NAME" msprop:Generator_ColumnPropNameInRow="RESOURCE_NAME" msprop:Generator_ColumnVarNameInTable="columnRESOURCE_NAME" msprop:Generator_ColumnPropNameInTable="RESOURCE_NAMEColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="LETTER_TEXT" msprop:Generator_UserColumnName="LETTER_TEXT" msprop:Generator_ColumnPropNameInRow="LETTER_TEXT" msprop:Generator_ColumnVarNameInTable="columnLETTER_TEXT" msprop:Generator_ColumnPropNameInTable="LETTER_TEXTColumn" type="xs:string" minOccurs="0" />
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>
+      </xs:choice>
+    </xs:complexType>
+    <xs:unique name="kBSDXResourceID">
+      <xs:selector xpath=".//mstns:BSDXResource" />
+      <xs:field xpath="mstns:RESOURCEID" />
+    </xs:unique>
+    <xs:keyref name="FK_BSDXResource_PatientAppts" refer="kBSDXResourceID" msprop:rel_Generator_UserRelationName="FK_BSDXResource_PatientAppts" msprop:rel_Generator_RelationVarName="relationFK_BSDXResource_PatientAppts" msprop:rel_Generator_UserChildTable="PatientAppts" msprop:rel_Generator_UserParentTable="BSDXResource" msprop:rel_Generator_ParentPropName="BSDXResourceRow" msprop:rel_Generator_ChildPropName="GetPatientApptsRows">
+      <xs:selector xpath=".//mstns:PatientAppts" />
+      <xs:field xpath="mstns:RESOURCEID" />
+    </xs:keyref>
+  </xs:element>
 </xs:schema>
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.Designer.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.Designer.cs	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.Designer.cs	(revision 772)
@@ -2,5 +2,5 @@
 // <auto-generated>
 //     This code was generated by a tool.
-//     Runtime Version:2.0.50727.3053
+//     Runtime Version:2.0.50727.3603
 //
 //     Changes to this file may cause incorrect behavior and will be lost if
@@ -30,5 +30,5 @@
         private BSDXResourceDataTable tableBSDXResource;
         
-        private global::System.Data.DataRelation relationBSDXResourcePatientAppts;
+        private global::System.Data.DataRelation relationFK_BSDXResource_PatientAppts;
         
         private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
@@ -207,5 +207,5 @@
                 }
             }
-            this.relationBSDXResourcePatientAppts = this.Relations["BSDXResourcePatientAppts"];
+            this.relationFK_BSDXResource_PatientAppts = this.Relations["FK_BSDXResource_PatientAppts"];
         }
         
@@ -222,5 +222,5 @@
             base.Tables.Add(this.tableBSDXResource);
             global::System.Data.ForeignKeyConstraint fkc;
-            fkc = new global::System.Data.ForeignKeyConstraint("BSDXResourcePatientAppts", new global::System.Data.DataColumn[] {
+            fkc = new global::System.Data.ForeignKeyConstraint("FK_BSDXResource_PatientAppts", new global::System.Data.DataColumn[] {
                         this.tableBSDXResource.RESOURCEIDColumn}, new global::System.Data.DataColumn[] {
                         this.tablePatientAppts.RESOURCEIDColumn});
@@ -229,8 +229,8 @@
             fkc.DeleteRule = global::System.Data.Rule.Cascade;
             fkc.UpdateRule = global::System.Data.Rule.Cascade;
-            this.relationBSDXResourcePatientAppts = new global::System.Data.DataRelation("BSDXResourcePatientAppts", new global::System.Data.DataColumn[] {
+            this.relationFK_BSDXResource_PatientAppts = new global::System.Data.DataRelation("FK_BSDXResource_PatientAppts", new global::System.Data.DataColumn[] {
                         this.tableBSDXResource.RESOURCEIDColumn}, new global::System.Data.DataColumn[] {
                         this.tablePatientAppts.RESOURCEIDColumn}, false);
-            this.Relations.Add(this.relationBSDXResourcePatientAppts);
+            this.Relations.Add(this.relationFK_BSDXResource_PatientAppts);
         }
         
@@ -530,5 +530,5 @@
                         string Clinic, 
                         string TypeStatus, 
-                        BSDXResourceRow parentBSDXResourceRowByBSDXResourcePatientAppts, 
+                        BSDXResourceRow parentBSDXResourceRowByFK_BSDXResource_PatientAppts, 
                         string APPT_MADE_BY, 
                         System.DateTime DATE_APPT_MADE, 
@@ -559,6 +559,6 @@
                         HOMEPHONE,
                         OldApptDate};
-                if ((parentBSDXResourceRowByBSDXResourcePatientAppts != null)) {
-                    columnValuesArray[7] = parentBSDXResourceRowByBSDXResourcePatientAppts[0];
+                if ((parentBSDXResourceRowByFK_BSDXResource_PatientAppts != null)) {
+                    columnValuesArray[7] = parentBSDXResourceRowByFK_BSDXResource_PatientAppts[0];
                 }
                 rowPatientApptsRow.ItemArray = columnValuesArray;
@@ -616,5 +616,5 @@
                 this.columnTypeStatus = new global::System.Data.DataColumn("TypeStatus", typeof(string), null, global::System.Data.MappingType.Element);
                 base.Columns.Add(this.columnTypeStatus);
-                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(uint), null, global::System.Data.MappingType.Element);
+                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(int), null, global::System.Data.MappingType.Element);
                 base.Columns.Add(this.columnRESOURCEID);
                 this.columnAPPT_MADE_BY = new global::System.Data.DataColumn("APPT_MADE_BY", typeof(string), null, global::System.Data.MappingType.Element);
@@ -865,5 +865,5 @@
             
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
-            public BSDXResourceRow AddBSDXResourceRow(uint RESOURCEID, string RESOURCE_NAME, string LETTER_TEXT, string NO_SHOW_LETTER, string CLINIC_CANCELLATION_LETTER) {
+            public BSDXResourceRow AddBSDXResourceRow(int RESOURCEID, string RESOURCE_NAME, string LETTER_TEXT, string NO_SHOW_LETTER, string CLINIC_CANCELLATION_LETTER) {
                 BSDXResourceRow rowBSDXResourceRow = ((BSDXResourceRow)(this.NewRow()));
                 object[] columnValuesArray = new object[] {
@@ -901,5 +901,5 @@
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
             private void InitClass() {
-                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(uint), null, global::System.Data.MappingType.Element);
+                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(int), null, global::System.Data.MappingType.Element);
                 base.Columns.Add(this.columnRESOURCEID);
                 this.columnRESOURCE_NAME = new global::System.Data.DataColumn("RESOURCE_NAME", typeof(string), null, global::System.Data.MappingType.Element);
@@ -1152,8 +1152,8 @@
             
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
-            public uint RESOURCEID {
-                get {
-                    try {
-                        return ((uint)(this[this.tablePatientAppts.RESOURCEIDColumn]));
+            public int RESOURCEID {
+                get {
+                    try {
+                        return ((int)(this[this.tablePatientAppts.RESOURCEIDColumn]));
                     }
                     catch (global::System.InvalidCastException e) {
@@ -1304,8 +1304,8 @@
             public BSDXResourceRow BSDXResourceRow {
                 get {
-                    return ((BSDXResourceRow)(this.GetParentRow(this.Table.ParentRelations["BSDXResourcePatientAppts"])));
-                }
-                set {
-                    this.SetParentRow(value, this.Table.ParentRelations["BSDXResourcePatientAppts"]);
+                    return ((BSDXResourceRow)(this.GetParentRow(this.Table.ParentRelations["FK_BSDXResource_PatientAppts"])));
+                }
+                set {
+                    this.SetParentRow(value, this.Table.ParentRelations["FK_BSDXResource_PatientAppts"]);
                 }
             }
@@ -1497,7 +1497,7 @@
             
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
-            public uint RESOURCEID {
-                get {
-                    return ((uint)(this[this.tableBSDXResource.RESOURCEIDColumn]));
+            public int RESOURCEID {
+                get {
+                    return ((int)(this[this.tableBSDXResource.RESOURCEIDColumn]));
                 }
                 set {
@@ -1609,9 +1609,9 @@
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
             public PatientApptsRow[] GetPatientApptsRows() {
-                if ((this.Table.ChildRelations["BSDXResourcePatientAppts"] == null)) {
+                if ((this.Table.ChildRelations["FK_BSDXResource_PatientAppts"] == null)) {
                     return new PatientApptsRow[0];
                 }
                 else {
-                    return ((PatientApptsRow[])(base.GetChildRows(this.Table.ChildRelations["BSDXResourcePatientAppts"])));
+                    return ((PatientApptsRow[])(base.GetChildRows(this.Table.ChildRelations["FK_BSDXResource_PatientAppts"])));
                 }
             }
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.cs
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.cs	(revision 772)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.cs	(revision 772)
@@ -0,0 +1,9 @@
+﻿namespace IndianHealthService.ClinicalScheduling {
+    
+    
+    public partial class dsRebookAppts {
+        partial class BSDXResourceDataTable
+        {
+        }
+    }
+}
Index: /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.xsd
===================================================================
--- /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.xsd	(revision 771)
+++ /Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.xsd	(revision 772)
@@ -1,53 +1,60 @@
-<?xml version="1.0" encoding="utf-8" ?>
-<xs:schema id="dsRebookAppts" targetNamespace="http://tempuri.org/dsRebookAppts.xsd" elementFormDefault="qualified"
-	attributeFormDefault="qualified" xmlns="http://tempuri.org/dsRebookAppts.xsd" xmlns:mstns="http://tempuri.org/dsRebookAppts.xsd"
-	xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
-	<xs:element name="dsRebookAppts" msdata:IsDataSet="true">
-		<xs:complexType>
-			<xs:choice maxOccurs="unbounded">
-				<xs:element name="PatientAppts">
-					<xs:complexType>
-						<xs:sequence>
-							<xs:element name="Name" type="xs:string" minOccurs="0" />
-							<xs:element name="DOB" type="xs:date" minOccurs="0" />
-							<xs:element name="Sex" type="xs:string" minOccurs="0" />
-							<xs:element name="HRN" type="xs:string" minOccurs="0" />
-							<xs:element name="NewApptDate" type="xs:date" minOccurs="0" />
-							<xs:element name="Clinic" type="xs:string" minOccurs="0" />
-							<xs:element name="TypeStatus" type="xs:string" minOccurs="0" />
-							<xs:element name="RESOURCEID" type="xs:unsignedInt" minOccurs="0" />
-							<xs:element name="APPT_MADE_BY" type="xs:string" minOccurs="0" />
-							<xs:element name="DATE_APPT_MADE" type="xs:date" minOccurs="0" />
-							<xs:element name="NOTE" type="xs:string" minOccurs="0" />
-							<xs:element name="STREET" type="xs:string" minOccurs="0" />
-							<xs:element name="CITY" type="xs:string" minOccurs="0" />
-							<xs:element name="STATE" type="xs:string" minOccurs="0" />
-							<xs:element name="ZIP" type="xs:string" minOccurs="0" />
-							<xs:element name="HOMEPHONE" type="xs:string" minOccurs="0" />
-							<xs:element name="OldApptDate" type="xs:date" minOccurs="0" />
-						</xs:sequence>
-					</xs:complexType>
-				</xs:element>
-				<xs:element name="BSDXResource">
-					<xs:complexType>
-						<xs:sequence>
-							<xs:element name="RESOURCEID" type="xs:unsignedInt" minOccurs="0" />
-							<xs:element name="RESOURCE_NAME" type="xs:string" minOccurs="0" />
-							<xs:element name="LETTER_TEXT" type="xs:string" minOccurs="0" />
-							<xs:element name="NO_SHOW_LETTER" type="xs:string" minOccurs="0" />
-							<xs:element name="CLINIC_CANCELLATION_LETTER" type="xs:string" minOccurs="0" />
-						</xs:sequence>
-					</xs:complexType>
-				</xs:element>
-			</xs:choice>
-		</xs:complexType>
-		<xs:key name="kBSDXResourceID">
-			<xs:selector xpath=".//mstns:BSDXResource" />
-			<xs:field xpath="mstns:RESOURCEID" />
-		</xs:key>
-		<xs:keyref name="BSDXResourcePatientAppts" refer="kBSDXResourceID">
-			<xs:selector xpath=".//mstns:PatientAppts" />
-			<xs:field xpath="mstns:RESOURCEID" />
-		</xs:keyref>
-	</xs:element>
+<?xml version="1.0" encoding="utf-8"?>
+<xs:schema id="dsRebookAppts" targetNamespace="http://tempuri.org/dsRebookAppts.xsd" xmlns:mstns="http://tempuri.org/dsRebookAppts.xsd" xmlns="http://tempuri.org/dsRebookAppts.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
+  <xs:annotation>
+    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
+      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
+        <Connections />
+        <Tables />
+        <Sources />
+      </DataSource>
+    </xs:appinfo>
+  </xs:annotation>
+  <xs:element name="dsRebookAppts" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsRebookAppts" msprop:Generator_DataSetName="dsRebookAppts">
+    <xs:complexType>
+      <xs:choice minOccurs="0" maxOccurs="unbounded">
+        <xs:element name="PatientAppts" msprop:Generator_UserTableName="PatientAppts" msprop:Generator_RowDeletedName="PatientApptsRowDeleted" msprop:Generator_TableClassName="PatientApptsDataTable" msprop:Generator_RowChangedName="PatientApptsRowChanged" msprop:Generator_RowClassName="PatientApptsRow" msprop:Generator_RowChangingName="PatientApptsRowChanging" msprop:Generator_RowEvArgName="PatientApptsRowChangeEvent" msprop:Generator_RowEvHandlerName="PatientApptsRowChangeEventHandler" msprop:Generator_TablePropName="PatientAppts" msprop:Generator_TableVarName="tablePatientAppts" msprop:Generator_RowDeletingName="PatientApptsRowDeleting">
+          <xs:complexType>
+            <xs:sequence>
+              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="DOB" msprop:Generator_UserColumnName="DOB" msprop:Generator_ColumnPropNameInRow="DOB" msprop:Generator_ColumnVarNameInTable="columnDOB" msprop:Generator_ColumnPropNameInTable="DOBColumn" type="xs:date" minOccurs="0" />
+              <xs:element name="Sex" msprop:Generator_UserColumnName="Sex" msprop:Generator_ColumnPropNameInRow="Sex" msprop:Generator_ColumnVarNameInTable="columnSex" msprop:Generator_ColumnPropNameInTable="SexColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="HRN" msprop:Generator_UserColumnName="HRN" msprop:Generator_ColumnPropNameInRow="HRN" msprop:Generator_ColumnVarNameInTable="columnHRN" msprop:Generator_ColumnPropNameInTable="HRNColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="NewApptDate" msprop:Generator_UserColumnName="NewApptDate" msprop:Generator_ColumnPropNameInRow="NewApptDate" msprop:Generator_ColumnVarNameInTable="columnNewApptDate" msprop:Generator_ColumnPropNameInTable="NewApptDateColumn" type="xs:date" minOccurs="0" />
+              <xs:element name="Clinic" msprop:Generator_UserColumnName="Clinic" msprop:Generator_ColumnPropNameInRow="Clinic" msprop:Generator_ColumnVarNameInTable="columnClinic" msprop:Generator_ColumnPropNameInTable="ClinicColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="TypeStatus" msprop:Generator_UserColumnName="TypeStatus" msprop:Generator_ColumnPropNameInRow="TypeStatus" msprop:Generator_ColumnVarNameInTable="columnTypeStatus" msprop:Generator_ColumnPropNameInTable="TypeStatusColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="RESOURCEID" msprop:Generator_UserColumnName="RESOURCEID" msprop:Generator_ColumnPropNameInRow="RESOURCEID" msprop:Generator_ColumnVarNameInTable="columnRESOURCEID" msprop:Generator_ColumnPropNameInTable="RESOURCEIDColumn" type="xs:int" minOccurs="0" />
+              <xs:element name="APPT_MADE_BY" msprop:Generator_UserColumnName="APPT_MADE_BY" msprop:Generator_ColumnPropNameInRow="APPT_MADE_BY" msprop:Generator_ColumnVarNameInTable="columnAPPT_MADE_BY" msprop:Generator_ColumnPropNameInTable="APPT_MADE_BYColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="DATE_APPT_MADE" msprop:Generator_UserColumnName="DATE_APPT_MADE" msprop:Generator_ColumnPropNameInRow="DATE_APPT_MADE" msprop:Generator_ColumnVarNameInTable="columnDATE_APPT_MADE" msprop:Generator_ColumnPropNameInTable="DATE_APPT_MADEColumn" type="xs:date" minOccurs="0" />
+              <xs:element name="NOTE" msprop:Generator_UserColumnName="NOTE" msprop:Generator_ColumnPropNameInRow="NOTE" msprop:Generator_ColumnVarNameInTable="columnNOTE" msprop:Generator_ColumnPropNameInTable="NOTEColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="STREET" msprop:Generator_UserColumnName="STREET" msprop:Generator_ColumnPropNameInRow="STREET" msprop:Generator_ColumnVarNameInTable="columnSTREET" msprop:Generator_ColumnPropNameInTable="STREETColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="CITY" msprop:Generator_UserColumnName="CITY" msprop:Generator_ColumnPropNameInRow="CITY" msprop:Generator_ColumnVarNameInTable="columnCITY" msprop:Generator_ColumnPropNameInTable="CITYColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="STATE" msprop:Generator_UserColumnName="STATE" msprop:Generator_ColumnPropNameInRow="STATE" msprop:Generator_ColumnVarNameInTable="columnSTATE" msprop:Generator_ColumnPropNameInTable="STATEColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="ZIP" msprop:Generator_UserColumnName="ZIP" msprop:Generator_ColumnPropNameInRow="ZIP" msprop:Generator_ColumnVarNameInTable="columnZIP" msprop:Generator_ColumnPropNameInTable="ZIPColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="HOMEPHONE" msprop:Generator_UserColumnName="HOMEPHONE" msprop:Generator_ColumnPropNameInRow="HOMEPHONE" msprop:Generator_ColumnVarNameInTable="columnHOMEPHONE" msprop:Generator_ColumnPropNameInTable="HOMEPHONEColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="OldApptDate" msprop:Generator_UserColumnName="OldApptDate" msprop:Generator_ColumnPropNameInRow="OldApptDate" msprop:Generator_ColumnVarNameInTable="columnOldApptDate" msprop:Generator_ColumnPropNameInTable="OldApptDateColumn" type="xs:date" minOccurs="0" />
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>
+        <xs:element name="BSDXResource" msprop:Generator_UserTableName="BSDXResource" msprop:Generator_RowDeletedName="BSDXResourceRowDeleted" msprop:Generator_TableClassName="BSDXResourceDataTable" msprop:Generator_RowChangedName="BSDXResourceRowChanged" msprop:Generator_RowClassName="BSDXResourceRow" msprop:Generator_RowChangingName="BSDXResourceRowChanging" msprop:Generator_RowEvArgName="BSDXResourceRowChangeEvent" msprop:Generator_RowEvHandlerName="BSDXResourceRowChangeEventHandler" msprop:Generator_TablePropName="BSDXResource" msprop:Generator_TableVarName="tableBSDXResource" msprop:Generator_RowDeletingName="BSDXResourceRowDeleting">
+          <xs:complexType>
+            <xs:sequence>
+              <xs:element name="RESOURCEID" msprop:Generator_UserColumnName="RESOURCEID" msprop:Generator_ColumnPropNameInRow="RESOURCEID" msprop:Generator_ColumnVarNameInTable="columnRESOURCEID" msprop:Generator_ColumnPropNameInTable="RESOURCEIDColumn" type="xs:int" />
+              <xs:element name="RESOURCE_NAME" msprop:Generator_UserColumnName="RESOURCE_NAME" msprop:Generator_ColumnPropNameInRow="RESOURCE_NAME" msprop:Generator_ColumnVarNameInTable="columnRESOURCE_NAME" msprop:Generator_ColumnPropNameInTable="RESOURCE_NAMEColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="LETTER_TEXT" msprop:Generator_UserColumnName="LETTER_TEXT" msprop:Generator_ColumnPropNameInRow="LETTER_TEXT" msprop:Generator_ColumnVarNameInTable="columnLETTER_TEXT" msprop:Generator_ColumnPropNameInTable="LETTER_TEXTColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="NO_SHOW_LETTER" msprop:Generator_UserColumnName="NO_SHOW_LETTER" msprop:Generator_ColumnPropNameInRow="NO_SHOW_LETTER" msprop:Generator_ColumnVarNameInTable="columnNO_SHOW_LETTER" msprop:Generator_ColumnPropNameInTable="NO_SHOW_LETTERColumn" type="xs:string" minOccurs="0" />
+              <xs:element name="CLINIC_CANCELLATION_LETTER" msprop:Generator_UserColumnName="CLINIC_CANCELLATION_LETTER" msprop:Generator_ColumnPropNameInRow="CLINIC_CANCELLATION_LETTER" msprop:Generator_ColumnVarNameInTable="columnCLINIC_CANCELLATION_LETTER" msprop:Generator_ColumnPropNameInTable="CLINIC_CANCELLATION_LETTERColumn" type="xs:string" minOccurs="0" />
+            </xs:sequence>
+          </xs:complexType>
+        </xs:element>
+      </xs:choice>
+    </xs:complexType>
+    <xs:unique name="kBSDXResourceID">
+      <xs:selector xpath=".//mstns:BSDXResource" />
+      <xs:field xpath="mstns:RESOURCEID" />
+    </xs:unique>
+    <xs:keyref name="FK_BSDXResource_PatientAppts" refer="kBSDXResourceID" msprop:rel_Generator_UserRelationName="FK_BSDXResource_PatientAppts" msprop:rel_Generator_RelationVarName="relationFK_BSDXResource_PatientAppts" msprop:rel_Generator_UserChildTable="PatientAppts" msprop:rel_Generator_UserParentTable="BSDXResource" msprop:rel_Generator_ParentPropName="BSDXResourceRow" msprop:rel_Generator_ChildPropName="GetPatientApptsRows">
+      <xs:selector xpath=".//mstns:PatientAppts" />
+      <xs:field xpath="mstns:RESOURCEID" />
+    </xs:keyref>
+  </xs:element>
 </xs:schema>
