What is News Analysis?

A new look for the whole site: one fit-to-window layout with the newsanalysis.com logo, and redesigned News, Newsmap, Link Analysis, Timeline, Podcast, TV News and About pages.

Changes:
- News: live feed with AI summaries, sentiment and bias gauges, a location map and a news-volume chart
- Newsmap: section toggles, stories per section and a story preview
- Link Analysis: ring graph with type filters, zoom and an entity card with 30-day mentions
- Timeline: a filmstrip player that steps through the coverage story by story or day by day
- Podcast: chapters, a synced transcript and story cards
- TV News: duplicate clips removed, edition language by default, autoplay next
- newsanalysis.org now redirects to newsanalysis.com

Enhanced podcast page with source cards, transcript improvements, and audio player fixes.

Changes:
- Fixed Episode entity column mapping (Updated_At to Completed_At)
- Added intro/closing script extraction from full transcript
- Calculate MP3 duration from file size (fixes concatenated MP3 metadata)
- Added source cards with article image, summary, publisher, and category
- JOIN query across SocialPosts, NewsFeeds, and Categories for source data
- Extract publisher domain from Article_URL to avoid news.google.com display
- Fixed column separator CSS to extend to footer
- Enabled timeline seeking in audio player

Added Autofac 4.9.4 for dependency injection. Configured all repositories and DbContexts with InstancePerRequest lifetime. Controllers now receive dependencies via constructor injection.

Updated NewsAnalysis.Build project to use Entity Framework 6 instead of LINQ-to-SQL. Added EF6 references, packages.config, and updated App.config with connection string and EF configuration.

Removed all 4 .dbml files, 4 .dbml.layout files, 4 .designer.cs auto-generated files, and ProfiledDataContextFactory.cs. Removed System.Data.Linq references. Project now uses Entity Framework 6 exclusively.

Converted all controller actions to async Task. Updated API controllers for async operations. Fixed OWIN startup issues. GitHub Issue #84.

Converted all 11 repositories to async/await patterns with proper EF6 async operations (ToListAsync, FirstOrDefaultAsync, SaveChangesAsync). Maintained sync versions where needed for Razor views. GitHub Issue #83.

Migrated all 4 LINQ-to-SQL DataContexts to Entity Framework 6. Created 33 entity classes, 4 DbContexts (NewsAnalysis, Meta, News, Live), and stored procedure result classes. Configured Autofac DI for DbContext lifecycle management. GitHub Issue #82.

- fixed #64: double-click nav dropdown issue by removing duplicate Bootstrap JS from _Layout.cshtml
- fixed #65: graph/news chart mismatch by using in-memory HashSet filtering instead of SQL IN clause in GetNewsItemsByNer
- fixed #63: NER dropdown returning empty results by using in-memory HashSet filtering in GetTopNerItems, SearchNerItems, and GetRelatedEntities
- root cause for #63, #65: SQL IN clause overflow when filtering 30 days of news items (exceeds ~2100 parameter limit)
- added 20 unit tests for Utilities class (Truncate, GetDomain, GetMST3KQuotes)
- fixed HomeControllerTest with HttpContext mocking (5 tests, was 1 failing)
- all 49 unit tests now passing
- closed GitHub issues #63, #64, #65

- fixed article image height to max 200px with vertical centering and overflow hidden
- updated named entity links to use NER ID instead of entity text
- added type ID to entity URLs to differentiate People/Organizations/Locations/Topics
- documented entity URL format in TECHNICAL-REFERENCE.md
- added shareable article URLs with News_Feed_ID parameter
- added browser history support for article navigation (back/forward buttons)
- added scroll-to-article on page load for shared URLs
- removed dead/commented code from Index.cshtml (mobile detection, outgoing links, unused functions)
- moved Google Maps API key from hardcoded to Web.config appSettings
- fixed duplicate progressbar() calls (reduced from 18 to 8 calls)
- consolidated duplicate async/non-async functions (removed 10 unused non-async versions)
- implemented centralized error handling with handleError() function
- fixed race condition in auto-refresh with isRefreshing flag
- restored Twitter section HTML/CSS/JS for future feature development
- created GitHub issues #43-#47 for code quality improvements
- closed GitHub issues #43, #44, #45, #46, #47

- added article image display from database to Article and Summary views
- added article text truncation to 20% to drive traffic to source sites
- normalized article line breaks to always use two
tags
- combined Sentiment Analysis and Political Bias into single "Article Analysis" section
- added auto-select first item when language/category dropdown changes
- added scroll to top on dropdown change in #newsHolder
- fixed multiple selection highlight bug when changing dropdowns
- added title splitting to show only title (not source) in news list
- added title truncation to 64 characters in news list
- added new translation keys (analysis.articleAnalysis, analysis.sentiment, analysis.bias) for all 14+ languages
- updated SQL script to truncate and re-insert all UI translations
- updated README with recent changes

- added API endpoint to refresh category dropdown when language changes
- added calculated height for chart placeholder to prevent layout shift
- added Height parameter to chart API for dynamic chart sizing
- added TV News section height calculation to stay above footer
- added localized 'no data' message for Article Entities when empty
- added SQL script for 'table.noData' translations in all languages

- Added Bahasa, Hindi, English UK news sources
- Minor fixes to newsmap layout

- added function to keep track of db size
- added db size chart
- added shrink db button

- Added content add/edit/etc pages.
- Added feature add/edit/etc pages.

- Added Table Index Sizes in admin
- Added build inc.

- Minor change to one of the api's to calculate news volume

- Added live stats update feed
- Added the about info page (no line stats here yet)
- Version inc.

- The first relase of newsmap.org