public Collection <ApiMovie> GetMovies()
{
var movies = new Collection <ApiMovie>();
var dblines = _parent.DBCommand("video", "SELECT c00,c01,c03,c04,c05,c07,C09,c11,c12,c14,c15,c16,c18,idFile,idMovie,strFileName,strPath,playCount FROM movieview");
if (dblines == null)
{
return(movies);
}
foreach (var dbline in dblines)
{
if (dbline.Length < 18)
{
_parent.Log("Invalid request DATA : " + dbline);
continue;
}
dbline[4] = dbline[4].Length > 3 ? dbline[4] : "0.0";
var movie = new ApiMovie
{
Title = dbline[0],
Plot = dbline[1],
Tagline = dbline[2],
Votes = dbline[3],
Rating = dbline[4].Substring(0, 3).Trim('.'),
Year = XbmcHttp.StringToNumber(dbline[5]),
IdScraper = dbline[6],
Length = dbline[7],
Mpaa = dbline[8],
Genre = dbline[9],
Director = dbline[10],
OriginalTitle = dbline[11],
Studio = dbline[12],
IdFile = XbmcHttp.StringToNumber(dbline[13]),
IdMovie = XbmcHttp.StringToNumber(dbline[14]),
FileName = dbline[15],
Path = dbline[16],
PlayCount = XbmcHttp.StringToNumber(dbline[17])
};
if (movie.FileName.StartsWith("stack://", StringComparison.OrdinalIgnoreCase))
{
var temp = movie.FileName.Split(new[] { " , " }, StringSplitOptions.None);
movie.IsStack = 1;
movie.Hash = XbmcHttp.Hash(temp[0].Replace("stack://", ""));
movie.Thumb = @"special://profile/Thumbnails/Video/" + movie.Hash[0] + "/" + movie.Hash + ".tbn";
movie.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + XbmcHttp.Hash(movie.FileName) + ".tbn";
}
else
{
movie.IsStack = 0;
movie.Hash = XbmcHttp.Hash(movie.Path + movie.FileName);
movie.Thumb = @"special://profile/Thumbnails/Video/" + movie.Hash[0] + "/" + movie.Hash + ".tbn";
movie.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + movie.Hash + ".tbn";
}
movies.Add(movie);
}
return(movies);
}
public Collection <ApiTvEpisode> GetTvEpisodes()
{
var episodes = new Collection <ApiTvEpisode>();
const string req = "SELECT idEpisode,c00,c01,c03,c05,c10,c12,c13,idFile,strFileName,strPath,playCount,strTitle,strStudio,idShow,mpaa FROM episodeview ";
var dblines = _parent.DBCommand("video", req);
if (dblines == null)
{
return(episodes);
}
foreach (var dbline in dblines)
{
if (dbline.Length < 15)
{
_parent.Log("Invalid request DATA : " + dbline);
continue;
}
dbline[3] = dbline[3].Length > 3 ? dbline[3] : "0.0";
var episode = new ApiTvEpisode
{
IdEpisode = XbmcHttp.StringToNumber(dbline[0]),
Title = dbline[1],
Plot = dbline[2],
Rating = dbline[3].Substring(0, 3).Trim('.'),
Date = dbline[4],
Director = dbline[5],
Season = XbmcHttp.StringToNumber(dbline[6]),
Episode = XbmcHttp.StringToNumber(dbline[7]),
IdFile = XbmcHttp.StringToNumber(dbline[8]),
FileName = dbline[9],
Path = dbline[10],
PlayCount = XbmcHttp.StringToNumber(dbline[11]),
ShowTitle = dbline[12],
Studio = dbline[13],
IdShow = XbmcHttp.StringToNumber(dbline[14]),
Mpaa = dbline[15]
};
if (episode.FileName.StartsWith("stack://", StringComparison.OrdinalIgnoreCase))
{
var temp = episode.FileName.Split(new[] { " , " }, StringSplitOptions.None);
episode.IsStack = 1;
episode.Hash = XbmcHttp.Hash(temp[0].Replace("stack://", ""));
episode.Thumb = @"special://profile/Thumbnails/Video/" + episode.Hash[0] + "/" + episode.Hash + ".tbn";
episode.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + XbmcHttp.Hash(episode.Path) + ".tbn";
}
else
{
episode.IsStack = 0;
episode.Hash = XbmcHttp.Hash(episode.Path + episode.FileName);
episode.Thumb = @"special://profile/Thumbnails/Video/" + episode.Hash[0] + "/" + episode.Hash + ".tbn";
episode.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + XbmcHttp.Hash(episode.Path) + ".tbn";
}
episodes.Add(episode);
}
return(episodes);
}
public XbmcHttpFile(XbmcHttp parent)
{
_parent = parent;
_workerDownloads = new BackgroundWorker {
WorkerSupportsCancellation = true
};
_workerDownload = new BackgroundWorker {
WorkerSupportsCancellation = true
};
}
public Collection <ApiAudioArtist> GetArtists()
{
var artists = new Collection <ApiAudioArtist>();
var dblines = _parent.DBCommand("music", "SELECT idArtist,strArtist FROM artist");
if (dblines == null)
{
return(artists);
}
foreach (var dbline in dblines)
{
if (dbline.Length < 2)
{
_parent.Log("Invalid request DATA : " + dbline);
continue;
}
var hash = XbmcHttp.Hash(dbline[1]);
var hash2 = XbmcHttp.Hash("artist" + dbline[1]);
var genre = new ApiAudioArtist
{
IdArtist = XbmcHttp.StringToNumber(dbline[0]),
Name = dbline[1],
Thumb = @"special://profile/Thumbnails/Music/Artists/" + hash2 + ".tbn",
Fanart = @"special://profile/Thumbnails/Music/Fanart/" + hash + ".tbn",
Hash = hash2
};
artists.Add(genre);
}
dblines = _parent.DBCommand("music", "SELECT idArtist,strBiography FROM artistinfo");
if (dblines == null)
{
return(artists);
}
foreach (var dbline in dblines)
{
if (dbline.Length < 2)
{
_parent.Log("Invalid request DATA : " + dbline);
continue;
}
foreach (var artist in artists)
{
if (artist.IdArtist.ToString(CultureInfo.InvariantCulture) == dbline[0])
{
artist.Biography = dbline[1];
}
}
}
return(artists);
}
public Collection <ApiAudioSong> GetSongs()
{
var songs = new Collection <ApiAudioSong>();
const string req = "SELECT idSong,strTitle,iTrack,iDuration,iYear,strFileName,idAlbum,strAlbum,strPath,idArtist,strArtist,idGenre,strGenre,strThumb FROM songview";
var dblines = _parent.DBCommand("music", req);
if (dblines == null)
{
return(songs);
}
foreach (var dbline in dblines)
{
if (dbline.Length < 14)
{
_parent.Log("Invalid request DATA : " + dbline);
continue;
}
var song = new ApiAudioSong
{
IdSong = XbmcHttp.StringToNumber(dbline[0]),
Title = dbline[1],
Track = XbmcHttp.StringToNumber(dbline[2]),
Duration = XbmcHttp.StringToNumber(dbline[3]),
Year = XbmcHttp.StringToNumber(dbline[4]),
FileName = dbline[5],
IdAlbum = XbmcHttp.StringToNumber(dbline[6]),
Album = dbline[7],
Path = dbline[8],
IdArtist = XbmcHttp.StringToNumber(dbline[9]),
Artist = dbline[10],
IdGenre = XbmcHttp.StringToNumber(dbline[11]),
Genre = dbline[12],
Thumb = dbline[13],
};
var thumbparts = dbline[13].Split('/');
var hash = thumbparts[thumbparts.Length - 1].Replace(".tbn", "");
song.Hash = hash;
songs.Add(song);
}
return(songs);
}
public Collection <ApiTvShow> GetTvShows()
{
var shows = new Collection <ApiTvShow>();
var dblines = _parent.DBCommand("video", "SELECT idShow,c00,c01,c04,c05,c08,c12,c13,c14,strPath,totalCount FROM tvshowview");
if (dblines == null)
{
return(shows);
}
foreach (var dbline in dblines)
{
if (dbline.Length < 11)
{
_parent.Log("Invalid request DATA : " + dbline);
continue;
}
dbline[3] = dbline[3].Length > 3 ? dbline[3] : "0.0";
var show = new ApiTvShow
{
IdShow = XbmcHttp.StringToNumber(dbline[0]),
Title = dbline[1],
Plot = dbline[2],
Rating = dbline[3].Substring(0, 3).Trim('.'),
Premiered = dbline[4],
Genre = dbline[5],
IdScraper = dbline[6],
Mpaa = dbline[7],
Studio = dbline[8],
Path = dbline[9],
TotalCount = XbmcHttp.StringToNumber(dbline[10])
};
show.Hash = XbmcHttp.Hash(show.Path);
show.Thumb = @"special://profile/Thumbnails/Video/" + show.Hash[0] + "/" + show.Hash + ".tbn";
show.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + show.Hash + ".tbn";
shows.Add(show);
}
return(shows);
}
public Collection <ApiAudioGenre> GetGenres()
{
var genres = new Collection <ApiAudioGenre>();
var dblines = _parent.DBCommand("music", "SELECT idGenre,strGenre,COUNT(DISTINCT strAlbum) AS albumCount FROM albumview GROUP BY idGenre");
if (dblines == null)
{
return(genres);
}
foreach (var dbline in dblines)
{
if (dbline.Length < 3)
{
_parent.Log("Invalid request DATA : " + dbline);
continue;
}
var genre = new ApiAudioGenre {
IdGenre = XbmcHttp.StringToNumber(dbline[0]), Name = dbline[1], AlbumCount = XbmcHttp.StringToNumber(dbline[2])
};
genres.Add(genre);
}
return(genres);
}
public Collection <ApiAudioAlbum> GetAlbums()
{
var albums = new Collection <ApiAudioAlbum>();
const string req = "SELECT idAlbum,strAlbum,idGenre,idArtist,strArtist,strGenre,iYear,strThumb FROM albumview GROUP BY strAlbum";
var dblines = _parent.DBCommand("music", req);
if (dblines == null)
{
return(albums);
}
foreach (var dbline in dblines)
{
if (dbline.Length < 8)
{
_parent.Log("Invalid request DATA : " + dbline);
continue;
}
var album = new ApiAudioAlbum
{
IdAlbum = XbmcHttp.StringToNumber(dbline[0]),
Title = dbline[1],
IdGenre = XbmcHttp.StringToNumber(dbline[2]),
IdArtist = XbmcHttp.StringToNumber(dbline[3]),
Artist = dbline[4],
Genre = dbline[5],
Year = XbmcHttp.StringToNumber(dbline[6]),
Thumb = dbline[7]
};
var thumbparts = dbline[7].Split('/');
var hash = thumbparts[thumbparts.Length - 1].Replace(".tbn", "");
album.Hash = hash;
albums.Add(album);
}
return(albums);
}
public Collection <ApiTvSeason> GetTvSeasons()
{
var seasons = new Collection <ApiTvSeason>();
const string req = "SELECT idShow, COUNT(idShow), c12, strPath FROM episodeview GROUP BY idShow,c12";
var dblines = _parent.DBCommand("video", req);
if (dblines == null)
{
return(seasons);
}
foreach (var dbline in dblines)
{
if (dbline.Length < 4)
{
_parent.Log("Invalid request DATA : " + dbline);
continue;
}
var season = new ApiTvSeason
{
EpisodeCount = XbmcHttp.StringToNumber(dbline[1]),
IdShow = XbmcHttp.StringToNumber(dbline[0]),
SeasonNumber = XbmcHttp.StringToNumber(dbline[2])
};
var temp = dbline[3];
season.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + XbmcHttp.Hash(temp) + ".tbn";
char[] charsToTrim = { '/' };
temp = temp.TrimEnd(charsToTrim);
var hash = XbmcHttp.Hash("season" + temp);
season.Thumb = @"special://profile/Thumbnails/Video/" + hash[0] + "/" + hash + ".tbn";
season.Hash = temp;
seasons.Add(season);
}
return(seasons);
}
public XbmcHttpPlayer(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpFile(XbmcHttp parent)
{
_parent = parent;
_workerDownloads = new BackgroundWorker { WorkerSupportsCancellation = true };
_workerDownload = new BackgroundWorker { WorkerSupportsCancellation = true };
}
public XbmcHttpAudioPlayer(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpSystem(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpAudioLibrary(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpVideoLibrary(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpAudioLibrary(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpRemote(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpAudioPlayer(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpPicturePlayer(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpSystem(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpVideoPlayer(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpVideoLibrary(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpVideoPlayer(XbmcHttp parent)
{
_parent = parent;
}
public XbmcHttpRemote(XbmcHttp parent)
{
_parent = parent;
}
