source: Scheduling/trunk/cs/bsdx0200GUISourceCode/DApptSearch.cs@ 1377

using System;

using System.Collections;

using System.Collections.Generic;

using System.Windows.Forms;

using System.Data;

using System.Linq;



namespace IndianHealthService.ClinicalScheduling

{

        /// <summary>

        /// Modal Dialog for searching for Patient Slots

        /// </summary>

        public class DApptSearch : System.Windows.Forms.Form

        {

                private System.Windows.Forms.Panel panel1;

                private System.Windows.Forms.Button cmdCancel;

                private System.Windows.Forms.Button btnAccept;

                private System.Windows.Forms.Panel pnlDescription;

                private System.Windows.Forms.GroupBox grpDescription;

                private System.Windows.Forms.Label lblDescription;

                private System.Windows.Forms.GroupBox groupBox1;

                private System.Windows.Forms.Label label3;

                private System.Windows.Forms.Label label2;

                private System.Windows.Forms.CheckedListBox lstAccessTypes;

                private System.Windows.Forms.ComboBox cboAccessTypeFilter;

                private System.Windows.Forms.GroupBox grpDayOfWeek;

                private System.Windows.Forms.CheckBox chkSun;

                private System.Windows.Forms.CheckBox chkSat;

                private System.Windows.Forms.CheckBox chkFri;

                private System.Windows.Forms.CheckBox chkThu;

                private System.Windows.Forms.CheckBox chkWed;

                private System.Windows.Forms.CheckBox chkTue;

                private System.Windows.Forms.CheckBox chkMon;

                private System.Windows.Forms.GroupBox grpTimeOfDay;

                private System.Windows.Forms.RadioButton rdoBoth;

                private System.Windows.Forms.RadioButton rdoPM;

                private System.Windows.Forms.RadioButton rdoAM;

        private System.Windows.Forms.Label label1;

        private System.Windows.Forms.GroupBox groupBox2;

        private System.Windows.Forms.Button cmdSearch;

        private ListView lstResults;

        private ColumnHeader colStartTime;

        private ColumnHeader colEndTime;

        private ColumnHeader colResource;

        private ColumnHeader colSlots;

        private ColumnHeader colAccessType;

        private ColumnHeader colDate;

        private Label lblEnd;

        private Label lblStart;

        private DateTimePicker dtEnd;

        private DateTimePicker dtStart;

        private ColumnHeader colDOW;

        private ColumnHeader colID;

        private Label lblMessage;

      

        private System.ComponentModel.IContainer components;



                public DApptSearch()

                {

                        InitializeComponent();

                }



                #region Fields



                private CGDocumentManager       m_DocManager;

                

                private DataSet m_dsGlobal;

                DataTable               m_dtTypes;

                DataView                m_dvTypes;

        List<CGAvailability> lstResultantAvailabilities;

        private CGAvailability _selectedAvailability;

                DateTime                m_dStart;

                DateTime                m_dEnd;

                ArrayList               m_alResources;

                ArrayList               m_alAccessTypes;

                string                  m_sWeekDays; //only practical use now is for sending to server

                string                  m_sAmpm; // same here.



                #endregion Fields



        #region Methods



        public void LoadListBox(string sGroup)

                {

                        if (sGroup == "ALL")

                        {

                                //Load the Access Type list box with ALL access types

                                m_dtTypes = m_dsGlobal.Tables["AccessTypes"];

                                m_dvTypes = new DataView(m_dtTypes);

                                lstAccessTypes.DataSource = m_dvTypes;

                                lstAccessTypes.DisplayMember = "ACCESS_TYPE_NAME";

                                lstAccessTypes.Tag = 1; //This holds the column index of the ACCESS_TYPE_NAME column

                                lstAccessTypes.ValueMember = "BMXIEN";

                        }

                        else 

                        {

                                //Load the Access Type list box with active access types belonging

                                //to group sGroup



                                //Build AccessGroup table containing *active* AccessTypes and their Groups

                                m_dtTypes = m_dsGlobal.Tables["AccessGroupType"];

                                //Create a view that is filterable on Access Group

                                m_dvTypes = new DataView(m_dtTypes);

                                m_dvTypes.RowFilter = "ACCESS_GROUP = '" + this.cboAccessTypeFilter.Text + "'";

                                lstAccessTypes.DataSource = m_dvTypes;

                                lstAccessTypes.DisplayMember = "ACCESS_TYPE";

                                lstAccessTypes.ValueMember = "ACCESS_TYPE_ID";

                                lstAccessTypes.Tag = 4; //This holds the column index of the ACCESS_TYPE column

                        }

                }



                public void InitializePage(ArrayList alResources, CGDocumentManager docManager)

