Index: Scheduling/trunk/cs/bsdx0200GUISourceCode/DAL.cs
===================================================================
--- Scheduling/trunk/cs/bsdx0200GUISourceCode/DAL.cs	(revision 843)
+++ Scheduling/trunk/cs/bsdx0200GUISourceCode/DAL.cs	(revision 848)
@@ -15,4 +15,5 @@
     {
         private BMXNetConnectInfo _thisConnection; // set in constructor
+        
         delegate DataTable RPMSDataTableDelegate(string CommandString, string TableName); // for use in calling (Sync and Async)
 
@@ -49,5 +50,57 @@
         }
 
+        /// <summary>
+        /// Get the Patients who have appointments in between dates for the clinics requested
+        /// </summary>
+        /// <param name="sClinicList">| delimited resource list (resource IENS, not names)</param>
+        /// <param name="BeginDate">Self Explanatory</param>
+        /// <param name="EndDate">Self Explanatory</param>
+        /// <returns>DataTable with the following columns:
+        /// T00030Name^D00020DOB^T00030Sex^T00030HRN^D00030ApptDate^T00030Clinic^T00030TypeStatus
+        /// I00010RESOURCEID^T00030APPT_MADE_BY^D00020DATE_APPT_MADE^T00250NOTE^T00030STREET^
+        /// T00030CITY^T00030STATE^T00030ZIP^T00030HOMEPHONE
+        ///</returns>
+        ///<remarks>Mirrors dsPatientApptDisplay2.PatientAppts Schema in this project. Can merge table into schema.</remarks>
+        public DataTable GetClinicSchedules(string sClinicList, DateTime BeginDate, DateTime EndDate)
+        {
+            string sBegin = FMDateTime.Create(BeginDate).DateOnly.FMDateString;
+            string sEnd = FMDateTime.Create(EndDate).DateOnly.FMDateString;
+            string cmd = String.Format("BSDX CLINIC LETTERS^{0}^{1}^{2}", sClinicList, sBegin, sEnd);
+            return RPMSDataTable(cmd, "");
+        }
 
+        /// <summary>
+        /// Get the letter templates associated with the requested clinics (reminder letter, cancellation letter etc)
+        /// </summary>
+        /// <param name="sClinicList">| delimited resource list (resource IENS, not names)</param>
+        /// <returns>DataTable with the following columns:
+        /// I00010RESOURCEID^T00030RESOURCE_NAME^T00030LETTER_TEXT^T00030NO_SHOW_LETTER^T00030CLINIC_CANCELLATION_LETTER
+        /// </returns>
+        /// <remarks>Mirrors dsPatientApptDisplay2.BSDXResource Schema. Can merge table into schema.</remarks>
+        public DataTable GetResourceLetters(string sClinicList)
+        {
+            string cmd = String.Format("BSDX RESOURCE LETTERS^{0}", sClinicList);
+            return RPMSDataTable(cmd, "");
+        }
+
+        /// <summary>
+        /// Get the list of Patients who have Rebooked Appointments
+        /// </summary>
+        /// <param name="sClinicList">| delimited resource list (resource IENS, not names)</param>
+        /// <param name="BeginDate">Self Explanatory</param>
+        /// <param name="EndDate">Self Explanatory</param>
+        /// <returns>T00030Name^D00020DOB^T00030Sex^T00030HRN^D00030NewApptDate^T00030Clinic^T00030TypeStatus
+        /// ^I00010RESOURCEID^T00030APPT_MADE_BY^D00020DATE_APPT_MADE^T00250NOTE^T00030STREET^T00030CITY
+        /// ^T00030STATE^T00030ZIP^T00030HOMEPHONE^D00030OldApptDate
+        ///</returns>
+        /// <remarks>Not sure if this works yet</remarks>
+        /// <remarks>Mirrors dsRebookAppts.PatientAppt Schema. Can merge table into schema.</remarks>
+        public DataTable GetRebookedAppointments(string sClinicList, DateTime BeginDate, DateTime EndDate)
+        {
+            string sBegin = FMDateTime.Create(BeginDate).DateOnly.FMDateString;
+            string sEnd = FMDateTime.Create(EndDate).DateOnly.FMDateString;
+            string cmd = String.Format("BSDX REBOOK CLINIC LIST^{0}^{1}^{2}", sClinicList, sBegin, sEnd);
+            return RPMSDataTable(cmd, "");
+        }
 
         /// <summary>
@@ -56,5 +109,4 @@
         /// <param name="sSQL"></param>
         /// <param name="sTableName"></param>
-        /// <param name="ds"></param>
         /// <returns></returns>
         private DataTable RPMSDataTable(string sSQL, string sTableName)
@@ -75,5 +127,5 @@
             catch (Exception ex)
             {
-                sErrorMessage = "CGDocumentManager.RPMSDataTable error: " + ex.Message;
+                sErrorMessage = "DAL.RPMSDataTable error: " + ex.Message;
                 throw ex;
             }
