C# Class Podcatcher.PodcastSqlModel

Inheritance: DataContext, INotifyPropertyChanged

Show file Open project: kypeli/Podcatcher Class Usage Examples

Public Properties

Property	Type	Description
Episodes	Table
PlayHistory	Table
Settings	Table
Subscriptions	Table

Public Methods

Method	Description
PodcastSqlModel ( ) : System
addEpisodeToPlayHistory ( PodcastEpisodeModel episode ) : void
addSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel podcastModel ) : void
allEpisodes ( ) : List
createDB ( ) : void
deleteEpisodeFromDB ( PodcastEpisodeModel episode ) : void
deleteEpisodesPerQuery ( IEnumerable query ) : void
deleteSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel podcastModel ) : void
episodeForEpisodeId ( int episodeId ) : PodcastEpisodeModel
episodeForPlaylistItem ( PlaylistItem item ) : PodcastEpisodeModel
episodesForSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel subscriptionModel ) : List
episodesForSubscriptionId ( int podcastId ) : List
insertEpisodesForSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel subscriptionModel, List newPodcastEpisodes ) : void
isPodcastInDB ( string subscriptionRssUrl ) : bool
playableEpisodesForSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel subscription ) : IEnumerable
settings ( ) : SettingsModel
subscriptionModelForIndex ( int index ) : Podcatcher.ViewModels.PodcastSubscriptionModel
unplayedEpisodesForSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel subscription ) : List
unplayedEpisodesForSubscription ( int subscriptionId ) : List

Private Methods

Method	Description
createSettings ( ) : void
episodesForTitle ( String episodeTitle ) : PodcastEpisodeModel
isValidSubscriptionModelIndex ( int index ) : bool

Method Details

PodcastSqlModel() public method

public PodcastSqlModel ( ) : System
return	System

addEpisodeToPlayHistory() public method

public addEpisodeToPlayHistory ( PodcastEpisodeModel episode ) : void
episode	Podcatcher.ViewModels.PodcastEpisodeModel
return	void

addSubscription() public method

public addSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel podcastModel ) : void
podcastModel	Podcatcher.ViewModels.PodcastSubscriptionModel
return	void

allEpisodes() public method

public allEpisodes ( ) : List
return	List

createDB() public method

public createDB ( ) : void
return	void

deleteEpisodeFromDB() public method

public deleteEpisodeFromDB ( PodcastEpisodeModel episode ) : void
episode	Podcatcher.ViewModels.PodcastEpisodeModel
return	void

deleteEpisodesPerQuery() public method

public deleteEpisodesPerQuery ( IEnumerable query ) : void
query	IEnumerable
return	void

deleteSubscription() public method

public deleteSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel podcastModel ) : void
podcastModel	Podcatcher.ViewModels.PodcastSubscriptionModel
return	void

episodeForEpisodeId() public method

public episodeForEpisodeId ( int episodeId ) : PodcastEpisodeModel
episodeId	int
return	Podcatcher.ViewModels.PodcastEpisodeModel

episodeForPlaylistItem() public method

public episodeForPlaylistItem ( PlaylistItem item ) : PodcastEpisodeModel
item	Podcatcher.ViewModels.PlaylistItem
return	Podcatcher.ViewModels.PodcastEpisodeModel

episodesForSubscription() public method

public episodesForSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel subscriptionModel ) : List
subscriptionModel	Podcatcher.ViewModels.PodcastSubscriptionModel
return	List

episodesForSubscriptionId() public method

public episodesForSubscriptionId ( int podcastId ) : List
podcastId	int
return	List

insertEpisodesForSubscription() public method

public insertEpisodesForSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel subscriptionModel, List newPodcastEpisodes ) : void
subscriptionModel	Podcatcher.ViewModels.PodcastSubscriptionModel
newPodcastEpisodes	List
return	void

isPodcastInDB() public method

public isPodcastInDB ( string subscriptionRssUrl ) : bool
subscriptionRssUrl	string
return	bool

playableEpisodesForSubscription() public method

public playableEpisodesForSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel subscription ) : IEnumerable
subscription	Podcatcher.ViewModels.PodcastSubscriptionModel
return	IEnumerable

settings() public method

public settings ( ) : SettingsModel
return	Podcatcher.ViewModels.SettingsModel

subscriptionModelForIndex() public method

public subscriptionModelForIndex ( int index ) : Podcatcher.ViewModels.PodcastSubscriptionModel
index	int
return	Podcatcher.ViewModels.PodcastSubscriptionModel

unplayedEpisodesForSubscription() public method

public unplayedEpisodesForSubscription ( Podcatcher.ViewModels.PodcastSubscriptionModel subscription ) : List
subscription	Podcatcher.ViewModels.PodcastSubscriptionModel
return	List

unplayedEpisodesForSubscription() public method

public unplayedEpisodesForSubscription ( int subscriptionId ) : List
subscriptionId	int
return	List

Property Details

Episodes public property

public Table Episodes
return	Table

PlayHistory public property

public Table PlayHistory
return	Table

Settings public property

public Table Settings
return	Table

Subscriptions public property

public Table Subscriptions
return	Table