public TvShowSegment(Guid segmentId) { _ctx = new MediaCatalogueEntities(); _segment = (from seg in _ctx.Media_Segment .Include("Media_Item") .Include("TV_Presenter") .Include("TV_SeriesCategory") where seg.id == segmentId select seg).FirstOrDefault(); ID = segmentId; if (_segment != null) { var seriesId = (from sm in _ctx.TV_SeriesMedia where sm.Media_Item.id == _segment.Media_Item.id select sm.TV_Series.id).FirstOrDefault(); Presenters = MediaCatalogueHelper.GetTvSeriesPresenters(seriesId, _ctx); Categories = MediaCatalogueHelper.GetTvSeriesCategories(seriesId, _ctx); Title = _segment.Title; Description = _segment.Description; StartOffset = _segment.SectionOffset; SectionLength = _segment.SectionLength; if (_segment.TV_Presenter != null) { Presenter = (from pres in Presenters where pres.ID == _segment.TV_Presenter.id select pres).FirstOrDefault(); } if (_segment.TV_SeriesCategory != null) { Category = (from cat in Categories where cat.ID == _segment.TV_SeriesCategory.id select cat).FirstOrDefault(); } } IsDirty = false; }
public static TvShowSegment NewSegment(Guid tvShowId) { var ctx = new MediaCatalogueEntities(); var seg = new TvShowSegment { ID = Guid.NewGuid(), ParentID = tvShowId, Title = "new segment", Description = "enter a description for this segment." }; var tvSeriesId = (from ser in ctx.TV_SeriesMedia .Include("TV_Series") where ser.Media_Item.id == tvShowId select ser.TV_Series.id).FirstOrDefault(); seg.Presenters = MediaCatalogueHelper.GetTvSeriesPresenters(tvSeriesId, ctx); seg.Categories = MediaCatalogueHelper.GetTvSeriesCategories(tvSeriesId, ctx); return(seg); }