                {



            this.Text = "Searching for available slots in: " + string.Join(" | ", alResources.Cast<string>());

            

            this.m_DocManager = docManager;

                        this.m_dsGlobal = m_DocManager.GlobalDataSet;

                        

                        LoadListBox("ALL");



                        m_dStart = DateTime.Today;

                        m_dEnd = new DateTime(9999);

                        this.m_alResources = alResources;

                        this.m_alAccessTypes = new ArrayList();

                        this.m_sAmpm="both";

                        this.m_sWeekDays = "";



                        //Load filter combo with list of access type groups

                        DataTable dtGroup = m_dsGlobal.Tables["AccessGroup"];

                        DataSet dsTemp = new DataSet("dsTemp");

                        dsTemp.Tables.Add(dtGroup.Copy());

                        DataTable dtTemp = dsTemp.Tables["AccessGroup"];

                        DataView dvGroup = new DataView(dtTemp);

                        DataRowView drv = dvGroup.AddNew();

                        drv["ACCESS_GROUP"]="<Show All Access Types>";

                        cboAccessTypeFilter.DataSource = dvGroup;

                        cboAccessTypeFilter.DisplayMember = "ACCESS_GROUP";

                        cboAccessTypeFilter.SelectedText = "<Show All Access Types>";

                        cboAccessTypeFilter.SelectedIndex = cboAccessTypeFilter.Items.Count - 1;

                        cboAccessTypeFilter.Refresh();





            /* OLD CODE 

            //Create DataGridTableStyle for Result grid

                        DataGridTableStyle tsResult = new DataGridTableStyle();

                        tsResult.MappingName = "Result";

                        tsResult.ReadOnly = true;



                        // Add START_TIME column style.

                        DataGridTextBoxColumn colStartTime = new DataGridTextBoxColumn();

            colStartTime.MappingName = "StartTime";

                        colStartTime.HeaderText = "Start Time";

                        colStartTime.Width = 200;

                        colStartTime.Format = "f";

                        tsResult.GridColumnStyles.Add(colStartTime);

                        

                        // Add END_TIME column style.

                        DataGridTextBoxColumn colEndTime = new DataGridTextBoxColumn();

            colEndTime.MappingName = "EndTime";

                        colEndTime.HeaderText = "End Time";

                        colEndTime.Width = 75;

                        colEndTime.Format = "h:mm tt";

                        tsResult.GridColumnStyles.Add(colEndTime);



                        // Add RESOURCE column style.

                        DataGridTextBoxColumn colResource = new DataGridTextBoxColumn();

            colResource.MappingName = "ResourceList";

                        colResource.HeaderText = "Resource";

                        colResource.Width = 200;

                        tsResult.GridColumnStyles.Add(colResource);



                        // Add SLOTS column style.

                        DataGridTextBoxColumn colSlots = new DataGridTextBoxColumn();

                        colSlots.MappingName = "SLOTS";

                        colSlots.HeaderText = "Slots";

                        colSlots.Width = 50;

                        tsResult.GridColumnStyles.Add(colSlots);



                        // Add AMPM column style.

                        DataGridTextBoxColumn colAccess = new DataGridTextBoxColumn();

                        colAccess.MappingName = "ACCESSNAME";

                        colAccess.HeaderText = "Access Type";

                        colAccess.Width = 200;

                        tsResult.GridColumnStyles.Add(colAccess);

                        //grdResult.TableStyles.Add(tsResult);

            */

            

                        this.UpdateDialogData(true);

                

                }



                /// <summary>

                /// If b is true, moves member vars into control data

                /// otherwise, moves control data into member vars

                /// </summary>

                /// <param name="b"></param>

                private void UpdateDialogData(bool b)

                {

                        if (b == true) //move member vars into controls

                        {



                        }

                        else //move control data into member vars

                        {



                                //Build AccessType list



                                this.m_alAccessTypes.Clear();

                                

                                for (int j = 0; j < this.lstAccessTypes.CheckedItems.Count; j++)

                                {

                                        DataRowView drv = (DataRowView) lstAccessTypes.CheckedItems[j];

                                        int nIndex = (int) lstAccessTypes.Tag;

                                        string sItem = drv.Row.ItemArray[nIndex].ToString();

                                        m_alAccessTypes.Add(sItem); 

                                }



                                //AM/PM

                                this.m_sAmpm = (this.rdoAM.Checked == true) ? "AM":"BOTH";

                                if (this.m_sAmpm != "AM")

                                        this.m_sAmpm = (this.rdoPM.Checked == true) ? "PM":"BOTH";



                                

                                //Weekday

                                this.m_sWeekDays = ""; //any

                                if (chkMon.Checked == true)

                                        m_sWeekDays += "Monday";

                                if (chkTue.Checked == true)

                                        m_sWeekDays += "Tuesday";

                                if (chkWed.Checked == true)

                                        m_sWeekDays += "Wednesday";

                                if (chkThu.Checked == true)

                                        m_sWeekDays += "Thursday";

                                if (chkFri.Checked == true)

                                        m_sWeekDays += "Friday";

                                if (chkSat.Checked == true)

                                        m_sWeekDays += "Saturday";

                                if (chkSun.Checked == true)

                                        m_sWeekDays += "Sunday";



                                //Start

                this.m_dStart = this.dtStart.Value;



                                //End

                this.m_dEnd = this.dtEnd.Value;

                        }               

                }





                /// <summary>

                /// Clean up any resources being used.

                /// </summary>

                protected override void Dispose( bool disposing )

                {

                        if( disposing )

                        {

                                if(components != null)

                                {

                                        components.Dispose();

                                }

                        }

                        base.Dispose( disposing );

        }



        #endregion Methods



        #region Windows Form Designer generated code

        /// <summary>

                /// Required method for Designer support - do not modify

                /// the contents of this method with the code editor.

