• Главная
• TvDatabase
• TvBusinessLayer

C# Класс TvDatabase.TvBusinessLayer

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод	Описание
AddCard ( string name, string devicePath, TvDatabase.Server server ) : TvDatabase.Card
AddChannelToGroup ( TvDatabase.Channel channel, TvDatabase.ChannelGroup group ) : void
AddChannelToGroup ( TvDatabase.Channel channel, string groupName ) : void
AddChannelToRadioGroup ( TvDatabase.Channel channel, TvDatabase.RadioChannelGroup group ) : void
AddChannelToRadioGroup ( TvDatabase.Channel channel, string groupName ) : void	Add a radio channel to radio group by name
AddNewChannel ( string name, int channelNumber ) : TvDatabase.Channel
AddSchedule ( int idChannel, string programName, System.DateTime startTime, System.DateTime endTime, int scheduleType ) : TvDatabase.Schedule
AddTuningDetails ( TvDatabase.Channel channel, IChannel tvChannel ) : TvDatabase.TuningDetail
AddWebStreamTuningDetails ( TvDatabase.Channel channel, string url, int bitrate ) : TvDatabase.TuningDetail
CreateGroup ( string groupName ) : TvDatabase.ChannelGroup
DeleteCard ( TvDatabase.Card card ) : void
DeleteChannel ( TvDatabase.Channel channel ) : void
EscapeSQLString ( string original ) : string
GetAllRadioChannels ( ) : IList
GetCardByDevicePath ( string path ) : TvDatabase.Card
GetCardByName ( string name ) : TvDatabase.Card
GetChannel ( int idChannel ) : TvDatabase.Channel
GetChannelByTuningDetail ( int networkId, int transportId, int serviceId ) : TvDatabase.Channel
GetChannelType ( TvLibrary.Channels.DVBBaseChannel channel ) : int
GetChannelsByName ( string name ) : IList
GetChannelsInGroup ( TvDatabase.ChannelGroup group ) : IList
GetConflictingSchedules ( TvDatabase.Schedule rec, List &conflictingSchedules, List &notViewableSchedules ) : void
GetDateTimeString ( ) : string
GetGenres ( ) : List
GetGroupByName ( string aGroupName ) : TvDatabase.ChannelGroup
GetGroupByName ( string aGroupName, int aSortOrder ) : TvDatabase.ChannelGroup
GetLinkagesForChannel ( TvDatabase.Channel channel ) : IList
GetMpGenres ( ) : List	Returns a list of MediaPortal genres.
GetNewestProgramForChannel ( int idChannel ) : System.DateTime
GetNowAndNext ( List aEpgChannelList ) : NowAndNext>.Dictionary
GetOnairNow ( ) : IList
GetProgramExists ( TvDatabase.Channel channel, System.DateTime startTime, System.DateTime endTime ) : IList
GetProgramGenres ( ) : List
GetPrograms ( TvDatabase.Channel channel, System.DateTime startTime ) : IList
GetPrograms ( TvDatabase.Channel channel, System.DateTime startTime, System.DateTime endTime ) : IList
GetPrograms ( System.DateTime startTime, System.DateTime endTime ) : IList
GetProgramsByTitle ( TvDatabase.Channel channel, System.DateTime startTime, System.DateTime endTime, string title ) : IList
GetProgramsByTitle ( System.DateTime startTime, System.DateTime endTime, string title ) : IList
GetProgramsForAllChannels ( System.DateTime startTime, System.DateTime endTime, List channelList ) : List>.Dictionary
GetRadioChannelGroupByName ( string name ) : TvDatabase.RadioChannelGroup
GetRadioGuideChannelsForGroup ( int groupID ) : List	Gets a list of radio channels sorted by their group
GetRecordingByFileName ( string fileName ) : TvDatabase.Recording
GetRecordingTimes ( TvDatabase.Schedule rec ) : List
GetRecordingTimes ( TvDatabase.Schedule rec, int days ) : List
GetSchedule ( int idChannel, string programName, System.DateTime startTime, System.DateTime endTime, int scheduleType ) : TvDatabase.Schedule
GetSetting ( string tagName ) : TvDatabase.Setting	gets a value from the database table "Setting"
GetSetting ( string tagName, string defaultValue ) : TvDatabase.Setting	gets a value from the database table "Setting"
GetSofwareEncodersAudio ( ) : IList
GetSofwareEncodersVideo ( ) : IList
GetTVGuideChannelsForGroup ( int groupID ) : List	Gets a list of tv channels sorted by their group
GetTuningChannel ( TvDatabase.TuningDetail detail ) : IChannel
GetTuningChannelByType ( TvDatabase.Channel channel, int channelType ) : IChannel
GetTuningChannelsByDbChannel ( TvDatabase.Channel channel ) : List
GetTuningDetail ( TvLibrary.Channels.DVBBaseChannel channel ) : TvDatabase.TuningDetail
GetTuningDetail ( String url, int channelType ) : TvDatabase.TuningDetail
GetTuningDetail ( int networkId, int serviceId, int channelType ) : TvDatabase.TuningDetail
GetTuningDetail ( int networkId, int transportId, int serviceId, int channelType ) : TvDatabase.TuningDetail
GetTuningDetailsByName ( string name, int channelType ) : IList
InsertPrograms ( List aProgramList, DeleteBeforeImportOption progamsToDelete, ThreadPriority aThreadPriority ) : int	Batch inserts programs - intended for faster EPG import. You must make sure before that there are no duplicates (e.g. delete all program data of the current channel). Also you MUST provide a true copy of "aProgramList". If you update it's reference in your own code the values will get overwritten (possibly before they are written to disk)! Inserts are queued to be performed in the background. Each batch of inserts is executed in a single transaction. You may also optionally specify to delete either all existing programs in the same channel(s) as the programs to be inserted (DeleteBeforeImportOption.ProgramsOnSameChannel), or existing programs that would otherwise overlap new programs (DeleteBeforeImportOption.OverlappingPrograms), or none (DeleteBeforeImportOption.None). The deletion is also performed in the same transaction as the inserts so that EPG will not be at any time empty. After all insert have completed and the background thread is idle for 60 seconds, the program states are automatically updated to reflect the changes.
InsertPrograms ( List aProgramList, ThreadPriority aThreadPriority ) : int	Batch inserts programs - intended for faster EPG import. You must make sure before that there are no duplicates (e.g. delete all program data of the current channel). Also you MUST provide a true copy of "aProgramList". If you update it's reference in your own code the values will get overwritten (possibly before they are written to disk)!
IsChannelMappedToCard ( TvDatabase.Channel dbChannel, TvDatabase.Card card, bool forEpg ) : bool
ListAllEnabledCardsOrderedByPriority ( ) : IList
MapChannelToCard ( TvDatabase.Card card, TvDatabase.Channel channel, bool epgOnly ) : TvDatabase.ChannelMap
OptimizeMySql ( string aTable ) : void	Checks a MySQL table for corruption and optimizes / compacts it. Use this after lots of insert / delete operations.
RemoveAllPrograms ( int idChannel ) : void
RemoveOldPrograms ( ) : void
RemoveOldPrograms ( int idChannel ) : void
SaveMpGenres ( List mpGenres ) : void	Save the specified list of MediaPortal genres to the database.
SearchMinimalPrograms ( System.DateTime startTime, System.DateTime endTime, string programName, TvDatabase.Channel channel ) : IList
SearchPrograms ( string searchCriteria ) : IList
SearchPrograms ( string searchCriteria, ChannelType channelType ) : IList
SearchProgramsByDescription ( string searchCriteria ) : IList
SearchProgramsByDescription ( string searchCriteria, ChannelType channelType ) : IList
SearchProgramsPerGenre ( string currentGenre, string searchCriteria ) : IList
SearchProgramsPerGenre ( string currentGenre, string searchCriteria, ChannelType channelType ) : IList
SetLogLevel ( ) : void	Set the log level
UpdateTuningDetails ( TvDatabase.Channel channel, IChannel tvChannel, TvDatabase.TuningDetail detail ) : TvDatabase.TuningDetail
WaitForInsertPrograms ( ) : void
WaitForInsertPrograms ( int millisecondsTimeout ) : void
isSameTransponder ( TvDatabase.Schedule schedule1, TvDatabase.Schedule schedule2 ) : bool	checks if 2 schedules have a common Transponder depending on tuningdetails of their respective channels

