示例#1
0
    public string GET_SiteMapAddress(string TargerGroupID)
    {
        Database  db             = new Database();
        DataTable dt             = new DataTable();
        int       nRet           = -1;
        string    SiteMapAddress = "";

        /*連線DB*/
        nRet = db.DBConnect();
        if (nRet == 0)
        {
            string strParentGroupID = NUtility.trimBad(Session["ParentGroupID"].ToString());
            string srtTargerGroupID = NUtility.trimBad(TargerGroupID);



            string SiteMap_SQL = @"DECLARE @Sitemap nvarchar(4000)  
                SET @Sitemap = ''  
                /*取得Sitmap*/  
                SELECT @Sitemap = @Sitemap + SecurityGroup.GroupName + '/'  
                FROM dbo.UTILfn_Split(  
                    (SELECT GroupSearchKey + '/' + GroupID FROM dbo.fn_GetGroupTree(@ParentGroupID_1) WHERE GroupID = @TargerGroupID),  
                    '/') AS tblA  
                INNER JOIN SecurityGroup ON tblA.[Value] = SecurityGroup.GroupID  
                WHERE tblA.[Value] <> (  
                    SELECT ParentGroupID FROM SecurityRelation WHERE AccountID =@ParentGroupID_2
                )  
                SELECT @Sitemap AS Sitemap ";


            System.Data.SqlClient.SqlCommand SqlCom = new System.Data.SqlClient.SqlCommand(SiteMap_SQL, db.getOcnn());

            SqlCom.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ParentGroupID_1", MDS.Utility.NUtility.trimBad(strParentGroupID)));
            SqlCom.Parameters.Add(new System.Data.SqlClient.SqlParameter("@TargerGroupID", MDS.Utility.NUtility.trimBad(srtTargerGroupID)));
            SqlCom.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ParentGroupID_2", MDS.Utility.NUtility.trimBad(strParentGroupID)));

            //呼叫傳入參數式sqlcmd的方法
            nRet = db.ExecQuerySQLCommand(SqlCom, ref dt);



            if (nRet == 0)
            {
                if (dt.Rows.Count > 0)
                {
                    SiteMapAddress = dt.Rows[0]["Sitemap"].ToString();
                }
            }

            db.DBDisconnect();
        }

        return(SiteMapAddress);
    }
示例#2
0
        public Recording(NUtility.ScheduledRecording BaseRecording, int UserOid)
        {
            this.BaseRecording = BaseRecording;

            this.Name = BaseRecording.Name;
            this.CaptureSourceOID = BaseRecording.CaptureSourceOID;
            this.ChannelName = BaseRecording.ChannelName;
            this.ChannelOID = BaseRecording.ChannelOID;
            this.EndTime = BaseRecording.EndTime;
            this.FailureReason = BaseRecording.FailureReason;
            this.Filename = BaseRecording.Filename;
            this.OID = BaseRecording.OID;
            this.PostPadding = BaseRecording.PostPadding;
            this.PrePadding = BaseRecording.PrePadding;
            this.StartTime = BaseRecording.StartTime;
            this.Status = BaseRecording.Status;
            this.EventOid = BaseRecording.EventOID;
            this.RecurrenceOid = BaseRecording.RecurrenceOID;

            NUtility.EPGEvent epgevent = Helpers.NpvrCoreHelper.EPGEventLoadByOID(BaseRecording.OID);

            var channel = Helpers.NpvrCoreHelper.ChannelLoadByOID(BaseRecording.ChannelOID);
            if (channel != null)
            {
                this.ChannelHasIcon = channel.Icon != null;
                this.ChannelNumber = channel.Number;
            }

            if (epgevent != null)
            {
                this.Subtitle = epgevent.Subtitle;
                this.Title = epgevent.Title;
                this.OriginalAirDate = epgevent.OriginalAirDate;
                this.Quality = epgevent.Quality;
                this.Rating = epgevent.Rating;
                this.Season = epgevent.Season;
                this.Episode = epgevent.Episode;
                this.Genres = epgevent.Genres;
                this.Description = epgevent.Description;
                this.Aspect = epgevent.Aspect;
                this.Audio = epgevent.Audio;
                this.StarRating = epgevent.StarRating;
            }
        }
