private void BindCategoryType()
        {
            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.GetBookingCancelledCategories(_logonSettings.LogonId, collectionRequest);

                if (returnValue.Success)
                {
                    _ddlCategory.DataSource     = returnValue.CancellationCodes.Rows;
                    _ddlCategory.DataTextField  = "Description";
                    _ddlCategory.DataValueField = "Code";
                    _ddlCategory.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
            //{
            //    _ddlCategory.DataSource = DataTables.GetCategoryType();
            //    _ddlCategory.DataTextField = "category";
            //    _ddlCategory.DataValueField = "category";
            //    _ddlCategory.DataBind();
            //}
            //catch (Exception ex)
            //{
            //    throw ex;
            //}
        }
        private void BindCategoryType()
        {
            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.GetBookingCancelledCategories(_logonSettings.LogonId, collectionRequest);

                if (returnValue.Success)
                {
                    _ddlCategory.DataSource = returnValue.CancellationCodes.Rows;
                    _ddlCategory.DataTextField = "Description";
                    _ddlCategory.DataValueField = "Code";
                    _ddlCategory.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
            //{
            //    _ddlCategory.DataSource = DataTables.GetCategoryType();
            //    _ddlCategory.DataTextField = "category";
            //    _ddlCategory.DataValueField = "category";
            //    _ddlCategory.DataBind();
            //}
            //catch (Exception ex)
            //{
            //    throw ex;
            //}
        }