Exemplo n.º 1
0
        /// <summary>
        ///     Adds entries to <paramref name="dictionary" />, based on the languages in <paramref name="excelCells" />
        /// </summary>
        /// <exception cref="CultureNotFoundException">
        ///     Thrown, if one of the cells of the header rows in <paramref name="excelCells" /> is not recognized as
        ///     a language.
        /// </exception>
        public static void FillSubDictionaries(Dictionary <CultureInfo, Dictionary <string, string> > dictionary,
                                               object[,] excelCells, int maxColumn, int numberOfKeyParts)
        {
            for (var langIndex = numberOfKeyParts + 1; langIndex <= maxColumn; langIndex++)
            {
                var lang = CultureInfoUtil.GetCultureInfo(ExcelCellToString(excelCells[1, langIndex]),
                                                          true);

                if (!dictionary.ContainsKey(lang))
                {
                    dictionary.Add(lang, new Dictionary <string, string>());
                }
            }
        }
Exemplo n.º 2
0
        /// <summary>
        ///     Returns a dictionary that maps <see cref="CultureInfo" /> objects to their column of
        ///     <paramref name="excelCells" />, in which they appear.
        /// </summary>
        /// <exception cref="CultureNotFoundException">
        ///     Thrown, if one of the cells of the header rows in <paramref name="excelCells" /> is not recognized as
        ///     a language.
        /// </exception>
        public static Dictionary <CultureInfo, int> GetLanguageColumnsLookupTable(object[,] excelCells,
                                                                                  int numberOfKeyParts)
        {
            var lookupTable = new Dictionary <CultureInfo, int>();
            var maxColumn   = excelCells.GetUpperBound(1);

            for (var column = GetNumberOfKeyParts(excelCells) + 1; column <= maxColumn; column++)
            {
                var culture = CultureInfoUtil.GetCultureInfo(
                    ExcelCellToString(excelCells[1, column]), true);
                lookupTable.Add(culture, column);
            }

            return(lookupTable);
        }
Exemplo n.º 3
0
        /// <summary>
        ///     Counts how many columns are reserved for the translation key, based on the
        ///     first column that can be identified as a language column.
        /// </summary>
        /// <param name="excelCells">The array conatining all cell values out of the sheet.</param>
        /// <returns>The number of columns reserved for the translation key.</returns>
        public static int GetNumberOfKeyParts(object[,] excelCells)
        {
            var maxColumn = excelCells.GetUpperBound(1);

            for (var column = 1; column <= maxColumn; column++)
            {
                var culture = CultureInfoUtil.GetCultureInfoOrDefault(
                    ExcelCellToString(excelCells[1, column]), true);

                if (culture != null)
                {
                    return(column - 1);
                }
            }

            return(maxColumn);
        }
Exemplo n.º 4
0
        /// <summary>
        ///     Adds an entry consisting of <paramref name="keyOfRow" /> and the translation in
        ///     <paramref name="translationCell" /> to <paramref name="dictionary" /> for the
        ///     language in <paramref name="languageCell" />.
        ///     If the language in <paramref name="languageCell" /> cannot be found or the
        ///     <paramref name="translationCell" /> is empty, <paramref name="dictionary" /> will not be updated.
        /// </summary>
        public static void TryAddExcelCellToDictionary(Dictionary <CultureInfo, Dictionary <string, string> > dictionary,
                                                       object languageCell, object translationCell, string keyOfRow)
        {
            var lang = CultureInfoUtil.GetCultureInfoOrDefault(
                ExcelCellToString(languageCell), true);

            if (lang == null)
            {
                return;
            }

            var translationString = translationCell as string;

            if (!string.IsNullOrEmpty(translationString))
            {
                dictionary[lang].Add(keyOfRow, translationString);
            }
        }