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 <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); }