Приватные методы

Метод	Описание
AddNewChannel ( string name ) : TvDatabase.Channel
AssignSchedulesToCard ( TvDatabase.Schedule schedule, List cardSchedules, List &overlappingSchedules, List &notViewabledSchedules ) : bool
BuildCommandTextMiniGuide ( string aProvider, ICollection aEpgChannelList ) : string
BuildEpgSelect ( IEnumerable channelList, string aProvider ) : string
BuildNowNextFromDataSet ( DataSet dataSet ) : NowAndNext>.Dictionary
ExecuteDeleteProgramsMySqlCommand ( IEnumerable deleteProgramRanges, MySqlConnection aConnection, MySql.Data.MySqlClient.MySqlTransaction aTransaction, int aDelay ) : void
ExecuteDeleteProgramsMySqlCommand ( IEnumerable channelIds, MySqlConnection aConnection, MySql.Data.MySqlClient.MySqlTransaction aTransaction, int aDelay ) : void
ExecuteDeleteProgramsSqlServerCommand ( IEnumerable deleteProgramRanges, SqlConnection aConnection, SqlTransaction aTransaction, int aDelay ) : void
ExecuteDeleteProgramsSqlServerCommand ( IEnumerable channelIds, SqlConnection aConnection, SqlTransaction aTransaction, int aDelay ) : void
ExecuteInsertProgramsMySqlCommand ( IEnumerable aProgramList, MySqlConnection aConnection, MySql.Data.MySqlClient.MySqlTransaction aTransaction, int aDelay ) : void
ExecuteInsertProgramsSqlServerCommand ( IEnumerable aProgramList, SqlConnection aConnection, SqlTransaction aTransaction, int aDelay ) : void
FileNotExistsString ( String fileName ) : String	Checks if a file doesnt exist and then returns the filename preceded by a CRLF combination. If the file does exist a empty string is returned.
FillProgramMapFromDataSet ( DataSet dataSet ) : List>.Dictionary
GetDefaultMpGenreNames ( ) : IList
InsertProgramsMySql ( ImportParams aImportParam ) : void
InsertProgramsSqlServer ( ImportParams aImportParam ) : void
InsertProgramsThreadStart ( ) : void
checkGentleFiles ( ) : void	Checks several files that are needed for using the gentle framework for the database. If some files are not present in the working folder an System.IO.FileNotFoundException exception is thrown

Описание методов