public List <WebPicture> GetAllPictures() { List <WebPicture> pics = new List <WebPicture>(); DBLocations dbs = Utils.GetMPDbLocations(); SQLiteConnection db = new SQLiteConnection(SQLiteConnStr(dbs.db_pictures)); try { db.Open(); } catch (Exception) { return(pics); } SQLiteCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT * FROM picture"; SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { pics.Add(new WebPicture(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2), reader.GetDateTime(3))); } reader.Close(); reader.Dispose(); cmd.Dispose(); db.Close(); db.Dispose(); return(pics); }
public List <WebPicture> GetAllPicturesByPath(string path) { List <WebPicture> pics = new List <WebPicture>(); DBLocations dbs = Utils.GetMPDbLocations(); SQLiteConnection db = new SQLiteConnection(SQLiteConnStr(dbs.db_pictures)); try { db.Open(); } catch (Exception) { return(pics); } SQLiteCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT * FROM picture WHERE strFile LIKE '" + path + "%' ORDER by strFile"; SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string s = reader.GetString(1); s = s.Remove(0, path.Length + 1); if (s.IndexOf('\\') == -1) { pics.Add(new WebPicture(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2), reader.GetDateTime(3))); } } reader.Close(); reader.Dispose(); cmd.Dispose(); db.Close(); db.Dispose(); return(pics); }
public List <WebMusicTrack> GetAllMusicTracks(string album, string artist, string title) { List <WebMusicTrack> tracks = new List <WebMusicTrack>(); DBLocations dbs = Utils.GetMPDbLocations(); SQLiteConnection db = new SQLiteConnection(SQLiteConnStr(dbs.db_music)); try { db.Open(); } catch (Exception) { return(tracks); } SQLiteCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT idTrack,strAlbum,strAlbumArtist,iTrack,strTitle,strPath,iDuration FROM tracks WHERE strAlbum LIKE '" + album + "%' AND strAlbumArtist LIKE '" + artist + "%' AND strTitle LIKE '" + title + "%'"; SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { tracks.Add(new WebMusicTrack(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3), reader.GetString(4), reader.GetString(5), reader.GetInt32(6))); } reader.Close(); reader.Dispose(); cmd.Dispose(); db.Close(); db.Dispose(); return(tracks); }
public List <string> GetAllPicturePaths() { List <string> paths = new List <string>(); DBLocations dbs = Utils.GetMPDbLocations(); SQLiteConnection db = new SQLiteConnection(SQLiteConnStr(dbs.db_pictures)); try { db.Open(); } catch (Exception) { return(paths); } SQLiteCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT strFile FROM picture ORDER BY strFile"; SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string p = reader.GetString(0); if (!paths.Contains(Path.GetDirectoryName(p))) { paths.Add(Path.GetDirectoryName(p)); } } reader.Close(); reader.Dispose(); cmd.Dispose(); db.Close(); db.Dispose(); return(paths); }
public List <WebMovie> GetAllMovies(string title) { List <WebMovie> movies = new List <WebMovie>(); DBLocations dbs = Utils.GetMPDbLocations(); SQLiteConnection db = new SQLiteConnection(SQLiteConnStr(dbs.db_movies)); try { db.Open(); } catch (Exception) { return(movies); } SQLiteCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT files.idMovie,movieinfo.strGenre,movieinfo.strTitle,movieinfo.strPlot,(path.strPath || files.strFilename) as filename FROM files LEFT OUTER JOIN movieinfo ON (movieinfo.idMovie=files.idMovie) INNER JOIN path ON (path.idPath=files.idPath) WHERE movieinfo.strTitle LIKE '" + title + "%'"; SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { movies.Add(new WebMovie(reader.GetInt32(0), SafeStr(reader, 1), SafeStr(reader, 2), SafeStr(reader, 3), SafeStr(reader, 4))); } reader.Close(); reader.Dispose(); cmd.Dispose(); db.Close(); db.Dispose(); return(movies); }
public WebMusicTrack GetMusicTrack(int idTrack) { WebMusicTrack track = new WebMusicTrack(); DBLocations dbs = Utils.GetMPDbLocations(); SQLiteConnection db = new SQLiteConnection(SQLiteConnStr(dbs.db_music)); try { db.Open(); } catch (Exception) { return(track); } SQLiteCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT idTrack,strAlbum,strAlbumArtist,iTrack,strTitle,strPath,iDuration FROM tracks WHERE idTrack=" + idTrack.ToString(); SQLiteDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { track = new WebMusicTrack(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3), reader.GetString(4), reader.GetString(5), reader.GetInt32(6)); } reader.Close(); reader.Dispose(); cmd.Dispose(); db.Close(); db.Dispose(); return(track); }
public WebMovingPicture GetMovingPicture(int id) { WebMovingPicture pic = new WebMovingPicture(); DBLocations dbs = Utils.GetMPDbLocations(); SQLiteConnection db = new SQLiteConnection(SQLiteConnStr(dbs.db_movingpictures)); try { db.Open(); } catch (Exception) { return(pic); } SQLiteCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT local_media.id,title,summary,fullpath,genres,certification,year FROM local_media,local_media__movie_info,movie_info WHERE local_media.id=local_media__movie_info.local_media_id AND local_media__movie_info.movie_info_id=movie_info.id AND local_media.id=" + id.ToString(); SQLiteDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { pic = new WebMovingPicture(SafeInt32(reader, 0), SafeStr(reader, 1), SafeStr(reader, 2), SafeStr(reader, 3), SafeStr(reader, 4), SafeStr(reader, 5), SafeInt32(reader, 6)); } reader.Close(); reader.Dispose(); cmd.Dispose(); db.Close(); db.Dispose(); return(pic); }
public WebMovie GetMovie(int idMovie) { WebMovie movie = new WebMovie(); DBLocations dbs = Utils.GetMPDbLocations(); SQLiteConnection db = new SQLiteConnection(SQLiteConnStr(dbs.db_movies)); try { db.Open(); } catch (Exception) { return(movie); } SQLiteCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT files.idFile,movieinfo.strGenre,movieinfo.strTitle,movieinfo.strPlot,(path.strPath || files.strFilename) as filename FROM files LEFT OUTER JOIN movieinfo ON (movieinfo.idMovie=files.idMovie) INNER JOIN path ON (path.idPath=files.idPath) WHERE files.idMovie=" + idMovie.ToString(); SQLiteDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { movie = new WebMovie(reader.GetInt32(0), SafeStr(reader, 1), SafeStr(reader, 2), SafeStr(reader, 3), SafeStr(reader, 4)); } reader.Close(); reader.Dispose(); cmd.Dispose(); db.Close(); db.Dispose(); return(movie); }
public List <WebMovingPicture> GetAllMovingPictures(string title) { List <WebMovingPicture> pics = new List <WebMovingPicture>(); DBLocations dbs = Utils.GetMPDbLocations(); SQLiteConnection db = new SQLiteConnection(SQLiteConnStr(dbs.db_movingpictures)); try { db.Open(); } catch (Exception) { return(pics); } SQLiteCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT local_media.id,title,summary,fullpath,genres,certification,year FROM local_media,local_media__movie_info,movie_info WHERE local_media.id=local_media__movie_info.local_media_id AND local_media__movie_info.movie_info_id=movie_info.id AND title LIKE '" + title + "%'"; SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { pics.Add(new WebMovingPicture(SafeInt32(reader, 0), SafeStr(reader, 1), SafeStr(reader, 2), SafeStr(reader, 3), SafeStr(reader, 4), SafeStr(reader, 5), SafeInt32(reader, 6))); } reader.Close(); reader.Dispose(); cmd.Dispose(); db.Close(); db.Dispose(); return(pics); }
public WebSeries GetTvSeries(string compositeId) { WebSeries series = new WebSeries(); DBLocations dbs = Utils.GetMPDbLocations(); SQLiteConnection db = new SQLiteConnection(SQLiteConnStr(dbs.db_tvseries)); try { db.Open(); } catch (Exception) { return(series); } SQLiteCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT online_episodes.SeasonIndex,online_episodes.EpisodeIndex,online_series.pretty_name,online_episodes.EpisodeName,online_episodes.Summary,local_episodes.EpisodeFilename,local_episodes.CompositeID FROM online_series,online_episodes,local_episodes WHERE online_series.ID=online_episodes.SeriesID AND online_episodes.CompositeID=local_episodes.CompositeID AND local_episodes.CompositeID='" + compositeId + "' ORDER BY online_series.pretty_name,online_episodes.SeasonIndex,online_episodes.EpisodeIndex"; SQLiteDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { series = new WebSeries(SafeInt32(reader, 0), SafeInt32(reader, 1), SafeStr(reader, 2), SafeStr(reader, 3), SafeStr(reader, 4), SafeStr(reader, 5), SafeStr(reader, 6)); } reader.Close(); reader.Dispose(); cmd.Dispose(); db.Close(); db.Dispose(); return(series); }
public static DBLocations GetMPDbLocations() { DBLocations dbLocations = new DBLocations(); XmlDocument doc = new XmlDocument(); doc.Load(AppDomain.CurrentDomain.BaseDirectory + "config.xml"); XmlNodeList dbNodes = doc.SelectNodes("/appconfig/mpdatabases/database"); foreach (XmlNode node in dbNodes) { switch (node.Attributes["name"].Value) { case "movies": dbLocations.db_movies = node.Attributes["filename"].Value; break; case "music": dbLocations.db_music = node.Attributes["filename"].Value; break; case "pictures": dbLocations.db_pictures = node.Attributes["filename"].Value; break; case "tvseries": dbLocations.db_tvseries = node.Attributes["filename"].Value; break; case "movingpictures": dbLocations.db_movingpictures = node.Attributes["filename"].Value; break; } } return(dbLocations); }
public SupportedMPFunctions GetSupportedMPFunctions() { DBLocations db = Utils.GetMPDbLocations(); SupportedMPFunctions f = new SupportedMPFunctions(); f.myVideos = File.Exists(db.db_movies); f.myMusic = File.Exists(db.db_music); f.myPictures = File.Exists(db.db_pictures); f.myTvSeries = File.Exists(db.db_tvseries); f.movingPictures = File.Exists(db.db_movingpictures); return(f); }
public static DBLocations GetMPDbLocations() { DBLocations dbLocations = new DBLocations(); XmlDocument doc = new XmlDocument(); doc.Load(AppDomain.CurrentDomain.BaseDirectory + "config.xml"); XmlNodeList dbNodes = doc.SelectNodes("/appconfig/mpdatabases/database"); foreach (XmlNode node in dbNodes) { switch (node.Attributes["name"].Value) { case "movies": dbLocations.db_movies = node.Attributes["filename"].Value; break; case "music": dbLocations.db_music = node.Attributes["filename"].Value; break; case "pictures": dbLocations.db_pictures = node.Attributes["filename"].Value; break; case "tvseries": dbLocations.db_tvseries = node.Attributes["filename"].Value; break; case "movingpictures": dbLocations.db_movingpictures = node.Attributes["filename"].Value; break; } } return dbLocations; }