                /// </summary>

                private void InitializeComponent()

                {

            this.panel1 = new System.Windows.Forms.Panel();

            this.lblMessage = new System.Windows.Forms.Label();

            this.cmdSearch = new System.Windows.Forms.Button();

            this.cmdCancel = new System.Windows.Forms.Button();

            this.btnAccept = new System.Windows.Forms.Button();

            this.pnlDescription = new System.Windows.Forms.Panel();

            this.grpDescription = new System.Windows.Forms.GroupBox();

            this.lblDescription = new System.Windows.Forms.Label();

            this.groupBox1 = new System.Windows.Forms.GroupBox();

            this.lblEnd = new System.Windows.Forms.Label();

            this.lblStart = new System.Windows.Forms.Label();

            this.dtEnd = new System.Windows.Forms.DateTimePicker();

            this.dtStart = new System.Windows.Forms.DateTimePicker();

            this.label3 = new System.Windows.Forms.Label();

            this.label2 = new System.Windows.Forms.Label();

            this.lstAccessTypes = new System.Windows.Forms.CheckedListBox();

            this.cboAccessTypeFilter = new System.Windows.Forms.ComboBox();

            this.grpDayOfWeek = new System.Windows.Forms.GroupBox();

            this.chkSun = new System.Windows.Forms.CheckBox();

            this.chkSat = new System.Windows.Forms.CheckBox();

            this.chkFri = new System.Windows.Forms.CheckBox();

            this.chkThu = new System.Windows.Forms.CheckBox();

            this.chkWed = new System.Windows.Forms.CheckBox();

            this.chkTue = new System.Windows.Forms.CheckBox();

            this.chkMon = new System.Windows.Forms.CheckBox();

            this.grpTimeOfDay = new System.Windows.Forms.GroupBox();

            this.rdoBoth = new System.Windows.Forms.RadioButton();

            this.rdoPM = new System.Windows.Forms.RadioButton();

            this.rdoAM = new System.Windows.Forms.RadioButton();

            this.label1 = new System.Windows.Forms.Label();

            this.groupBox2 = new System.Windows.Forms.GroupBox();

            this.lstResults = new System.Windows.Forms.ListView();

            this.colID = ((System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader()));

            this.colDate = ((System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader()));

            this.colDOW = ((System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader()));

            this.colStartTime = ((System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader()));

            this.colEndTime = ((System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader()));

            this.colResource = ((System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader()));

            this.colSlots = ((System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader()));

            this.colAccessType = ((System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader()));

            this.panel1.SuspendLayout();

            this.pnlDescription.SuspendLayout();

            this.grpDescription.SuspendLayout();

            this.groupBox1.SuspendLayout();

            this.grpDayOfWeek.SuspendLayout();

            this.grpTimeOfDay.SuspendLayout();

            this.groupBox2.SuspendLayout();

            this.SuspendLayout();

            // 

            // panel1

            // 

            this.panel1.Controls.Add(this.lblMessage);

            this.panel1.Controls.Add(this.cmdSearch);

            this.panel1.Controls.Add(this.cmdCancel);

            this.panel1.Controls.Add(this.btnAccept);

            this.panel1.Dock = System.Windows.Forms.DockStyle.Bottom;

            this.panel1.Location = new System.Drawing.Point(0, 461);

            this.panel1.Name = "panel1";

            this.panel1.Size = new System.Drawing.Size(923, 40);

            this.panel1.TabIndex = 4;

            // 

            // lblMessage

            // 

            this.lblMessage.AutoSize = true;

            this.lblMessage.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.lblMessage.ForeColor = System.Drawing.Color.Red;

            this.lblMessage.Location = new System.Drawing.Point(337, 16);

            this.lblMessage.Name = "lblMessage";

            this.lblMessage.Size = new System.Drawing.Size(0, 16);

            this.lblMessage.TabIndex = 3;

            // 

            // cmdSearch

            // 

            this.cmdSearch.Location = new System.Drawing.Point(33, 6);

            this.cmdSearch.Name = "cmdSearch";

            this.cmdSearch.Size = new System.Drawing.Size(72, 24);

            this.cmdSearch.TabIndex = 2;

            this.cmdSearch.Text = "Search";

            this.cmdSearch.Click += new System.EventHandler(this.cmdSearch_Click);

            // 

            // cmdCancel

            // 

            this.cmdCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;

            this.cmdCancel.Location = new System.Drawing.Point(828, 8);

            this.cmdCancel.Name = "cmdCancel";

            this.cmdCancel.Size = new System.Drawing.Size(64, 24);

            this.cmdCancel.TabIndex = 1;

            this.cmdCancel.Text = "Cancel";

            // 

            // btnAccept

            // 

            this.btnAccept.DialogResult = System.Windows.Forms.DialogResult.OK;

            this.btnAccept.Location = new System.Drawing.Point(135, 8);

            this.btnAccept.Name = "btnAccept";

            this.btnAccept.Size = new System.Drawing.Size(176, 24);

            this.btnAccept.TabIndex = 0;

            this.btnAccept.Text = "Select Slot for Appointment";

            this.btnAccept.Click += new System.EventHandler(this.btnAccept_Click);

            // 

            // pnlDescription

            // 

            this.pnlDescription.Controls.Add(this.grpDescription);

            this.pnlDescription.Dock = System.Windows.Forms.DockStyle.Bottom;

            this.pnlDescription.Location = new System.Drawing.Point(0, 397);

            this.pnlDescription.Name = "pnlDescription";

            this.pnlDescription.Size = new System.Drawing.Size(923, 64);

            this.pnlDescription.TabIndex = 47;

            // 

            // grpDescription

            // 

            this.grpDescription.Controls.Add(this.lblDescription);

            this.grpDescription.Dock = System.Windows.Forms.DockStyle.Fill;

            this.grpDescription.Location = new System.Drawing.Point(0, 0);

            this.grpDescription.Name = "grpDescription";

            this.grpDescription.Size = new System.Drawing.Size(923, 64);

            this.grpDescription.TabIndex = 0;

            this.grpDescription.TabStop = false;

            this.grpDescription.Text = "Description";

            // 

            // lblDescription

            // 

            this.lblDescription.Dock = System.Windows.Forms.DockStyle.Fill;

            this.lblDescription.Location = new System.Drawing.Point(3, 16);

            this.lblDescription.Name = "lblDescription";

            this.lblDescription.Size = new System.Drawing.Size(917, 45);

            this.lblDescription.TabIndex = 1;

            this.lblDescription.Text = "Search for available slots times using this panel.  You may narrow your search by" +

                " selecting an access type or by selecting specific days of the week or times of " +

                "day.";

            // 

            // groupBox1

            // 

            this.groupBox1.Controls.Add(this.lblEnd);

            this.groupBox1.Controls.Add(this.lblStart);

            this.groupBox1.Controls.Add(this.dtEnd);

            this.groupBox1.Controls.Add(this.dtStart);

            this.groupBox1.Controls.Add(this.label3);

            this.groupBox1.Controls.Add(this.label2);

            this.groupBox1.Controls.Add(this.lstAccessTypes);

            this.groupBox1.Controls.Add(this.cboAccessTypeFilter);

            this.groupBox1.Controls.Add(this.grpDayOfWeek);

            this.groupBox1.Controls.Add(this.grpTimeOfDay);

            this.groupBox1.Controls.Add(this.label1);

            this.groupBox1.Dock = System.Windows.Forms.DockStyle.Top;

            this.groupBox1.Location = new System.Drawing.Point(0, 0);

            this.groupBox1.Name = "groupBox1";

            this.groupBox1.Size = new System.Drawing.Size(923, 208);

            this.groupBox1.TabIndex = 56;

            this.groupBox1.TabStop = false;

            this.groupBox1.Text = "Search Parameters";

            // 

            // lblEnd

            // 

            this.lblEnd.AutoSize = true;

            this.lblEnd.Location = new System.Drawing.Point(12, 124);

            this.lblEnd.Name = "lblEnd";

            this.lblEnd.Size = new System.Drawing.Size(153, 13);

            this.lblEnd.TabIndex = 67;

            this.lblEnd.Text = "End Date to Search (Inclusive)";

            // 

            // lblStart

            // 

            this.lblStart.AutoSize = true;

            this.lblStart.Location = new System.Drawing.Point(12, 35);

            this.lblStart.Name = "lblStart";

            this.lblStart.Size = new System.Drawing.Size(159, 13);

            this.lblStart.TabIndex = 66;

            this.lblStart.Text = "Start Date to Search (Inclusive)";

            // 

            // dtEnd

            // 

            this.dtEnd.Location = new System.Drawing.Point(12, 141);

            this.dtEnd.Name = "dtEnd";

            this.dtEnd.Size = new System.Drawing.Size(200, 20);

            this.dtEnd.TabIndex = 65;

            this.dtEnd.ValueChanged += new System.EventHandler(this.dtEnd_ValueChanged);

            // 

            // dtStart

            // 

            this.dtStart.Location = new System.Drawing.Point(12, 54);

            this.dtStart.Name = "dtStart";

            this.dtStart.Size = new System.Drawing.Size(200, 20);

            this.dtStart.TabIndex = 64;

            this.dtStart.ValueChanged += new System.EventHandler(this.dtStart_ValueChanged);

            // 

            // label3

            // 

            this.label3.Location = new System.Drawing.Point(684, 64);

            this.label3.Name = "label3";

            this.label3.Size = new System.Drawing.Size(80, 16);

            this.label3.TabIndex = 63;

            this.label3.Text = "Access Type:";

            // 

            // label2

            // 

            this.label2.Location = new System.Drawing.Point(684, 21);

            this.label2.Name = "label2";

            this.label2.Size = new System.Drawing.Size(104, 16);

            this.label2.TabIndex = 62;

            this.label2.Text = "Access Group:";

            // 

            // lstAccessTypes

            // 

            this.lstAccessTypes.CheckOnClick = true;

            this.lstAccessTypes.HorizontalScrollbar = true;

            this.lstAccessTypes.Location = new System.Drawing.Point(661, 88);

            this.lstAccessTypes.MultiColumn = true;

            this.lstAccessTypes.Name = "lstAccessTypes";

            this.lstAccessTypes.Size = new System.Drawing.Size(250, 109);

            this.lstAccessTypes.TabIndex = 61;

            // 

            // cboAccessTypeFilter

            // 

            this.cboAccessTypeFilter.Location = new System.Drawing.Point(661, 40);

            this.cboAccessTypeFilter.Name = "cboAccessTypeFilter";

            this.cboAccessTypeFilter.Size = new System.Drawing.Size(250, 21);

            this.cboAccessTypeFilter.TabIndex = 60;

            this.cboAccessTypeFilter.Text = "cboAccessTypeFilter";

            this.cboAccessTypeFilter.SelectionChangeCommitted += new System.EventHandler(this.cboAccessTypeFilter_SelectionChangeCommitted);

            // 

            // grpDayOfWeek

            // 

            this.grpDayOfWeek.Controls.Add(this.chkSun);

            this.grpDayOfWeek.Controls.Add(this.chkSat);

            this.grpDayOfWeek.Controls.Add(this.chkFri);

            this.grpDayOfWeek.Controls.Add(this.chkThu);

            this.grpDayOfWeek.Controls.Add(this.chkWed);

            this.grpDayOfWeek.Controls.Add(this.chkTue);

            this.grpDayOfWeek.Controls.Add(this.chkMon);

            this.grpDayOfWeek.Location = new System.Drawing.Point(311, 94);

            this.grpDayOfWeek.Name = "grpDayOfWeek";

            this.grpDayOfWeek.Size = new System.Drawing.Size(240, 101);

            this.grpDayOfWeek.TabIndex = 59;

            this.grpDayOfWeek.TabStop = false;

            this.grpDayOfWeek.Text = "Day of the Week";

            // 

            // chkSun

            // 

            this.chkSun.Location = new System.Drawing.Point(176, 64);

            this.chkSun.Name = "chkSun";

            this.chkSun.Size = new System.Drawing.Size(48, 16);

            this.chkSun.TabIndex = 6;

            this.chkSun.Text = "Sun";

            // 

            // chkSat

            // 

            this.chkSat.Location = new System.Drawing.Point(128, 64);

            this.chkSat.Name = "chkSat";

            this.chkSat.Size = new System.Drawing.Size(48, 16);

            this.chkSat.TabIndex = 5;

            this.chkSat.Text = "Sat";

            // 

            // chkFri

            // 

            this.chkFri.Location = new System.Drawing.Point(72, 64);

            this.chkFri.Name = "chkFri";

            this.chkFri.Size = new System.Drawing.Size(48, 16);

            this.chkFri.TabIndex = 4;

            this.chkFri.Text = "Fri";

            // 

            // chkThu

            // 

            this.chkThu.Location = new System.Drawing.Point(16, 64);

            this.chkThu.Name = "chkThu";

            this.chkThu.Size = new System.Drawing.Size(48, 16);

            this.chkThu.TabIndex = 3;

            this.chkThu.Text = "Thu";

            // 

            // chkWed

            // 

            this.chkWed.Location = new System.Drawing.Point(128, 32);

            this.chkWed.Name = "chkWed";

            this.chkWed.Size = new System.Drawing.Size(48, 16);

            this.chkWed.TabIndex = 2;

            this.chkWed.Text = "Wed";

            // 

            // chkTue

            // 

            this.chkTue.Location = new System.Drawing.Point(72, 32);

            this.chkTue.Name = "chkTue";

            this.chkTue.Size = new System.Drawing.Size(48, 16);

            this.chkTue.TabIndex = 1;

            this.chkTue.Text = "Tue";

            // 

            // chkMon

            // 

            this.chkMon.Location = new System.Drawing.Point(16, 32);

            this.chkMon.Name = "chkMon";

            this.chkMon.Size = new System.Drawing.Size(48, 16);

            this.chkMon.TabIndex = 0;

            this.chkMon.Text = "Mon";

            // 

            // grpTimeOfDay

            // 

            this.grpTimeOfDay.Controls.Add(this.rdoBoth);

            this.grpTimeOfDay.Controls.Add(this.rdoPM);

            this.grpTimeOfDay.Controls.Add(this.rdoAM);

            this.grpTimeOfDay.Location = new System.Drawing.Point(311, 32);

            this.grpTimeOfDay.Name = "grpTimeOfDay";

            this.grpTimeOfDay.Size = new System.Drawing.Size(240, 48);

            this.grpTimeOfDay.TabIndex = 58;

            this.grpTimeOfDay.TabStop = false;

            this.grpTimeOfDay.Text = "Time of Day";

            // 

            // rdoBoth

            // 

            this.rdoBoth.Checked = true;

            this.rdoBoth.Location = new System.Drawing.Point(176, 24);

            this.rdoBoth.Name = "rdoBoth";

            this.rdoBoth.Size = new System.Drawing.Size(48, 16);

            this.rdoBoth.TabIndex = 2;

            this.rdoBoth.TabStop = true;

            this.rdoBoth.Text = "Both";

            // 

            // rdoPM

            // 

            this.rdoPM.Location = new System.Drawing.Point(96, 24);

            this.rdoPM.Name = "rdoPM";

            this.rdoPM.Size = new System.Drawing.Size(72, 16);

            this.rdoPM.TabIndex = 1;

            this.rdoPM.Text = "PM Only";

            // 

            // rdoAM

            // 

            this.rdoAM.Location = new System.Drawing.Point(16, 24);

            this.rdoAM.Name = "rdoAM";

            this.rdoAM.Size = new System.Drawing.Size(72, 16);

            this.rdoAM.TabIndex = 0;

            this.rdoAM.Text = "AM Only";

            // 

            // label1

            // 

            this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.label1.Location = new System.Drawing.Point(6, 16);

            this.label1.Name = "label1";

            this.label1.Size = new System.Drawing.Size(136, 16);

            this.label1.TabIndex = 57;

            this.label1.Text = "Date Range:";

            // 

            // groupBox2

            // 

            this.groupBox2.Controls.Add(this.lstResults);

            this.groupBox2.Dock = System.Windows.Forms.DockStyle.Fill;

            this.groupBox2.Location = new System.Drawing.Point(0, 208);

            this.groupBox2.Name = "groupBox2";

            this.groupBox2.Size = new System.Drawing.Size(923, 189);

            this.groupBox2.TabIndex = 57;

            this.groupBox2.TabStop = false;

            this.groupBox2.Text = "Search Result";

            // 

            // lstResults

            // 

            this.lstResults.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {

            this.colID,

            this.colDate,

            this.colDOW,

            this.colStartTime,

            this.colEndTime,

            this.colResource,

            this.colSlots,

            this.colAccessType});

