/// <summary>
        /// Provides the languages.
        /// </summary>
        /// <remarks>
        ///  Sequence Diagram:<br/>
        /// <img src="SequenceDiagrams/SD_PrintRoverWeb.Administration.ManageLanguage.ProvideLanguages.jpg" />
        /// </remarks>
        private void ProvideLanguages()
        {
            CultureInfo[] cultures = CultureInfo.GetCultures(CultureTypes.SpecificCultures);


            DataTable dataTableNew = new DataTable();

            dataTableNew.Columns.Add("RESX_CULTURE_ID");
            dataTableNew.Columns.Add("RESX_DISPLAYNAME");
            DataSet dsLanguages = ApplicationSettings.ProvideExistingLanguages();


            for (int language = 0; language < cultures.Length; language++)
            {
                string    cultureId = cultures[language].ToString();
                DataRow[] dataRowExistingLanguage = dsLanguages.Tables[0].Select("APP_CULTURE='" + cultureId + "'");
                if (dataRowExistingLanguage.Length < 1)
                {
                    dataTableNew.Rows.Add(cultureId, cultures[language].DisplayName.ToString());
                }
            }

            DropDownListLanguage.DataSource     = dataTableNew;
            DropDownListLanguage.DataTextField  = "RESX_DISPLAYNAME";
            DropDownListLanguage.DataValueField = "RESX_CULTURE_ID";
            DropDownListLanguage.DataBind();
        }
        /// <summary>
        /// Provides the editable language.
        /// </summary>
        /// <remarks>
        ///  Sequence Diagram:<br/>
        /// <img src="SequenceDiagrams/SD_PrintRoverWeb.Administration.ManageLanguage.ProvideEditableLanguage.jpg" />
        /// </remarks>
        private void ProvideEditableLanguage()
        {
            DbDataReader drLanguages = ApplicationSettings.ProvideEditLanguages();

            DropDownListLanguage.DataSource     = drLanguages;
            DropDownListLanguage.DataTextField  = "APP_LANGUAGE";
            DropDownListLanguage.DataValueField = "APP_CULTURE";
            DropDownListLanguage.DataBind();
            drLanguages.Close();
        }
        /// <summary>
        /// Provides the languages.
        /// </summary>
        /// <remarks>
        /// Sequence Diagram:<br/>
        ///     <img src="SequenceDiagrams/SD_PrintRoverWeb.Administration.CustomMessages.ProvideLanguages.jpg"/>
        /// </remarks>
        private void ProvideLanguages()
        {
            DropDownListLanguage.DataSource     = ApplicationSettings.ProvideLanguages(); //Application["APP_LANGUAGES"] as DataTable;
            DropDownListLanguage.DataTextField  = "APP_LANGUAGE";
            DropDownListLanguage.DataValueField = "APP_CULTURE";
            DropDownListLanguage.DataBind();

            string currentCulture = Session["SelectedCulture"] as string;

            if (string.IsNullOrEmpty(currentCulture))
            {
                currentCulture = DataManager.Provider.SystemInfo.CurrentCulture();
            }
            else if (string.IsNullOrEmpty(currentCulture))
            {
                currentCulture = "en-US";
            }
        }