Recording a specific episode based on season and episode number

[cbgifford]

It is, it looked like it couldn't find system.data.sqlite dll so I moved it to the bin\debug directory and then got a different exception that has my stumped for the moment.

ERR: Failed to complete setup of assembly (hr = 0x80131040). Probing terminated.

HResult=-2146234304
Message=Could not load file or assembly 'System.Data.SQLite, Version=1.0.85.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
Source=NUtility
StackTrace:
at NUtility.DatabaseHelper..ctor()
at NUtility.DatabaseHelper..cctor()
InnerException:

[sub]

Did you follow my advice about setting the target to x86? You need to do that, or you'll get that error.

[cbgifford]

Did you follow my advice about setting the target to x86? You need to do that, or you'll get that error.

Yes I did, that's the confusing part

[sub]

Did you try dropping your executable in "c:\program files (x86)\npvr" and running it form there? It might be some other dependency missing.

[mvallevand]

There is sqlite.interop.dll needed for sure

Martin

[cbgifford]

Did you try dropping your executable in "c:\program files (x86)\npvr" and running it form there? It might be some other dependency missing.

What that issue was that I had the latest SQLite instead of the version in the NPVR directory. I dropped that version in the debug directory and the error went away, however, now the app just stares at me and appears to be dead but is sitting on the line below doing what appears to benothing, it's not locked up, I can break out of it. It just sits there. :confused:

Code:

NUtility.ScheduleHelperFactory.GetScheduleHelper.ScheduleRecording(NUtility.EPGEvent.LoadByOID(t.Rows(X).Item("OID")), RecordingQuality.QUALITY_DEFAULT)

[cbgifford]

The only thing I can come up with is that the utility needs to run on the server instead of the client but work comes early for me so my plan for tomorrow is to install NPVR onto the development machine. I'll let you know what happens.

Thanks sub, I would have never gotten as far as I have without your help. I make a good utilities programmer, plugins not so much. If there's anything y'all need done in that area that I can help with, I'd be happy to.

[cbgifford]

I converted sub's code to VB, that's below. Everything works up to the line that actually tries to schedule. When I compile and run the code from the NPVR program directory, nothing happens. I checked the task manager and it shows up as a background process and then exits a few seconds later. When I try and run it in the environment, I get the highlighted error. Any ideas what I'm doing wrong?

An unhandled exception of type 'System.NotImplementedException' occurred in NShared.dll

Additional information: The method or operation is not implemented.

Code:

Sub Main()
        '
        ' Check for existance of config file and create if missing
        '
        If My.Settings.NConnection = "" Or Command() = "/C" Then
            frmInteractive.ShowDialog()
        End If
        Dim t As DataTable
        t = LoadEPG("SELECT * FROM EPG_EVENT WHERE season = 1 and episode=1 AND first_run='Y'")
        For X As Integer = 0 To t.Rows.Count - 1

            If ScheduleHelperFactory.GetScheduleHelper() Is Nothing Then
                RecordingServiceProxy.ForceRemote()
                ScheduleHelperFactory.SetScheduleHelper(RecordingServiceProxy.GetInstance())
                PluginRegistry.GetInstance().LoadPlugins()
            End If
            Dim helper As IScheduleHelper = ScheduleHelperFactory.GetScheduleHelper()

            evt = EPGEvent.LoadByOID(t.Rows.Item(X).Item("OID"))
            If evt IsNot Nothing Then
                Dim myRecording As New ScheduledRecording()
                If True Then
                    myRecording = helper.ScheduleRecording(evt, 1, 0, RecordingQuality.QUALITY_BEST, "[TV Shows]")
                    If myRecording IsNot Nothing Then
                        Logger.Debug((myRecording.OID.ToString() & " Schedule " & evt.StartTime.ToLocalTime().ToString("yyyy-MM-dd HH:mm") & " ") + evt.Subtitle)
                    Else

                        Logger.Debug((evt.OID.ToString() & " Failed   " & evt.StartTime.ToLocalTime().ToString("yyyy-MM-dd HH:mm") & " ") + evt.Subtitle)
                    End If

                End If
            End If
        Next
        MsgBox("Finished!")
    End Sub

[cbgifford]

Think I know what happened, my development machine does not have a physical tuner in it, teh stack trace points to the IP TV device. Answers that! Off to drop the executable on the actual box. Looks like I need to build a development machine with an actual physical tuner in it.

System.NotImplementedException was unhandled
HResult=-2147467263
Message=The method or operation is not implemented.
Source=NShared
StackTrace:
at NShared.IPTVRecorder.IsMultiRecordPossible(ScheduledRecording requiredRecording, List`1 overlappingRecordings)
at NShared.Visible.CaptureSource.CanRecord(ScheduledRecording scheduledRecording)
at NShared.RecordingServiceProxy.ScheduleRecording(EPGEvent epgEvent, Boolean onlyNewEpisodes, ScheduledRecording scheduledEvent, Boolean allocateRecurring, DayMask dayMask, Int32 keep, Int32 recurrenceGroupID, Boolean timeslot, Boolean forceScheduleReload, String advancedRules)
at NShared.RecordingServiceProxy.ScheduleRecording(EPGEvent epgEvent, ScheduledRecording scheduledEvent, Boolean allocateRecurring, DayMask dayMask, Int32 keep, Int32 recurrenceGroupID, Boolean timeslot, Boolean forceScheduleReload)
at NShared.RecordingServiceProxy.ScheduleRecording(EPGEvent epgEvent, Int32 prePadding, Int32 postPadding, RecordingQuality quality, String recordingDirectoryID)
at NScheduler.modMain.Main() in C:\Users\Chris\Documents\Visual Studio 2013\Projects\NScheduler\modMain.vb:line 123
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
at System.AppDomain.nExecuteAssembly(RuntimeAssembly assembly, String[] args)
at System.Runtime.Hosting.ManifestRunner.Run(Boolean checkAptModel)
at System.Runtime.Hosting.ManifestRunner.ExecuteAsAssembly()
at System.Runtime.Hosting.ApplicationActivator.CreateInstance(ActivationContext activationContext, String[] activationCustomData)
at System.Runtime.Hosting.ApplicationActivator.CreateInstance(ActivationContext activationContext)
at System.Activator.CreateInstance(ActivationContext activationContext)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssemblyDebugInZone()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:

[cbgifford]

Okey Dokey, success in translating code from C# to VB, it works! Now I have a question, what method do I call to schedule a recurring show instead of a one time episode?