            this.lstResults.Dock = System.Windows.Forms.DockStyle.Fill;

            this.lstResults.FullRowSelect = true;

            this.lstResults.GridLines = true;

            this.lstResults.Location = new System.Drawing.Point(3, 16);

            this.lstResults.MultiSelect = false;

            this.lstResults.Name = "lstResults";

            this.lstResults.Size = new System.Drawing.Size(917, 170);

            this.lstResults.TabIndex = 0;

            this.lstResults.UseCompatibleStateImageBehavior = false;

            this.lstResults.View = System.Windows.Forms.View.Details;

            this.lstResults.DoubleClick += new System.EventHandler(this.lstResults_DoubleClick);

            // 

            // colID

            // 

            this.colID.Text = "ID";

            this.colID.Width = 0;

            // 

            // colDate

            // 

            this.colDate.Text = "Date";

            this.colDate.Width = 91;

            // 

            // colDOW

            // 

            this.colDOW.Text = "Day of Week";

            this.colDOW.Width = 80;

            // 

            // colStartTime

            // 

            this.colStartTime.Text = "Start Time";

            this.colStartTime.Width = 87;

            // 

            // colEndTime

            // 

            this.colEndTime.Text = "End Time";

            this.colEndTime.Width = 116;

            // 

            // colResource