示例#3
0
 public EpgListing(NUtility.EPGEvent EpgEvent)
 {
     this.Aspect = EpgEvent.Aspect;
     this.Audio = EpgEvent.Audio;
     this.ChannelOid = EpgEvent.ChannelOID;
     this.Description = EpgEvent.Description;
     this.EndTime = EpgEvent.EndTime;
     this.Episode = EpgEvent.Episode;
     this.FirstRun = EpgEvent.FirstRun;
     this.Genres = EpgEvent.Genres;
     this.Oid = EpgEvent.OID;
     this.OriginalAirDate = EpgEvent.OriginalAirDate;
     this.Rating = EpgEvent.Rating;
     this.Season = EpgEvent.Season;
     this.StarRating = EpgEvent.StarRating;
     this.StartTime = EpgEvent.StartTime;
     this.Subtitle = EpgEvent.Subtitle;
     this.Title = EpgEvent.Title;
 }
        public RecurringRecording(NUtility.RecurringRecording BaseRecurringRecording)
        {
            this.AdvancedRules = BaseRecurringRecording.AdvancedRules;
            this.ChannelName = BaseRecurringRecording.ChannelName;
            this.ChannelOid = BaseRecurringRecording.ChannelOID;
            this.DayMask = BaseRecurringRecording.DayMask;
            this.EndTime = BaseRecurringRecording.EndTime;
            this.Keep = BaseRecurringRecording.Keep;
            this.MatchRules = BaseRecurringRecording.MatchRules;
            this.Name = BaseRecurringRecording.Name;
            this.Oid = BaseRecurringRecording.OID;
            this.OnlyNewEpisodes = BaseRecurringRecording.OnlyNewEpisodes;
            this.PostPadding = BaseRecurringRecording.PostPadding;
            this.PrePadding = BaseRecurringRecording.PrePadding;
            this.Quality = BaseRecurringRecording.Quality;
            this.RecordingDirectoryId = BaseRecurringRecording.RecordingDirectoryID;
            this.StartTime = BaseRecurringRecording.StartTime;
            this.Timeslot = BaseRecurringRecording.Timeslot;

            this.EpgTitle = BaseRecurringRecording.EPGTitle;

            this.ChannelHasIcon = BaseRecurringRecording.ChannelName == "All Channels" || (BaseRecurringRecording.Channel != null && BaseRecurringRecording.Channel.Icon != null);

            if (OnlyNewEpisodes && !this.Timeslot && DayMask == NUtility.DayMask.ANY && ChannelOid > 0)
                this.Type = RecordingType.Record_Season_New_This_Channel;
            else if (!OnlyNewEpisodes && !this.Timeslot && DayMask == NUtility.DayMask.ANY && ChannelOid > 0)
                this.Type = RecordingType.Record_Season_All_This_Channel;
            else if (this.Timeslot && DayMask == NUtility.DayMask.ANY && ChannelOid > 0)
                this.Type = RecordingType.Record_Season_Daily_This_Timeslot;
            else if (this.Timeslot && ChannelOid > 0 && ((int)this.DayMask & ((int)this.DayMask - 1)) == 0) // make sure only 1 day is set, by checking daymask is a power of 2
                this.Type = RecordingType.Record_Season_Weekly_This_Timeslot;
            else if (this.Timeslot && ChannelOid > 0 && this.DayMask == (NUtility.DayMask.MONDAY | NUtility.DayMask.TUESDAY | NUtility.DayMask.WEDNESDAY | NUtility.DayMask.THURSDAY | NUtility.DayMask.FRIDAY))
                this.Type = RecordingType.Record_Season_Weekdays_This_Timeslot;
            else if (this.Timeslot && ChannelOid > 0 && this.DayMask == (NUtility.DayMask.SATURDAY | NUtility.DayMask.SUNDAY))
                this.Type = RecordingType.Record_Season_Weekends_This_Timeslot;
            else if (!this.Timeslot && this.ChannelOid == 0 && this.DayMask == NUtility.DayMask.ANY && !this.OnlyNewEpisodes)
                this.Type = RecordingType.Record_Season_All_Episodes_All_Channels;
        }
        public static RecordingType GetRecordingType(NUtility.RecurringRecording RecurringRecording)
        {
            // put most specific at top
            if (RecurringRecording.OnlyNewEpisodes == false && RecurringRecording.Timeslot && RecurringRecording.DayMask == (DayMask.MONDAY | DayMask.TUESDAY | DayMask.WEDNESDAY | DayMask.THURSDAY | DayMask.FRIDAY))
                return RecordingType.Record_Season_Weekdays_This_Timeslot;

            if (RecurringRecording.OnlyNewEpisodes == false && RecurringRecording.Timeslot && RecurringRecording.DayMask == (DayMask.SATURDAY | DayMask.SUNDAY))
                return RecordingType.Record_Season_Weekends_This_Timeslot;

            if (RecurringRecording.OnlyNewEpisodes && RecurringRecording.Timeslot && ((((int)RecurringRecording.DayMask) & (((int)RecurringRecording.DayMask) - 1)) == 0))
                return RecordingType.Record_Season_Weekly_This_Timeslot;

            if (RecurringRecording.OnlyNewEpisodes && RecurringRecording.Timeslot == false && RecurringRecording.DayMask == DayMask.ANY && RecurringRecording.ChannelOID == 0)
                return RecordingType.Record_Season_All_Episodes_All_Channels;

            if (RecurringRecording.OnlyNewEpisodes && RecurringRecording.Timeslot == false && RecurringRecording.DayMask == NUtility.DayMask.ANY)
                return RecordingType.Record_Season_New_This_Channel;
            if (RecurringRecording.OnlyNewEpisodes == false && RecurringRecording.Timeslot == false && RecurringRecording.DayMask == NUtility.DayMask.ANY)
                return RecordingType.Record_Season_All_This_Channel;
            if (RecurringRecording.OnlyNewEpisodes == false && RecurringRecording.Timeslot == true && RecurringRecording.DayMask == NUtility.DayMask.ANY)
                return RecordingType.Record_Season_Daily_This_Timeslot;

            return RecordingType.Record_Once; // unknown assume once
        }
