private void BindReasonType()
        {
            DiaryServiceClient diaryService = null;

            try
            {
                diaryService = new DiaryServiceClient();

                CollectionRequest collectionRequest = new CollectionRequest();
                collectionRequest.ForceRefresh = true;
                collectionRequest.StartRow     = 0;
                collectionRequest.RowCount     = 0;

                CancellationCodeSearchReturnValue returnValue = new CancellationCodeSearchReturnValue();
                returnValue = diaryService.GetBookingCancelledReasons(_logonSettings.LogonId, collectionRequest);

                if (returnValue.Success)
                {
                    _ddlReason.DataSource     = returnValue.CancellationCodes.Rows;
                    _ddlReason.DataTextField  = "Description";
                    _ddlReason.DataValueField = "Code";
                    _ddlReason.DataBind();
                }
                else
                {
                    throw new Exception(returnValue.Message);
                }
            }
            catch (System.ServiceModel.EndpointNotFoundException)
            {
                _lblError.Text     = DataConstants.WSEndPointErrorMessage;
                _lblError.CssClass = "errorMessage";
            }
            catch (Exception ex)
            {
                _lblError.Text     = ex.Message;
                _lblError.CssClass = "errorMessage";
            }
            finally
            {
                if (diaryService != null)
                {
                    if (diaryService.State != System.ServiceModel.CommunicationState.Faulted)
                    {
                        diaryService.Close();
                    }
                }
            }
            //try
            //{
            //    _ddlReason.DataSource = DataTables.GetReasonType();
            //    _ddlReason.DataTextField = "reason";
            //    _ddlReason.DataValueField = "reason";
            //    _ddlReason.DataBind();
            //}
            //catch (Exception ex)
            //{
            //    throw ex;
            //}
        }
        private void BindReasonType()
        {
            DiaryServiceClient diaryService = null;
            try
            {
                diaryService = new DiaryServiceClient();

                CollectionRequest collectionRequest = new CollectionRequest();
                collectionRequest.ForceRefresh = true;
                collectionRequest.StartRow = 0;
                collectionRequest.RowCount = 0;

                CancellationCodeSearchReturnValue returnValue = new CancellationCodeSearchReturnValue();
                returnValue = diaryService.GetBookingCancelledReasons(_logonSettings.LogonId, collectionRequest);

                if (returnValue.Success)
                {
                    _ddlReason.DataSource = returnValue.CancellationCodes.Rows;
                    _ddlReason.DataTextField = "Description";
                    _ddlReason.DataValueField = "Code";
                    _ddlReason.DataBind();
                }
                else
                {
                    throw new Exception(returnValue.Message);
                }
            }
            catch (System.ServiceModel.EndpointNotFoundException)
            {
                _lblError.Text = DataConstants.WSEndPointErrorMessage;
                _lblError.CssClass = "errorMessage";
            }
            catch (Exception ex)
            {
                _lblError.Text = ex.Message;
                _lblError.CssClass = "errorMessage";
            }
            finally
            {
                if (diaryService != null)
                {
                    if (diaryService.State != System.ServiceModel.CommunicationState.Faulted)
                        diaryService.Close();
                }
            }
            //try
            //{
            //    _ddlReason.DataSource = DataTables.GetReasonType();
            //    _ddlReason.DataTextField = "reason";
            //    _ddlReason.DataValueField = "reason";
            //    _ddlReason.DataBind();
            //}
            //catch (Exception ex)
            //{
            //    throw ex;
            //}
        }