/// <summary>
        /// Gets the ratings.
        /// </summary>
        private void GetRatings()
        {
            ClientServiceClient clientService = null;
            try
            {
                clientService = new ClientServiceClient();
                CollectionRequest collectionRequest = new CollectionRequest();
                RatingSearchCriteria searchCriteria = new RatingSearchCriteria();
                searchCriteria.IncludeArchived = false;
                RatingSearchReturnValue returnValue = clientService.RatingSearch(_logonSettings.LogonId, collectionRequest,
                                                                    searchCriteria);

                if (returnValue.Success)
                {
                    _ddlRating.DataSource = returnValue.Ratings.Rows;
                    _ddlRating.DataTextField = "Description";
                    _ddlRating.DataValueField = "Id";
                    _ddlRating.DataBind();
                }
                else
                {
                    throw new Exception(returnValue.Message);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (clientService != null)
                {
                    if (clientService.State != System.ServiceModel.CommunicationState.Faulted)
                        clientService.Close();
                }
            }
        }