Schedule Corrector Plugin (automaticly)

[MoPhat]

Hi i have started to delvelop a plugin witch checks the recording (schedule) table and if the recording time has changed will the plugin change the schedule time to a new one.

the goal is that no more recordings g to manual recordings

I have now a few probs...

1. How do i am using the gentle.config to receive the connection string?
2. how do i am fire the schedule update to the TVServer, im just change the SQL table entry?

the solution has a test form for testing purpose.

thanks for any feedback
MoPhat

[MoPhat]

No one a idea?



MoPhat

[gemx]

1)
Have a look at "SetupDatabaseForm.cs" and there at the function "public bool TestConnection()" starting at line 167 and "LoadConnectionDetails"
but you said you intend to write a plugin (i think for TvServer) because then you don't need to bother with the connection details. TvServer establishes the connection upon starting up. You can just use the DB wrapper classes

2)
Just call "RemoteControl.Instance.OnNewSchedule();".

Hope this helps.
I like your idea very much

[MoPhat]

Thank you gemx

I hate that if the recordings going to "manual", my wife asks me everytime: where is my recording???

In my code i have normaly sql statements like this:

public static void update_ScheduleEntry(cProgram schedule)
        {
            SqlConnection SqlCon = new SqlConnection(myConnection);
            try
            {
                SqlCon.Open();
                SqlCommand SqlCmd = new SqlCommand("UPDATE Schedule SET  startTime = @startTime, endTime = @endTime WHERE id_Schedule = @id_Schedule", SqlCon);
                SqlCmd.Parameters.AddWithValue("@id_Schedule", schedule.id_Schedule);
                SqlCmd.Parameters.AddWithValue("@startTime", schedule.startTime);
                SqlCmd.Parameters.AddWithValue("@endTime", schedule.endTime);
                SqlCmd.ExecuteNonQuery();
            }
            catch (Exception exp)
            {
                Log.Error(exp.Message, new object[0]);
            }
            finally
            {
                if (SqlCon.State == ConnectionState.Open)
                {
                    SqlCon.Close();
                }
            }
        }

and i need just for the "myConnection" the connection string of Gentle.Config

Do i get with "LoadConnectionDetails" a SqlConnection object?

Can i fire at last the method RemoteControl.Instance.OnNewSchedule();" or on every table change?


P.S.

I have a idea for documentations:
Everyone ho create/change a interface / namespace / method etc. must update/create a wiki entry for this piece of code.

Without that, the code/patch etc. is not inserted in the SVN!
Then we had a well docu of all this classes

What do you think about that?

thank you for your help
MoPhat

[MoPhat]

No one a tip?

[MoPhat]

bump, no one any tips for me?



MoPhat

[dvdfreak]

Have you considered using TV Scheduler?

Rule-based TvScheduler service

It does exactly what you want, and so much more...

[MoPhat]

Hi dvdfreak, i know that , but its now fully integrated in to MP?
I use my MP only with my remote control (and my wife too).

MoPhat

[dvdfreak]

Originally Posted by MoPhat

Hi dvdfreak, i know that , but its now fully integrated in to MP?
I use my MP only with my remote control (and my wife too).

Stay tuned then, announcement coming soon(ish)... Hope you will like it...

[MoPhat]

Ok.... should i stop my dev on this plugin?

MoPhat