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); }