            // 

            this.colResource.Text = "Resource";

            this.colResource.Width = 370;

            // 

            // colSlots

            // 

            this.colSlots.Text = "Slots";

            this.colSlots.Width = 47;

            // 

            // colAccessType

            // 

            this.colAccessType.Text = "Access Type";

            this.colAccessType.Width = 101;

            // 

            // DApptSearch

            // 

            this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);

            this.CancelButton = this.cmdCancel;

            this.ClientSize = new System.Drawing.Size(923, 501);

            this.Controls.Add(this.groupBox2);

            this.Controls.Add(this.groupBox1);

            this.Controls.Add(this.pnlDescription);

            this.Controls.Add(this.panel1);

            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;

            this.Name = "DApptSearch";

            this.Text = "Find Clinic Availability";

            this.panel1.ResumeLayout(false);

            this.panel1.PerformLayout();

            this.pnlDescription.ResumeLayout(false);

            this.grpDescription.ResumeLayout(false);

            this.groupBox1.ResumeLayout(false);

            this.groupBox1.PerformLayout();

            this.grpDayOfWeek.ResumeLayout(false);

            this.grpTimeOfDay.ResumeLayout(false);

            this.groupBox2.ResumeLayout(false);

            this.ResumeLayout(false);



                }

                #endregion



        #region Event Handlers



                private void cmdSearch_Click(object sender, System.EventArgs e)

                {

                        //Tell user we are processing

            this.Cursor = Cursors.WaitCursor;

            this.lblMessage.Text = String.Empty;



            //Get the control data into local vars

                        UpdateDialogData(false);

                        //Resource array, Begin date, Access type array, MTWTF , AM PM



            //Get Availabilities and Appointments from the DB

            //NB: m_sAmpm and m_sWeekDays don't have an effect on the M side side right now

            m_dStart = m_dStart.Date; // move to 1200

            m_dEnd = m_dEnd.Date.AddHours(23).AddMinutes(59).AddSeconds(59); //move to 235959

            string sSearchInfo = "1|" + m_sAmpm + "|" + m_sWeekDays;

                        DataTable m_availTable = CGSchedLib.CreateAvailabilitySchedule(m_DocManager, m_alResources, m_dStart, m_dEnd, m_alAccessTypes, ScheduleType.Resource, sSearchInfo);

            DataTable m_apptTable = CGSchedLib.CreateAppointmentSchedule(m_DocManager, m_alResources, m_dStart, m_dEnd);



#if DEBUG            

            System.Diagnostics.Stopwatch stopwatch = new System.Diagnostics.Stopwatch();

            stopwatch.Start();

#endif

            lstResultantAvailabilities = (from rowAV in m_availTable.AsEnumerable()

                         

                         // Calculate the number of slots consumed in this availability by appointments

                         let slotsConsumed = (from appt in m_apptTable.AsEnumerable()

                                              //If the resource is the same and the user selection overlaps, then...

                                              where (rowAV.Field<string>("RESOURCE") == appt.Field<string>("RESOURCENAME")

                                                && CalendarGrid.TimesOverlap(rowAV.Field<DateTime>("START_TIME"), rowAV.Field<DateTime>("END_TIME"), appt.Field<DateTime>("START_TIME"), appt.Field<DateTime>("END_TIME")))

                                              // if appt starttime is before avail start time, only count against the avail starting from the availability start time

                                              let startTimeToCountAgainstBlock = appt.Field<DateTime>("START_TIME") < rowAV.Field<DateTime>("START_TIME") ? rowAV.Field<DateTime>("START_TIME") : appt.Field<DateTime>("START_TIME")

                                              // if appt endtime is after the avail ends, only count against the avail up to where the avail ends

                                              let endTimeToCountAgainstBlock = appt.Field<DateTime>("END_TIME") > rowAV.Field<DateTime>("END_TIME") ? rowAV.Field<DateTime>("END_TIME") : appt.Field<DateTime>("END_TIME")

                                              // theoretical minutes per slot for the availability

                                              let minPerSlot = (rowAV.Field<DateTime>("END_TIME") - rowAV.Field<DateTime>("START_TIME")).TotalMinutes / rowAV.Field<int>("SLOTS")

                                              // how many minutes does this appointment take away from the slot

                                              let minPerAppt = (endTimeToCountAgainstBlock - startTimeToCountAgainstBlock).TotalMinutes

                                              // how many slots the appointment takes up using this availability's scale

                                              let slotsConsumed = minPerAppt / minPerSlot

                                              select slotsConsumed).Sum()

                         

                         // Subtract the number consumed from the original ones

                         let slotsLeft = (float)rowAV.Field<int>("SLOTS") - slotsConsumed

                         // filter by that value if it is at least one slot

                         where slotsLeft >= 1

                         // Sort by Start Time, then by Resource Name

                         orderby rowAV.Field<DateTime>("START_TIME"), rowAV.Field<string>("RESOURCE")

                          //return as a CGAvailability

                          select new CGAvailability

                         {

                             ResourceList = rowAV.Field<string>("RESOURCE"),

                             StartTime = rowAV.Field<DateTime>("START_TIME"),

                             EndTime = rowAV.Field<DateTime>("END_TIME"),

                             Slots = (int)slotsLeft,

                             // AccessTypeName is grabbed from the Access Type Table using a psuedojoin syntax.

                             // "ACCESS_TYPE" is the IEN of the AcceesType.

                             // Single or default is b/c we are expecting one result.

                             AccessTypeName = (from at in m_dsGlobal.Tables["AccessTypes"].AsEnumerable() 

                                              where at.Field<int>("BMXIEN")==Int32.Parse(rowAV.Field<string>("ACCESS_TYPE"))

                                              select at.Field<string>("ACCESS_TYPE_NAME")).SingleOrDefault<string>(),

                             AvailabilityType = rowAV.Field<int>("AVAILABILITYID")

                         })

                         // convert to Generic List

                         .ToList<CGAvailability>();



            // if specific access types are chosen, filter the results based on a join against them.

            if (m_alAccessTypes.Count > 0)

                lstResultantAvailabilities = (from av in lstResultantAvailabilities

                                              join at in m_alAccessTypes.Cast<string>() on av.AccessTypeName equals at

                                              select av).ToList<CGAvailability>();



            // if user chose AM radio button, get morning appointments

            // TimeSpan.FromHours(12) gets the number of ticks since Midnight

            if (rdoAM.Checked) // less than 12 pm

            {

                lstResultantAvailabilities = (from av in lstResultantAvailabilities

                                              where av.StartTime.TimeOfDay < TimeSpan.FromHours(12)

                                              select av).ToList<CGAvailability>();

            }

            // if user chose PM radio button, get morning appointments

            if (rdoPM.Checked) // after or equal to 12 pm

            {

                lstResultantAvailabilities = (from av in lstResultantAvailabilities

                                              where av.StartTime.TimeOfDay >= TimeSpan.FromHours(12)

                                              select av).ToList<CGAvailability>();

            }



            // if any of the days of week are checked, create a new list based on them

            // and clear the original list, and join the new lists together

            if (chkMon.Checked || chkTue.Checked || chkWed.Checked || chkThu.Checked || chkFri.Checked || chkSat.Checked || chkSun.Checked)

            {



                var lstMonday = new List<CGAvailability>();

                var lstTuesday = new List<CGAvailability>();

                var lstWednesday = new List<CGAvailability>();

                var lstThursday = new List<CGAvailability>();

                var lstFriday = new List<CGAvailability>();

                var lstSaturday = new List<CGAvailability>();

                var lstSunday = new List<CGAvailability>();



                if (chkMon.Checked == true)

                {

                    lstMonday = (from av in lstResultantAvailabilities

                                 where av.StartTime.DayOfWeek == DayOfWeek.Monday

                                 select av).ToList<CGAvailability>();

                }



                if (chkTue.Checked == true)

                {

                    lstTuesday = (from av in lstResultantAvailabilities

                                  where av.StartTime.DayOfWeek == DayOfWeek.Tuesday

                                  select av).ToList<CGAvailability>();

                }



                if (chkWed.Checked == true)

                {

                    lstWednesday = (from av in lstResultantAvailabilities

                                    where av.StartTime.DayOfWeek == DayOfWeek.Wednesday

                                    select av).ToList<CGAvailability>();



                }



                if (chkThu.Checked == true)

                {

                    lstThursday = (from av in lstResultantAvailabilities

                                   where av.StartTime.DayOfWeek == DayOfWeek.Thursday

                                   select av).ToList<CGAvailability>();



                }



                if (chkFri.Checked == true)

                {

                    lstFriday = (from av in lstResultantAvailabilities

                                 where av.StartTime.DayOfWeek == DayOfWeek.Friday

                                 select av).ToList<CGAvailability>();

                }



                if (chkSat.Checked == true)

                {

                    lstSaturday = (from av in lstResultantAvailabilities

                                   where av.StartTime.DayOfWeek == DayOfWeek.Saturday

                                   select av).ToList<CGAvailability>();



                }



                if (chkSun.Checked == true)

                {

                    lstSunday = (from av in lstResultantAvailabilities

                                 where av.StartTime.DayOfWeek == DayOfWeek.Sunday

                                 select av).ToList<CGAvailability>();



                }





                lstResultantAvailabilities.Clear();

                lstResultantAvailabilities.AddRange(lstMonday);

                lstResultantAvailabilities.AddRange(lstTuesday);

                lstResultantAvailabilities.AddRange(lstWednesday);

                lstResultantAvailabilities.AddRange(lstThursday);

                lstResultantAvailabilities.AddRange(lstFriday);

                lstResultantAvailabilities.AddRange(lstSaturday);

                lstResultantAvailabilities.AddRange(lstSunday);



                lstResultantAvailabilities.OrderBy(av => av.StartTime).ThenBy(av => av.ResourceList);

            }



            



#if DEBUG

            System.Diagnostics.Debug.Write("LINQ took this long: " + stopwatch.ElapsedMilliseconds + "\n");

            stopwatch = null;

#endif

            

            //Then, convert the availabilities to ListViewItems

            var items = (from item in lstResultantAvailabilities

                        let s = new string[] {item.AvailabilityType.ToString(), item.StartTime.ToShortDateString(), item.StartTime.DayOfWeek.ToString(),item.StartTime.ToShortTimeString() ,item.EndTime.ToShortTimeString() ,item.ResourceList,item.Slots.ToString(),item.AccessTypeName}

                        let lvItem = new ListViewItem(s)

                        select lvItem).ToArray<ListViewItem>();



            //--Updating Listview

            lstResults.BeginUpdate(); //tell listview to suspend drawing for now

            lstResults.Items.Clear(); //empty it from old data



            if (items.Length > 0) lstResults.Items.AddRange(items); // add new data

            else this.lblMessage.Text = "No available slots found!";



            lstResults.EndUpdate(); // ok done adding items, draw now.

            //--End Update Listview



            //We are done

            this.Cursor = Cursors.Default;

                }



                private void cboAccessTypeFilter_SelectionChangeCommitted(object sender, System.EventArgs e)

                {

                        //Load Access Types listbox & filter

                        string sGroup = cboAccessTypeFilter.Text;

                        if (sGroup == "<Show All Access Types>")

                        {

                                LoadListBox("ALL");

                        }

                        else 

                        {

                                LoadListBox("SELECTED");

                        }                       

                                

                }





        private void lstResults_DoubleClick(object sender, EventArgs e)

        {

            ProcessChoice(sender, e);

        }



        private void btnAccept_Click(object sender, EventArgs e)

        {

            ProcessChoice(sender, e);

        }



        /// <summary>

        /// Shared method to process a user's choice

        /// </summary>

        /// <param name="s">sender</param>

        /// <param name="e">EventArgs</param>

        private void ProcessChoice(object s, EventArgs e)

        {

            if (lstResults.SelectedIndices.Count == 0)

            {

                this.DialogResult = DialogResult.None;

                lblMessage.Text = "No slot selected!";

                return;

            }



            int availabilityKey = Int32.Parse(lstResults.SelectedItems[0].SubItems[0].Text);

            _selectedAvailability = (from av in lstResultantAvailabilities

                                     where av.AvailabilityType == availabilityKey

                                     select av).Single<CGAvailability>();

            this.DialogResult = DialogResult.OK;

        }



        /// <summary>

        /// Adjust start date based on end date.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void dtStart_ValueChanged(object sender, EventArgs e)

        {

            if (dtEnd.Value < dtStart.Value) dtEnd.Value = dtStart.Value;

        }



        /// <summary>

        /// Adjust end date based on start date.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void dtEnd_ValueChanged(object sender, EventArgs e)

        {

            if (dtStart.Value > dtEnd.Value) dtStart.Value = dtEnd.Value;

        }



        #endregion  Event Handlers



        #region Properties

        

        /// <summary>

        /// Gets the Availability Selected by the User in which to put an appointment

        /// </summary>

        public CGAvailability SelectedAvailability

        {

            get { return this._selectedAvailability; }

        }



                #endregion Properties





    }

}