示例#6
0
        private Models.EpgListing GetListingToRecord(NUtility.DayMask DayMask = NUtility.DayMask.ANY)
        {
            var controller = base.LoadController<NextPvrWebConsole.Controllers.Api.GuideController>(User);

            DateTime date = DateTime.Now.AddDays(1);
            switch (DayMask)
            {
                case NUtility.DayMask.MONDAY: date = date.Next(DayOfWeek.Monday); break;
                case NUtility.DayMask.TUESDAY: date = date.Next(DayOfWeek.Tuesday); break;
                case NUtility.DayMask.WEDNESDAY: date = date.Next(DayOfWeek.Wednesday); break;
                case NUtility.DayMask.THURSDAY: date = date.Next(DayOfWeek.Thursday); break;
                case NUtility.DayMask.FRIDAY: date = date.Next(DayOfWeek.Friday); break;
                case NUtility.DayMask.SATURDAY: date = date.Next(DayOfWeek.Saturday); break;
                case NUtility.DayMask.SUNDAY: date = date.Next(DayOfWeek.Sunday); break;
                case NUtility.DayMask.SATURDAY | NUtility.DayMask.SUNDAY: if (date.DayOfWeek != DayOfWeek.Sunday) { date = date.Next(DayOfWeek.Saturday); } break;
                case NUtility.DayMask.MONDAY | NUtility.DayMask.TUESDAY | NUtility.DayMask.WEDNESDAY | NUtility.DayMask.THURSDAY | NUtility.DayMask.FRIDAY: if (date.DayOfWeek == DayOfWeek.Saturday || date.DayOfWeek == DayOfWeek.Sunday) { date = date.Next(DayOfWeek.Monday); } break;
            }

            var listings = Models.ChannelGroup.LoadAll(User.Oid, false)
                                              .Take(1)
                                              .SelectMany(x => controller.Get(date, x.Name))
                                              .SelectMany(x => x.Listings)
                                              .OrderByDescending(x => x.StartTime)
                                              .ToList();

            var listing = listings.Where(x => x.StartTime > DateTime.UtcNow.AddMinutes(15))
                                  .OrderBy(x => Guid.NewGuid()) // random order
                                  .FirstOrDefault();

            return listing;
        }