/// <summary>
        /// Create or update a Theme Language
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        internal int CreateOrUpdate(ThemeLanguage_DTO dto)
        {
            var inputParams = new List <ADO_inputParams>()
            {
                new ADO_inputParams()
                {
                    name = "@ThmCode", value = dto.ThmCode
                },
                new ADO_inputParams()
                {
                    name = "@TlgValue", value = dto.ThmValue
                },
                new ADO_inputParams()
                {
                    name = "@ThmIsoCode", value = dto.LngIsoCode
                }
            };

            var returnParam = new ADO_returnParam()
            {
                name = "@ReturnVal", value = 0
            };

            ado.ExecuteNonQueryProcedure("System_Navigation_ThemeLanguage_CreateOrUpdate", inputParams, ref returnParam);

            return((int)returnParam.value);
        }
        /// <summary>
        /// Create and Update a SubjectLanguage
        /// </summary>
        /// <param name="dto"></param>
        /// <param name="Ado"></param>
        /// <returns></returns>
        internal int CreateOrUpdate(Theme_DTO_Update dto, ADO Ado)
        {
            ThemeLanguage_DTO themeLanguageDTO = new ThemeLanguage_DTO
            {
                ThmValue   = dto.ThmValue,
                ThmCode    = dto.ThmCode,
                LngIsoCode = dto.LngIsoCode
            };
            ThemeLanguage_ADO themeLanguageADO = new ThemeLanguage_ADO(Ado);

            return(themeLanguageADO.CreateOrUpdate(themeLanguageDTO));
        }