internal static LanguageURL GetLanguageURL(List<LanguageURL> LanguageURLs, SqlDataReader reader)
        {
            int colIndex = 0;
            colIndex = reader.GetOrdinal(CN_LANGUAGE_URL_ID);
            int value = reader.GetInt32(colIndex);

            LanguageURL LanguageURL = LanguageURLs.Where(c => c.ID == value).FirstOrDefault();
            if (LanguageURL == null)
            {
                LanguageURL = new LanguageURL();
                LanguageURLs.Add(LanguageURL);
            }
            return LanguageURL;
        }
        internal static void FillFromReader(LanguageURL LanguageURL, SqlDataReader reader)
        {
            int colIndex = 0;
            colIndex = reader.GetOrdinal(CN_LANGUAGE_URL_ID);
            if (!reader.IsDBNull(colIndex))
                LanguageURL.ID = reader.GetInt32(colIndex);

            colIndex = reader.GetOrdinal(CN_LANGUAGE_URL_NAME);
            if (!reader.IsDBNull(colIndex))
                LanguageURL.Name = reader.GetString(colIndex);

            colIndex = reader.GetOrdinal(CN_LANGUAGE_URL_LANGUAGE_ID);
            if (!reader.IsDBNull(colIndex))
                LanguageURL.LanguageID = reader.GetInt32(colIndex);

            colIndex = reader.GetOrdinal(CN_LANGUAGE_URL_PORTAL_ID);
            if (!reader.IsDBNull(colIndex))
                LanguageURL.PortalID = reader.GetInt32(colIndex);

        }